Senior PostgreSQL DBA - On-Site in DC | TS Clearance

Zachary Piper Solutions; Washington (District of Columbia); Hybride; USD 135 000 - 175 000; Plein temps

Résumé du poste

Zachary Piper Solutions is seeking a Senior Database Administrator for an on-site role in Washington DC. This position designs, implements, maintains, and optimizes enterprise PostgreSQL environments while ensuring data integrity, security, and performance. You will work with PostgreSQL, AWS cloud database technologies, high availability solutions, and enterprise data platforms in support of a DOJ Program.

REQUIRES TOP SECRET CLEARANCE

Qualifications

• Bachelor's Degree in Information Technology or a related field, or equivalent experience, and 8+ years of relevant experience.
• Strong experience designing, implementing, and maintaining complex database environments and database management systems.
• Hands-on experience administering PostgreSQL (v13+) including performance tuning, patching, capacity planning, and database optimization.
• Experience implementing backup and recovery solutions using pg_dump/pg_restore, WAL archiving, replication, and high availability configurations.
• Experience with PostgreSQL query tuning, indexing, partitioning, performance analysis, and database monitoring tools.
• Experience planning and executing database migrations, including PostgreSQL, Oracle, AWS RDS, and Aurora PostgreSQL environments.
• Knowledge of database security, access controls, and security best practices for safeguarding enterprise data.
• Experience establishing monitoring and alerting solutions using Prometheus, Grafana, or similar observability platforms, with strong communication and troubleshooting skills.

Responsabilités

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

Connaissances

PostgreSQL

Performance tuning

Database security

AWS RDS/Aurora

Backup & recovery

Monitoring & alerting

Migration planning

High availability

SQL tuning

Formation

Bachelor's Degree in IT or related field

Outils

pg_dump/pg_restore

WAL archiving

Prometheus

Grafana

Description du poste

Zachary Piper Solutions is seeking a Senior Database Administrator for an on-site role in Washington DC. This position designs, implements, maintains, and optimizes enterprise PostgreSQL environments while ensuring data integrity, security, and performance. You will work with PostgreSQL, AWS cloud database technologies, high availability solutions, and enterprise data platforms in support of a DOJ Program.

REQUIRES TOP SECRET CLEARANCE