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, directly supporting end‑to‑end securitization and deal execution workflows.
What Will You Do
- 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 employees located across Canada and worldwide.
What Do You Need to Succeed
Must‑Have
- 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‑Have
- Experience with NoSQL databases (e.g., Elastic) or in‑memory computing tools.
- Certifications in SQL Server or cloud data platforms.
What’s in it for you
- A comprehensive Total Rewards Program, including bonuses, 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.
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more
