Mitsubishi Heavy Industries

Senior SQL Server, Data/AIA Engineer

Mitsubishi Heavy Industries

full-time

Posted on:

Location Type: Hybrid

Location: Mississauga • 🇨🇦 Canada

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

ETLSQLSSIS

About the role

  • 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
  • Own and improve existing ETL workflows (SSIS packages and/or custom ETL processes)
  • Stabilize ETL: Add proper logging, monitoring/alerting, and restart/recovery patterns
  • Document and rationalize data flows: Between SQL databases, ETL, upstream applications, and reporting/analytics
  • Refactor and optimize stored procedures, functions, and queries to reduce runtime, resource usage, and complexity
  • Prepare and structure enterprise data for AI use cases (RAG, copilots, internal assistants, automation)

Requirements

  • 5+ years hands-on experience as a SQL Server Developer / Database Engineer / Data Engineer with SQL Server as your main platform
  • Strong T-SQL skills: Complex stored procedures, functions, and views
  • Solid query tuning using execution plans, index strategies, and statistics
  • Proven ETL / data integration experience: Designing, owning, and troubleshooting production ETL jobs (SSIS or similar tools, or custom script-based ETL)
  • Solid grasp of: Relational data modelling, normalization vs denormalization, and the impact of design on performance and maintainability
  • Comfortable taking over legacy SQL and ETL: Reading messy code, simplifying it, and documenting what’s actually happening
  • Used to owning outcomes: You can prioritize, communicate trade-offs, and defend good technical decisions to both technical and non-technical stakeholders
  • Clear written and verbal communication
Benefits
  • Overtime hours with advanced notice may be required to meet project deadlines
  • Hybrid opportunities available – incumbent must commute to work

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQL ServerT-SQLETLSSISdata integrationquery tuningrelational data modelingstored proceduresfunctionsviews
Soft skills
communicationprioritizationtechnical decision-makingdocumentationtroubleshootingperformance optimizationstakeholder engagementproblem-solvingadaptabilitycollaboration