PostgreSQL Database Administrator

PostgreSQL Database Administrator 3.7 3.7 out of 5 stars Fort Meade, MD 20755 $123,764.13 - $150,000.00 a year - Full-time Agensys Corporation 27 reviews $123,764.13 - $150,000.00 a year - Full-time We are seeking an experienced PostgreSQL DBA to manage our database infrastructure. The ideal candidate will have a deep understanding of PostgreSQL internals, with a specific focus on designing and maintaining robust replication strategies to ensure 24/7 data availability and seamless failover. 2.

Key Responsibilities High Availability:

Manage HA clusters consisting postgreSQL DB instances maintained as Kubernetes pods

Performance Tuning:

Optimize complex queries, index usage, and memory settings

Disaster Recovery:

Maintain rigorous backup and Point-in-Time Recovery (PITR) strategies

Monitoring:

Monitor proactive alerting for replication lag, memory usage and licensing

Upgrades:

Execute major and minor version upgrades with minimal downtime 3.

Technical Requirements Experience:

5+ years of experience managing production PostgreSQL environments with replication using EPRS a plus

Replication Expertise:

Proven experience with WAL (Write-Ahead Logging), replication slots etc Strong understanding of

Linux Clearance:

Active Secret Clearance #AC1

Job Type:

Full-time Pay:

$123,764.13 - $150,000.00 per year

Experience:

PostgreSQL:

5 years (Required) Database management: 5 years (Required) Security clearance: Secret (Required)

Work Location:

In person