Title: Lead Database Developer (SQL Server)

Position Type: Full-time, Permanent

Location: Montreal, QC

Working Model: Hybrid - up to 4 days per week in office (**currently only in 2 days per week)

Compensation: $130,000 - $155,000 per annum plus bonus and benefits

About Our Client

Our client is a leading global financial institution undergoing a significant technology modernization initiative within its Capital Markets division.

As part of a multi-year strategy to bring critical technology capabilities in-house, the organization is building a high-performing engineering team focused on modernizing and enhancing a core securitization platform. This business-critical platform supports deal execution, financing workflows, reporting, analytics, and data-driven decision making across a growing business function.

The team is investing heavily in cloud technologies, AI-driven solutions, document processing, reporting capabilities, and next-generation data architecture. This role presents an exciting prospect to join a high-visibility initiative at an early stage and help shape the future of a strategic platform.

About the Opportunity

We are seeking a Lead Database Developer to play a key role in designing, optimizing, and evolving the data foundation of a mission-critical Capital Markets platform.

This individual will serve as the team's database subject matter expert, driving database architecture, performance tuning, ETL development, cloud migration initiatives, and data modelling best practices.

The successful candidate will work closely with software developers, AI engineers, business analysts, project managers, and business stakeholders to deliver scalable, secure, and high-performing data solutions that support complex financial workflows and real-time analytics.

This is an excellent chance for a senior database professional who enjoys solving complex technical challenges, influencing technology direction, and working within a modern, collaborative engineering environment.

What You'll Do

- Design, develop, and optimize Microsoft SQL Server databases supporting mission-critical business applications
- Create and maintain complex stored procedures, functions, views, triggers, and database objects
- Lead database performance tuning efforts through indexing strategies, execution plan analysis, and query optimization
- Design scalable data models that support transactional processing, analytics, reporting, and audit requirements




- Develop and enhance ETL processes and data integration solutions utilizing SSIS and related technologies
- Partner with software development teams to deliver robust, data-driven application solutions
- Design and implement data warehousing and reporting solutions
- Support cloud database initiatives across AWS and Azure environments
- Collaborate with cross-functional teams to define data standards, governance practices, and architecture principles
- Troubleshoot production issues and drive root cause analysis for complex database-related challenges
- Implement high-availability, disaster recovery, backup, and security best practices
- Evaluate and implement modern database technologies, including caching and in-memory data solutions
- Support initiatives involving AI, document processing, and advanced analytics
- Mentor junior team members and provide technical leadership across database-related projects
- Contribute to long-term modernization and platform transformation efforts

What You Bring

Must-Have Qualifications

- 8+ years of hands-on experience with Microsoft SQL Server
- Strong expertise in database design, data modelling, and relational database architecture
- Advanced knowledge of T-SQL development, stored procedures, and query optimization
- Experience with SQL Server Integration Services (SSIS) and ETL development
- Strong understanding of indexing, execution plans, performance tuning, and troubleshooting techniques
- Hands-on experience with data warehousing concepts and enterprise reporting environments
- Experience supporting high-volume transactional systems in complex enterprise environments
- Exposure to cloud database solutions within AWS and/or Azure
- Robust understanding of data governance, security, auditability, and compliance requirements
- Excellent problem-solving, communication, and stakeholder management skills
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline

Nice-to-Have Qualifications

- Experience within Capital Markets, Banking, Financial Services,



FinTech, or Payments environments
- Knowledge of securitization, structured finance, risk reporting, or financial data models
- Experience with NoSQL database technologies such as Elasticsearch
- Exposure to in-memory databases, caching technologies, Redis, or SingleStore
- Experience supporting AI, machine learning, analytics, or document processing initiatives
- SQL Server, Azure, AWS, or cloud-related certifications
- Experience participating in large-scale platform modernization projects
- Previous experience in a technical leadership or lead developer capacity

What You'll Love About This Opportunity

- Opportunity to join a strategic Capital Markets technology initiative at an early stage
- Play a key role in building and modernizing a critical business platform
- High visibility and direct interaction with business and technology leadership
- Influence database architecture, engineering standards, and long-term technology direction
- Work alongside talented engineers across software development, AI, data, and analytics teams
- Exposure to cloud modernization, AI-driven innovation, and advanced data platforms
- Collaborative environment focused on innovation, continuous improvement, and technical excellence
- Strong career growth potential as the team expands over the coming years
- Opportunity to make a meaningful impact within a leading global financial institution

How to Apply

If you are interested in learning more, don't hesitate to apply today or check out Akkodis Canada website for more opportunities.

Important

We thank all applicants for their interest in this opportunity. Only candidates meeting the above qualifications will be contacted for further discussions.

Akkodis Canada will never share your resume or any personal details without your explicit consent.

We thank all applicants for their interest in this opportunity. Only candidates meeting the above qualifications will be contacted for further discussions.

Our Commitment:

At Akkodis, part of The Adecco Group, our purpose is simple: to make the future work for everyone. We live our values, Passion, Collaboration, Inclusion, Courage, and Customers at Heart, by fostering a workplace where diversity is celebrated and every voice matters. We encourage applications from individuals of all backgrounds and identities. Together, we’re making the future work for everyone.

📌 Lead Database Developer (SQL Server) (Montreal)
🏢 Akkodis
📍 Montreal