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