MS SQL Server Developer
Astra-North Infoteck Inc.
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 .
Reference: WJ-4483_1647973 · Posted 16 Nov 2026, 05:37 PM