Job descriptionJob Overview Ontario Power Generation (OPG) is looking for a dynamic, strategic and results‑driven professional to join the team as Senior Database Administrator. Reporting to the Senior Manager IT Services, the role owns end‑to‑end administration and governance of enterprise database platforms across on‑prem and Azure, covering deployment, availability/DR, performance, backup/recovery, security/compliance, and Databricks Unity Catalog to ensure reliable, secure and SLA‑aligned data services.
Key Accountabilities
Install, configure and administer relational and NoSQL platforms (Oracle, SQL Server, PostgreSQL, MongoDB, Cosmos DB) ensuring stable, scalable, and standards‑based deployments.
Deploy, operate and optimize cloud database services (Azure SQL DB and related Azure data services) ensuring secure connectivity, reliability, and cost‑effective performance.
Design, implement and regularly test HA/DR architectures to meet business continuity objectives (RTO/RPO) and minimize service downtime.
Execute routine operational tasks including health checks, patching, and version upgrades while maintaining compliance and improving platform stability.
Proactively monitor database health and performance; conduct query tuning, indexing strategies and workload optimization to maintain response times and meet SLAs.
Implement, monitor and validate backup/restore procedures and recovery drills to protect enterprise data and ensure rapid restoration when required.
Enforce security controls (RBAC, encryption, secrets management), remediate vulnerabilities and support audit/internal control activities with evidence, logging and governance practices.
Administer Unity Catalog governance, including metastore management, identity/access controls, privilege governance, external location and storage oversight, and catalog/schema design aligned to security and compliance standards.
Qualifications
4‑Year university education in Computer Science, Information Technology or a related field.
Minimum of 6+ years of experience in database administration and cloud data platform management, including on‑prem and Azure databases, HA/DR, performance tuning, backup/recovery, security/compliance and Databricks Unity Catalog governance.
Proven experience managing Azure database services such as Azure SQL DB including deployment, configuration, monitoring and cost/performance optimization.
Demonstrated expertise designing, implementing and testing high availability and disaster recovery solutions with a clear understanding of RTO/RPO objectives.
Strong skills in database performance monitoring and optimization, including query tuning, indexing strategies and troubleshooting complex production issues.
Experience implementing and validating backup/restore strategies and conducting recovery testing to ensure data protection and rapid restoration.
Working knowledge of database security and compliance practices (RBAC, encryption, vulnerability remediation, audit support) plus administration of Databricks Unity Catalog (metastore, access controls, privilege governance, external locations, catalog/schema design).
EEO Statement OPG is committed to fostering an inclusive, equitable, and accessible environment. We encourage applicants from equity‑seeking communities (Indigenous Peoples, racialised persons, persons with disabilities, and women) and will consider priority hiring for qualified self‑identifying individuals as part of a special program under the Human Rights Code/Canadian Human Rights Act.
#J-18808-Ljbffr