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.

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

Qualifications:

- Five (5) years experience as a DBE in programs and contracts of similar scope, type, and complexity

- Bachelors 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 bachelors degree

Required:

- 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

Desired:

- 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