PostgreSQL DBA

Global Business Ser. 4u; St. Louis (MO); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Global Business Ser. 4u is seeking a Postgres/Cassandra Database Engineer in St. Louis, hybrid work arrangement. You will design, deploy, and maintain EDB Postgres, Postgres Distributed and AWS RDS clusters to support large-scale platforms and applications.

You will tackle replication, tuning, diagnostics, and automation across Postgres and AWS environments, collaborate with multiple teams, and contribute to database upgrade planning and incident response.

Qualifications

• Experience in design, maintenance, and administration of EDB Postgres, Postgres Distributed and AWS RDS.
• Deep understanding of EDB Postgres architecture and internals.
• Proficiency in PostgreSQL installation and configuration, esp. PostgreSQL Plus Advanced Server and Postgres Distributed from EnterpriseDB.
• Skills in monitoring tools PEM; familiarity with observability tools like Splunk & Dynatrace is a plus.
• Experience with binary and logical replication (Binary Streaming, BDR) and data diagnostics tuning.
• Proficient in PL/pgSQL, PL/Tcl, PL/Perl, PL/Python and SQL; strong debugging skills.
• Automation experience for Postgres and AWS platforms; strong Linux (Oracle Linux) background.
• Scripting with Bash, KSH, and Perl; excellent cross-functional collaboration.

Responsibilities

• Design, deploy, and maintain EDB Postgres, PGD, and AWS RDS clusters for large-scale platforms.
• Create backup strategies, upgrades, and patches; monitor performance and tune SQL.
• Collaborate with cross-functional teams and cloud vendors to drive automation.
• Lead best practices for database development and strategy in coordination with stakeholders.
• Provide day-to-day admin support and participate in on-call rotations.

Skills

EDB Postgres

Postgres Distributed

AWS RDS

Postgres Architecture

PostgreSQL Install

PEM

Observability Tools

BDR Replication

Diagnostics & Tuning

PL/pgSQL

PL/Tcl

PL/Perl

PL/Python

Linux

Bash Scripting

Perl Scripting

Tools

Splunk

Dynatrace

Prometheus

Graphana

Job description

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

Postgres/Cassandra Database Engineer

12+ Months

Location: St. Louis, MO (Hybrid)

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.

On Cassandra Skills Set

Roles and Responsibilities

• Design, deploy, and maintain Cassandra clusters across development, stage, and production environments.


• Ensure high availability, fault tolerance, and disaster recovery capabilities in Cassandra deployments.


• Collaborate with application teams to understand data access patterns and optimize data models accordingly.


• Monitor and tune performance of Cassandra clusters, compaction strategies, and read/write throughput.


• Develop and implement backup, restore, and archival strategies


• Automate operational tasks using scripting languages (e.g., Python, Bash) and infrastructure-as-code tools (e.g., Ansible, Terraform).


• Participate in on-call rotations and provide production support for critical incidents.


• Define and enforce best practices for schema design, replication strategies, and consistency levels.


• Lead efforts in upgrading Cassandra versions and applying patches with minimal downtime.


• Collaborate with security teams to ensure compliance with internal and external data protection standards.


• Document architecture, configurations, and operational procedures for knowledge sharing and audit readiness.

Required Skills And Experience

• Deep understanding of Cassandra internals, including repair mechanisms.


• Proficiency in NoSQL and experience with Cassandra drivers (Java, Python, etc.).


• Experience with monitoring tools such as Prometheus, Grafana, and DataStax OpsCenter.


• Familiarity with multi-region deployments and hybrid cloud architectures.


• Strong troubleshooting and debugging skills for distributed systems.


• Experience with data migration and integration across heterogeneous systems.


• Excellent communication and collaboration skills to work across global teams and time zones.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.


• Experience with complementary NoSQL technologies (e.g., Redis, MongoDB) is a plus.


• Exposure to Kubernetes and Cassandra operators (e.g., Cass-Operator) is desirable.