Database Administrator

Overview

Lotus IT is seeking a Senior Database Administrator for an onsite engagement with the Health Services Cluster under the Ministry of Public and Business Service Delivery and Procurement. The successful candidate will be responsible for the design, administration, and optimization of enterprise-scale database systems with a strong focus on Azure cloud platforms and data warehousing. This is a mission-critical role supporting high availability, disaster recovery, and modern data operations within a governed public-sector environment.

Key Responsibilities

• Design and develop data pipelines from source systems to end users, including optimization of pipeline performance
• Create physical and logical database designs, including schema optimization for OLTP and analytical workloads
• Administer the database management system (DBMS), including installation, configuration, migration, upgrades, and patching
• Perform database performance tuning, capacity planning, growth forecasting, and lifecycle management
• Design and support high availability (HA) and disaster recovery (DR) strategies for mission-critical systems
• Manage cloud data services including Azure PaaS and IaaS database services, 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 database backup and recovery strategies, including RMAN, ASM, and Flash Recovery Area (FRA) configurations
• Monitor and enforce database rules, security policies, and compliance requirements including vulnerability remediations
• Participate in incident, change, and configuration management processes aligned with ITIL frameworks
• Support Oracle e-Business Suite, Oracle Data Guard, WebLogic, and OEM Grid Control administration where required

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 (Azure SQL Database, etc.)
• 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 with 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 for project delivery including Data Lake, Data Warehouse, and Data Lakehouse platforms
• Experience supporting enterprise data warehouse and lakehouse solutions for structured, semi-structured, and unstructured data
• Demonstrated application of DataOps principles including monitoring, alerting, performance optimization, and operational tuning
• Strong background in incident, change, and configuration management within ITIL-aligned or public-sector governed environments
• Valid CRJMC security clearance or ability to obtain one

Nice-to-Have Skills

• Experience with distributed data systems, middleware, and gateways
• Experience researching and implementing cybersecurity vulnerability remediations
• Knowledge of Computer Aided Software Engineering (CASE) tools
• Knowledge and understanding of Information Management principles, concepts, policies, and practices
• Experience with Oracle e-Business Suite Applications 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, sizing, capacity planning, and backup/recovery using RMAN
• Knowledge and experience configuring WebLogic and OEM Grid Control
• Expert-level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x
• Knowledge of Advanced Compression, data partitioning, and data masking using Oracle patches and database scripts
• Performance tuning experience with e-Business Suite R12.2/19c in multi-node RAC environments
• Knowledge of UNIX/Linux OS utilities and shell scripting
• Experience in Cloud DB Administration, DevOps/DataOps, and data integration automation tools
• Experience with Ontario Government Enterprise Architecture processes and practices
• Awareness of emerging IT trends and directions in data management

Work Environment

This is a fully onsite position. The resource is expected to work 7.25 hours per calendar day between standard working hours of 8:00 AM – 5:00 PM (excluding lunch), Monday to Friday, at either 222 Jarvis St. in Toronto or 49 Place d'Armes in Kingston. A CRJMC security clearance is required for this engagement. The role is with the Health Services Cluster under the Ontario Public Service (OPS).