20 Nov
|
Astra North Infoteck
|
Winnipeg
20 Nov
Astra North Infoteck
Winnipeg
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 .
- 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