Senior SQL Developer

Job description

Position Description:

The Senior SQL Developer will support all phases of the software development lifecycle, including understanding and validating user requirements, designing and developing SQL solutions, performing comprehensive testing, assisting with production deployments, and responding to system outages. 
This role requires strong technical expertise, problem‑solving skills, and the ability to collaborate across technology and business teams to troubleshoot and resolve issues efficiently.

 

Your future duties and responsibilities:

Application & Database Development – 40%
• Design, develop, and optimize SQL applications, systems, and software solutions for both
on‑premise and cloud environments.
• Collaborate closely with senior developers and architecture teams to translate business
requirements into technical solutions.
• Build complex SQL scripts, stored procedures, functions, and data integration processes.

Testing & Quality Assurance – 25%
• Conduct Unit, Integration, System, and Smoke Testing to validate code functionality and
stability.
• Prepare builds for QA handoff and support the resolution of issues identified during testing.
• Ensure high-quality code delivery through adherence to development standards.

Performance Optimization & Continuous Improvement – 20%
• Recommend and implement enhancements to improve system performance, data integrity,
and application efficiency.
• Monitor database performance and proactively identify optimization opportunities.

Production Support & Issue Resolution – 10%
• Provide support for Severity 1 issues and assist with resolution of Severity 2 and 3 tickets.
• Manage and meet Service Level Agreements (SLAs) for issue resolution and service delivery.
• Assist in coordinating production deployments and migrations.

Cross-Functional Collaboration – 5%
• Work with business and operations teams to troubleshoot and resolve system and data related issues.
• Communicate impacts and resolutions clearly to stakeholders

Required qualifications to be successful in this role:

Must Have

. Advanced SQL proficiency, including complex queries and performance tuning
. ANSI SQL expertise
. Strong experience with Microsoft SQL Server
. Proficient in SQL Server Management Studio (SSMS)
. Experience developing and maintaining SQL Server Integration Services (SSIS) packages
. Demonstrated ability to support all phases of the SDLC (requirements, development, testing, deployment, support)

Nice to Have

. Experience working in Agile Scrum environments
. Strong Complex Data Analysis capabilities
. General Data Analysis experience supporting business or operational needs

Ideal Candidate Profile:
The ideal Senior SQL Developer is a detail‑oriented, analytical problem solver with strong ownership of their work. They thrive in collaborative environments and bring a proactive approach to optimizing database performance and improving application functionality. This individual can balance development responsibilities with production support, communicates effectively with technical and business partners, and maintains a high standard of code quality and systems reliability.

CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $60,0000–$120,000. This role is an existing vacancy.

Skills:

·  Data Analysis
·  SQL
·  SSIS

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.

To learn more about accessibility at CGI, contact us via email . Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our team—one of the largest IT and business consulting services firms in the world.