Serv Recruitment Agency

Senior PostgreSQL Database Administrator

Serv Recruitment Agency

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

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