Associate Director, Lead Database Developer (SQL)

RBC • Montreal, QC

11d • Onsite

About The Position

Shape the data backbone of RBC’s securitization platform by designing scalable, high-performance database solutions. As a Database Developer, you’ll architect data pipelines, optimize SQL Server environments, and enable real-time analytics for structured finance products. Your work will directly support end to end securitization workflows, and deal execution workflows.

Requirements

• 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.

Nice To Haves

• Experience with NoSQL databases (e.g., Elastic) or in-memory computing tools.
• Certifications in SQL Server or cloud data platforms.

Responsibilities

• 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 to deliver 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.
• Communicate and interact frequently with RBC partners and/or employees located across Canada and/or worldwide.

Benefits

• A comprehensive Total Rewards Program including bonuses and flexible benefits
• competitive compensation
• commissions
• stock where applicable
• Leaders who support your development through coaching and managing opportunities
• Flexible work/life balance options
• Work in a dynamic, collaborative, progressive, and high-performing team
• Ability to make a difference and lasting impact

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed