Database Engineer II
Posted Updated
Summary
Database Engineer II supporting the DEFSMAC team on-site in Annapolis Junction, MD: designing and tuning PostgreSQL/PostGIS schemas and queries, maintaining HA and replication, monitoring performance, and automating tasks with Bash/Python. Requires an in-scope polygraph (within 7 years) and five years of DBE experience.
Reflexive Concepts is seeking a skilled Database Engineer to join our team!
Specifically, the DEFSMAC team is seeking a Database Engineer with experience in PostgreSQL and PostGIS. This position requires an in-scope polygraph (within 7 years). For qualified candidates, the labor category level for this position may be flexible.
Key Responsibilities:
Specifically, the DEFSMAC team is seeking a Database Engineer with experience in PostgreSQL and PostGIS. This position requires an in-scope polygraph (within 7 years). For qualified candidates, the labor category level for this position may be flexible.
Key Responsibilities:
- Design and optimize PostgreSQL database schemas, indexes, and queries for performance and scalability
- Monitor and tune database performance using native tools and custom scripts
- Implement and maintain high availability (HA) and replication strategies
- Collaborate with developers to refine complex queries and stored procedures
- Automate routine tasks using scripting languages (e.g., Bash, Python)
- Document database architecture, processes, and best practices
- Five (5) years experience as a DBE in programs and contracts of similar scope, type, and complexity
- Bachelor’s degree in Computer Science or related discipline from an accredited college or university
- Five (5) years of additional DBE experience may be substituted for a bachelor’s degree
- Experience with PostgreSQL and PostGIS
- Strong SQL skills and experience with performance tuning and query optimization
- Proficiency in Linux/Unix environments and CLI tools like psql
- Experience with logical and physical replication, partitioning, and backup strategies
- Familiarity with monitoring tools (e.g., pg_stat_statements, Prometheus, Grafana)
- Knowledge of scripting languages for automation and tooling
- In-scope polygraph within 7 years
- Experience with containerized environments (Docker, Kubernetes)
- Familiarity with cloud platforms (AWS RDS, GCP Cloud SQL, or Azure Database for PostgreSQL)
- Understanding of CI/CD pipelines and infrastructure as code (Terraform, Ansible)
- Exposure to other RDBMS (e.g., Oracle, MySQL) or NoSQL systems
