RQ- Specialized IT Consultant - Senior

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) ODA-X9 are currently in operation in the COMPASS ATMS environment since 2023 and have been running Oracle 19C database with two-node 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 province-wide COMPASS ATMS system.

• 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
  • Re-create 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.

• 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 ODA-X9 environment

Technical Experience and Qualifications - 30%

• Demonstrated practical experience in Oracle single-node DB systems and 2-node RAC DB systems on virtual machines within the last 5 years
• Demonstrated practical experience in Oracle Standby Database Architecture and Oracle…