Kenneth Onyeka Ugwu is a database Consultant with over 15 years of experience, cutting across Global Telecoms and Financials Institutions with indebt knowledge in the Database Architecture, Installation, Configuration, Performance Analysis & Tuning, Optimization, Configuration, Scripting et cetera on different Database Systems including relational (Oracle DBs, MySQL & Microsoft SQL) and non-relational databases (Mongo DB). Strong professional skills in Oracle Real Application Cluster (RAC), Database Upgrade, Oracle Database Online Archiving (Information Life Cycle (ILM)), Database Migration, Database Consolidation, Database Restructuring and Performance Tuning with sound leadership skills. I have managed a team of nine vibrant database Administrators. Expert in the Troubleshooting and Resolution of Database Performance Issues. Excellent in the Proactive and Quarterly Database Patching and versatile in the Routine Disaster Recovery / Business Continuity Readiness Exercises using different databases Business Continuity technologies
Experience
WIPRO/CWG
Jul 2017 – Present
Lagos Nigeria
Senior Database Consultant
Experience in Oracle 10g/11g/12c/19c RAC and GRID Infrastructure, Architecture, Configuration, Upgrade and Administration • Performance Tuning on Critical Databases that includes Oracle, MySQL, and MongoDB databases. • Oracle Real Application Cluster (RAC) 11g, 12c installation, setup, Upgrade and database Migration. • Oracle RAC to RAC Active data guard configuration and Setup on 11g and 12c • Oracle RMAN Backup and Restore Implementation both on Single Instance and RAC 11g and 12c environments • Installation and Setup of MySQL 5.6,5.7.22 and configuration of MySQL Enterprise Backup and recovery. • MySQL Database Upgrade and Migration from 5.6 to 5.7.22 across different infrastructures. • Setup and Configuration of MySQL Replication for High Availability •configured, installed, and implemented more than 20 Oracle Database RAC (2-node each) Databases for MTN Nigeria • Upgrade Oracle database from 9i to 10g, from 10g to 11gR1/R2 and from 10g/11gR1/R2 to 12cR1/R2 in Dev, Test, QA and Production db •Application of Oracle Patch Set Update (PSU) patches in line with MTN Nigeria’s policies • High Expertise in the Installation, Configuration and Optimization of Enterprise SQL Servers in 2000,2005, 2008, 2008R2, 2012, 2014 and 2016. • Carried out Quarterly Application of SQL Service Packs and Cumulative Updates in line with Company’s Policy. • Implemented and Managed SQL Server 2005, 2008 and 2014 Failover Clustering for Higher SQL Server Database Availability. • Put in place SQL Server 2008R2 mirroring in our Enterprise SQL Server Instances as part of business Continuity plan. •Proactive Database Monitoring of databases for optimized performance using Oracle Enterprise Manager Cloud Control 12c, 13c • Provided 24*7 DBA onsite and remote supports • Database Consolidation and Restructuring • Oracle Online Archiving: Implemented Monthly online database archiving on our Enterprise Data Warehouse