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
Oracle cloud services
Performance tuning
Oracle ASM management
Network configuration
Database security management
Data guard implementation
PL and SQL development
Patch management
Disaster recovery planning
Database cloning
Oracle RAC configuration
Disaster recovery
High availability solutions
Memory management
Backup and recovery
Oracle exadata management
GoldenGate implementation
Database troubleshooting
Real application testing
Capacity planning
Linux administration
Shell scripting
Database migration
Linux operating system
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