Database Administrator - Application

Description

• *Deliverable and Skillset**

To enhance the efficiency, security, and overall maintainability of the system, ministry is initiating the Cúram and Oracle upgrade projects and requires servicers of a seasoned Oracle Application DBA.

This strategic endeavour must be to upgrade the existing Cúram platform and Oracle Database version, which is approaching the end of its support, to the latest versions. As part of this exercise, to support the latest middleware, WebSphere will also be upgraded.

The key deliverable and skillsets required.

• An experience Oracle Database Administrator including Oracle RDBMS, Data Guard, Golden Gate, Automatic Storage Management (ASM), Oracle Vault, Oracle Security/Encryption, and Oracle Enterprise Manager (OEM) on RedHat Linux Enterprise.
• Experience with installing and testing new versions i.e., upgrading from Oracle 12c version of 19c.
• Working knowledge of features such as Oracle Multitenant option, Oracle Active Data Guard Far Sync, in-memory database, RMAN backup/recovery, fail-over, data masking, security, and new data types.
• Experience with install, patch, and maintenance of all Oracle software
• Hands-on Experience in Azure Cloud including VM, Storage, Network, Security, Key Vault, Backup/Recovery
• Strong leadership and Ability to communicate regularly with project and operational teams.
• Excellent analytical, problem-solving, and decision-making skills
• SKILLS
• *EXPERIENCE REQUIREMENTS**
• *CRITERION**
• *CRITERION DETAILS**
• *CRITERION MAXIMUM RATING**

TECHNICAL SKILLS AND

EXPERIENCE- 10+ YEARS EXPERIENCE ORACLE DATABASE ADMINISTRATOR INCLUDING ORACLE

RDBMS, DATA GUARD, AUTOMATIC STORAGE MANAGEMENT (ASM), ORACLE VAULT, ORACLE

SECURITY/ENCRYPTION, AND ORACLE ENTERPRISE MANAGER (OEM) ON REDHAT LINUX

ENTERPRISE.- 2+ YEARS OF EXPERIENCE WITH ORACLE GOLDEN GATE

• EXPERIENCE WITH INSTALLING AND TESTING NEW VERSIONS I.E., UPGRADING FROM

ORACLE 12C VERSION OF 19C.- WORKING KNOWLEDGE OF FEATURES SUCH AS ORACLE MULTITENANT OPTION,

ORACLE ACTIVE DATA GUARD FAR SYNC, IN-MEMORY DATABASE, RMAN BACKUP/RECOVERY, FAIL-OVER,

DATA MASKING, SECURITY, AND NEW DATA TYPES.- EXPERIENCE WITH INSTALL, PATCH, AND MAINTENANCE OF ALL ORACLE SOFTWARE

• EXPERIENCE WITH PERFORMANCE TUNING ALL ORACLE INSTANCE COMPONENTS

INCLUDING SQL AND PL/SQL FOR APPLICATION HANDS-ON EXPERIENCE IN AZURE CLOUD INCLUDING VM, STORAGE, NETWORK, SECURITY,

KEY VAULT, BACKUP/RECOVERY, SCRIPTING/AUTOMATION AND MAINTAINING DATA

STANDARDS WHILE ADHERING TO THE DATA PROTECTION ACT35PROBLEM-SOLVING SKILLS- 5+ YEARS EXPERIENCE WITH TROUBLESHOOTING, PROBLEM SOLVING, PERFORMANCE

TUNING, INFRASTRUCTURE, APPLICATION, AND DATA RELATED ISSUES.- EXPERIENCE WITH ORACLE DATABASE VERSION UPGRADE AND MIGRATION ISSUES

• PROFICIENT IN TROUBLESHOOTING, ROOT CAUSE ANALYSIS, AND IMPLEMENTING

SOLUTIONS25PROJECT MANAGEMENT

SKILLS- 2+ YEARS EXPERIENCE WITH PROJECT PLANNING AND EXECUTION

20SOFT SKILLS- ABILITY TO COMMUNICATE REGULARLY WITH PROJECT AND OPERATIONAL TEAMS.

• EXCELLENT ANALYTICAL, PROBLEM-SOLVING, AND DECISION-MAKING SKILLS
• STRONG LEADERSHIP AND COLLABORATION SKILLS
• PROVEN TRACK RECORD FOR BUILDING STRONG WORKING RELATIONSHIPS.
• A DEMONSTRATED TEAM PLAYER WITH A TRACK RECORD FOR MEETING DEADLINES

15PUBLIC SECTOR EXPERIENCE- PREVIOUS EXPERIENCE WORKING WITHIN THE PUBLIC SECTOR WOULD BE AN ASSET

5**TOTAL**

• *100**
• SUPPLIER COMMENTS
• *CLOSING TIME/DATE**:2024-12-23, 3:30 P.M. EST
• *MAX SUBMISSION: 1 (ONE)**
• *HYBRID: 3 DAYS ONSITE / 2 DAYS REMOTE**
• *MUST HAVES**:
• 10+ YEARS’ EXPERIENCE ORACLE DATABASE ADMINISTRATOR INCLUDING ORACLE RDBMS, DATA GUARD, AUTOMATIC STORAGE MANAGEMENT (ASM), ORACLE VAULT, ORACLE SECURITY/ENCRYPTION, AND ORACLE ENTERPRISE MANAGER (OEM) ON REDHAT LINUX ENTERPRISE.
• 2+ YEARS OF EXPERIENCE WITH ORACLE GOLDEN GATE
• EXPERIENCE WITH INSTALLING AND TESTING NEW VERSIONS I.E., UPGRADING FROM ORACLE 12C VERSION OF 19C.
• HANDS-ON EXPERIENCE IN AZURE CLOUD