Database Engineer

Description

Job Title: Database Engineer

Job Location: Remote and or various locations within the company

Job Type: Full time 40 hours

Travel Requirement: Up to 10%

Secret: Ability to Obtain and Maintain Top Secret

Job Description: 

Sherpa 6 is seeking a talented Database Engineer with deep expertise in PostgreSQL to join our team and play a crucial role to design, optimize, and maintain our data infrastructure. We build mission critical systems for the Department of Defense (DoD) and other commercial customers. You’ll collaborate closely with engineering, QA, and product owners to ensure our databases are scalable, secure, and high-performing as we continue to grow our platform and data-driven capabilities.  

Responsibilities: 

• Design and maintain PostgreSQL database architectures to support application and analytical workloads.  
• Develop and optimize SQL queries, stored procedures, and database functions for high performance and reliability. 
• Ensure data integrity and security, including backups, disaster recovery, and access controls. 
• Monitor and tune database performance using tools like pg_stat_statements, EXPLAIN ANALYZE, and pgBadger. 
• Collaborate with developers to review schema changes and ensure efficient database usage patterns. 
• Automate database operations through CI/CD pipelines and Infrastructure-as-Code (IaC) tools (e.g., Terraform, Ansible). 
• Develop and support migration plans 
• Troubleshoot production issues and provide on-call support for critical database incidents. 
• Document database standards, procedures, and schemas for consistency across teams. 

Requirements

Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or related field. 
• 5+ years of hands-on experience designing and tuning PostgreSQL databases for production environments.  
• Strong knowledge of SQL, query optimization, indexing, and execution plans. 
• Solid understanding of database replication, failover, and backup/restore strategies. 
• Strong knowledge of source control systems (Git, branching strategies, tagging). 
• Experience with scripting and automation (e.g., Python, Bash, Groovy, PowerShell). 
• Familiarity with containerization and orchestration (Docker, Kubernetes). 
• Solid understanding of software development lifecycle (SDLC) and agile methodologies. 
• Excellent analytical and problem-solving skills, with a keen attention to detail. 
• Strong communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams 
• Must be a US citizen 

Qualities of Exceptional Candidates: 

• Experience with PostgreSQL extensions (e.g., PostGIS, TimescaleDB, pg_partman).  
• Working knowledge of cloud environments (AWS RDS, Aurora PostgreSQL, GCP Cloud SQL, or Azure Database for PostgreSQL). 
• Knowledge of ETL pipelines, data warehousing, or analytics systems. 
• Certification in PostgreSQL administration (e.g., EDB Certified PostgreSQL DBA). 
• Experience with NoSQL databases (e.g., Redis, MongoDB) 
• Knowledge of Linux operating systems 

Background Screening/Check/Investigation:

Successful completion of a background screening/check/investigation will/may be required as a condition of hire.

ADA:

Sherpa 6 will make reasonable accommodations in compliance with the Americans with Disabilities Act 1990

EEO/AA:

Sherpa 6 does not discriminate based on race, color, national origin, sex, religion age, disability, sexual orientation, gender identity, veteran status, height, weight, or marital status in employment or the provision of services and is an equal access/opportunity/affirmative action employer.

Benefits:

We offer a competitive benefits package, covering the cost of medical for you and your family; we also offer dental, vision, health and wellness benefits and a generous retirement savings plan. We believe that our employees can manage their workload and their personal life, therefore we extend a generous PTO policy. This allows our employees to balance their lives as they see fit.

Salary Range:

The proposed salary range is reflective across all Sherpa 6 locations, years of experience, and skill levels. Salary negotiations will be based on a host of factors including but