Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Tailor your resume to this Senior Data Platform Engineer - Toronto role.

Rezi rewrites your resume against Trisura Guarantee Insurance Company's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Senior Data Platform Engineer - Toronto posting at Trisura Guarantee Insurance Company — free, in seconds.

About the Role

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. Working closely with Data Engineers, BI Developers, Analysts, Infrastructure, Security, Architecture, and application teams, the Senior Data Platform Engineer will provide a stable foundation for enterprise data and analytics solutions.

Responsibilities

Administer, maintain, patch, upgrade, and troubleshoot on-premises Microsoft SQL Server environments.
Manage core SQL Server services and components.
Design, operate, and support high-availability and disaster-recovery solutions.
Monitor and optimize database performance.
Implement and maintain database operational processes.
Support database migrations, refreshes, environment synchronization, server consolidation, version upgrades, and modernization initiatives.
Implement and support SQL Server data movement and change technologies.
Troubleshoot complex database and platform issues.
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.
Administer SQL Server authentication, logins, users, server and database roles, and permissions.
Implement and maintain role-based access control, least-privilege principles, privileged access reviews, and appropriate separation of duties.
Configure and maintain database auditing, security logging, activity monitoring, and related controls.
Support database encryption and secure connectivity technologies.
Partner with Cybersecurity and Infrastructure teams to address database vulnerabilities, security recommendations, patching requirements, audit findings, and remediation activities.
Design, administer, and optimize data platform services across Microsoft Azure and Microsoft Fabric.
Support Fabric and Azure integration technologies.
Monitor Fabric capacity, workload performance, throttling, resource utilization, and On-premises Data Gateway availability, performance, upgrades, connectivity, and disaster-recovery readiness.
Implement proactive monitoring, alerting, health metrics, and operational dashboards.
Develop automation for routine platform administration, maintenance, deployments, monitoring, access reviews, and environment configuration.
Participate in production incident response, root-cause analysis, capacity planning, problem management, and preventative improvement.
Implement and support Git-based source control and CI/CD practices.
Establish controlled and repeatable deployment processes across Development, UAT, and Production.
Partner with Data Engineering and Architecture teams to define reusable platform standards and patterns.
Evaluate new Microsoft data platform capabilities and contribute to modernization initiatives.
Maintain architecture diagrams, platform configuration documentation, operational procedures, disaster-recovery documentation, and technical standards.

Requirements

Strong hands-on experience administering Microsoft SQL Server in enterprise production environments, both on premise and cloud(Azure SQL Managed Instance and/or Azure SQL Database).
Strong knowledge of SQL Server architecture, configuration, security, backup/recovery, performance tuning, and troubleshooting.
Experience with SQL Server Availability Groups and high-availability/disaster-recovery technologies.
Experience administering SQL Server Agent jobs and database maintenance processes.
Experience in Microsoft Fabric administration and architecture(Fabric Warehouse,Lakehouse,OneLake, Fabric Capacity, On-Premise Data Gateway)
Experience with data integration technologies such as SSIS, Azure Data Factory, or Fabric Data Factory.
Experience with scripting and automation using PowerShell, Python, T-SQL, or similar technologies.
Understanding of enterprise networking, Active Directory/Entra ID, service accounts, managed identities, firewalls, private endpoints, and secure connectivity.
Experience supporting business-critical production systems and troubleshooting complex technical issues.
Bachelor's degree or diploma in Computer Science, Information Technology, Engineering, or a related discipline, or equivalent professional experience.
Minimum of 5 years of experience in database administration, data platform engineering, cloud engineering, or a related technical role.
Demonstrated experience managing production-critical data services with a strong analytical and problem-solving mindset.
Sound understanding of enterprise security, governance, access control, reliability, and operational risk management principles.
Ability to manage competing priorities, respond effectively to production issues, and support reliable, secure, and highly available enterprise data platforms.

Skills

Microsoft SQL Server
Azure SQL
Microsoft Fabric
Azure Data Factory
Power BI infrastructure
SQL Server Agent
SSIS/SSISDB
SSRS
Availability Groups
Change Data Capture (CDC)
Change Tracking
Replication
PowerShell
T-SQL
Python
Azure CLI
REST APIs
Azure DevOps
DACPACs
Fabric Warehouse
Fabric Lakehouse
Fabric OneLake
Fabric Capacity
On-Premise Data Gateway
Fabric Data Factory
Azure SQL Managed Instance
Azure SQL Database

Location

Toronto

Work Type

Hybrid

Experience Level

Senior
Minimum of 5 years of experience

Education Level

Bachelor's degree or diploma in Computer Science, Information Technology, Engineering, or a related discipline, or equivalent professional experience.

Salary/Compensations

$125,000

About the Company

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.
Trisura, headquartered in the heart of Canada’s financial district, is a specialty lines insurer with a focus on Surety, Specialty Insurance, Property & Casualty, and Warranty products.
Trisura brings innovative solutions and expertise through a select network of both national and regional brokerage firms.
The company, founded in 2006, and operating across North America with offices in Toronto, Ottawa, Halifax, Montréal, Calgary, Vancouver, Stamford. Denver, Chicago, Philadelphia and Oklahoma City, is uniquely positioned to satisfy all varieties of risk in Contract, Commercial and Developer Surety, Directors' and Officers' Liability, Fidelity, and Professional Liability including Media Liability, as well as Warranty products.

Equal Opportunity

We are committed to an inclusive and barrier-free workplace that reflects the diversity in each of our offices across Canada. Accommodations will be provided on request for candidates taking part in all aspects of our recruitment and selection process.