Summary
Overview
Work History
Education
Skills
Certification
References
Interests
Disclaimer
Additional Skills
Accomplishments
Software
Timeline
Generic
Duncan Ochieng Otieno

Duncan Ochieng Otieno

Oracle Database Administrator/APPS DBA

Summary

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

14
14
years of professional experience
2014
2014
years of post-secondary education
5
5
Certifications
1
1
Language

Work History

Oracle Database Administrator/Oracle Apps DBA

Safaricom PLC
11.2017 - Current
  • ERP 12.1.3 support and administration.
  • Provided technical support to end-users, troubleshooting database-related issues and offering guidance on best practices.
  • ERP 12.1.3 cloning and support on the dev and test environments.
  • Managed user accounts within the Oracle Database environment, granting appropriate permissions while adhering to security protocols.
  • ERP 12.1.3 upgrade to ERP 12.2.10.
  • Provided resources and skill sets to support DBA functions for applications.
  • ERP 12.2.10 administration and support.
  • Developed custom scripts and PL/SQL procedures for efficient automation of routine tasks and data management operations.
  • Installation and setup of 19.3 oracle database and administration.
  • Upgrade ebs 11i to 12.2.10.
  • ERP DB upgrade from 9i to 19C.
  • Database patching.
  • Established effective communication channels between IT teams responsible for managing different aspects of the Oracle Database infrastructure.
  • ERP 12.1.3 and 12.2.10 patching activities.
  • Installed and configured middleware in Linux and Windows environments.
  • SOA 12.1.3 setup, support, and administration.
  • Led training sessions for junior team members on best practices in maintaining an efficient Oracle Database environment.
  • SOA 12.1.3 upgrade to SOA 12.2.1.4.
  • Served as a subject matter expert in meetings with stakeholders discussing project requirements related to Oracle Databases integration.
  • SOA set up and administration (Database Integration)
  • Worked with customers and other third parties to support DBA functions.
  • ODI installation and administration.
  • ODI 12.2.1.3 upgrade to ODI 12.2.1.4.
  • ODI migration from Oracle Exalogic to PCA.
  • OMFT installation and administration.
  • OMFT 12.2.1.3 upgrades to OMFT 12.2.1.4
  • OMFT migration from Exalogic to PCA.
  • IDM 12.2.1.3 installation and administration.
  • ERP DB performance monitoring on EM and other monitoring tools.
  • Workflow monitoring.
  • Applications integration to ERP.
  • ERP cloning on dev and test instances.
  • Concurrent managers monitoring.
  • Performance tuning and monitoring.
  • SOA apps monitoring.
  • OMFT monitoring.
  • ODI monitoring.
  • WebLogic 12.2.1.3 installation and administration (12C, 11g).
  • POS setup and administration.
  • EDQ apps and DB setup and administration.
  • Exadata administration
  • DBA shell scripting for monitoring database and application
  • Network configuration in both windows and Linux environment.
  • Oracle E-Business Suite installation and configuration
  • General database maintenance and security tasks (scripting, error troubleshooting, creation and management of database objects e. g. tablespaces, indexes, views etc.)
  • Oracle Compliance Management.
  • Performance tuning
  • Database and application tier patch management.
  • Instance cloning
  • Formulating and implementing back up and disaster recovery strategies
  • Performing cold and hot backups (RMAN )
  • Streamlined backup and recovery processes, enhancing overall system stability and availability.
  • Troubleshot database issues to create and resolve trouble tickets.
  • Implemented capacity planning strategies, optimizing resource allocation and preventing system overloads.
  • Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
  • Streamlined backup processes, ensuring timely recovery in case of data loss or system failure.
  • Reduced downtime by proactively monitoring and addressing potential issues with the Oracle Database system.
  • Established working relationships across various departments to understand existing and emerging IT requirements.
  • Improved database performance by optimizing SQL queries and implementing indexing strategies.
  • Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.

oracle apps dba

