- Company Name
- MHI Canada Aerospace, Inc.
- Job Title
- Senior SQL Server & Data/AI Engineer
- Job Description
-
**Job Title**
Senior SQL Server & Data/AI Engineer
**Role Summary**
Owns and optimizes the SQL Server data layer and foundational AI data structures. Balances production database stewardship, ETL workflow improvement, and design of vector‑store pipelines for AI applications. Drives performance, reliability, and maintainability across on‑prem and cloud‑compatible environments.
**Expectations**
- End‑to‑end ownership of production SQL Server instances (~10 databases).
- 70 % focus on database performance, ETL stability, and data modeling; 30 % on AI‑readiness (vector stores, RAG, semantic layers).
- Architecture decisions, risk‑free implementations, and proactive collaboration with infrastructure, application, and AI teams.
**Key Responsibilities**
- Manage schemas, code, performance, security, and backup/restore strategies for production SQL Server instances.
- Monitor, tune, and troubleshoot index/statistics, query plans, blocking, deadlocks, replication, and SQL Agent jobs.
- Design and implement database objects (tables, views, constraints, indexes) for new features and integrations.
- Own and enhance ETL workflows (SSIS or custom scripts): logging, alerting, recovery patterns, and documentation of data flows.
- Improve data quality by validating source vs target data, reconciling discrepancies, and automating repeatable fixes.
- Refactor T‑SQL code, enforce development standards, and perform root‑cause analysis of production issues.
- Design vector‑aware data stores for AI use cases: schemas, ingestion pipelines, and governance, integrating with Azure or on‑prem solutions.
- Collaborate with BI developers and stakeholders to create reusable models, semantic layers, and optional SSAS support.
- Assist in evaluating cloud services (Azure OpenAI, managed vector stores) against on‑prem capabilities.
**Required Skills**
- 5+ years as a SQL Server Developer / Database Engineer / Data Engineer.
- Advanced T‑SQL: complex stored procedures, functions, views, and query optimization.
- Strong ETL/data integration expertise (SSIS or equivalent, custom scripting).
- Relational data modeling, normalization vs denormalization principles.
- Performance tuning: execution plans, indexing strategies, statistics management.
- Experience with backup/restore, replication, SQL Agent, and database security.
- Knowledge of vector stores, embeddings, RAG patterns, and AI data workflows.
- Familiarity with cloud services (Azure SQL, Azure OpenAI, managed vector/search services) and on‑prem integration.
- Version control (Git, TFS) and CI/CD for database objects.
- Excellent problem‑solving, communication, and teamwork abilities.
**Required Education & Certifications**
- Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or related field.
- Certifications preferred: Microsoft Certified: Azure Data Engineer Associate, Microsoft Certified: Database Administrator Associate, or equivalent.