Description

Description Section for Assignment in VMS (Flextrack):

The MTO COMPASS Advanced Traffic Management System (ATMS) allows Traffic Operation Centres to monitor the traffic and road conditions of selected provincially maintained highways; as well as control in real time all the field traffic control assets through MTOs private COMPASS fibre network. Oracle Database Appliance (ODA) with Virtual Machine (VM) provisioning and Oracle Weblogic Application Server are two key components within the COMPASS ATMS environment.

Two (2) ODAX9 are currently in operation in the COMPASS ATMS environment since 2023 and have been running Oracle 19C database with twonode RAC configuration Fusion Middleware (Weblogic) VMs and also hosted other COMPASS application VMs. The ODA development environment has been set up to mirror the production environment. Oracle Dataguard is deployed for the 19C database and Oracle Cloud Control software is used as grid management tools supporting

the 24x7 operation of the provincewide COMPASS ATMS system.

As the existing service provided by the Data Architect/Modeller through IT source is ending on March 31 2025 the new service contract is required to maintain the COMPASS systems production and backup Oracle Database Appliances and to provide preventive maintenance support to COMPASS operations in order to continue support of the 24x7 COMPASS operations and applications as well as ongoing system migration activities.

ITS Office oversees the COMPASS ATMS environment and performs all required testing on the development environment prior to the production rollout. Under this contract all the Oracle components on both production and development environment shall be maintained regularly and upgraded to conform with Oracle support level and certification requirements.

Responsibilities/Assignment Deliverables

This project involves the following tasks to ensure the 24x7 operation of the provincewide COMPASS systems production and backup Oracle Database Appliance (ODA).

1. Provide technical support in COMPASS production database and application update and migration activities. Services include but not limited to the following:

Upgrade the Oracle Cloud Control infrastructure to latest version

Update/reconfigure ODA infrastructure

Update IP addresses of ODA infrastructure to the latest COMPASS VLAN topology

Relocate and/or backup existing VMs

Recreate database and restore necessary VMs

Create new VMs and/or databases

Failover database to another ODA

2. Provide preventive maintenance works. Key tasks involve but not limited to the following:

Monitor and review Oracle Enterprise Manager Cloud Control alerts

Perform regular ODA health checks

Conduct space analysis and checks

Install the latest patches (including latest released Oracle security patches) in the ODA database and Weblogic in both production and backup environment

Maintain the Cloud Control platform

Maintain the Production and Standby Emergency Backup environment and user access control

Provide system support to resolve issue related to Oracle database Fusion Middleware (Weblogic) Cloud Control and JEOS VMs.

3. Interface with Oracle on behalf of the Client on the following:

Manage ODA related incidents and Service Requests (SR)

Coordinate hardware repair/replacement of the ODAs

The consultant must work closely with the client and will undertake and manage the tasks in close collaboration with the Client. The successful consultant shall meet with the Clients team on a frequent basis as deemed required by each task.

The consultant must have practical experience in:

ODA migration in complex production system environment

Deploying and maintaining ODA X92HA and X92L

Installing deploying upgrading and maintaining ODA VM provisioning including the latest versions of Oracle database Weblogic Oracle Fusion Middleware and Linux Just Enough Operation System (JEOS) VMs.

Current COMPASS ODA Configurations:

ODAX9 (to operate in production environment pending completion of migration activities):

One ODA X92HA with VM Provisioning (not baremetal) base configuration

One ODA X92L with VM Provisioning (not baremetal) base configuration

Oracle 19C Enterprise Edition (subject to change)

Weblogic with Fusion Middleware (Forms/Reports) are running as VMs on the same ODA

Weblogic Managed Server are running as VMs on the same ODA

Oracle Cloud Control is running on all ODAs and its VMs

COMPASS ATMS Distributed Functions java programs are running as standalone JEOS VM on ODA DOMx (DOM1 DOM2 etc) NK1

Experience and Skill Set Requirements for Assignment in VMS (Flextrack):

Skill Set Requirements

One (1) Specialized IT Consultant

Practical experience in installing deploying and provisioning Oracle DB Systems Oracle 19C Database VMs and Oracle Weblogic.

Practical expertise in Oracle Database Appliance (ODA) X9 Model Family

Practical expertise in Oracle Standby Database Architecture

Practical expertise in building Oracle Virtual Machine (VM) and VM Template

Practical expertise in applying patches in ODA X9 Model Family

Practical expertise in Oracle Weblogic with Form and Report Services

Practical expertise in working with JEOS Linux

Project management competencies such as planning and organizational skills to be able to complete the deliverables in timeframe provided culminating with high quality results

Previous experience and performance of other similar projects

Demonstrated ability to build effective working relationship with clients

Written and spoken communication skills with respect to both formal presentations reports and correspondence

Practical experience in Oracle Cloud Control

Practical experience in integrating WLS JEOS and Cloud Control in ODAX9 environment

Maintenance and Support Requirements

1. Oracle Certified Professional / Database Administrator

2. Oracle Implementation Certification in Oracle Database Appliance

3. Oracle Implementation Certification in Oracle Virtual Machine

4. Oracle Implementation Certification in Oracle Real Application Clusters

5. Oracle Implementation Certification in Oracle Database

6. Oracle Implementation Certification in Oracle Performance Tuning

7. Oracle Implementation Certification in Oracle Enterprise Manager Oracle Linux

Note: Please be advised that this is an indemand Role and the contractor will be contacted on a needbasis.

SkillsExperience and Skill Set Requirements

Evaluation Criteria

Technical Experience and Qualifications 30%

Demonstrated practical experience in Oracle singlenode DB systems and 2node RAC DB systems on virtual machines within the last 5 years

Demonstrated practical experience in Oracle Standby Database Architecture and Oracle Data Guard within the last 5 years

Demonstrated practical experience in building Oracle Virtual Machine (VM) and VM Template

Demonstrated practical experience in Oracle Weblogic with Form and Report Service (WLS)

Demonstrated practical experience in Oracle Cloud Control

Project Management Skills 20%

Demonstrated experience with project management and in completing deliverables in timeframe provided culminating with a high quality results

Proven experience deploying installing and managing other similar projects

Strong experience with building effective working relationship with clients

Strong written and spoken communication skills with respect to both formal presentations reports and correspondence

ODA Experience 50%

Demonstrated experience in Oracle Database Appliance (ODA) X9 Model Family

Demonstrated practical experience in applying patches in ODA X9 Model Family

Demonstrated practical experience in deploying upgrading and managing Oracle Real

Application Cluster database (including backup/standby) in Oracle Database Appliance (ODA) Virtual Machine (VM) provisioning.

Demonstrated practical experience in deploying upgrading and managing Oracle Fusion Middleware Weblogic (WLS) in ODA VM provisioning.

Demonstrated practical experience in deploying upgrading and managing Just Enough OS (JEOS) Linux VM in ODA.

Demonstrated practical experience in deploying upgrading and managing Oracle Cloud Control in ODA VM provisioning.

Demonstrated practical experience in integrating the WLS JEOS and Cloud Control in the ODA VM provisioning.

Must haves:ODA X92HA and X92L
Note:This consultant is required On Demand basis. This is a Part Time/In Demand Role and not full time 40 hours a week.