MS SQL Server Developer at Astra-North Infoteck Inc. — NeverHard
MS SQL Server Developer at Astra-North Infoteck Inc. in Toronto, Ontario. Skills: ETL/ELT, MSSQL server, Optimisation de la performance, Procédures stockées, Programmation SQL avancée. Apply on NeverHard.
Company
Astra-North Infoteck Inc.
Location
Toronto, Ontario
Type
full_time
Required skills:
ETL/ELT
MSSQL server
Optimisation de la performance
Procédures stockées
Programmation SQL avancée
modélisation de données
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 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 Responsibilities
1. 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