MS SQL Server Developer - Data Modeling & Performance Tuning
Astra North Infoteck Inc.Toronto, ON, ca
Full-time
MS SQL Server Developer - Data Modeling & Performance Tuning.SQL programming, data modeling, and performance optimization.The ideal candidate will have experience managing large-scale data volu...Show moreLast updated: 29 days ago
Server
Jack Astor'sToronto, ON, CA
Full-time
At Jack Astor’s it’s all about personality, yes, we’re all about a.Jacks is about being ourselves.In your role, you will consistently provide our guests with.We will prepare and support you for suc...Show moreLast updated: 30+ days ago
SQL Server DBA - Remote
NTT DATA ServicesToronto, ON, CA
Remote
Full-time
NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us.If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now....Show moreLast updated: 6 days ago
Software Engineer (Python/PL-SQL)
ScotiabankToronto, ON, CA
Full-time
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engi...Show moreLast updated: 10 days ago
Server
Loose MooseToronto, ON, CA
Full-time
In your role, you will consistently provide our guests with.We will prepare and support you for success.Working alongside your managers and other TMs to provide the highest quality standards for fo...Show moreLast updated: 30+ days ago
Server - La Plume
La PlumeToronto, Ontario, Canada
Full-time
Under the direction of the Front of House Management Team, Servers are extremely knowledgeable about all food and beverage items in the restaurant.By adhering to the steps of service they answer qu...Show moreLast updated: 11 days ago
Catering Server / Banquet Server – Event Staff (Freelance Events)
Seventh Heaven Event CateringToronto, ON, CAN
Full-time
Quick Apply
Catering Server / Banquet Server – Event Staff (Freelance Events).Flexible Event Work | $22–$30 per hour depending on experience.Toronto & Greater Toronto Area.This position is ideal for candidates...Show moreLast updated: 10 days ago
Database MS SQL Server
J M Group IncToronto, ON, Canada
Full-time
Quick Apply
Job Title: Database MS SQL Server Location : Toronto, ON Analyze highly complex business requirements and generate technical specifications to create data pipelines for applications.Create template...Show moreLast updated: 3 days ago
Server
Scaddabush Italian Kitchen & BarToronto, ON, CA
Full-time +1
Front-of-House Opportunities – Scaddabush (Service Inspired Restaurants).At Scaddabush we're a little of this, a little of that, and a whole new take on Italian.We’re inspired by Italian passion an...Show moreLast updated: 30+ days ago
Server Assistant
Marriott InternationalToronto, ON, Canada
Full-time
Provide professional, courteous and efficient presentation of food and beverage service to all guests.Clean and set up tables in the outlet and perform other food service related duties, including ...Show moreLast updated: 23 days ago
SQL Server DBA - Remote
NTTToronto, Canada
Remote
Full-time
Provide architecture development, design, implementation, upgrading, administration, and management for Enterprise and Standard Microsoft Structured Query Language (SQL) databases.Support installat...Show moreLast updated: 16 days ago
Server
Chelsea Hotel, TorontoToronto
Full-time
Banquet Servers prepare the tables and banquet area before guests arrive, effectively serving a number of different dishes and courses to guests during a meal, and clearing the tables and banquet a...Show moreLast updated: 30+ days ago
Oracle SQL Forms Specialist
eTeamToronto, ON
Full-time
Primary skill Oracle Forms SQL.We are seeking an experienced FinOps Developer Technical Analyst with strong handson expertise in Oracle PLSQL Oracle Forms Reports Perl Unix Shell Scripting and Java...Show moreLast updated: 6 days ago
Server
Prohibition Social HouseToronto, ON
Full-time
As a Server you will create memorable guest experiences by making great food and beverage recommendations and serving delicious items.You will be a member of a cohesive team that supports each othe...Show moreLast updated: 30+ days ago
Server - Cast Member
CEC Entertainment Canada, ULC.2452 Sheppard Ave. East, North York, ON
Part-time
Cheese (CEC) is a great place for a first-time job seeker or a place to build an exciting career.Our Cast Members are empowered to provide the greatest service anywhere through cross-training in a ...Show moreLast updated: 23 days ago
Server
Granite ClubToronto, Ontario, Canada
Full-time
Quick Apply
The Granite Club is looking for full-time Servers to create a positive dining experience through excellent food and beverage knowledge and the ability to adhere to the standards of service.Servers ...Show moreLast updated: 30+ days ago
Server - Arcadian
ArcadianToronto, Ontario, Canada
Full-time
Event Servers play a key role in the execution of special events.They assist with setup and breakdown, deliver food and beverage service with efficiency and professionalism, and help maintain a cle...Show moreLast updated: 11 days ago
Vertica DBA 9898
FoilconToronto, Ontario, Canada
Temporary
To provide support for the Vertica database technology and its deployment and usage standards.To lead application development and support teams in optimal use of Vertica database technology through...Show moreLast updated: 30+ days ago
PostgreSQL Senior Database Administrator (DBA)
CA001 Marsh Canada LimitedBremner,Toronto
Full-time
Marsh McLennan’s Database Services team is growing rapidly, and we have an exciting opportunity for a creative and inquisitive Senior Database Administrator skilled in Postgres and Oracle.This hybr...Show moreLast updated: 30+ days ago
MS SQL Server Developer - Data Modeling & Performance Tuning
Astra North Infoteck Inc.Toronto, ON, ca
29 days ago
Job type
Full-time
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.