Title: Postgres Engineer
Location: St. Louis, MO (On-site)
Duration: 6 months (possibility of extension)
Implementation Partner: Infosys
End Client: To be disclosed
JD:
- 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.