Publié il y a 8 mois
MS SQL Server Developer
@ Astra North Infoteck Inc.
Toronto, Ontario
En bref
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.
Responsabilités :
- 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
Résumé des exigences :
- 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
Outils et compétences
Source et dates
Type de source non vérifié · zoho
- Date publiée par l’employeur
- 2026-02-24
- Première détection par notre source
- 2026-10-11
- Mise à jour du dossier source
- 2026-10-11
Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.
Détails du poste
| Niveau | Senior |
| Domaine | Développement logiciel |
| Expérience | 8 an(s) et plus |
| Heures par semaine | 40 (estimé) |
| Déplacements | avion : aucun · route : aucun |
| Milieu de travail | Bureau |
| Position | Surtout assis |
| Exigences physiques | physique faible · ordinateur élevé |
| Langues | English |
Résumé et détails rédigés par l’IA à partir de l’offre; l’offre de l’employeur fait foi.
Astra North Infoteck Inc.
| Champ | Valeur |
|---|---|
| Offres sur 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
Visible seulement par vous. Conservé sur cet appareil, et dans votre compte une fois connecté.