Description

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, Indexing, write high-performance T-SQL code, and manage data integration processes. The ideal candidate ensures maximum database uptime, speed, scalability, and security.

Core Responsibilities

- T-SQL Development: Write, debug, and optimize complex stored procedures, triggers, views, and user-defined functions.
- Database Tuning: Analyze execution plans, profile query activity, and resolve deadlocks or CPU bottlenecks.
- ETL Pipeline Management: Build and maintain data pipelines.
- Schema Design: Develop relational data models, configure table partitioning, and implement advanced indexing strategies.




- Reporting Solutions: Develop Stored produces to pull data formatted for Reporting Service.

Required Skills & Qualifications

- Bachelor's degree in Computer Science, IT, or equivalent experience.
- 5+ years of dedicated experience using Microsoft SQL Server environments.
- Syntax Mastery: Deep understanding of Transact-SQL (T-SQL) extensions and relational logic.
- Tool Proficiency: Mastery of SQL Server Management Studio (SSMS), SQL Profiler, and Extended Events.
- Integration Skills: Familiarity with programming languages like C#, .NET, or Python for database connectivity.

📌 MS SQL Developer (Mississauga)
🏢 Capgemini
📍 Mississauga