16 Nov
|
Astra North Infoteck
|
Ontario
16 Nov
Astra North Infoteck
Ontario
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 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.
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
📌 MS SQL Server Developer (Ontario)
🏢 Astra North Infoteck
📍 Ontario