PostgreSQL DBA: Performance, HA & Cloud-Ready

Synechron; St. Louis (MO); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Highly competitive compensation

10 days of paid annual leave

Comprehensive insurance plan

Retirement savings plans

Extensive training opportunities

Job summary

A global consulting firm is seeking an experienced PostgreSQL Database Administrator (DBA) in St. Louis. The role involves managing mission-critical PostgreSQL databases, ensuring high availability, performance, and security. Candidates should have extensive experience in database administration, performance tuning, and optimizing database environments. Successful applicants will enjoy a competitive compensation package, extensive training opportunities, and the chance to work with top-tier financial institutions.

Qualifications

• 5+ years of hands-on experience as a PostgreSQL DBA in large-scale enterprise environments.
• Strong knowledge of PostgreSQL architecture, including WAL, replication, and partitioning.
• Experience with performance tuning, query optimization, and index management.
• Working knowledge of database monitoring and alerting tools (e.g., Prometheus, Grafana, Datadog).

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL database servers.
• Monitor database performance, identify bottlenecks, and implement tuning strategies.
• Design and manage database backup and recovery strategies.
• Implement replication, clustering, and failover mechanisms for high availability.

Skills

PostgreSQL architecture

performance tuning

query optimization

index management

PL/pgSQL

Linux/Unix environments

problem-solving

Tools

pgAdmin

pgBackRest

Patroni

pgBouncer

pgPool-II

AWS RDS/Aurora PostgreSQL

Azure Database for PostgreSQL

GCP Cloud SQL

Job description

A global consulting firm is seeking an experienced PostgreSQL Database Administrator (DBA) in St. Louis. The role involves managing mission-critical PostgreSQL databases, ensuring high availability, performance, and security. Candidates should have extensive experience in database administration, performance tuning, and optimizing database environments. Successful applicants will enjoy a competitive compensation package, extensive training opportunities, and the chance to work with top-tier financial institutions.