Database Administrator - Senior
Summary:
Join our team as a Senior Oracle Database Administrator to modernize Ontario’s mission-critical Air Quality systems. In this role, you'll lead the design, optimization, and migration of Oracle databases (10g–19c) within a complex, multi-tenant environment. You’ll implement cloud-ready solutions, enforce database security and auditing protocols, and provide expert-level support across both on-premises and GoCloud infrastructures. With a focus on performance tuning, backup, and recovery, you’ll also contribute to solution architecture and technical risk assessment. Ideal for experienced DBAs with strong documentation and communication skills who thrive in collaborative, compliance-driven, and large-scale enterprise environments. This is a remote, Ontario-based role.
 
Description

To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis.

 

Project Description - 'Air Quality Suite Evergreening' - The goal of the Air Quality suite evergreening initiative is to upgrade the full technical stack for Ontario's Mission Critical Air Quality I&IT solutions. The current suite is built with Oracle database, APEX/ORDS, and Red Hat Linux OS software which are all at end-of-life support with the manufacturer. To stay secure and compliant with Ontario's Digital and Data Strategy, the systems software and hardware technical components must be upgraded - A process known as Evergreening . Cloud hosting is targeted as part of this evergreening.

 

This Statement of Work (SOW) shall expire on 31st March 2026. Clients may exercise its option(s) to extend the SOW beyond 31st March 2026. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 1 2026 and be upon the same terms, conditions and covenants contained in the SOW

Skills
Experience and Skill Set Requirements

Responsibilities:

  • Creates and implements physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery. 
  • Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
  • Maintain and monitor a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments including database administration, maintenance, optimization, migration, and fine tuning of databases
  • Design, build and configure Oracle Database Servers on Windows, Solaris, Linux
  • Ensure existing databases meet performance requirements including but not limited to SIEBEL, ARCGIS, APEX databases on Oracle
  • Ensure that all deployed databases are secure and that appropriate security and auditing controls are in place to meet security and privacy requirements
  • Provide database administration technical expertise during design and architecture phases of new solutions
  • Lead and design solutions for enterprise Oracle migration project to migrate to 19c
  • Plan, manage and coordinate implementation of technically advanced complex systems and assist in Data refreshes to lower non production environment
  • Provide regular support to resolve complex and unique database management issues
  • Provide expert support and guidance to production database systems and clients by overseeing the deployment and evaluation of complex Oracle databases
  • Provide support and maintenance of databases in GoCloud and on premise based environments
  • Carry out complex/specialized systems analysis and design for success of Oracle migration
  • Provide assistance in the implementing, TDE, Dataguard, RAC, OMS, OEM 13c
  • Provide assistance with replicated database management and migration
  • Documentation of your technical work such that knowledge can be transferred to you colleagues
  •  Identifies, analyses, prioritizes and communicates technical risks for decision makers
  • Provides recommendations and mitigation strategies based on a detailed evaluation of technical risks and issues
  •  Communicates effectively to identify needs and evaluate solutions to complex business and technical issues   

 

Experience Requirements:

 

  • Minimum 10+ years experience as Database Analysis (other IT roles to be considered as part of years experience)
  • Experience with one or more operating systems
  • Experience with one or more database technologies
  • Experience in one or more programming languages Experience in the use of information retrieval packages and proficiency with query languages
  • Experience in monitoring and enforcing database rules
  • Experience in Cloud migration
  • Experience in Incident, Change and Configuration Management procedures
  • Experience with one or more communications protocols
  • Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
  • A team player with a track record for meeting deadlines

 

Desirable Skills

  • Experience with distributed data systems
  • Experience with middleware and gateways
  • Experience with researching and implementing cyber security vulnerability remediation's
  • Awareness of emerging IT trends and directions
  • Experience with Computer Aided Software Engineering (CASE) tools
  • Knowledge and understanding of Information Management principles, concepts, policies and practices
  • Experience in Database Administration, Maintenance Optimization
  • Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE
  • Subject matter expert in database design of the data warehouse or data marts.
  • Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
  • Additional Skills for Case Management and ERP Experience in designing/developing an automated data distribution mechanism
  • Knowledge and understanding of object-oriented analysis and design techniques.
  • Experience in developing enterprise architecture deliverables (e.g. models)
  • Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
  • Knowledge and understanding of Information Management principles, concepts, policies and practices
  • Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
  • Experience in technical design, planning and implementation of specific technology or suite
  • Experience with database administration and vendor support services

 

Knowledge Transfer Requirements

  • Knowledge transfer is expected to occur throughout the duration of the assignment through regular meetings, touchpoints, and working sessions with LRC staff
  • All artefacts, including all relevant and complete documents, must be transferred to the ministry in the designated repositories provided
  • Dedicated knowledge transfer sessions will be scheduled to ensure completeness of knowledge transfer and all documentation is shared, and allow LRC staff to ask clarification and/or follow up questions

 

Evaluation Criteria

 

Database Analysis, Design and Implementation Skills/Experience - 50%

  • 10+ years hands on experience
  • Experience with database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery in Cloud environments.
  • Experience maintaining and monitoring a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments
  • Experience with deployed databases security i.e. ensuring appropriate security and auditing controls are in place to meet security and privacy requirements

 

Technical Planning, Coordination and Monitoring Skills/Experience - 15%

  • Experience coordinating implementation of technically advanced complex systems resources to lower non production environment
  • Experience in providing complex/specialized systems analysis and design for success
  • Communicates effectively to drive technical outcomes with technical staff/teammates

 

Communications and Teamwork Skills - 30%

  • Experience documenting technical work that facilitates knowledge transfer
  • Communicates technical issues in plain language effectively
  • Excellent verbal and written communication skills
  • Demonstrated strength building strong relationships and being a strong team player

 

Desired Technical Skills - 5%

  • Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
  • Experience with distributed data systems
  • Experience with middleware and gateways
  • Awareness of emerging IT trends and directions

 

Supplier Comments

 

 

Assigning Type - Remote (Candidate must be in Ontario)

 

Max no of submission- 1( one)

Must Haves:

 

  • Experience maintaining and monitoring a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments
  • Experience with deployed databases security i.e. ensuring appropriate security and auditing controls are in place to meet security and privacy requirements
  • Experience documenting technical work that facilitates knowledge transfer
  • Excellent verbal and written communication skills