Senior Application Database Developer(PostgreSQL)

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

Job summary

An established industry player is seeking a Senior Application Database Developer to enhance their database solutions. This role involves collaborating with product and development teams to design robust data models and optimize database performance. You will lead initiatives requiring specialized database knowledge, implement security measures, and contribute to CI-CD processes. Join a forward-thinking company that values innovation and teamwork, where your expertise will help shape the future of data management in a dynamic environment. If you're passionate about database technologies and eager to make an impact, this opportunity is for you.

Qualifications

• Strong experience with PostgreSQL and other relational databases.
• Proficiency in DDL and DML with a focus on performance tuning.

Responsibilities

• Design and implement data models for high-throughput applications.
• Lead database projects and provide technical guidance to teams.
• Optimize database performance and ensure security compliance.

Skills

PostgreSQL

Database Security

Query Optimization

Data Manipulation Language (DML)

Data Definition Language (DDL)

Performance Tuning

Agile Methodologies

Scripting Languages (Unix shell, Ruby, Python)

Education

Bachelor's Degree in Computer Science or related field

Tools

Azure Database for PostgreSQL

IBM Db2

Flyway

Liquibase

Azure Cosmos DB

Snowflake

Jenkins CI/CD

Dynatrace

Splunk

Docker

Job description

Job Title: Senior Application Database Developer

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.

To drive our future growth, we are scaling our platform and building new products. Ethoca’s growth is explosive, and only great problem-solvers, collaborators, and thinkers can help us take it to the next level. If that sounds like you then keep reading!

We believe in decoupled, message-driven, and distributed systems. We strive to keep codebases small and manageable. We’re interested in reactive design patterns that will make our systems more resilient and responsive, yet remain elastic to change. As we proceed through our technology roadmap, we are evaluating and implementing new community endorsed technologies for every tier of our platform. Our backend tiers are presently JVM-based. We are using or considering technologies like Kafka, Spring boot, ElasticSearch, Angular 10, Bootstrap, Chef, Ansible, Openstack, Docker and so on.

We want to hire a Senior Application Database Developer (PostgreSQL) who has a proven record of delivering high-quality database solutions by using the appropriate industry leading products, patterns, and practices! You will also work with developers from various teams to code SQL queries and provide necessary recommendations on optimizing query plans.

Role

1. Work closely with product and development teams to design and implement data model and infrastructure solution for a high-throughput distributed application.
2. Lead moderate project or initiative where specialized database knowledge is required.
3. Provide technical leadership and/or assistance to scrum teams on database development, maintenance, deployment, and releases support.
4. Implement and maintain robust security measures across database systems, adhering to security and compliance standards.
5. Perform runtime impact analysis (i.e. query optimization, performance analysis, index management, etc.) to ensure database systems are running at high performance level.
6. Contribute to the CI-CD pipeline and automate routine tasks using scripting tools.
7. Contribute to Database Engineering process and procedures documentation.
8. Configuring, patching, upgrading, and optimizing database software and related products.
9. Provide technical guidance and support to customer service and product team, helping them leverage data efficiently for decision making.

All About You

1. Strong experience working with Azure Database for PostgreSQL, IBM Db2, and other relational databases.
2. Experience with DB Change Management Tools (Flyway and Liquibase).
3. Experience with Azure Cosmos DB, and/or Snowflake.
4. Familiar with Agile (Scrum/Kanban), Jenkins CI/CD pipeline and automation.
5. Strong proficiency on data definition language (DDL) and data manipulation language (DML).
6. Experience in security, backup/recovery, architecture, networking, and administration of database disciplines.
7. Strong performance and tuning skills with the ability to identify, respond, and resolve database performance issues and communicate database performance resolution to team or stakeholders.
8. Experience with Dynatrace or Splunk.
9. Experience with scripting languages like Unix shell, Ruby, and Python.

#LI-FT1