Back to job search
J&M Group logo

SQL Architect

  • Toronto, ON
  • On-site
  • Posted Oct 20, 2026
  • 1 position

Opens LinkedIn

Sign in to save this job
Employment type
Full-time
Experience level
Lead · 10+ years
Apply by
Apr 17, 2027
Posting language
English
Working hours
40 hours per week
Seniority
Mid-Senior level
Application method
Direct apply is available

Job summary

Design enterprise-scale OLTP and data warehouse solutions using Microsoft SQL Server. Apply database architecture expertise, including database internals, indexing, partitioning, query optimization, and data modeling.

Job details

10+ years of experience in database development, administration, or data architecture. 5+ years of experience in a database architecture or technical leadership role. Expert-level knowledge of Microsoft SQL Server. Extensive experience designing enterprise-scale OLTP and data warehouse solutions. Strong understanding of database internals, indexing strategies, partitioning, and query optimization. Experience with data modeling methodologies (Kimball, Data Vault, dimensional modeling). Strong understanding of data governance, security, and compliance principles. Excellent communication and stakeholder management skills.

What you’ll do

Design enterprise-scale OLTP and data warehouse solutions using Microsoft SQL Server. Apply database architecture expertise, including database internals, indexing, partitioning, query optimization, and data modeling.

Requirements

Requires 10+ years of experience in database development, administration, or data architecture, including 5+ years in database architecture or technical leadership. Candidates should have expert-level Microsoft SQL Server knowledge, experience with enterprise-scale solutions and data modeling methodologies, and strong governance, security, compliance, communication, and stakeholder management skills.

Listed skills

  • Compliance · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

  • Microsoft SQL Server
  • Database Architecture
  • Database Development
  • Database Administration
  • Data Architecture
  • Technical Leadership
  • OLTP Solutions
  • Data Warehousing
  • Database Internals
  • Indexing Strategies
  • Partitioning
  • Query Optimization
  • Data Modeling
  • Data Governance
  • Database Security
  • Compliance

Job areas

  • Technology
  • Data & Analytics
  • Software
  • Management & Leadership
  • Consulting

More jobs from J&M Group

See all jobs from J&M Group