MS SQL Server Developer (Winnipeg)

MS SQL Server Developer (Winnipeg)

17 Nov
|
Astra North Infoteck
|
Winnipeg

17 Nov

Astra North Infoteck

Winnipeg

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 .

#J-18808-Ljbffr

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

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 (winnipeg) / winnipeg