MS SQL Server Developer
Posted Updated 2
views
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 deep
hands-on expertise in advanced SQL programming, data modeling, and
performance optimization. The ideal candidate will have experience managing
large-scale data volumes, developing complex stored procedures/functions, and
tuning SQL queries for high-performance database environments.
Key Responsibilities
1. Database Design & Data Modeling
- Design
and maintain conceptual, logical, and physical data models for
enterprise systems.
- Create normalized and denormalized schemas, ensuring scalability, data
integrity, and performance.
- Collaborate
with architects and application teams to support data architecture
decisions.
2. SQL Programming & Development
- Develop,
enhance, and maintain stored procedures, functions, triggers, views,
packages, and complex SQL scripts.
- Implement
business logic in the database layer with efficient, reusable, and
well-structured SQL code.
- Assist
in code reviews and enforce SQL development best practices.
3. Large Data Volume Processing
- Build
and optimize ETL/ELT logic to handle large-scale datasets
efficiently.
- Write
and tune queries to support high-volume transactional and analytical
systems.
- Ensure data accuracy, quality, and consistency across all processes.
4. Advanced Querying & Optimization
- Write highly optimized, complex SQL queries for reporting, analytics, and
application workloads.
- Analyze execution plans and tune long-running queries using indexing
strategies, statistics updates, and schema refinements.
- Identify
performance bottlenecks and implement proactive database optimizations.
5. Performance Tuning & Maintenance
- Monitor
and optimize database performance including indexing, partitioning,
query tuning, and resource utilization.
- Identify
and resolve locking, blocking, deadlocks, and long-running processes.
- Recommend
improvements to database design, configurations, and operational
processes.
Required Skills & Expertise
- Advanced
proficiency in MS SQL Server development.
- Strong
experience with data modeling (ER design, schema design).
- Expertise
in stored procedures, functions, triggers, and complex SQL programming.
- Experience
handling large data volumes in enterprise environments.
- Strong
command of advanced SQL queries and performance tuning techniques.
- Understanding
of query plans, indexing strategies, and database optimization methods.
- Experience
with SQL Server tools: SSMS, Profiler, Query Store, Execution Plan
Analysis.
Preferred Experience
- Enterprise-scale
databases and analytics platforms.
- Optimizing
ETL/ELT pipelines for high-volume transactional or analytical workloads.