Job description

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 • 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 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

Requirements

Must-haves

Reflexive Concepts is seeking a skilled Database Engineer to join our team!
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

Nice-to-haves

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

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

pythonsqldockerkubernetesawsgcpazureci/cd

Platform: catsone
Effort: medium