Lead PostgreSQL Engineer

Job Description

Company: Mastercard
Location: O’Fallon, Missouri
Workplace Type: Hybrid
Employment Type: Full-time
Pay / Compensation: $122,000 – $207,000 USD

About the Role

The Database Engineering team at Mastercard is seeking a Lead Platform Engineer to lead the design, engineering, automation, modernization, and operational excellence of enterprise database platforms. This role combines deep expertise in PostgreSQL database technologies with platform engineering practices to build and operate secure, scalable, and highly available database services powering global applications. You will provide technical leadership, define engineering standards, drive automation initiatives, and advance cloud-native database capabilities.

What You’ll Do / Key Responsibilities

• Platform Leadership: Lead the design, implementation, operation, and continuous improvement of enterprise database platforms, serving as the primary technical leader for PostgreSQL, EnterpriseDB (EDB), and AWS Aurora PostgreSQL.
• Cloud Infrastructure Engineering: Engineer and support cloud infrastructure and cloud-native database services across AWS and hybrid environments.
• Automation & IaC: Drive Infrastructure as Code (IaC) adoption and platform automation using Terraform, CloudFormation, Ansible, Chef, and XLR.
• CI/CD Integration: Build and enhance CI/CD integration for database provisioning, deployments, upgrades, testing, and operational workflows.
• Troubleshooting & Performance: Perform advanced troubleshooting, root cause analysis, performance analysis, capacity planning, tuning, backup, recovery, and disaster recovery planning.
• Observability & Standards: Establish monitoring, observability, reliability, and operational health frameworks while defining database engineering standards and configuration management practices.
• Collaboration & Mentorship: Collaborate with software engineering and platform teams to provide architecture guidance, mentor engineers, and promote engineering excellence.

Requirements & Qualifications

• Deep expertise in PostgreSQL architecture, administration, replication, performance tuning, high availability, disaster recovery, and security.
• Strong experience with AWS Aurora PostgreSQL and EnterpriseDB (EDB).
• Expertise in cloud infrastructure engineering and enterprise-scale platform operations.
• Strong hands-on knowledge of Infrastructure as Code (IaC) and configuration management tools including Terraform, CloudFormation, Ansible, and Chef.
• Strong Linux/Unix system administration and software scripting skills, alongside understanding of container platforms such as Kubernetes and OpenShift.
• Experience supporting enterprise database technologies including Oracle, Cassandra, MongoDB, Redis, and cloud-native database services.
• Strong stakeholder management, communication, and leadership skills with a demonstrated commitment to Agile methodologies and operational excellence.

Preferred / Bonus Qualifications (if applicable)

• Experience leading strategic initiatives and driving technology modernization across geographically distributed teams.
• Understanding of microservices architectures and modern platform engineering practices.

Benefits & Perks (if applicable)

• Comprehensive insurance including medical, prescription drug, dental, vision, disability, and life insurance.
• Flexible spending account and health savings account.
• Paid leaves including 16 weeks of new parent leave and up to 20 days of bereavement leave.
• 80 hours of Paid Sick and Safe Time, 25 days of vacation time, 5 personal days, and 10 annual paid U.S. observed holidays.
• 401(k) with a competitive company match and deferred compensation for eligible roles.
• Fitness reimbursement, on-site fitness facilities, and tuition reimbursement eligibility.

Mastercard is a merit-based, inclusive, equal opportunity employer that considers applicants without regard to gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.