Lead Software 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

Lead Software Engineer

Overview
The Database Engineering team is looking for a Lead Database Engineer to drive our customer experience strategy forward by consistently innovating and problem-solving. The ideal candidate is passionate about the customer experience journey, highly motivated, intellectually curious, analytical, and possesses an entrepreneurial mindset. Provide Oracle Database support for MasterCard Application databases in On-Prem and Cloud databases. As a Database Engineer, will play a critical role in designing, implementing, and maintaining Mastercard’s database systems. Collaborate with cross-functional teams to understand data requirements, optimize database performance, and ensure data integrity and security along with maintaining best practices.

Role
• Experience in configuring, patching, upgrading and/or optimizing database software and related products.
• Understand database security topics including database users, roles, and privileges.
• Intermediate skills in testing, diagnosing, and resolving database issues.
• Write and support the development of efficient and performant PL/SQL code and related SQL statements.
• Participates in the development, maintenance, testing, implementation and support of assigned database technologies and associated software products.
• Partners with technology teams and customers to understand business needs and can communicate solutions in business terms with mentoring.
• Basic to intermediate performance and tuning skills with the ability to identify, respond and resolve database performance issues; communicates database performance resolution to technical teams.Oracle Database knowledge is must. Should be able to handle disaster scenarios.Additional scripting knowledge would be add on.
• Successfully follow change management, problem management and incident management processes and procedures.
• May manage smaller project/initiatives with specialized knowledge within assigned discipline.
• Good written and verbal communication skills to promote Database Engineering in support of sound database structures, data governance, standards, and procedures to internal and external teams.
• Good documentation skills to contribute to Database Engineering processes and procedures.
• Ability to learn Mastercard best practices in planning, coordinating, implementing, and maintaining database solutions.
• Communicate, collaborate, and work effectively in a global environment.
• Ability to be on-call after hours and weekends.

All About YouThe ideal candidate for this position should:
1. Have Bachelor's degree in Computer Science, Information Technology, or related field.
2. In depth experience with Oracle 19c (or later) database versions.
3. In depth proficiency in Oracle development, using SQL and PL/SQL.
4. In depth experience with Oracle tools such as SQL*Plus, SQL Developer, and Oracle Enterprise Manager.
5. Strong understanding and experience in database architecture, indexing, partitioning and query optimization.
6. Experience with database design, normalization, data modeling and optimization techniques.
6. Knowledge and experience with Oracle AQ.
7. Proven work experience as a Database Engineer or similar role with expertise in managing Oracle databases.
8. Strong understanding of database management systems (DBMS), especially Oracle Database.
9. Experience with developing Flyway scripts to implement Oracle database schemas
11. Proficiency in working with Windows and Linux based operating system.
12. Advanced skills in monitoring and reporting tools such as Dynatrace and Splunk.
13. Familiarity with database security best practices such as implementation of SSL/TLS, TDE (Transparent data encryption), Access management principles along with authentication mechanisms.
14. Managing database recovery and availability principles by defining and implementing database backup and recovery principles to guarantee point in time recovery for different database technologies.
15. Defining and implementing database resiliency strategy to test and account for different failure scenarios such as network, disaster, power, etc. Corporate Security Responsibility Every person working for, or on behalf of, Mastercard is responsible for information security. All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and therefore, it is expected that the successful candidate for this position 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.
Posting windows may change based on the volume of applications received and business necessity. Candidates are encouraged to apply expeditiously

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.