Principal Database Engineer

Immediate need for a talented Principal Database Engineer. This is a 12+ months contract opportunity with long-term potential and is located in Westlake, TX/ Boston, MA,/ Merrimack, NH (Onsite). Please review the job description below and contact me ASAP if you are interested.Job ID: 25-56901Pay Range: $70 - $75/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).Key Responsibilities: Distributed SQL and NoSQL Databases: Extensive experience in CockroachDB and Oracle, with a preference for MongoDB knowledge.CockroachDB Administration: Hands-on experience with installation, configuration, upgrading, architecture, geo-partitioning, data replication, sharding, and consensus algorithms (Raft / Paxos).Schema Design and Performance Tuning: Expertise in schema design, performance optimization, query optimization, and both physical and logical backup solutions.Troubleshooting and Debugging: Strong debugging skills with the ability to identify and resolve complex issues.Scripting/Automation: Proficient in automation tools like bash, Python, and Ansible.DevOps and CI/CD: Experience with tools such as Udeploy, JIRA, Confluence, Jenkins, Git, Liquibase. Familiar with Datadog and ServiceNow integration.Cross-Functional Skills: Knowledge of Site Reliability Engineering (SRE) and DevOps practices.API Knowledge: Ability to work with REST APIs and read documentation to make API calls for data interactions.Containerization: Familiar with ECS and Docker.Collaboration: Strong ability to work across multiple teams in an organization.Key Requirements and Technology Experience:Key skills; 10+ Years of DBA Experience with a focus on Oracle and CockroachDB, as well as experience managing migrationsHands-on experience with installation, configuration, upgrading, architecture, geo-partitioning, data replication, sharding, and consensus algorithms (Raft / Paxos)Expertise in schema design, performance optimization, query optimization, and both physical and logical backup solutions.Cloud Solutions: Expertise in AWS (EC2, CFT, Route53, RDS), with experience in other cloud platforms like Azure or GCP.Additional Technologies: Experience with Redis, Elasticsearch, cloud data warehousing, and data lake solutions.Version Control & Build Tools: Proficient in GIT Stash, Maven.Infrastructure Experience: Familiarity with various types of hosted infrastructure and ability to adapt to changing environments.Communication Skills: Strong written and oral communication in English.10+ Years of DBA Experience with a focus on Oracle and CockroachDB, as well as experience managing migrations.AWS Solutions Architect Certification: Required for database engineering and cloud hosting.API and Infrastructure Alignment: Expertise in aligning APIs and infrastructure during the migration from MongoDB to CockroachDB.Database Integrity: Ensuring the alignment of schemas, tables, and processes during the migration, particularly in relation to Snowflake team coordination for schema and database consistency.Migration & Client Processes: Experience in rehydrations, schema creation, table creation, and alignment across systems.Our client is a leading Financial Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.By applying to our jobs, you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here

Created: 2025-01-26