MS SQL Server Developer

10 hours ago

Winnipeg, Manitoba, Canada Astra-North Infoteck Inc. Full-time
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 .