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

📌 Lead Database Developer (Montreal)
🏢 Akkodis
📍 Montreal