19 Nov
|
Astra North Infoteck
|
Winnipeg
19 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 .
- SQL Programming & Development
Develop,enhance, and maintain stored procedures, functions, triggers, views,packages, and complex SQL scripts .
Implementbusiness logic in the database layer with effective, 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.
- 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.
- 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 .
📌 MS SQL Server Developer (Winnipeg)
🏢 Astra North Infoteck
📍 Winnipeg