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.