Ms Sql Server Developer
Astra-North Infoteck Inc.
MS SQL Server Developer - Data Modeling &Performance TuningLocation:
Toronto, ON
Experience:
8-10 Years
Role OverviewWe 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 Responsibilities1. 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
efficient, 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
Toronto, ON
Experience:
8-10 Years
Role OverviewWe 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 Responsibilities1. 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
efficient, 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
Vacancy posted 43 minutes ago
Similar jobs that could be interesting for youBased on the Ms Sql Server Developer in Winnipeg, MB vacancy
- Job Description : Strong expertise in SSIS, SSRS, and Power BI (Desktop & Service) with knowledge of DAX, Power Query, and MDX. Proficient in T-SQL, database concepts, ETL processes, and data warehousing principles. Skilled in data modeling, performance optimization...Suggested
- MS-SQL database design and application development define this Systems Analyst assignment... ...remediation.This experienced Application Developer and Analyst will support the Bitumen Royalty... ...: Five years with MS SQL Server and Management StudioFive years with data...SQL Server
- Build reliable database solutions at RIMEX in Langley using SQL Server, T-SQL, and performance tuning for TyreSense applications.This hands-on Database Developer role supports the continued evolution of the TyreSense product line. You will design relational databases, develop...SQL Server
- ...AMWe are seeking a talented and solutions-oriented Full Stack Developer to join our team. In this role, you will be responsible for... ...candidate combines strong application development skills with advanced SQL Server expertise and enjoys collaborating with business users to...SQL Server
$90 - $110 per hour
Senior Microsoft 365 Software Developer Location: National Capital Region, ON/QC – Hybrid/Remote within CanadaCompensation: $90-110/hr... ...enterprise platforms, including .NET Framework, SharePoint, SQL Server, Dynamics 365, IIS, Windows Server, and existing Azure infrastructure...SQL ServerLong term contractFull timeContract workWork at officeRemote work- Key Skills: T-SQL +Azure SQL MI, Performance Tuning + Always On + HA/DR + Backup/Recovery... ...Administer andsupport Microsoft SQL Server and Azure SQL Managed Instance environments... ...indexing strategies, and execution plans. Develop and supportETL processes using SSIS and Azure...SQL Server
- ...is informed by our values and commitment to protecting and saving lives. Job Summary - THIS IS A TERM POSITION The Specialist, MS&T role is a member of the Manufacturing Sciences & Technology (MS&T) department providing technical expertise to support Production (manufacturing...Work at officeFlexible hours
- ...do. About the Position We are seeking a Senior Full-Stack Developer with proven expertise in Microsoft-stack web applications to... ...and 4.7). ~5+ years of professional experience with Microsoft SQL Server/T-SQL. Database skills are crucial for this position, and you must...SQL ServerFull timeRemote workTrial period
- ...availability and data integrity for CAE applications through Oracle, SQL Server, recovery, and diagnostic support in Halifax.This Application... ...during outages and maintenanceAbility to collaborate with developers, infrastructure, testers, and usersAbility to obtain security and...SQL Server
- Microsoft SQL Server expertise defines this Database Administrator role, covering performance tuning, security, backup, and enterprise database... ...AWS and Microsoft Azure.This Database Administrator designs, develops, administers, secures, and optimizes enterprise databases...SQL Server
- Senior SQL Server Database Administrator in Toronto, ON, supporting FSRA database operations through performance, security, backup, and recovery expertise.This full-time position provides senior technical leadership across FSRA database systems. You will design, configure, maintain...SQL ServerFull time
- SQL Server administration and performance tuning define this Montreal hybrid role, combining three onsite days with two remote days each week... ....Key Responsibilities: Configure and maintain database servers and processesInstall and patch SQL Server 2016 through 2019Handle...SQL ServerRemote work2 days per week
- Lead SQL Server administration remotely from Toronto, applying performance tuning and high availability expertise across a large on-premises environment.This Database Administrator will structure a rapidly grown estate supporting an established recovery-audit firm. You will...SQL ServerRemote work
- Lead enterprise SQL Server operations in Vancouver with hands-on database administration, performance tuning, and high-availability expertise. Coordinate technical delivery across teams.This Technical Lead role requires 10–15 years of Microsoft SQL Server production support...SQL Server
- Database Reliability Engineering, SQL Server, and Azure SQL expertise define this GIRO opportunity supporting production environments worldwide. Flexible working hours include remote work.As a Database Administrator, you will maintain, operate, and support production databases...SQL ServerRemote workWorldwideFlexible hours
- Manage Oracle, SQL Server, and AWS RDS platforms from Toronto in a hybrid model, focusing on automation, availability, and performance.This Database Administrator supports enterprise environments across on-premises and cloud platforms. The role requires Oracle, Microsoft SQL...SQL Server
- Administer SQL Server and Azure SQL Managed Instance environments in Brampton, Ontario, using T-SQL and performance tuning skills within a hybrid schedule.This SQL Server DBA role requires seven or more years of SQL Server DBA and database development experience. You will support...SQL Server
- SQL Server, Azure Arc et intégration de données définissent ce poste d’administrateur principal de base de données à l’OCRI. L’environnement de travail est hybride.Vous soutiendrez la performance, la fiabilité et l’intégrité des systèmes financiers de l’OCRI. Le poste exige...SQL Server
- ...Seeking an experienced Senior Software Developer to design, develop, test, and maintain enterprise-grade web applications. Strong hands... ..., ASP.NET, and Web API development . Strong knowledge of SQL Server, relational database design, stored procedures, query...SQL Server
$113k - $130.22k per year
...-thinking organization, We are currently seeking a Java + SQL + Angular Developer to join our team in Toronto, Ontario (CA-ON), Canada (CA).... ...knowledge and working experience with relation databases like SQL Server, Oracle. Writing Stored Procedures, performance tuning...SQL ServerLong term contractTemporary workInterim roleWork at officeRemote workFlexible hours- Database Administrator – Oracle, SQL Server, AWS RDS Database Administrator – Oracle, SQL Server... ...Administration (DBMS), IT IS_AMS_Database_MS SQL Server Job Summary The role... ...ensure high availability and performance, develop automation solutions, and collaborate with...SQL ServerWork at office2 days per week
- CIRO / OCRI recherche un administrateur principal de base de données (ABD) très compétent pour soutenir la performance, la fiabilité et l’intégrité des systèmes financiers et de l’écosystème de données. Vous renforcerez la résilience opérationnelle et soutiendrez des intégrations...SQL Server
- Build business intelligence solutions at Cencora using advanced SQL Server, SSIS, and SAP Business Objects development skills. Analyze data for targeted client reporting.As a Business Insights Developer, you will create analytics solutions for internal and external clients....SQL ServerWork at office
- Maîtrisez .NET et SQL Server comme Développeur logiciel principal chez Insurity, avec un modèle de travail flexible selon le rôle et le lieu.Ce poste s’adresse à un développeur expérimenté capable de définir des solutions techniques et de diriger des travaux complexes. Vous...SQL ServerFlexible hours
- Python Developer with SQLToronto, ON (Hybrid)Long TermJob Description 7+ years of development experience Background in Python development; experienced with Pythonlibraries Strong SQL background Show aptitude for adapting to new technologies About Iris Software...Flexible hours
- Apply senior software development expertise across Azure SQL, T-SQL, and data platforms in a hybrid consulting assignment. Build scalable, documented solutions.This Senior Software Developer role focuses on coding, architecture, reporting, and data engineering. You will enhance...
- Use Cognos and SQL expertise as a Senior Cognos Developer in a hybrid work arrangement at 5700 Yonge St. Apply technical systems specifications to tested applications.This senior position requires seven to ten years of experience in public sector environments or large businesses...
- La Banque Nationale recherche un développeur(euse) principal(e) en gestion quantitative des risques (QRM) pour soutenir les applications et l’infrastructure QRM dans un cadre de production critique. Vous travaillerez dans l’équipe TI des marchés des capitaux et collaborerez...SQL Server
- Architect - (ASP.NET, SQL Server) REQ_177 Employee RegularJob Description3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe...SQL ServerLong term contractWork at officeRemote workFlexible hours
- Technical Lead - SQL DBA, SQL Server & Database Administration Vancouver, Canada | Posted on 11/05/2026The role requires hands-on SQL DBA expertise, leadership, troubleshooting, availability management, performance tuning, backup/recovery governance and cross-team coordination...SQL Server
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Ms Sql Server Developer. Be the first to apply!

