Senior PostgreSQL DBA — On-Site in DC (Top Secret)

Piper Companies; Washington (District of Columbia); On-site; USD 135,000 - 175,000; Full time

Job summary

Zachary Piper Solutions is seeking a Senior Database Administrator to design, implement, maintain, and optimize enterprise PostgreSQL environments in Washington, D.C. This on-site role supports a DOJ program and requires top secret clearance.

You will manage AWS RDS/Aurora PostgreSQL, high availability, backups, and security controls. The ideal candidate has 8+ years of experience, a IT-related degree, and hands-on PostgreSQL admin skills, with cloud and migration expertise for modern data

Qualifications

• Bachelor's degree in IT or related field, with 8+ years of relevant experience.
• Experience designing and maintaining complex PostgreSQL environments.
• Hands-on PostgreSQL 13+ administration, tuning, patching, and HA.
• Experience with backups using pg_dump/pg_restore, WAL archiving, replication.
• Knowledge of security practices for enterprise data.
• Experience with migrations across PostgreSQL, Oracle, AWS RDS, Aurora PostgreSQL.

Responsibilities

• Design, implement, maintain, and optimize enterprise database environments for performance and reliability.
• Administer PostgreSQL databases, including configuration, tuning, patching, capacity planning, backups, and HA.
• Implement database security controls and coordinate changes with system integrators.
• Monitor health, troubleshoot performance, optimize queries and indexing, and establish alerts.
• Support migrations and cloud modernization with AWS RDS/Aurora PostgreSQL.

Skills

PostgreSQL administration

Performance tuning

Capacity planning

Security controls

Cloud migrations

Education

Bachelor's Degree in Information Technology or related field

Tools

Prometheus

Grafana

AWS RDS

Aurora PostgreSQL

Job description

Zachary Piper Solutions is seeking a Senior Database Administrator to design, implement, maintain, and optimize enterprise PostgreSQL environments in Washington, D.C. This on-site role supports a DOJ program and requires top secret clearance.

You will manage AWS RDS/Aurora PostgreSQL, high availability, backups, and security controls. The ideal candidate has 8+ years of experience, a IT-related degree, and hands-on PostgreSQL admin skills, with cloud and migration expertise for modern data