Database Engineer

mthree Recruiting Portal; Canada; On-site; CAD 70,000 - 90,000; Full time

Job summary

A major financial institution is seeking a Junior Database Engineer to help with database engineering projects, contributing to core infrastructure components across various database platforms. Ideal candidates should have at least 3 years of relevant experience and a passion for data. Strong communication skills are vital as the role involves interaction across teams. This position promises a fast-paced Agile environment with opportunities for performance optimization and testing.

Qualifications

• At least 3 years of relevant experience.
• Knowledge of development and performance optimization on major RDBMS and NoSQL.
• Experience in a fast-paced Agile environment.

Responsibilities

• Conduct database engineering projects and evaluate RDBMS products.
• Contribute to core infrastructure components for multiple database platforms.
• Participate in discussions on technical and business issues.

Skills

Database engineering projects

RDBMS technologies

Data optimization

Scripting knowledge (Python)

Basic knowledge of Unix/Linux

Tools

Sybase

DB2

MSSQL

MongoDB

Snowflake

Azure SQL

Job description

A fantastic opportunity for Junior Database Engineer, looking to build their career working with one of the world's largest financial institutions.

This role will sit within Trade Reporting & Allocations, which is part of the Institutional Securities Technology Division. It is responsible for maintaining, distributing, and reporting on trading, revenue, risk, and reference data (client, product, and pricing). As the authoritative source of key data sets, they are at the forefront of database technology and are heavily involved in data engineering, data science, data visualization, and machine learning efforts across the bank.

This area is responsible for systems and infrastructure that supports trade data extraction/enrichment, Data‑Mart creation, report generation and distribution, high performance business intelligence platforms for internal clients.

Responsibilities

• The Reference Data Development Team is tasked with database engineering projects and other strategic RDBMS product evaluations.
• The team is looking for talented data engineers to contribute on the development of its core infrastructure components on Sybase, DB2 and MSSQL database plants as well as new database platforms such as MongoDB, Snowflake and Azure SQL.
• The successful candidate must be passionate about data, have a strong interest and experience in RDBMS technologies, including enterprise‑scale, real time, highly accessed transactional databases and replication systems.
• This position offers an opportunity to participate in lively discussion on technical and business issues, meaning that strong communication skills and willingness to express their own views as well as listen to others is vital.
• The tasks will include performance optimization, testing, database engineering, platform migration, version upgrades, development and distribution on cloud platforms.
• You must be able to operate in a fast‑paced Agile environment where time to market is a key requirement without compromising on the quality and resiliency of the application.

Required Skills

• At least 3 years of relevant experience
• Knowledge (intermediate level) of development and performance optimization on major RDBMS and NoSQL (MongoDB) technologies
• Scripting knowledge (Python)
• Basic knowledge of Unix/Linux operating systems

Nice to Have

• Data modeling concepts.
• Version control, preferably with GIT.
• Knowledge of ETL products such as Talend or Informatica.
• Replication
• Experience working in geographically dispersed teams.