SQL Server DB Developer

Iris's Fortune 100 direct client is looking for a Senior SQL Server DB Developer in Montreal, Quebec. Please find the job description below:

Job Title: Senior SQL Server DB Developer

Location: Montreal, Quebec (Hybrid – 4 days a week in office)

Domain: Banking / Financial

• 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 standard
• sTune 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
• .In this role, you will communicate and interact frequently with RBC partners and/or employees located across Canada and/or 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

.About Iris Software Inc

.With 4,000+ associates and offices in India, the U.S.A., and Canada, Iris Software delivers technology services and solutions that help clients complete fast, far reaching digital transformations and achieve their business goals.

A strategic partner to Fortune 500 and other top companies in financial services and many other industries, Iris provides a value-driven approach - a unique blend of highly-skilled specialists, software engineering expertise, cutting-edge technology, and flexible engagement models.

High customer satisfaction has translated into long-standing relationships and preferred-partner status with many of our clients, who rely on our 30+ years of technical and domain expertise to future-proof their enterprises.

Associates of Iris work on mission-critical applications supported by a workplace culture that has won numerous awards in the last few years, including Certified Great Place to Work in India; Top 25 GPW in IT & IT-BPM; Ambition Box Best Place to Work, #3 in IT/ITES; and Top Workplace NJ-USA

.