MS SQL Developer
Capgemini•Mississauga, ON
•CA$79,000 - CA$90,000
About The Position
We are seeking an experienced MS SQL Developer to design, optimize, and maintain our enterprise Microsoft SQL Server database environments. You will build robust database architectures, write high-performance T-SQL code, and manage data integration processes. The ideal candidate ensures maximum database uptime, speed, scalability, and security.
Requirements
- Bachelor's degree in Computer Science, IT, or equivalent experience.
- 5+ years of dedicated experience using Microsoft SQL Server environments.
- Deep understanding of Transact-SQL (T-SQL) extensions and relational logic.
- Mastery of SQL Server Management Studio (SSMS), SQL Profiler, and Extended Events.
- Familiarity with programming languages like C#, .NET, or Python for database connectivity.
Responsibilities
- Write, debug, and optimize complex stored procedures, triggers, views, and user-defined functions.
- Analyze execution plans, profile query activity, and resolve deadlocks or CPU bottlenecks.
- Build and maintain data pipelines.
- Develop relational data models, configure table partitioning, and implement advanced indexing strategies.
- Develop Stored procedures to pull data formatted for Reporting Service.
Benefits
- Vacation: 12-25 days, depending on grade
- Company paid holidays
- Personal Days
- Sick Leave
- Medical, dental, and vision coverage
- Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
- Life and disability insurance
- Employee assistance programs
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
