Lead Database Engineer [DB2 LUW / DB2 on Distributed Platform]

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 Database Engineer [DB2 LUW / DB2 on Distributed Platform]

Overview
• Responsible for defining and maintaining the data architecture and associated data maintenance, integration and load processes for the organization
* Responsible for Data design, SQL development & maintenance, optimization and tuning
* Experience in working with DB2 on Distributed Platform
Experiences
• 9-12 years of overall career experience in Technology or a similar role
• Expert level experience working with DB2 LUW or similar Distributed Platform
• Experience in coding & development in relation to DB2 LUW & not only limited to Admin activities
• Experience leading a major work stream or multiple smaller work streams for a large domain initiative, often providing technical guidance and advice to project team members
• Experience creating deliverables within the global database technology domains and sub-domains, supporting cross-functional leaders in the technical community to derive new solutions
• Experience supporting automation and/or cloud delivery effort; may perform financial and cost analysis
• Experience in database architecture or other relevant IT experience, with knowledge across multiple Mastercard product lines
• Experience in leading business system application and database architecture design, influencing technology direction in range of breadth of IT areas
• Experience developing a specialization in a particular functional area (e.g., replication, performance tuning, logical and physical database design, performance and troubleshooting, data replication, backup and recovery, and data security)
Responsibilities
• Leads initiatives to build and maintain database technologies, environments, and applications, seeking opportunities for improvements and efficiencies
• Architects internal data solutions as part of the full stack to include data modeling
• Writes SQL statement procedures to optimize SQL tuning and query development
• Manages the deployment of database solutions that are optimally standardized and database updates to meet project deliverables
• Leads database security posture, which includes proactively identifying security risks and implementing both risk mitigation plans and control functions
• Oversees the resolution of chronic complex problems to prevent future database performance issues
• Supports process improvement efforts to identify and test opportunities for automation and/or reduction in time to deployment
• Responsible for complex design, development, and performance and system testing, and provides functional guidance, advice to experienced database administrators
• Mentors junior staff by providing training to develop technical skills and capabilities across the team

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.