
Senior PostgreSQL Database Administrator
Serv Recruitment Agency
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $145,000 per year
Job Level
About the role
- Own the end-to-end lifecycle of PostgreSQL clusters
- Design and manage high-availability (HA) PostgreSQL clusters across all environments
- Proactively monitor and resolve bottlenecks
- Implement advanced partitioning strategies and automated archival policies
- Own the backup/DR strategy and execute zero-downtime upgrades
- Optimize read-replicas and materialized views for BI reporting
- Utilize Infrastructure as Code (Terraform) and scripting to automate provisioning
- Design and orchestrate automated failover to maintain RTO of <15 minutes
- Enforce SOC2/GDPR standards and implement data retention policies
Requirements
- 5–10 years as a production PostgreSQL DBA
- Deep mastery of MVCC, WAL, and Query Planner behavior
- Proficiency with pgBouncer, Patroni, and cloud-native database environments (AWS/Azure)
- Strong Linux skills and experience with Prometheus/Grafana monitoring
- BS in Computer Science or equivalent practical experience
Benefits
- 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
PostgreSQLhigh-availability (HA) clustersadvanced partitioning strategiesautomated archival policiesbackup/DR strategyzero-downtime upgradesread-replicasmaterialized viewsInfrastructure as Code (Terraform)scripting
Soft Skills
proactive monitoringproblem resolutiondesign skillsorchestrationautomation
Certifications
BS in Computer Science