Job Title: PostgreSQL/PostGIS Database Engineer
Location: Currently located at a secure facility (with a planned relocation in the near future)
Clearance Requirement: Active in-scope polygraph (within the past 7 years)
Employment Type: Full-Time
Position Overview:
A dynamic and mission-focused team is seeking a Database Engineer with hands-on experience in PostgreSQL and PostGIS. The ideal candidate will be skilled in database design, performance tuning, and automation, with the ability to support a complex, high-availability environment.
Key Responsibilities:
- Design and optimize PostgreSQL database schemas, indexes, and queries for performance and scalability
- Monitor and tune database performance using both built-in tools and custom scripts
- Implement and maintain high availability (HA), replication, and backup strategies
- Collaborate with developers to refine complex SQL queries and stored procedures
- Automate routine administrative tasks using scripting languages such as Bash or Python
- Document database architecture, processes, and best practices for internal use
Required Qualifications:
- Strong SQL skills and experience with performance tuning and query optimization
- Proficiency in Linux/Unix environments and command-line tools like psql
- Experience with logical and physical replication, partitioning, and data backup strategies
- Familiarity with database monitoring tools such as pg_stat_statements, Prometheus, or Grafana
- Knowledge of scripting for task automation and tool integration
Preferred Qualifications:
- Experience with containerized deployments (e.g., Docker, Kubernetes)
- Familiarity with cloud-based PostgreSQL services (AWS RDS, GCP Cloud SQL, Azure)
- Understanding of CI/CD pipelines and Infrastructure as Code tools (Terraform, Ansible)
- Exposure to other database technologies such as Oracle, MySQL, or NoSQL systems
