MS SQL Server Developer
10 hours ago
Winnipeg, Manitoba, Canada
Astra-North Infoteck Inc.
Full-time
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
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 .
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 .