Associate Director, Lead Database Developer; SQL

Pay information not provided

What is the Opportunity?

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.

• Design and optimize SQL Server databases, stored procedures, and SSIS packages for securitization analytics.
• Implement in-memory computing (e.g., Memsql/Single Store, 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.

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

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

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and 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.

Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements Analysis

Address:

City:

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

Job Type:

Regular

Pay Type:

Posted Date:

Final date to receive applications:

Note** :
** Applications will be accepted until 11:59 PM on the day prior to the Final date to receive applications date above