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.

Browse jobs