Lead Database Developer

Position: Lead Database Developer Location: Montreal, QC Work Model: Hybrid Salary Range: $140,000 - $ 150,000 Position Overview We are seeking an experienced Lead Database Developer to design, develop, and optimize high-performance database solutions supporting enterprise applications. This role is ideal for a senior SQL Server professional with expertise in database architecture, performance tuning, ETL development, and scalable data solutions. You will work closely with application developers and technology teams to build reliable, secure, and high-performing database environments. Key Responsibilities Design, develop, and optimize Microsoft SQL Server databases, stored procedures, functions, and SSIS packages. Build and maintain scalable ETL processes to support enterprise reporting, analytics, and operational data needs. Design efficient database schemas, ensuring data integrity, normalization, and optimal performance. Monitor and tune SQL Server performance by optimizing queries, indexes, and execution plans. Implement high-availability and disaster recovery strategies for critical database environments. Collaborate with application development teams to integrate database solutions into enterprise applications. Support cloud-based database initiatives and optimize database performance across hybrid environments. Troubleshoot database issues, identify bottlenecks, and recommend performance improvements. Ensure compliance with organizational data governance, security, and regulatory requirements. Document database architecture, development standards, and operational procedures. Required Qualifications 8+ years of experience developing and supporting Microsoft SQL Server databases. Strong expertise in SQL Server, T-SQL, stored procedures, triggers, views, and database design. Hands-on experience with SQL Server Integration Services (SSIS). Extensive experience with database performance tuning, indexing strategies, and query optimization. Strong understanding of database normalization, relational database design, and data modeling. Experience developing ETL processes and working with data warehousing concepts. Experience supporting cloud-based database platforms, including Azure and/or AWS. Strong troubleshooting, analytical, and problem-solving skills. Excellent communication and collaboration skills within cross-functional technical teams. Preferred Qualifications Experience with NoSQL databases such as Elasticsearch or other document-based databases. Exposure to in-memory databases or caching technologies such as Redis or SingleStore. SQL Server, Azure, or cloud platform certifications. Experience working in Agile development environments. Familiarity with .NET applications and integrating database solutions with enterprise software. Ideal Candidate The ideal candidate is a senior SQL Server developer who combines deep database development expertise with strong performance optimization skills. They are passionate about designing scalable, reliable database solutions, building efficient ETL processes, and partnering with development teams to deliver high-quality enterprise applications. This role is best suited for someone who thrives in a collaborative environment and enjoys solving complex database challenges. 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, we’re committed to making 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.

Design, develop, and optimize high-performance Microsoft SQL Server databases and scalable ETL processes. Collaborate with technical teams to ensure data integrity, security, and optimal performance across hybrid environments.

Requires 8+ years of experience with SQL Server, T-SQL, and SSIS, with a strong focus on performance tuning and data modeling. Experience with cloud platforms like Azure or AWS is required, while NoSQL and caching technologies are preferred.

Identified from the job description. Confirm important requirements above.

• Microsoft SQL Server
• T-SQL
• SSIS
• Database Architecture
• Performance Tuning
• ETL Development
• Data Modeling
• Azure
• AWS
• Query Optimization
• Database Normalization
• NoSQL
• Elasticsearch
• Redis
• SingleStore
• Agile

• Data & Analytics
• Software
• Technology
• Engineering
• Finance & Accounting

Minimum experience

10+ years

Apply by

Aug 28, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level

Application method

Direct apply is available