Position Overview

We are seeking an experienced SQL Architect to lead the design, optimization, governance, and ongoing evolution of enterprise database and data platforms. The ideal candidate will have extensive expertise in Microsoft SQL Server architecture, database design, performance tuning, data integration, and cloud-based data solutions.

In this role, you will collaborate with business stakeholders, data engineers, BI developers, application teams, and enterprise architects to build and maintain secure, scalable, reliable, and high-performing data platforms that support critical business operations and analytics.

Key Responsibilities

Data Architecture and Database Design

- Design, develop, and maintain enterprise database architectures and data models.
- Create logical and physical data models aligned with business requirements and technology strategies.
- Establish and enforce database standards, naming conventions, and data governance practices.
- Lead architecture reviews and recommend improvements to existing database environments.
- Design and implement high-availability (HA) and disaster recovery (DR) solutions.

Database Performance and Optimization
- Analyze and optimize complex SQL queries, stored procedures, and ETL processes.
- Monitor database performance and implement tuning strategies to improve scalability, reliability, and efficiency.
- Identify and resolve performance bottlenecks across OLTP and analytical workloads.
- Develop capacity planning strategies to support database growth and evolving business needs.

Data Engineering and Integration
- Design and oversee ETL/ELT frameworks and enterprise data integration processes.
- Collaborate with data engineering teams to support data lake, data warehouse, and analytics initiatives.




- Architect solutions for ingesting, transforming, processing, and serving large-scale datasets.
- Lead and support data migration initiatives between on-premises and cloud environments.

Data Governance, Security, and Compliance
- Define and enforce database security standards, access controls, and governance policies.
- Ensure database platforms comply with applicable regulatory requirements and organizational policies.
- Establish and maintain backup, recovery, auditing, and monitoring procedures.
- Implement data quality controls and master data management (MDM) practices.

Technical Leadership and Collaboration
- Provide technical leadership and mentorship to DBAs, database developers, data engineers, and BI teams.
- Review database designs, SQL code, and deployment plans to ensure adherence to architectural standards.
- Lead root-cause analysis and remediation efforts for critical database incidents.
- Evaluate emerging database technologies and recommend appropriate adoption strategies.
- Collaborate with cross-functional teams to align database architecture with enterprise technology objectives.

Required Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent experience.
- 10+ years of experience in database development, database administration, or data architecture.




- 5+ years of experience in database architecture, technical leadership, or a similar senior-level role.
- Expert-level knowledge of Microsoft SQL Server architecture and database technologies.
- Extensive experience designing and supporting enterprise-scale OLTP and data warehouse solutions.
- Strong understanding of database internals, indexing strategies, partitioning, query execution plans, and performance optimization.
- Hands-on experience with data modeling methodologies, including Kimball, Data Vault, and dimensional modeling.
- Strong understanding of data governance, database security, access controls, and compliance principles.
- Excellent analytical, problem-solving, communication, and stakeholder management skills.

Preferred Qualifications
- Experience with Azure SQL, Azure Synapse Analytics, Microsoft Fabric, Snowflake, or Databricks.
- Experience leading cloud database migration and modernization initiatives.
- Knowledge of modern data architecture concepts, including Data Lakehouse and Data Mesh.
- Experience supporting AI, machine learning, and advanced analytics platforms.
- Microsoft Azure Data Engineer or Database Administrator certifications.
- Experience working in Agile delivery environments.

Ideal Candidate Profile The ideal candidate is a hands-on SQL architecture expert with solid technical leadership capabilities and a proven track record of designing, optimizing, and governing enterprise-scale database environments. They should be comfortable working across database engineering, data integration, cloud migration, security, and enterprise architecture while partnering with technical teams and business stakeholders.

📌 SQL Architect (Toronto)
🏢 Axiom Global Technologies
📍 Toronto