Edwin Nkemleke

About Edwin Nkemleke

An Oracle DBA with Over 8 years of experience in the IT industry and 6 plus years of…

Experience

1. Oracle Database Administrator

   UBS

   Jan 2020 — Present · US

   Installed, configuration, maintenance and monitoring of enterprise Development, QA, Staging and Production support of Oracle, SQL server, PostgreSQL databases within the organization to ensure applications availability to the business community.• Goldengate set up with parameterization, scaling, and log dump utility for extract files.• Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the cron job periodically in regular intervals. Write Complex Shell Scripts that automate the Import of Reports to PostgreSQL and MySQL Databases.• Experience in Exadata ½ Rack and Storage Cell Rescue/Re-Image.• Troubleshooting Hardware issues on Exadata machines X6 and X7.• Experience in Cloud OEM 12c/13c for configuration and Maintained Exadata Machines.• End to End Exadata Maintenance, troubleshooting hardware issues on Exadata.• Loading data from flat files to database using SQL*Loader, External Tables.• Extensively used AWR, ADDM and explain plan for periodic performance tuning.• Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g, 11g, 12c, 18c and 19c environments.• Involved in construction of DR sites, configuring data-guard and Enterprise Failover Manager for Production environments, participated in scheduled switch over tests. • Performed Database Refresh from Production to QA, UAT and Development databases. • Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth, and file system space.