Senior SQL Server & Data / AI Engineer

Senior SQL Server & Data / AI Engineer

Join to apply for the Senior SQL Server & Data / AI Engineer role at Mitsubishi Heavy Industries.

Job Title : Senior SQL Server & Data / AI Engineer

Department : IT / ERP

Reports to : Director

Job Category : Yearly

Scope of Position

Reporting to the Director, the Senior SQL Server & Data / AI Engineer will own our SQL Server data layer end-to-end and help lay the foundations for our AI platform. Roughly 70% of your time will be on SQL Server, ETL, and data modelling : stabilizing, tuning, and improving what we already run in production. The rest will be spent designing data structures and pipelines for AI (vector store, RAG-style data access) and, if it makes sense, basic semantic models / SSAS.

Infrastructure / IT will manage servers, OS, and patching. You own schema, code, performance, ETL, and data models. You’ll be expected to make architecture decisions, challenge assumptions, and push for robust, maintainable solutions.

Responsibilities

SQL Server Ownership (Data Layer)

• Own several production SQL Server instances and ~10 databases from a data perspective (schemas, code, performance, reliability, security at the DB level, backups / restore strategies).
• Monitor and tune performance : Index and statistics strategy, query plans, blocking / deadlocks, resource usage.
• Maintain and troubleshoot : Replication, SQL Agent jobs, and other DB-level automation.
• Design and implement : Tables, views, indexes, constraints, and other DB objects for new features and integrations.
• Work with infrastructure / IT on capacity, patching windows, and DR, while ensuring the data layer supports those plans.

ETL & Data Workflows

SQL Development & Optimization

AI & Data Platform Enablement (Cloud‑Friendly)

Collaboration & (Light) Analytics Enablement

Work Conditions

Skills and Qualifications

Nice to Have

Education

Please note – the Company will conduct a criminal background check upon hire.

We thank all applicants in advance for their interest; however, only those candidates selected for an interview will be contacted.

MHI Canada Aerospace is an equal opportunity employer and encourages women, Aboriginal people, persons with disabilities and members of visible minorities to apply. MHICA is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). MHICA will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.

Location : Toronto, Ontario, Canada. Salary : Can$100,000.00 – 105,000.00

#J-18808-Ljbffr