Senior Data Platform Engineer

At Trisura, we expect more because we believe it can be done better.

We are a young, growth oriented team with a commitment to exceptional talent and have been named one of Canada’s Top Small and Medium Employers since 2017. Our growth and our entrepreneurial style, niche market position and development opportunities ensure that our people see the results of their commitment reflected in the company’s success.

We are currently seeking a driven and collaborative Senior Data Platform Engineer to join our forward-thinking Data and Analytics team.

SENIOR DATA PLATFORM ENGINEER
TORONTO

Position Overview
As a Senior Data Platform Engineer on our Data & Analytics Team, you will be a hands‑on technical leader responsible for designing, implementing, administering, monitoring, and continuously improving the organization’s enterprise data platform across on‑premises and cloud environments. The role provides technical ownership of core data platform technologies including Microsoft SQL Server, Azure SQL, Microsoft Fabric, Azure Data Factory, Power BI infrastructure, and associated integration and automation services.

The Senior Data Platform Engineer will ensure that database and data platform services are highly available, secure, reliable, scalable, recoverable, and cost‑effective.

What You Will Do
SQL Server Administration & Database Platform Management
Administer, maintain, patch, upgrade, and troubleshoot on‑premises Microsoft SQL Server environments across Development, UAT, Production, Disaster Recovery, and other enterprise environments.
Manage core SQL Server services and components, including the Database Engine, SQL Server Agent, SSIS/SSISDB, SSRS, linked servers, Database Mail, and supporting platform services.
Design, operate, and support high‑availability and disaster‑recovery solutions, including Availability Groups, failover testing, backup and restore strategies, point‑in‑time recovery, retention, and recovery procedures aligned with organizational RPO and RTO requirements.
Monitor and optimize database performance, including query execution, indexing, statistics, blocking, deadlocks, CPU, memory, storage, TempDB, database files, and overall platform utilization.
Implement and maintain database operational processes, including integrity checks, index and statistics maintenance, backup validation, SQL Server Agent jobs, alerts, schedules, and automated maintenance activities.
Support database migrations, refreshes, environment synchronization, server consolidation, version upgrades, and modernization initiatives.
Implement and support SQL Server data movement and change technologies such as Change Data Capture (CDC), Change Tracking, replication, and related integration mechanisms.
Troubleshoot complex database and platform issues involving connectivity, performance degradation, failed jobs, storage constraints, corruption, availability, and recovery.
Identify and evaluate opportunities to modernize on‑premises SQL Server workloads using Azure SQL Managed Instance, Azure SQL Database, Microsoft Fabric, and other strategic cloud platforms.

Database Security & Governance
Administer SQL Server authentication, logins, users, server and database roles, and permissions across enterprise database environments.
Implement and maintain role‑based access control, least‑privilege principles, privileged access reviews, and appropriate separation of duties for administrators, developers, applications, deployment accounts, and service accounts.
Configure and maintain database auditing, security logging, activity monitoring, and related controls to support operational oversight and compliance requirements.
Support database encryption and secure connectivity technologies, including Transparent Data Encryption…