Senior PostgreSQL DBA

Trillion Technology Solutions • Fort Meade, MD

3d • Onsite

About The Position

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. THIS IS AN ON-SITE POSITION AT FORT MEADE ACTIVE SECRET CLEARANCE REQUIRED

Requirements

• 5+ years of experience managing production PostgreSQL environments with replication using EPRS a plus
• Proven experience with WAL (Write-Ahead Logging), replication slots etc
• Strong understanding of Linux

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed