MS SQL Server Developer
- Toronto, ON, Canada
Applications open in a new tab.
Job details
- Experience
- Experience: 8-10 Years
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
The MS SQL Server Developer at Astra North Infoteck will design data models, build database logic such as stored procedures and views, and tune queries and indexes so large data systems run quickly and reliably.
Requirements
Candidates need 8-10 years of hands-on MS SQL Server development experience, strong data modeling and advanced SQL skills, and proven performance tuning on large enterprise databases.
Skills
- MS SQL Server
- T-SQL
- Stored procedures
- Functions
- Triggers
- Views
- Data modeling
- Entity-relationship design
- Schema design
- Query optimization
- Execution plan analysis
- Indexing strategies
- Partitioning
- Statistics maintenance
- SQL Server Management Studio (SSMS)
- SQL Server Profiler
- Query Store
- ETL/ELT
- Deadlock and blocking resolution
- Database performance tuning
- Code review
- Data quality
Categories
- Technology
- Software
- Data & Analytics
Keywords
- MS SQL Server
- SQL Server Developer
- T-SQL
- stored procedures
- data modeling
- performance tuning
- query optimization
- ETL
- ELT
- database developer
- SSMS
- SQL Profiler
- Query Store
- execution plans
- indexing
- data warehouse
Seniority
Senior
Tools
- MS SQL Server
- SSMS
- SQL Server Profiler
- Query Store
Languages
- English