Database Administrator

Overview

The Health Services Cluster (Ministry of Public and Business Service Delivery and Procurement) is seeking a Senior Database Administrator to support enterprise-scale database operations across cloud and on-premises environments. The successful consultant will be responsible for designing, implementing, optimizing, and administering mission-critical database systems, including cloud-based platforms on Azure. This is a hands-on senior role requiring deep expertise in database architecture, performance tuning, high availability, and disaster recovery.

Key Responsibilities

• Design and develop logical and physical database structures, including schema optimization for OLTP and analytical workloads
• Administer and operate database management systems (DBMS), including installation, configuration, migration, and upgrades across on-premises and cloud environments
• Design, implement, and support high availability (HA) and disaster recovery (DR) strategies for mission-critical database systems
• Perform database performance tuning, capacity planning, growth forecasting, and lifecycle management
• Design and optimize data pipelines from source to end user, ensuring efficiency and reliability
• Manage cloud data services including storage repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms
• Support structured, semi-structured, and unstructured data ingestion, exchange, and provisioning for enterprise data warehouse and lakehouse solutions
• Apply DataOps principles including monitoring, alerting, performance optimization, and operational tuning across environments
• Manage and enforce database security, backup and recovery strategies, and compliance with data governance policies
• Participate in incident, change, and configuration management processes in alignment with ITIL-governed procedures
• Support database modernization initiatives, including migrations from legacy platforms to cloud environments
• Administer Oracle database environments including e-Business Suite R12.2, Oracle Data Guard, RMAN, ASM, and RAC configurations where applicable

Must-Have Requirements

• 7–10+ years of experience in Database Administration, including design, implementation, operations, and optimization of enterprise-scale database systems
• Proven expertise administering cloud database platforms with a strong focus on Azure PaaS and IaaS database services
• Extensive experience creating logical and physical database designs including schema optimization for OLTP and analytical workloads
• Demonstrated experience in database performance tuning, capacity planning, growth forecasting, and lifecycle management
• Hands-on experience in database installation, configuration, migration, and upgrades including modernization from legacy platforms to cloud environments
• Proven ability to design and support high availability (HA) and disaster recovery (DR) strategies for mission-critical systems
• Experience managing cloud data services including storage, repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms
• Experience supporting structured, semi-structured, and unstructured data ingestion, exchange, and provisioning for enterprise data warehouse and lakehouse solutions
• Demonstrated application of DataOps principles including monitoring, alerting, performance optimization, and operational tuning across environments
• Strong background in incident, change, and configuration management within ITIL-aligned or public-sector governed environments
• Security clearance eligibility at the CRJMC level

Nice-to-Have Skills

• Experience with distributed data systems and middleware/gateway technologies
• Experience researching and implementing cybersecurity vulnerability remediations
• Awareness of emerging IT trends and directions in data management
• Knowledge and understanding of Information Management principles, concepts, policies, and practices
• Experience with Computer Aided Software Engineering (CASE) tools
• Subject matter expertise in data warehouse or data mart database design, including Oracle OBIEE
• Experience with Oracle e-Business Suite R12.2 and Oracle Data Guard (installation, configuration, maintenance, patching, upgrade, and cloning)
• Expert-level knowledge of Oracle 12c/19c database administration, security implementation, upgrade and patching, performance tuning, and backup/recovery using RMAN
• Experience with WebLogic, OEM Grid Control, Advanced Compression, and data partitioning
• Knowledge of UNIX/Linux OS, utilities, and shell scripting
• Experience with Online Patching and Oracle E-Business Suite Release 12.2 using Logical Host configuration
• Experience in designing and developing automated data distribution mechanisms for Case Management and ERP environments
• Knowledge of Ontario Government Enterprise Architecture processes and practices
• Experience in public sector or Ontario Public Service (OPS) environments

Work Environment

This is a fully onsite role. The consultant is expected to work 7.25 hours per calendar day between 8:00 AM and 5:00 PM (excluding lunch), Monday through Friday, at either 222 Jarvis St., Toronto or 49 Place d'Armes, Kingston. A CRJMC security clearance is required. This role operates within a governed public-sector environment aligned with ITIL-based incident, change, and configuration management practices.