- Guelph, Ontario, Canada
- Full-time · Staff
- 8+ years
Own how data is stored, moved, modelled, and governed across our Parks & Recreation platform, focusing on Azure SQL production databases (Core) and the Snowflake data platform.
Compensation
The listed salary range reflects a nationwide benchmark and the broad spectrum of pay for this role. Actual compensation will be determined based on factors such as the role's scope, complexity, and location, as well as the candidate's skills, education, experience, and credentials.
Responsibilities
- Act as the senior escalation point for Azure SQL production issues
- Tune reporting and transactional stored procedures and indexes across a large, multi-tenant Core database fleet
- Own data lifecycle jobs, index and statistics maintenance, and the SQL Elastic Jobs
- Extend in-database monitoring using Query Store baselines, deviation alerts, and Extended Events sessions
- Review schema changes and migration scripts and guide SSDT / DACPAC deployments
Requirements
- Bachelor's degree or equivalent diploma/certification in Computer Science, Software Engineering, or a related field
- Nice to have: Meltano
- Nice to have: Singer taps and targets
- Nice to have: Power BI
- Nice to have: Azure Container Apps
