Postgres Database Engineer - EDB

People Consultancy Services (PCS); St. Louis (MO); On-site; USD 80,000 - 120,000; Part time

Job summary

A consultancy firm is looking for a Mid-Senior level IT professional specializing in EDB Postgres. The role entails designing, maintaining, and administering EDB Postgres systems, along with a strong focus on performance tuning and administration of PostgreSQL on AWS RDS. Ideal candidates will have extensive experience with PostgreSQL installation, configuration, and monitoring tools. This is a contract position based in St. Louis, Missouri.

Qualifications

• Experience in the design, maintenance, and administration of EDB Postgres.
• Deep understanding of EDB Postgres architecture and internals.
• Strong troubleshooting and debugging skills.

Responsibilities

• Administer EDB Postgres, Postgres Distributed, and AWS RDS.
• Monitor and configure PostgreSQL performance.
• Set up and configure PostgreSQL binary and logical replication.

Skills

EDB Postgres

PostgreSQL installation and configuration

Monitoring and alerting tools

PostgreSQL performance tuning

Linux

Scripting languages (Bash, ksh, Perl)

Job description

Note: Experience on EDB Postgres is Highly required

Responsibilities

• Experience in the design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS.
• Deep understanding of EDB Postgres architecture and internals.
• 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.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• Information Services