Database Engineer II

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.

• 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