Senior Database Engineer

at  MasterCard

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.
Title and Summary
Senior Database Engineer

Overview

• Responsible for defining and maintaining the data architecture and associated data maintenance, integration and load processes for the organization

Responsibilities

• Identifies and selects appropriate technologies, develops, builds, maintains and tests database technologies, including associated software products
• Supports the development of SQL tuning statement procedures to optimize SQL tuning and query development
• Supports database security posture which includes escalating potential concerns, and implementing both risk mitigation plans and control functions
• Design, implement, and maintain scalable database solutions in AWS cloud environments.
• Optimize ETL processes using AWS Glue and AWS Lambda, SNS, AWS DMS, for data ingestion, transformation, and loading into Redshift.
• Monitor database performance, troubleshoot issues, and implement solutions to ensure optimal performance and reliability.
• Implement and manage data pipelines and workflows using AWS services such as Lambda, S3, and DynamoDB.
• Ensure data integrity, security, and compliance with organizational standards and industry regulations.
• Automate repetitive tasks and processes to improve efficiency and scalability.
• Propose and implement active monitoring system making an alert and troubleshooting notification and solution more efficient.
• Optimize the performance and system scalability of the ETL processes, data storage and database tuning to re-optimize the system and improve the overall performance.
• Document the changes and processes, with detailed architecture diagrams and description of the processes.

Experiences

• Gains exposure to automation and/or cloud delivery effort
• Knowledge in AWS cloud infrastructure and services for databases implementation and optimization.
• Experience with databases on Aurora, Postgresql and MySQL.
• Practical experience in the ETL development.
• Hands-on experience with AWS Glue, AWS Redshift, AWS DMS, AWS Lambda, Amazon EventBridge, Queues, S3, etc.
• SQL skills and experience in database design, optimization, and performance tuning.
• Experience in at least one scripting languages (Python, SQL, PySpark)
• Solid understanding of data warehousing concepts, ETL processes, and data modeling techniques.
• Ability to work independently and collaboratively in a fast-paced environment with evolving requirements.

Optional:

• AWS Data Analytics certification, AWS Solutions Architect, AWS Big Data or AWS Certified Database - Specialty , ideally.
• Experience with other data integration and ETL tools apart from AWS Glue.

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.

Responsibilities

• Identifies and selects appropriate technologies, develops, builds, maintains and tests database technologies, including associated software products
• Supports the development of SQL tuning statement procedures to optimize SQL tuning and query development
• Supports database security posture which includes escalating potential concerns, and implementing both risk mitigation plans and control functions
• Design, implement, and maintain scalable database solutions in AWS cloud environments.
• Optimize ETL processes using AWS Glue and AWS Lambda, SNS, AWS DMS, for data ingestion, transformation, and loading into Redshift.
• Monitor database performance, troubleshoot issues, and implement solutions to ensure optimal performance and reliability.
• Implement and manage data pipelines and workflows using AWS services such as Lambda, S3, and DynamoDB.
• Ensure data integrity, security, and compliance with organizational standards and industry regulations.
• Automate repetitive tasks and processes to improve efficiency and scalability.
• Propose and implement active monitoring system making an alert and troubleshooting notification and solution more efficient.
• Optimize the performance and system scalability of the ETL processes, data storage and database tuning to re-optimize the system and improve the overall performance.
• Document the changes and processes, with detailed architecture diagrams and description of the processes

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