DBA Infra Engineer

MasterCard; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading technology company is seeking a DBA Infra Engineer to optimize database performance and ensure data integrity. The ideal candidate will have over 5 years of experience with RDBMS and NoSQL databases, expertise in AWS, and strong collaboration skills. This role involves monitoring database performance, resolving issues, and enhancing security measures while working closely with development teams.

Qualifications

• Over 5 years of experience with RDBMS and NoSQL databases.
• Extensive hands-on experience in configuring and optimizing database software.
• Advanced expertise in security, backup and recovery.

Responsibilities

• Proactively monitoring database performance and resolving issues.
• Collaborating with engineers to enhance query performance.
• Developing and maintaining documentation and troubleshooting playbooks.

Skills

Database Performance Monitoring

SQL Tuning

Collaboration

Communication

Tools

AWS

MySQL

MongoDB

PostgreSQL

Redis

Cassandra

ElasticSearch

Job description

Job Title:

DBA Infra Engineer

Overview:

Who is Mastercard?
Mastercard is a global technology company in the payments industry. Our mission is 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. With connections across more than 210 countries and territories, we are building a
sustainable world that unlocks priceless possibilities for all.

Overview
Dynamic Yield by Mastercard is seeking a professional Infrastructure DBA skilled in optimizing system latency, ensuring data integrity, and delivering high-quality results while staying current with emerging technologies. The goal is to provide secure, scalable, and resilient infrastructure and software deployment capabilities.
The ideal candidate will excel in a collaborative environment, driving innovation and contributing to the overall success of the team.


Role
Proactively monitoring database performance, resolving issues and overseeing on-call duties.
Identifies and selects suitable technologies, and develops, constructs, maintains, and tests database systems and related software products.
Collaborating with engineers professionals to enhance query performance, address bottlenecks, and improve or design new schemas, reviewing and approving database modifications.
Assists in creating SQL tuning procedures to enhance performance and query development.
Conducting research and providing recommendations on data products, services, protocols, and standards, while also strategizing for the future growth of platform data assets.
Supports the database security posture by identifying and escalating potential issues, and by implementing risk mitigation strategies and control measures.
Oversee projects or initiatives as a seasoned individual contributor with expertise in the assigned discipline.
Developing and maintaining documentation, creating troubleshooting playbooks, testing failover and recovery plans.
Enhancing database expertise across the company.


All about you
Over 5 years of experience with RDBMS and NoSQL databases in large-scale production environments, along with expertise in optimizing infrastructure solutions using AWS technologies.
Extensive hands-on experience in configuring, patching, upgrading, and optimizing database software and related products.
Demonstrated success with extensive hands-on experience collaborating with development and infrastructure engineering teams to ensure the database tier achieves reliability, operability, scalability, performance, and security.
Advanced expertise in security, backup and recovery, architecture, networking, and administration within the assigned database discipline.
Experience working on cloud-hosted services like AWS, Azure
Experience with IAC Automation tools for building automation for DB builds, Patching and maintenance.
Experience with both RDBMS and NoSQL database technologies, including but not limited to MySQL, Redis, MongoDB, PostgreSQL, Cassandra, ScyllaDB, and ElasticSearch.
Advanced written and verbal communication skills to advocate for Database Engineering.
Experience in development working with new trends.
Experience with coding languages such as: Python, Golang, NodeJS, C++ is a plus.