Posted 8 months ago
MS SQL Server Developer
@ Astra North Infoteck Inc.
Toronto, Ontario
Overview
Astra North Infoteck Inc. is hiring a full-time MS SQL Server Developer in Toronto, ON, for an experienced role of 8-10 years. The work covers data modeling, stored procedures and complex SQL, large-volume ETL/ELT processing, and query and performance tuning.
Responsibilities:
- Design and maintain conceptual, logical and physical data models
- Develop stored procedures, functions, triggers and complex SQL
- Build and optimize ETL/ELT logic for large data volumes
- Tune queries, indexes and execution plans
- Resolve locking, blocking and deadlocks
Requirements summary:
- 8-10 years of experience
- Advanced MS SQL Server development proficiency
- Strong data modeling experience
- Expertise with stored procedures and complex SQL
- Experience with SSMS, Profiler, Query Store and execution plan analysis
Tools & skills
Source and dates
Source type not verified · zoho
- Employer posting date
- 2026-02-24
- First seen by our source
- 2026-10-11
- Source record updated
- 2026-10-11
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Software development |
| Experience | 8+ years |
| Hours per week | 40 (estimated) |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Astra North Infoteck Inc.
| Field | Value |
|---|---|
| Open jobs on Jobsy | 426 |
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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.