MS SQL Server Developer (Toronto)

MS SQL Server Developer (Toronto)

17 Nov
|
Astra North Infoteck
|
Toronto

17 Nov

Astra North Infoteck

Toronto

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 productive, 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.

📌 MS SQL Server Developer (Toronto)
🏢 Astra North Infoteck
📍 Toronto

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: ms sql server developer (toronto) / toronto

Subscribe to this job alert:

Get the latest job offers by email for: ms sql server developer (toronto) / toronto