Talent.com
MS SQL Server Developer - Data Modeling & Performance Tuning
MS SQL Server Developer - Data Modeling & Performance TuningAstra North Infoteck Inc. • Toronto, ON, ca
No longer accepting applications
MS SQL Server Developer - Data Modeling & Performance Tuning

MS SQL Server Developer - Data Modeling & Performance Tuning

Astra North Infoteck Inc. • Toronto, ON, ca
30+ days ago
Job type
  • Full-time
Job description
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 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.


Create a job alert for this search

MS SQL Server Developer - Data Modeling & Performance Tuning • Toronto, ON, ca

Similar jobs

Data Modeler

Tredence Inc.markham, on, ca
Full-time

We are looking for a detail-oriented Data Modeler to design, develop, and maintain conceptual, logical, and physical data models that support business processes and analytics.The ideal candidate wi...Show more

 • Promoted

Senior SQL Developer

Targeted TalentToronto, ON, CA
Permanent

We are looking for an experienced.Our client is a large fintech firm with a product that you've likely used many times before.You'll have the opportunity to work on an extremely large, internationa...Show more

 • Promoted

SQL Server DBA

TEEMA Solutions GroupToronto, ON, CA
Full-time

We are seeking an experienced SQL Server Database Administrator (Level 3) to join our Data Center Engineering team.This role is ideal for a technically strong and operationally mature professional ...Show more

 • Promoted

Senior Database Engineer: Hybrid SQL Server Data Migration

Altis TechnologyToronto, ON, CA
Full-time

A staffing agency is looking for a Senior Database Engineer to lead SQL Server data migration and maintain critical data systems.This hybrid role involves designing and optimizing databases to ensu...Show more

 • Promoted

Mid-Level Data Engineer with SQL Expertise

People Inc.Toronto, Ontario, Canada
Full-time

Become a vital member of a committed Data Operations team as a Data Engineer 2.Utilize your Python and SQL skills to construct efficient data integration pipelines.This role emphasizes collaboratio...Show more

 • Promoted • New!

Expert Tableau Developer: Transforming Data into Actionable Insights

Project X Ltd.Toronto, Ontario, Canada
Full-time

Advance your career as a Senior Tableau Developer, creating high-impact dashboards that drive business performance.Focus on client interactions and utilize your Tableau skills to deliver sophistica...Show more

 • Promoted

Senior Sql Server & Data/Ai Engineer

MHI Canada Aerospace, Inc.Toronto, Canada
Full-time

Seeking a Senior SQL Server & Data/AI Engineer to manage SQL Server instances, ETL processes, and design data structures for AI platforms, focusing on data layer ownership and AI enablement.Show more

 • Promoted

Senior SQL Server DBA — Hybrid, AWS, HA/DR Expert

MorningstarToronto, ON, CA
Full-time

A leading financial services firm is seeking a full-time Senior SQL Server DBA to strengthen their database administration team.The ideal candidate will possess at least 7 years of experience with ...Show more

 • Promoted

SQL Database Application Developer

Canadian Imperial Bank of CommerceToronto, Ontario, Canada
Full-time

Elevate application development by leveraging SQL and Oracle expertise.Drive end-to-end solution design, technical infrastructure management, and ensure adherence to regulatory standards.In this ro...Show more

 • Promoted

Senior MSSQL DB Architect / Developer - Data & ETL Leader

CI FinancialToronto
Full-time

A financial services provider in Toronto is seeking a skilled Senior Database Architect / Developer (MSSQL) to manage and optimize SQL databases.Responsibilities include data purging, index optimiz...Show more

 • Promoted

Senior MS SQL & SSIS Developer

Tata Consultancy ServicesToronto, ON, CA
Full-time

Drive data integration as a Senior Developer focused on MS SQL and SSIS.Bring advanced SQL skills and experience in banking domain to create effective data solutions and pipelines.You will leverage...Show more

 • Promoted

SQL Developer

Randstad DigitalToronto, ON, CA
Full-time

Must be eligible to work in Canada.Duration: 3 months initial contract to start.The SQL Developer with TOAD proficiency, focusing on Oracle database development and management, leveraging TOAD as a...Show more

 • Promoted

Senior Data Modeler — Client-Facing Data Solutions

GFT TechnologiesToronto, ON, CA
Full-time

A leading technology firm in Ontario, Toronto, is seeking an experienced data modeler to capture business requirements and translate them into logical data models.The role involves collaborating wi...Show more

 • Promoted

Oracle/MS SQL Database Engineer – Performance

ScotiabankToronto, ON, CA
Full-time

A leading North American bank is seeking a Database Developer to maintain and optimize applications on Oracle and MS SQL databases.The ideal candidate will have 6-10 years of experience, strong ski...Show more

 • Promoted

Remote Data Analytics Developer with SQL and Power BI Expertise

Cpus Engineering Staffing Solutions Inc.Toronto, ON, CA
Remote
Full-time

Elevate your career as a Data Analytics Developer, harnessing SQL and Power BI to drive data insights.Work fully remote, contributing to crucial analytics across enterprise functions.In this role, ...Show more

 • Promoted

Remote Database Solutions Analyst SQL Server & Azure Expert

CHROME TECHNOLOGIESToronto, ON, CA
Remote
Full-time

Une société de technologie recherche un Analyste en administration de bases de données pour rejoindre son équipe de Montréal.Le poste est en télétravail complet et exige plus de 5 années d'expérien...Show more

 • Promoted

Remote Database Developer for Advanced SQL and ETL Solutions

Signal49 ResearchToronto, Ontario, Canada
Remote
Full-time

Elevate your career as a Database Developer with expertise in SQL and ETL.Join a remote team focused on innovation through data management, automation, and cloud integration.This position is vital ...Show more

 • Promoted

Senior Data Architect & Modeller — Cloud Mulesoft/Azure

Rubicon PathToronto, ON, CA
Full-time

A leading consulting firm in Toronto is seeking a Senior Data Architect/Modeller to manage technical architecture across platforms.The ideal candidate will have extensive experience with Mulesoft a...Show more