About the role

Senior Database Administrator managing production, non-production, and DR databases for Canadian Tire Corporation. Ensuring high availability and performance while driving automation and modernization initiatives.

Responsibilities

Administer and support production, non‑production, and DR databases (e.g., Oracle, SQL Server, PostgreSQL, MySQL, Azure SQL, etc.)
Ensure high availability, disaster recovery, backup, and restore strategies meet business SLAs/RTO/RPO
Proactively monitor database health, capacity, and performance to prevent incidents
Lead root cause analysis (RCA) for database‑related incidents and drive permanent fixes
Tune SQL queries, indexing strategies, memory, and storage for optimal performance
Analyze workload patterns and recommend architectural improvements
Drive database automation for provisioning, patching, monitoring, backups, and schema deployments
Implement and enforce database security controls , including encryption, access management, auditing, and vulnerability remediation
Design and support cloud database solutions (Azure), including migration from on‑prem systems
Act as L3/L4 escalation for complex database issues
Provide technical guidance and mentoring to Vendor DBAs and support teams

8+ years of hands-on experience as a Database Administrator in enterprise environments
Strong expertise in one or more RDBMS platforms: Oracle / SQL Server / PostgreSQL / MySQL (or equivalent)
Deep understanding of: High Availability and Disaster Recovery
Backup and recovery strategies
Performance tuning and capacity planning
Experience supporting mission-critical production systems with 24x7 availability
Experience working with cloud platforms (Azure)
Strong scripting and automation skills (PowerShell, Python, Bash, etc.)
Solid understanding of ITIL processes (Incident, Change, Problem Management)