19 Nov
|
Astra North Infoteck
|
Toronto
19 Nov
Astra North Infoteck
Toronto
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 productive, 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 (Toronto)
🏢 Astra North Infoteck
📍 Toronto