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.
Technical Customer Support Engineer at Viscar Industrial Capacity(SAFARICOM PLC)Technical Customer Support Engineer at Viscar Industrial Capacity(SAFARICOM PLC)
Sr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems IncSr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems Inc