Senior PostgreSQL DBA – On-Site in DC, Top Secret Clearance

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 in Washington, D.C. for an on-site role supporting a DOJ program. You will design, implement, and optimize enterprise PostgreSQL environments with AWS RDS/Aurora, focusing on security, performance, and high availability.

The role requires TS clearance, 8+ years of experience, and strong expertise in backups, migrations, and observability tools. This is a hands-on, mission-critical position in a secure environment.

Qualifications

• Bachelor's Degree in IT or related field with 8+ years of experience.
• Strong experience designing, implementing, and maintaining complex database environments and DBMS.
• Hands-on PostgreSQL (v13+) administration including tuning, patching, capacity planning, and optimization.
• Experience backup/recovery using pg_dump/pg_restore, WAL archiving, replication, and high availability configurations.
• PostgreSQL query tuning, indexing, partitioning, performance analysis, and monitoring tools.
• Experience migrations including PostgreSQL, Oracle, AWS RDS, and Aurora PostgreSQL.
• Knowledge of database security, access controls, and security best practices.
• Experience monitoring/alerting with Prometheus, Grafana or similar observability platforms.

Responsibilities

• Design, implement, maintain, and optimize enterprise database environments for performance, scalability, and reliability.
• Administer PostgreSQL databases, including configuration, tuning, patching, capacity planning, backup, recovery, and high availability.
• Implement database security controls, coordinate changes, and support system integration initiatives.
• Monitor database health, troubleshoot performance issues, optimize queries and indexing strategies, and establish alerting solutions.
• Support migrations, cloud modernization efforts, and AWS RDS/Aurora PostgreSQL environments.

Skills

PostgreSQL

AWS

High availability

Performance tuning

Security best practices

Monitoring tools

Query optimization

Education

Bachelor's Degree in IT or related field

Tools

pg_dump/pg_restore

WAL archiving

Replication

AWS RDS

Aurora PostgreSQL

Prometheus/Grafana

Job description

Zachary Piper Solutions is seeking a Senior Database Administrator in Washington, D.C. for an on-site role supporting a DOJ program. You will design, implement, and optimize enterprise PostgreSQL environments with AWS RDS/Aurora, focusing on security, performance, and high availability.

The role requires TS clearance, 8+ years of experience, and strong expertise in backups, migrations, and observability tools. This is a hands-on, mission-critical position in a secure environment.