The International Institute of Tropical Agriculture (IITA) is a not-for-profit institution that generates agricultural innovations to meet Africa’s most pressing challenges of hunger, malnutrition, poverty, and natural resource degradation. Working with various partners across sub-Saharan Africa, we improve livelihoods, enhance food and nutrition security, increase employment, and preserve natural resource integrity. IITA is a member of CGIAR, a global agriculture research partnership for a food secure future.
Install, configure, and support database management systems (Oracle & 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.
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 & 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 & 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.
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.