SQL Developer - Senior
Description
Join CGI!
Do you want to be part of one of the five largest IT and business process companies in the world? At CGI, we are looking for a SQL Programmer to work on a major international banking sector project.
Requirements:
- Technician, technologist, or professional in computer science, Software Engineering, or related fields.
- Conversational English (B2 level or higher).
- 6+ years of experience as a SQL Developer.
- 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)
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.
Nice to have:
- Experience working in Agile Scrum environments
- Strong Complex Data Analysis capabilities
- General Data Analysis experience supporting business or operational needs
Complementary Skills:
- 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.
!
#LI-AD3
Skills
AgileSql ServerScrumSQL