Senior Oracle and Postgres DBA Engineer

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 Oracle and Postgres DBA Engineer

Job Title:
Senior Platform Engineer

Overview:
Who is Mastercard?

Mastercard is a global technology company in the payments sector. We power payments and provide products and services for individuals and industries all around the world. Our people, technology, data and brand provide the capabilities that drive our success. We believe in connecting people to priceless possibilities.

As a company, we know that our success is driven by the skills, experience, integrity and mindset of the talent we hire. By building an inclusive, world-class culture, our employees have once-in-a-career opportunities to be a part of teams that have a greater impact on our community and our world. We invite you to join our team to find out how you too can start something priceless.

Our Purpose

We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our decency quotient, or DQ, drives our culture and everything we do inside and outside of our company. We cultivate a culture of inclusion for all employees that respects their individual strengths, views, and experiences. We believe that our differences enable us to be a better team – one that makes better decisions, drives innovation and delivers better business results.

About the job

Title And Summary

Senior Platform Engineer (Oracle and Postgres DBA)

The Senior Database Engineer is responsible for both database build and support functions. This individual will lead large initiatives, be responsible for gathering requirements through feature requests from our development partners, perform analysis and implementation of database designs, provide consulting, and drive the best practice, governance, and standards of Database Engineering in Mastercard. This role involves fostering strong partnerships with internal and external stakeholders and managing both the operational and strategic initiatives of the team. The Senior Database Engineer champions the Mastercard Way.

Role
· Relevant more than 6 - 8 plus years of experience handling Oracle and Postgres databases.
· Responsible for installation, configuration, applying patching, DB upgrades, object creations and administration of Oracle and Postgres databases.
· Implement proactive monitoring and observability dashboards of all databases to predict and diagnose the majority of problems before they impact application performance or user experience. Create dashboard and configure alerts on OEM, Splunk, Dynatrace, and PEM.
· Configure and manage Postgres Installation, replication, upgrades, applying minor patching activities.
· Good problem solving and troubleshooting skills.
· Good working oracle knowledge with oracle RAC, data guard & Goldengate.
· Manage user access and security: Set up user accounts and ensure database security protocols are followed.
· Backup and recovery: Implement backup and recovery plans to protect data against loss.
· Undertake periodic upgrades of database schema and perform testing and verification of released database schema upgrades.
· Support the installation and configuration of Databases for high availability.
· Work on maintaining database security (roles, privileges, authentication)
· Work with auditors (ISA and QSA) to support internal and external audits (like PCI).
· Create and maintain documentation, procedures and best practice guides for database deployment and maintenance
· Uses strong writing and verbal communication skills to build awareness and to proactively promote DBA’s position in support of sound database structures, data governance and other Corporate strategies.
· Displays excellent collaborative skills with cross-functional teams.
· Provide positive customer service to internal business partners.
· Ability to multi-task and prioritize efforts.
· Ability to pick up new technologies at a quick pace.
· Ability to work with team members located in multiple geographies.

Education (preferred)
· Bachelor’s Degree in Computer Science, Information systems or equivalent experience.

About You
· DBA : 6 - 8 plus Years of Experience in the design, maintenance, and administration of Postgres and Oracle.
· Proficient with Oracle database performance tuning and knowledge of table partitioning.
· Proficient with SQL tuning, including generating and analysing performance reports like AWR.
· Proficient with backup/recovery using RMAN.
· Proficient with PL/SQL coding.
· Generating and interpreting EXPLAIN plans and providing SQL performance tuning recommendations.
· Highly knowledgeable about different access paths and join methods in Oracle and Postgres.
· Proficient with Postgres installation and configuration, particularly Postgres Plus Advanced Server from EnterpriseDB.
· Proficient with Postgres monitoring and alerting tools/processes, specifically PEM from EnterpriseDB.
· Proficient in the setup, configuration, and monitoring of PostgreSQL binary and logical data replication solutions (Binary Streaming, XDB, Bi-Directional Replication - BDR, etc.).
· Proficient with collecting diagnostics and tuning PostgreSQL as well as SQL tuning.
· Proficient with Postgres procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python) and SQL.
· Proficient in designing and supporting Postgres clustered environments.
· Experience in Postgres replication technologies.
· Excellent troubleshooting skills.
· Perform debugging, tuning, and performance enhancement, as well as automation of operational and continuous integration aspects of the Postgres platforms.
· Proficient with the Linux operating system, specifically Oracle Linux Enterprise.
· Intermediate understanding of logical and physical data models.
· Intermediate working knowledge of CI/CD, automation tool and scripting languages, including git, bitbucket, chef, ansible, XLR , Jenkins Flyway, Bash, Ksh, Perl, etc.
· Knowledge of other cloud-native and NoSQL database technologies, such as Amazon Aurora, Cassandra, and Redis is a bonus.
· Uses strong verbal and written communication skills to build awareness and to proactively promote DBA’s position in support of sound database structures, data governance and other Corporate strategies.

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.

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.