PostgreSQL DBA: AWS RDS/EDB, Replication & Automation

Global Business Ser. 4u; St. Louis (MO); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Global Business Ser. 4u is seeking a Postgres/Cassandra Database Engineer in St. Louis, hybrid work arrangement. You will design, deploy, and maintain EDB Postgres, Postgres Distributed and AWS RDS clusters to support large-scale platforms and applications.

You will tackle replication, tuning, diagnostics, and automation across Postgres and AWS environments, collaborate with multiple teams, and contribute to database upgrade planning and incident response.

Qualifications

• Experience in design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS.
• Deep understanding of EDB Postgres architecture and internals.
• Proficiency in PostgreSQL installation and configuration, esp. PostgreSQL Plus Advanced Server and Postgres Distributed from EnterpriseDB.
• Skills in monitoring tools PEM; familiarity with observability tools like Splunk & Dynatrace is a plus.
• Experience with binary and logical replication (Binary Streaming, BDR) and data diagnostics tuning.
• Proficient in PL/pgSQL, PL/Tcl, PL/Perl, PL/Python and SQL; strong debugging skills.
• Automation experience for Postgres and AWS platforms; strong Linux (Oracle Linux) background.
• Scripting with Bash, KSH, and Perl; excellent cross-functional collaboration.

Responsibilities

• Design, deploy, and maintain EDB Postgres, PGD, and AWS RDS clusters for large-scale platforms.
• Create backup strategies, upgrades, and patches; monitor performance and tune SQL.
• Collaborate with cross-functional teams and cloud vendors to drive automation.
• Lead best practices for database development and strategy in coordination with stakeholders.
• Provide day-to-day admin support and participate in on-call rotations.

Skills

EDB Postgres

Postgres Distributed

AWS RDS

Postgres Architecture

PostgreSQL Install

PEM

Observability Tools

BDR Replication

Diagnostics & Tuning

PL/pgSQL

PL/Tcl

PL/Perl

PL/Python

Linux

Bash Scripting

Perl Scripting

Tools

Splunk

Dynatrace

Prometheus

Graphana

Job description

Global Business Ser. 4u is seeking a Postgres/Cassandra Database Engineer in St. Louis, hybrid work arrangement. You will design, deploy, and maintain EDB Postgres, Postgres Distributed and AWS RDS clusters to support large-scale platforms and applications.

You will tackle replication, tuning, diagnostics, and automation across Postgres and AWS environments, collaborate with multiple teams, and contribute to database upgrade planning and incident response.