MS SQL Server Developer - Data Modeling & Performance Tuning

MS SQL Server Developer - Data Modeling & Performance Tuning

Location: Toronto, ON

Experience: 8-10 Years

Role Overview

We are seeking a MS SQL Server Developer with deep hands-on expertise in advanced SQL programming, data modeling, and performance optimization. The ideal candidate will have experience managing large-scale data volumes, developing complex stored procedures/functions, and tuning SQL queries for high-performance database environments.

Key Responsibilities

1. Database Design & Data Modeling

• Design and maintain conceptual, logical, and physical data models for enterprise systems.
• Create normalized and denormalized schemas, ensuring scalability, data integrity, and performance.
• Collaborate with architects and application teams to support data architecture decisions.

2. SQL Programming & Development

• Develop, enhance, and maintain stored procedures, functions, triggers, views, packages, and complex SQL scripts.
• Implement business logic in the database layer with efficient, reusable, and well-structured SQL code.
• Assist in code reviews and enforce SQL development best practices.

3. Large Data Volume Processing

• Build and optimize ETL/ELT logic to handle large-scale datasets efficiently.
• Write and tune queries to support high-volume transactional and analytical systems.
• Ensure data accuracy, quality, and consistency across all processes.

4. Advanced Querying & Optimization

• Write highly optimized, complex SQL queries for reporting, analytics, and application workloads.
• Analyze execution plans and tune long-running queries using indexing strategies, statistics updates, and schema refinements.
• Identify performance bottlenecks and implement proactive database optimizations.

5. Performance Tuning & Maintenance

• Monitor and optimize database performance including indexing, partitioning, query tuning, and resource utilization.
• Identify and resolve locking, blocking, deadlocks, and long-running processes.
• Recommend improvements to database design, configurations, and operational processes.

Required Skills & Expertise

• Advanced proficiency in MS SQL Server development.
• Strong experience with data modeling (ER design, schema design).
• Expertise in stored procedures, functions, triggers, and complex SQL programming.
• Experience handling large data volumes in enterprise environments.
• Strong command of advanced SQL queries and performance tuning techniques.
• Understanding of query plans, indexing strategies, and database optimization methods.
• Experience with SQL Server tools: SSMS, Profiler, Query Store, Execution Plan Analysis.

Preferred Experience

• Enterprise-scale databases and analytics platforms.
• Optimizing ETL/ELT pipelines for high-volume transactional or analytical workloads.