PostgreSQL DBA

Job Title : PostgreSQL DBA

Location : St Louis, MO (Onsite)

Job Type : Full Time

Required Skills :

Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS.

Deep understanding of EDB Postgres architecture and internals.

Expertise in Table Partitioning on Large Data sets

Proficient in PostgreSQL installation and configuration, especially PostgreSQL Plus Advanced Server and Postgres Distributed from EnterpriseDB.

Skilled in PostgreSQL monitoring and alerting tools, particularly PEM. Familiarity with observability tools like Splunk and Dynatrace is a plus.

Experienced in setting up, configuring, and monitoring PostgreSQL binary and logical replication (e.g., Binary Streaming, Bi-Directional Replication - BDR).

Strong skills in collecting diagnostics and tuning PostgreSQL and SQL performance.

Proficient in PostgreSQL procedural languages (PL / pgSQL, PL / Tcl, PL / Perl, PL / Python) and SQL.

Excellent troubleshooting and debugging skills.

Experience in performance tuning and automation for Postgres and AWS platforms.

Proficient in Linux, especially Oracle Linux Enterprise.

Familiarity with scripting languages such as Bash, KSH, and Perl.