Senior Data Platform Engineer - Toronto

Job summary

The Senior Data Platform Engineer is a hands-on technical leader responsible for designing, implementing, and managing the enterprise data platform across on-premises and cloud environments. This role involves administering Microsoft SQL Server, Azure SQL, and Microsoft Fabric, ensuring high availability, security, and optimal performance. Collaboration with various teams is essential to support data integration and automation using technologies like Azure Data Factory and Power BI.

Qualifications

• Strong hands-on experience administering Microsoft SQL Server in enterprise production environments
• 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
• 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

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
• 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

Skills

Degrees

Relocation