IT & Software

MS SQL Server Developer

Astra-North Infoteck Inc.

Toronto · Ontario · Canada

Share this job: X Facebook WhatsApp Save job : MS SQL Server Developer

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 deephands-on expertise in advanced SQL programming, data modeling, andperformance optimization . The ideal candidate will have experience managinglarge-scale data volumes, developing complex stored procedures/functions, andtuning SQL queries for high-performance database environments .

Key Responsibilities

1. Database Design & Data Modeling

  • Designand maintain conceptual, logical, and physical data models forenterprise systems.
  • Create normalized and denormalized schemas , ensuring scalability, dataintegrity, and performance.
  • Collaboratewith architects and application teams to support data architecturedecisions .

2. SQL Programming & Development

  • Develop,enhance, and maintain stored procedures, functions, triggers, views,packages, and complex SQL scripts .
  • Implementbusiness logic in the database layer with efficient, reusable, andwell-structured SQL code .
  • Assistin code reviews and enforce SQL development best practices .
  • Buildand optimize ETL/ELT logic to handle large-scale datasetsefficiently.
  • Writeand tune queries to support high-volume transactional and analyticalsystems .
  • Ensure data accuracy, quality, and consistency across all processes.

4. Advanced Querying & Optimization

  • Write highly optimized, complex SQL queries for reporting, analytics, andapplication workloads.
  • Analyze execution plans and tune long-running queries using indexingstrategies, statistics updates, and schema refinements .
  • Identifyperformance bottlenecks and implement proactive database optimizations.

5. Performance Tuning & Maintenance

  • Monitorand optimize database performance including indexing, partitioning,query tuning, and resource utilization.
  • Identifyand resolve locking, blocking, deadlocks, and long-running processes .
  • Recommendimprovements to database design, configurations, and operationalprocesses .

Required Skills & Expertise

  • Advancedproficiency in MS SQL Server development .
  • Strongexperience with data modeling (ER design, schema design).
  • Expertisein stored procedures, functions, triggers, and complex SQL programming .
  • Experiencehandling large data volumes in enterprise environments.
  • Strongcommand of advanced SQL queries and performance tuning techniques .
  • Understandingof query plans, indexing strategies, and database optimization methods .
  • Experiencewith SQL Server tools : SSMS, Profiler, Query Store, Execution PlanAnalysis.

Preferred Experience

  • Enterprise-scaledatabases and analytics platforms.
  • OptimizingETL/ELT pipelines for high-volume transactional or analytical workloads .
#J-18808-Ljbffr

Reference: WJ-4483_1647973 · Posted 16 Nov 2026, 05:37 PM

Find more on GigBlow

This role is listed on GigBlow for discovery and search. Hiring decisions and applications are handled by the employer or their chosen application system.

MS SQL jobs in other states

Browse jobs