Manager Cloud

Joseph Udeh

678-***-**** ******.*******@*****.***

A visionary, team player, hands-on, dependable, and results-driven Oracle Database Administrator with over 7 years experience in installation, implementation, tuning, development, documentation, and support of Oracle Database 11g /12c/19c databases on various OS platforms. Skills Summary

Proficient in all DBA tasks including: Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup, Recovery, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, Unix Shell Scripting, Scripting in RMAN and Documentation.

Participated in a 24/7 production support for Oracle database 11g/12c/19c Proficient in root-cause analysis and performance tuning using Explain Plan, Hints, SQL Tuning Advisor, SQL Developer, TOAD, AWR Report and Enterprise Manager 13c Cloud Control Exposure to Oracle Cloud Infrastructure and Oracle Autonomous Database EDUCATION & PROFESSIONAL CERTIFICATIONS

Certified Oracle Cloud Infrastructure Architect Professional Certified Oracle Cloud Infrastructure Architect Associate Certified Oracle Autonomous Database Specialist

Certified Oracle Cloud Infrastructure Foundation Associate Oracle Database 11g: Structured Query Language (SQL) BSc. Economics - Ambrose Ali University, Ekpoma

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Textron GSE, Atlanta GA. Feb-2018~ Oct-2020

Provided problem resolution support, specific to database issues; identified and resolved database problems, coordinating with application users to determine root cause and ensure accurate resolution Monitored and tunes database performance during testing and production operations; coordinated and implemented database sizing/resizing, restructures and index rebuilds; assists with capacity planning for future database growth; documents benchmarks and procedures needed to optimize performance; ensure that all performance guidelines are followed.

Reviews and analyzes change requests to determine the scope of work and estimate the level of effort for database changes. Writes technical specifications. Planned and implemented disaster recovery infrastructure using Oracle Active Data Guard with Broker and monitoring with OEM 13c Cloud Control.

Coordinated and performed periodic disaster recovery test including Site failover/switchover using Oracle Active Data Guard with Broker

Cloned/Refresh DEV and Test databases from PROD using RMAN DUPLICATE and Data Pump. As well as performed periodic test recovery procedures to ensure the validity of backups and workability of the recovery system

Performed upgrade/migrate of oracle database 12.2 to 19c using Transportable Tablespace (TTS), Data pump and DBUA as well as upgrade of Grid infrastructure. Evaluated and Applied quarterly Patches as well as work with Oracle Support to escalate and resolve issues based on SLA

Designed and implemented UNIX shell script/SQL Loader for loading flat files to Oracle Database daily Oracle Database Administrator

Vintage Press Limited, Oshodi. Jan-2012 ~ Nov-2017 Developed and modified database definitions including entities, attributes, relationships, and referential integrity triggers. Maintains detailed database design documentation. Implements database access procedures including User ID administration Managed backup & recovery for Oracle on Oracle Solaris using RMAN Processed the day-to-day user requests and troubleshooting the database related problems. Monitored Tablespace size, resizing Tablespace, relocating data files for better disk I/O. Enhanced end users’ understanding of database system by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials. Work with Developers to design, develop, test and maintain Oracle PL/SQL packages, triggers, stored procedures and functions to support multiple clients. Created, modified and maintained Oracle database objects and storage structures including tablespaces, tables, users, roles, profiles, directories and indexes. Act as a liaison and leader to resolve application or system issues working with cross-departmental teams: application developers, quality assurance testers, other application support individuals & server, network and mentor Junior database administrators.

SQL*Plus, DBCA, NETMGR, NETCA, Recovery Catalog, Automated Workload Repository (AWR), ADRCI, ASMCA, Enterprise Manager (OEM) cloud Control, Data Pump, SQL Loader, Oracle Recovery Manager (RMAN),, Oracle Scheduler, Real Application Clusters (RAC), Unix Shell Scripting, Automatic Storage Management (ASM), TOAD, MobaxTerm, SecureCRT, putty

References

Available upon request/Green Card

Contact this candidate