Full-Time

On-Site

Associate Director, Lead Database Developer (SQL)

RRoyal Bank of Canada 1 Place Ville Marie, Suite 300, MONTRÉAL, QC0

Description

This role focuses on shaping RBC's securitization platform by designing scalable, high-performance database solutions. The Database Developer will architect data pipelines, optimize SQL Server environments, and enable real-time analytics for structured finance products, directly supporting end-to-end securitization and deal execution workflows.

What We're Looking For

Design and optimize SQL Server databases, stored procedures, and SSIS packages for securitization analytics.

Implement in-memory computing (e.g., Memsql/SingleStore, Redis) and caching strategies for real-time insights.

Collaborate with data engineers to build ETL pipelines for market data, risk metrics, and audit trails.

Ensure data integrity, security, and compliance with global regulatory standards.

Tune query performance, troubleshoot bottlenecks, and maintain high-availability database environments.

Partner with .NET and UI teams to integrate data solutions into end-to-end securitization platforms.

8+ years of experience with SQL Server, and SSIS.

Expertise in database design, normalization, and performance tuning.

Hands-on experience with ETL processes and data warehousing concepts.

Knowledge of financial data models (e.g., time-series data, risk attributes).

Understanding of cloud database solutions (Azure, AWS).

Understanding of capital markets or securitization workflows.

Ideal Candidate

Experience with NoSQL databases (e.g., Elastic) or in-memory computing tools (Nice-to-Have).

Certifications in SQL Server or cloud data platforms (Nice-to-Have).

Hard Skills

SQL Server

SSIS

Database Design

Normalization

Performance Tuning

ETL Processes

Data Warehousing

Financial Data Models

Cloud Database Solutions (Azure

AWS)

Capital Markets

Securitization Workflows

NoSQL Databases (Elastic)

In-memory computing (Memsql/SingleStore

Redis)

Big Data Management

Cloud Computing

Database Development

Data Mining

ETL Processing

Quality Management

Requirements Analysis

Soft Skills

Group Problem Solving

Collaboration

Communication

Work Hours

37.5 hours/week

Benefits

Bonuses

Flexible benefits

Competitive compensation

Commissions

Stock (where applicable)

Leaders who support development through coaching and managing opportunities

Flexible work/life balance options

Dynamic and collaborative team

Ability to make a difference and lasting impact

Special Commitments

Communicate and interact frequently with RBC partners and/or employees located across Canada and/or worldwide.

About the Company

Royal Bank of Canada

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.

Purpose-driven

Inclusive

Innovative

Collaborative

Professional

View all jobs at Royal Bank of Canada

Back to Job Board