OFA Database Administrator at Jubilee Insurance

Job Ref. No. JLIL065

Main Purpose of the Job (Job Summary)

The role holder will support and maintain Oracle EBS R12 across multiple instances for production, UAT and development environment. Working knowledge in Oracle EBS 12.X architecture, installation, patching, cloning, backups & recovery, and performance tuning.

Main Responsibilities

• Knowledge of online patching of EBS application patches
• Experience working with WebLogic administration
• Working knowing on setting up environment on RAC
• Troubleshooting and resolve issues related to oracle workflows/ integrations /ODI
• Design and build database, schemes, and database objects
• Working knowledge of version oracle database 11g/12c/19c
• Set up routine database backup procedures and disaster recovery procedures.
• Setup of disaster recovery site for production environment and monitor of the same
• Design and implement database security schemas
• Assist developers and end-users with database usage, query development, and tuning
• Perform cloning of application and database instances utilizing Oracles Rapid Clone methodology
• Good exposure on RMAN, ASM, Dataguard, Datapump Utilities.

Academic Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Telecommunications or any other related field.
• Oracle Certified Professional (OCP)
• Experience in release 11/12
• Experience in Oracle RAC

Experience

• A minimum of 5 years’ experience in Oracle applications database administration
• Working knowledge in Oracle EBS 12.X architecture, installation, patching, cloning, backups & recovery, and performance tuning.
• Completed minimum 5 end to end installation on R12.
• Experience on working with EBS on cloud environment.
• Experience in recovering application & database in case of any eventuality.
• 3-5 years’ experience in technology/data roles
• Experience with relational database systems (MSSQL, Oracle, Sybase, MySQL, Postgres, SAP HANA)
• Advanced skills in data scripting and database development technologies (SQL, C#, Python, PowerShell, Ruby, Java, Batch Scripting)
• Experience with Cloud platforms (AWS, Azure, Google Cloud)

Closing date: 30 May 2022