Contract - 8 Months (Extension Possible)

Remote - Anywhere in Ontario

Public Sector Experience: Required - OPS / Public Sector

Contract End Date: 2027-03-31 *

Rate: $86/hour

Overview

The Ministry of Public and Business Service Delivery and Procurement is seeking a Senior Database Administrator to support the Solaris Evergreening Project within the Land & Resources Cluster. This time-sensitive, high-priority initiative focuses on migrating Oracle databases off end-of-life Solaris infrastructure onto supported platforms, with upgrades to the latest Oracle versions where applicable. The successful consultant will bring deep Oracle DBA expertise to ensure a secure, performant, and seamless transition with zero current application development.

Key Responsibilities

Create and implement physical database designs; administer and operate the database management system (DBMS) including optimization, capacity planning, installation, migration, performance tuning, and backup and recovery

Maintain and monitor Oracle 10g, 11g, 12c, and 19c databases across large multi-tenant environments, including administration, maintenance, optimization, and fine-tuning

Design, build, and configure Oracle Database Servers on Windows, Solaris, and Linux platforms

Ensure existing databases (including SIEBEL, Java, ArcGIS, and APEX) meet performance requirements on Oracle infrastructure

Ensure all deployed databases are secure and that appropriate security and auditing controls are in place to satisfy security and privacy requirements

Lead and design solutions for the enterprise Oracle migration project, targeting Oracle 19c or higher

Plan, manage, and coordinate implementation of technically advanced, complex systems and assist with data refreshes to lower non-production environments

Provide database administration technical expertise during design and architecture phases





Provide expert support and guidance for production database systems, overseeing deployment and evaluation of complex Oracle databases in GoCloud and on-premise environments

Assist with implementing TDE, Dataguard, RAC, OMS, and OEM 13c technologies

Identify, analyze, prioritize, and communicate technical risks; provide recommendations and mitigation strategies to decision makers

Document technical work thoroughly to enable knowledge transfer to colleagues and ministry staff

Must-Have Requirements

Minimum 10+ years of experience as a Database Administrator or in related IT roles

Hands-on experience with Oracle database optimization, capacity planning, installation, migration, performance tuning, and backup and recovery

Experience maintaining and monitoring Oracle 10g, 11g, 12c, and 19c databases in large multi-tenant environments

Experience migrating from end-of-life Oracle databases to the latest supported versions in both on-premise and cloud data centres

Experience with Oracle Database Server configuration on Windows, Solaris, and Linux operating systems

Experience ensuring database security and implementing appropriate auditing controls to meet security and privacy requirements

Experience with Incident, Change, and Configuration Management procedures

Experience monitoring and enforcing database rules and standards

Experience with one or more programming languages and proficiency with query languages and information retrieval packages

Excellent analytical, problem-solving,



and decision-making skills with strong verbal and written communication abilities

Proven track record as a team player with ability to meet deadlines in complex, high-priority environments

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

Experience with Computer Aided Software Engineering (CASE) tools

Knowledge of Information Management principles, concepts, policies, and practices

Additional Oracle DBA skills including Oracle OBIEE and data warehouse/data mart design

Subject matter expertise in data warehouse or data mart database design

Experience with installation, configuration, maintenance, upgrade, and cloning of Oracle technology stacks

Experience in designing and developing automated data distribution mechanisms for Case Management or ERP environments

Knowledge of object-oriented analysis and design techniques

Experience developing enterprise architecture deliverables including models

Knowledge of Ontario Government Enterprise Architecture processes and practices

Experience with impact analysis, implementation planning, and application of technology patches, maintenance packs, and releases

Experience with database administration vendor support services

Work Environment

This is a fully remote position open to candidates located anywhere in Ontario. No security clearance is required. The role operates within the Land & Resources Cluster under the Ministry of Public and Business Service Delivery and Procurement, contributing to a high-priority FY26/27 operating plan deliverable. Consultants are expected to collaborate closely with ministry staff throughout the engagement.

#J-18808-Ljbffr

📌 Database Administrator Senior- Remote (Ottawa)
🏢 Lotus IT Solutions
📍 Ottawa