Postgres Database Engineer

Global Business Ser. 4u; St. Louis (MO); Presencial; USD 120 000 - 180 000; Tempo parcial

Resumo da oferta

Global Business Ser. 4u is seeking a Postgres/Cassandra Database Engineer for a 12+ month contract in St. Louis, MO. You will design, deploy, and administer EDB Postgres, Postgres Distributed and AWS RDS clusters, ensuring high availability and performance.

The role requires strong expertise in PostgreSQL internals, replication, monitoring, and automation. You will collaborate with global teams, optimize SQL, and implement backup and upgrade strategies across cloud and on‑prem environments.

Qualificações

• Experience in design, maintenance, and admin of EDB Postgres, Postgres Distributed and AWS RDS.
• Deep understanding of EDB Postgres architecture and internals.
• Proficient in PostgreSQL installation and configuration with EnterpriseDB tools.
• Strong monitoring with PEM; observability tools like Splunk or Dynatrace are a plus.
• Experience with replication (BDR) and performance tuning.

Responsabilidades

• Excellent interpersonal and communication skills.
• Strong collaboration to work across cross-functional teams.
• Forward-thinking approach to infrastructure automation and scripting.
• Ability to work with global teams across multiple time zones.
• Self-motivated with the ability to work independently and seek guidance when needed.
• Design, deploy, and maintain EDB Postgres, PGD and AWS RDS clusters for large-scale platforms.
• Create and manage database clusters across dev, QA, and prod with performance tuning.
• Review configurations and recommend improvements.
• Assist with upgrades and migrations of Postgres databases.
• Provide day-to-day admin support for Postgres and AWS Aurora databases.
• Partipate in production support and on-call rotations as needed.
• Collaborate with Postgres and cloud vendors and use support channels.

Conhecimentos

EDB Postgres

Postgres Distributed

AWS RDS

Replication

PEM monitoring

SQL tuning

PL/pgSQL

Linux

Scripting

Ferramentas

Splunk

Dynatrace

PEM

Descrição da oferta de emprego

Job Title: Postgres/Cassandra Database Engineer

Job type: Contract

Duration: 12+ Months

Location: St. Louis, MO

• 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.

Job Title: Postgres/Cassandra Database Engineer

Job type: Contract

Duration: 12+ Months

Location: St. Louis, MO

About You On Postgres 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 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.

Roles And Responsibilities

• Excellent interpersonal and communication skills.
• Strong collaboration skills to work effectively across cross-functional teams.
• Forward-thinking approach to infrastructure automation and scripting.
• Ability to work with global teams across multiple time zones.
• Self-motivated with the ability to work independently and seek guidance when needed.
• Ability to understand application data requirements and recommend appropriate database solutions.
• Responsible for designing, deploying, and maintaining EDB Postgres, PGD and AWS RDS database clusters to support large-scale platforms and applications.
• Create and manage fully functional database clusters across development, QA, and production environments, with experience in performance tuning.
• Review existing configurations and recommend improvements.
• Assist with planning and executing Postgres database upgrades and migrations.
• Provide day-to-day administrative support and maintenance for Postgres and AWS Aurora databases.
• Participate in production support and on‑call rotations as needed.
• Collaborate with Postgres and cloud vendors and utilize their support channels.
• Develop and implement backup strategies, perform upgrades, and apply patches.
• Identify inefficiencies and implement optimized solutions.
• Design and execute data and database migrations to new hardware or platforms.
• Lead best practices and database solution strategies at Mastercard.
• Work with management to plan and implement new tools and data services.
• Represent Database Engineering in strategic planning and long‑term direction.
• Support both internal and future cloud‑managed Postgres systems, define best practices, and drive automation and innovation.
• Collaborate with multiple application teams and developers.
• Assist in defining long‑term strategic goals for database development in alignment with stakeholders.