The International Institute of Tropical Agriculture seeks suitable applicants for the position below at the Institute’s Headquarters in Ibadan.
Position: Oracle Applications Database Administrator
Contract: 3-year renewable contract
Location: Ibadan
Closing Date: 15 March 2024
DUTIES:
- Install, configure, and support database management systems (Oracle amp; SQL databases) and related software to resolve highly complex and/or unique issues without precedent and/or structure. Work on databases using more advanced database administration concepts.
- Carry out day to day activities for ERP and/or Database including but not limited to creating, cloning, patching, code migration, performance tuning, capacity planning, database monitoring, administration, user management, backup/recovery management, SR management, monitoring applications and its services, documentation
- Install, Upgrade, Configure, Clone, Patching amp; Managing of Oracle eBusiness Suite 12.7.
- Responsible for EBS System Administration - User/Role Management, Responsibilities Management, Concurrent Manager/Requests Management.
- Act as liaison to Oracle ERP and other internal applications teams.
- Ensure and maintain highly available databases.
- Take responsibility for database performance optimization, backup and recovery strategies and implementation, as well as monitoring the overall health of the database environment.
- Provide on-going system administration and technical support.
- Experience in Oracle RAC, DR Setups, DataGuard, RMAN, load balancers and Fine-tunning Weblogic.
- Experience in hang analyzer, system state dump, SQL tuning, AWR analysis and Trace analysis.
- Evaluate and test marketplace tools and utilities, including system integration and automation, which enhance server functionality and promote the development of RDBMS applications.
- Maintain documentation and contribute to the ongoing development of new standards.
- Ensure proper disaster recovery procedures are in place and adhered to.
- Responsible for contribution and adherence to standards that ensure the integrity and security of the enterprise's data resources.
- Ensure compliance with IITA Oracle license agreement.
- Provide technical guidance and mentoring to others in areas of expertise.
- Oracle EBS R12 modules user support (Finance amp; Supply chain, iExpense)
- Hands on experience in Oracle Cloud environment will be an added advantage.
- Perform any other job-related duties as may be assigned by the supervisor.
Requirements
QUALIFICATION:
Master's degree in Computer Science, Management Information Systems (MIS), Engineering or related field with a minimum of six (6) years’ experience performing a similar role in a well-structured environment.
COMPETENCIES:
The ideal candidate must:
- Have experience configuring and maintaining Oracle Dataguard/RAC/RMAN
- Have MS SQL Server database administration experience.
- Have Oracle DBA, Apps DBA or other relevant certification.
- Have organizational and documentation skills.
- Have experience supporting critical systems especially Oracle EBS R12.7.
- Have sound troubleshooting and analytical skills.
- Have experience working with remote teams and ability to communicate effectively.
- Have experience supporting EBS financials and Supply chain Modules SCM.
- Have experience supporting Oracle cloud and ERP cloud applications.
Benefits
We offer highly competitive salaries with equally attractive benefits and excellent working conditions in a pleasant campus environment.