Senior PostgreSQL DBA — On-Site DC, Top Secret Clearance

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

Benefits offered by this job

Cigna Medical

Dental

Vision

401K

PTO

Holidays

Job summary

Zachary Piper Solutions seeks a Senior Database Administrator to design, implement, and optimize enterprise database environments in Washington DC. You will manage PostgreSQL, AWS RDS/Aurora, and advanced high-availability solutions for critical DOJ programs.

The role requires top-secret clearance, 8+ years of experience, and strong skills in performance tuning, security, and migrations. On-site in Washington, DC with comprehensive benefits.

Qualifications

• Bachelor's degree in Information Technology or related field and 8+ years of experience.
• Extensive experience designing, implementing, and maintaining complex database environments.
• Hands-on PostgreSQL (v13+) administration with tuning, patching, and capacity planning.
• Experience with backup/recovery (pg_dump/pg_restore), WAL archiving, replication, and HA configurations.
• Experience with PostgreSQL query tuning, indexing, partitioning, and monitoring tools.
• Experience migrating PostgreSQL, Oracle, AWS RDS, and Aurora PostgreSQL environments.
• Knowledge of database security, access controls, and safeguarding enterprise data.
• Ability to establish monitoring/alerting using Prometheus, Grafana, or similar.

Responsibilities

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

Skills

PostgreSQL

AWS

High Availability

Performance Tuning

Security Best Practices

Data Integrity

Query Optimization

Relational Databases

Education

Bachelor's Degree in IT or related field

Tools

pg_dump/pg_restore

WAL Archiving

AWS RDS

Aurora PostgreSQL

Prometheus

Grafana

Job description

Zachary Piper Solutions seeks a Senior Database Administrator to design, implement, and optimize enterprise database environments in Washington DC. You will manage PostgreSQL, AWS RDS/Aurora, and advanced high-availability solutions for critical DOJ programs.

The role requires top-secret clearance, 8+ years of experience, and strong skills in performance tuning, security, and migrations. On-site in Washington, DC with comprehensive benefits.