Ms Sql Server Developer (Canada)

Ms Sql Server Developer (Canada)

17 Nov
|
Astra North Infoteck
|
Canada

17 Nov

Astra North Infoteck

Canada

MS SQL Server Developer - Data Modeling &Performance; TuningLocation:
Toronto, ON
Experience:
8-10 Years
Role OverviewWe 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 Responsibilities1. 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 (Canada)
🏢 Astra North Infoteck
📍 Canada

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

Subscribe to this job alert:

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