Ms Sql Server Developer
21 hours ago
Winnipeg MB, Winnipeg Census Division, MB; 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 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
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 .
#J-18808-Ljbffr
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
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 .
#J-18808-Ljbffr