Principal PostgreSQL Engineer (TS/SCI)
Core
Design, deploy, administer, and maintain high-availability PostgreSQL database environments for a large-scale U.S. Government big data analytics platform.
Role type
Principal PostgreSQL Engineer (Infrastructure & Operations)
Builds
Mission-critical database services supporting big data analytics and operational tools
Domain
U.S. Government / Big Data Analytics / Database Infrastructure
Deliverable
production ML models | infrastructure
Required skills
PostgreSQL administration, performance tuning, query optimization, indexing, partitioning, high availability, replication, backup and recovery, disaster recovery, Linux administration, scripting (Bash/Python), Infrastructure as Code, cloud/hybrid/containerized environments
Preferred skills
Big data analytics platforms, database security (encryption, auditing), PostgreSQL extensions (PostGIS, TimescaleDB), Kubernetes, Docker, Ansible, Terraform, NIST RMF/FedRAMP compliance
Technologies
PostgreSQL, Linux, Bash, Python, Kubernetes, Docker, Ansible, Terraform, PostGIS, TimescaleDB
Responsibilities
Design and deploy PostgreSQL environments; optimize performance via tuning and indexing; implement HA, replication, and DR solutions; develop database automation scripts; collaborate with DevSecOps and data engineering teams
Seniority
Principal, hands-on IC with strategic oversight