Opens LinkedIn
- 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
ForgeRock Developer
- On-site
- Montréal, QC
- Posted Oct 21, 2026
Business Systems Analyst
- On-site
- Toronto, ON
- Posted Oct 21, 2026
Senior Python Developer with PySpark and AWS
- On-site
- Toronto, ON
- Posted Oct 20, 2026
GCP Data Engineer
- On-site
- Toronto, ON
- Posted Oct 20, 2026
