Lead PostgreSQL Engineer
Mastercard · O'Fallon, MO · 3 wk ago
Hybrid$122k–$207k/yrFull-time
About the Role
The Lead Platform Engineer, Database Engineering is responsible for the strategy, architecture, implementation, lifecycle management, and continuous improvement of Mastercard's enterprise database platforms. This individual will serve as the technical lead for PostgreSQL platforms while contributing to the modernization and support of Oracle, Cassandra, MongoDB, Redis, and cloud-native database technologies. The role requires expertise in platform engineering, cloud infrastructure engineering, Infrastructure as Code, automation, distributed systems, performance optimization, security, and operational excellence.
Responsibilities
- Lead the design, implementation, operation, and continuous improvement of enterprise database platforms.
- Serve as the primary technical leader for PostgreSQL, including Open Source PostgreSQL, EnterpriseDB (EDB), and AWS Aurora PostgreSQL.
- Design highly available, secure, scalable, and resilient database solutions using modern platform engineering principles.
- Engineer and support cloud infrastructure and cloud-native database services across AWS and hybrid environments.
- Drive Infrastructure as Code (IaC) adoption and platform automation using Terraform, CloudFormation, Ansible, Chef, XLR, and related technologies.
- Build and enhance CI/CD integration for database provisioning, deployments, upgrades, testing, and operational workflows.
- Develop automation solutions that improve platform velocity, reliability, consistency, and operational efficiency.
- Design and maintain database infrastructure supporting distributed systems, microservices-based applications, and cloud-native architectures.
- Perform advanced troubleshooting, root cause analysis, performance analysis, capacity planning, tuning, backup, recovery, and disaster recovery planning.
- Establish monitoring, observability, reliability, and operational health frameworks for database services.
- Collaborate with software engineering and platform teams to provide architecture guidance, technical consultation, and platform support.
- Define and implement database engineering standards, configuration management practices, governance processes, and operational procedures.
- Ensure database platforms meet security requirements, risk controls, audit standards, regulatory requirements, and compliance obligations.
- Evaluate emerging database technologies and contribute to platform roadmaps, proof-of-concepts, and modernization initiatives.
- Lead complex technical initiatives spanning multiple teams and regions.
- Mentor engineers and promote engineering excellence through coaching, knowledge sharing, and technical leadership.
- Champion Agile delivery practices, operational excellence, and continuous improvement across database engineering services.
Requirements
- 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.
- Experience with CI/CD pipelines and automated deployment methodologies.
- Strong hands-on knowledge of Infrastructure as Code (IaC) and configuration management tools including Terraform, CloudFormation, Ansible, Chef, and related technologies.
- Experience building and supporting distributed systems and cloud-native platforms.
- Working knowledge of container platforms such as Kubernetes and OpenShift.
- Strong Linux/Unix system administration and software scripting skills.
- Experience with software programming and automation development.
- Understanding of microservices architectures and modern platform engineering practices.
- Expertise in troubleshooting, performance analysis, root cause analysis, and operational problem solving.
- Experience implementing security requirements, risk controls, platform hardening, and compliance standards.
- Experience supporting enterprise database technologies including Oracle, Cassandra, MongoDB, Redis, and cloud-native database services.
- Strong stakeholder management, communication, collaboration, and influencing skills.
- Experience leading strategic initiatives and driving technology modernization across geographically distributed teams.
- Demonstrated commitment to Agile methodologies, IT Service Management, and operational excellence.
Benefits
- Insurance (including medical, prescription drug, dental, vision, disability, 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, and 5 personal days (pro-rated based on date of hire).
- 10 annual paid U.S. observed holidays.
- 401k with a best-in-class company match.
- Deferred compensation for eligible roles.
- Fitness reimbursement or on-site fitness facilities.
- Eligibility for tuition reimbursement.
Pay
O'Fallon, Missouri: $122,000 - $207,000 USD