Senior Postgres DBA

Our Purpose

Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential.

Title and Summary

Senior Postgres DBA

Overview - DBA to handle Critical Production Oracle databases. Additional Database technology knowledge like Oracle, Redis will be an advantage .
Role- Senior Postgres Database Administrator
* Proactively monitoring database performance and troubleshooting issues
* Working cross-functionally with our engineers and analytics professionals to optimize queries, fix performance bottlenecks, improve existing schemas and design new ones
* Creating and maintaining change control and testing processes, reviewing and approving database modifications
* Have good knowledge of Replication strategy - BDR,BSR
* Reviewing development and deployment processes related to databases and identifying areas of improvement (such as online schema changes)
* Implement database changes and modifications as per the application release activities
* Can do database patching , database upgrades and implement best practice on databases .
* Knowledge of Postgres high availability , Proxy nodes will be must..
* Improving database expertise company-wide
* Additional knowledge of Oracle and Redis will be helpful as there are some critical respective modules resides on those technologies.
All about You/Experience
* Postgres DBA experience in a 24x7 production environment
* Database management and engineering experience
* Exceptional SQL development and performance tuning skills
* Experience architecting a large-scale production database platforms
* Expertise with Postgres system metrics and optimization strategies
* Familiarity with system level metrics and practical use of common Linux utilities
* Mastery of one of the following scripting languages: Python, Perl, Bash
* Understanding of virtualization and clustered environments
* Great communication skills and a passion for both teaching and learning

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. We hire the most qualified candidate for the role. In the US or Canada, if you require accommodations or assistance to complete the online application process or during the recruitment process, please contact [email protected] and identify the type of accommodation or assistance you are requesting. Do not include any medical or health information in this email. The Reasonable Accommodations team will respond to your email promptly.

Corporate Security Responsibility

All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must:

• Abide by Mastercard’s security policies and practices;

• Ensure the confidentiality and integrity of the information being accessed;

• Report any suspected information security violation or breach, and

• Complete all periodic mandatory security trainings in accordance with Mastercard’s guidelines.

In line with Mastercard’s total compensation philosophy and assuming that the job will be performed in the US, the successful candidate will be offered a competitive base salary based on location, experience and other qualifications for the role and may be eligible for an annual bonus or commissions depending on the role. Mastercard benefits for full time (and certain part time) employees generally include: insurance (including medical, prescription drug, dental, vision, disability, life insurance), flexible spending account and health savings account, paid leaves (including 16 weeks new parent leave, up to 20 paid days bereavement leave), 10 annual paid sick days, 10 or more annual paid vacation days based on level, 5 personal days, 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, gender-inclusive benefits and many more.

Pay Ranges

O'Fallon, Missouri: $94,000 - $157,000 USD