Database Engineer- Secret clearance eligible
Natick, MA - USA
Job Summary
Travel Requirement: Up to 25%
Security Clearance: Ability to obtain a Secret Clearance required
Citizenship: US Citizenship required
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. Youll 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 pgstatstatements 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.
- Bachelors 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
Qualities of Exceptional Candidates:
- Experience with PostgreSQL extensions (e.g. PostGIS TimescaleDB pgpartman).
- 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
About Sherpa 6:
At Sherpa 6 we love to solve problems and provide the best solutions for our customers. Our approach to a problem is to find a user-focused and design-driven solution that is simple yet functional and effective. We are a group of enthusiastic forward-thinkers who are excited to build amazing solutions with bleeding-edge technology. We hire people who are forward thinkers passionate about what they do love to collaborate and want to constantly learn. We enjoy what we do and were not afraid to put the extra effort in to accomplish the mission; call us Sherpas. As a Service-Disabled Veteran Owned Small Business we know what it means to serve. We have made it our mission to be the leaders in solutions that protect and give our Warfighters the edge they need when put into harms way.
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 not limited to your geographic location prior experience relevant skills education and certifications.
Required Experience:
IC
About Company
Sherpa 6 is a Veteran-Owned full-service engineering firm and the answer for all your design, development, and engineering needs.