Database Administrator - Senior

Job Title: Database Administrator - Senior
Assignment: Sr DBA - APEX/ORDS Evergreening Project
Location: Anywhere in Ontario
Work Model: Remote
Duration: 8 Months
Extension: 1 Extension
Submission Deadline: 2026-07-15, 10:00 a.m. EST

Must Haves

• 10+ years hands-on DBA experience.
• Experience with database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
• Experience maintaining and monitoring Oracle 10g, 11g, 12c, and 19c databases in large multi-tenant environments.
• Experience migrating end-of-life Oracle databases to the latest supported Oracle versions in both on-premises and cloud environments.

Description / Responsibilities / Skills

Project Description

APEX/ORDS Evergreening Initiative

The goal of the APEX/ORDS Evergreening initiative is to upgrade the complete technical stack supporting five Ministry of Environment, Conservation and Parks business-critical applications.

Current technologies include:

• Oracle Database
• Oracle APEX
• Oracle REST Data Services (ORDS)
• Red Hat Linux

These technologies are approaching or have reached end-of-life support and require modernization to comply with Ontario's Digital and Data Strategy.

Cloud hosting is part of the modernization roadmap.

Responsibilities

The Senior Database Administrator will:

• Create and implement physical database designs.
• Administer Oracle database management systems.
• Perform database optimization and capacity planning.
• Install, migrate, maintain, and monitor Oracle databases.
• Design, build, and configure Oracle database servers on:
• Windows
• Solaris
• Linux
• Support Oracle database versions:
• 10g
• 11g
• 12c
• 19c
• 23c
• Ensure performance and availability of:
• Oracle APEX databases
• Siebel databases
• Java application databases
• ArcGIS databases
• Implement security and auditing controls.
• Support new solution architecture and design activities.
• Lead Oracle migration initiatives to Oracle 19c or higher.
• Assist with data refreshes into lower environments.
• Resolve complex Oracle database issues.
• Support production and cloud-hosted environments.
• Assist with:
• TDE (Transparent Data Encryption)
• Oracle Data Guard
• Oracle RAC
• OMS
• OEM 13c
• Support replicated database environments and migrations.
• Document technical solutions and perform knowledge transfer activities.
• Identify, assess, and communicate technical risks.
• Develop mitigation and remediation strategies.

Experience Requirements

• Minimum 10+ years of experience in database administration/analysis.
• Experience with one or more operating systems.
• Experience with Oracle database technologies.
• Experience with SQL and query languages.
• Experience monitoring and enforcing database standards and controls.
• Experience with:
• Incident Management
• Change Management
• Configuration Management
• Experience with communication protocols.
• Strong analytical, troubleshooting, and communication skills.
• Proven ability to meet deadlines.

Desirable Skills

• Distributed data systems.
• Middleware and gateway technologies.
• Cybersecurity vulnerability remediation.
• Awareness of emerging technology trends.
• CASE tools.
• Information Management principles.
• Oracle OBIEE.
• Data Warehouse and Data Mart architecture.
• Enterprise database architecture.
• Technology stack installation, configuration, maintenance, cloning, and upgrades.
• Automated data distribution mechanisms.
• Object-Oriented Analysis and Design.
• Enterprise Architecture deliverables.
• Ontario Government Enterprise Architecture methodology.
• Patch management and technology release upgrades.
• Vendor support coordination.

Knowledge Transfer Requirements

• Knowledge transfer is expected throughout the assignment.
• Regular meetings, working sessions, and touchpoints with ministry staff.
• Transfer of all project documentation and technical artifacts into ministry repositories.
• Dedicated knowledge transfer sessions prior to assignment completion.

Evaluation Criteria

Database Analysis, Design & Implementation 50%

• 10+ years hands-on Oracle DBA experience.
• Database optimization, capacity planning, installation, migration, design, performance tuning, backup, and recovery.
• Experience maintaining Oracle 10g, 11g, 12c, and 19c databases.
• Experience migrating legacy Oracle platforms to supported Oracle versions.
• Database security, auditing, privacy, and compliance implementation.

Technical, Planning, Coordination & Monitoring 20%

• Experience coordinating implementation of complex technical solutions.
• Systems analysis and solution design experience.
• Strong stakeholder communication skills.
• Patch management and implementation planning.
• Experience with distributed data systems.
• Experience with middleware and gateways.
• Understanding of emerging technologies and technology roadmaps.

Communications & Teamwork 30%

• Experience documenting technical solutions for knowledge transfer.
• Ability to explain technical concepts in plain language.
• Excellent verbal and written communication skills.
• Strong teamwork and relationship-building abilities.