Database Administrator (PostgreSQL, Cassandra)

Skill

PostgreSQL, Cassandra

Location

St. Louis, MO

Experience

4-7 Years

REMOTE / Onsite Role

Onsite

2-3 lines of must have skills

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 Enterprise DB.

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.