MS SQL Server Developer

Astra-North Infoteck Inc.

Toronto

On-site

CAD 110,000 - 150,000

Full time

14 days+

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Astra-North Infoteck Inc. invites an MS SQL Server Developer to join our Toronto team. You will leverage deep hands-on expertise in advanced SQL programming, data modeling, and performance optimization to support large-scale data environments.

You will design flexible data models, implement robust database logic, and optimize ETL/ELT processes while ensuring data accuracy, quality, and high performance across transactional and analytical workloads.

Qualifications

  • Advanced SQL programming and data modeling
  • Experience in high-performance database environments
  • Proficiency with enterprise-scale data volumes and ETL/ELT pipelines

Responsibilities

  • Database design & data modeling for enterprise systems (conceptual, logical, physical)
  • Develop, optimize and maintain stored procedures, functions, triggers, views and complex SQL scripts
  • Analyze execution plans and tune queries using indexing, statistics updates and schema refinements
  • Monitor and optimize database performance, resolve locking and deadlocks, and improve operational processes

Skills

MS SQL Server
Data modeling
Performance tuning
Stored procedures
ETL/ELT
Query optimization
Execution plans
Large data volumes

Tools

SSMS
Profiler
Query Store
Execution Plan Analysis

Job description

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Oracle Database Developer
Senior Oracle Database Developer

Bevertec • Toronto

On-site
CAD 124,000 - 138,000
Senior Database Administrator (DBA) – SQL Server
Senior Database Administrator (DBA) – SQL Server

Strategize it Inc. • Toronto, Winnipeg

Hybrid
CAD 90,000 - 120,000
Data & Reporting Analyst - SQL (Power BI and Tableau)
Data & Reporting Analyst - SQL (Power BI and Tableau)

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 70,000 - 90,000
Remote SQL Developer: T-SQL, SSIS & ETL Expert
Remote SQL Developer: T-SQL, SSIS & ETL Expert

Two95 International, Inc • Town of Trenton

Remote
USD 90,000 - 120,000
Database Administrator - Senior (SQL)
Database Administrator - Senior (SQL)

Bevertec • Toronto

On-site
CAD 110,208 - 117,096
SQL Server DBA
SQL Server DBA

Astra-North Infoteck Inc. • Brampton

Hybrid
CAD 90,000 - 120,000
Data Modeler, Microsoft Stack
Data Modeler, Microsoft Stack

DevEngine Ltd. • Canada

Remote
CAD 70,000 - 110,000
Senior Database & ETL Developer (Ongoing)
Senior Database & ETL Developer (Ongoing)

TGT Solutions Inc. • Calgary

On-site
CAD 42,000 - 70,000
HANA SQL Developer | Data & DB Concepts Expert
HANA SQL Developer | Data & DB Concepts Expert

Tata Consultancy Services Limited • Toronto

On-site
CAD 70,000 - 110,000
Data Architect/Modeler for CDE Long-Term Solution
Data Architect/Modeler for CDE Long-Term Solution

Lancesoft • Toronto

Hybrid
CAD 124,000 - 193,000