Simba Technologies ltd
12.2015 - 01.2017
  • Linux system installation and administration
  • SOA set up and administration (Database Integration)
  • Database migration to a new platform
  • Oracle database and application migration to latest releases
  • Weblogic installation and administration
  • Exadata administration
  • DBA shell scripting for monitoring database and application
  • Network configuration in both windows and linux environment.
  • Oracle E-Business Suite installation and configuration
  • General database maintenance and security tasks (scripting, error troubleshooting, creation and management of database objects e. g. tablespaces, indexes, views etc.)
  • Oracle Compliance Management
  • Netapps storage administration
  • Performance tuning
  • Database and application tier patch management.
  • Instance cloning
  • Formulating and implementing back up and disaster recovery strategies
  • Performing cold and hot backups (RMAN )
  • Sysadmin responsibilities e.g. creation of users, roles and responsibilities, menus etc

Oracle Intern

Koenig Solutions Limited
01.2015 - 05.2016
  • Administering users in 10g/11g DBA and Developer, SQL Tuning of the pl/sql procedures, sql statements and any other query language.
  • Responsible for providing support to clients in writing complex querries
  • Skills in Oracle database 11g , which include creating SQL Queries, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers etc.
  • Skills in writing Exceptions, Joins, Sub Queries and Set Operators.
  • Good knowledge of database administration including export- import, data pump, SQL Loader external tables.
  • Extensively worked with tools like Oracle SQL Developer and SQL
  • Plus and Toad for oracle
  • Interacted frequently with In-house client side resources. Analyzed the issues reported by client team and worked with them to resolve the reported issues.
  • Extensively involved in System understanding, requirement discussion and gaps identification.
  • Recognized for strong skills in organization, analysis, communication, customer satisfaction, troubleshooting and collaboration with cross- functional teams.

Intern

Soft Clans Technologies ltd
01.2012 - 05.2012
  • ERP monitoring.
  • ERP DB performance monitoring on EM and other monitoring tools.
  • Workflow monitoring.
  • Applications integration to ERP.
  • ERP cloning on dev and test instances.
  • Concurrent managers monitoring.
  • Performance tuning and monitoring.
  • SOA apps monitoring.
  • OMFT monitoring.
  • ODI monitoring.
  • Creating SQL Queries, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers etc.
  • Writing Exceptions, Joins, Sub Queries and Set Operators.
  • Created views from data
  • Created triggers on database objects to perform automatic updates and insertions
  • Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
  • Attachment

Education

B.Sc. - Computer Technology

Multimedia University Of Kenya

Secondary Education - undefined

Muhoroni Secondary School

Primary School Education - undefined

Oduwo Primary School

Skills

Oracle database administration

Certification

OCP(Oracle Certified Professional) in Database Administration 11g, 2014

References

Alex, Kibe, Oracle specialist, 0722354847, KENYA

Interests

Listening to Music, watching movies, travelling

Disclaimer

I hereby declare that the information given above is correct to the best of my knowledge and belief.

Additional Skills

  • Strong work ethics, good attention to detail, excellent team player, great communication skills and ability to learn in a fast paced environment.
  • Strong leadership skills- has attended various leadership seminars and was a class chairman for a period of four years in campus.

Accomplishments

  • Resolved product issue through consumer testing.
  • Achieved ERP DB upgrades.
  • Documented and resolved SOA Applications.
  • Achieved EBS upgrade from 12.1.3 to 12.2.10.
  • Installation and setup of 19.3 DB.

Software

Professional

Timeline

Oracle Database Administrator/Oracle Apps DBA

Safaricom PLC
11.2017 - Current

oracle apps dba

Simba Technologies ltd
12.2015 - 01.2017

Oracle Intern

Koenig Solutions Limited
01.2015 - 05.2016

Intern

Soft Clans Technologies ltd
01.2012 - 05.2012

Secondary Education - undefined

Muhoroni Secondary School

Primary School Education - undefined

Oduwo Primary School

B.Sc. - Computer Technology

Multimedia University Of Kenya
Duncan Ochieng OtienoOracle Database Administrator/APPS DBA