Manager Oracle

CHINEDU C. UGWUEGBULEM

Oracle Database Administrator

ac18hv@r.postjobfree.com 202-***-****

H I GHL I GHT

An Oracle Database Administrator with 6years of experience which includes Migration, Database Backup & Recovery, data guard implementation, Tuning at Instance level and SQL level, Cloning, Space Management, Database Security and Auditing, Troubleshooting, Managing Oracle 10g, 11g/12c databases and documentation in heterogeneous environments. Worked on Databases across various platforms such as Solaris, AIX, UNIX, Linux, HP and Windows. PROFES S I ONAL SUMMARY

Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.

Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning. Experience in full Software Development Lifecycle (SDLC) from association with end-users for requirements determination, defining the system scope, system analysis, Business Case Development to Rollout, Production, testing, maintenance and documentation Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems

Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs

Troubleshoot and resolve slowness or performance issues with extensive investigation and follow- up with respective application teams with RCA and proposed solutions. Developed Recovery Manager (RMAN) scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances. Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams. Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.

Upgraded Oracle 10g to 11g and 11g to 12c database versions Provided database related services to development & QA environments Good experience of Installation and configuration of RAC (Real Application Cluster) on different nodes with ASM (automatic storage management) Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC Supported Server migrations, Application upgrades/Migrations and Data center movements Configured Offline and Online Disaster recovery sites to maximize database availability Applied Oracle Patches (CPU/PSUs and One-off patches) Strong skills in SQL*PLUS, PL/SQL, SQL*Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager

Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers

2

Thorough understanding and excellent experience in tuning, assigning proper indexes such as BITMAP or B-Tree Index according to requirement.

Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise. Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.

Excellent experience in Performance tuning of oracle databases using Oracle Grid Control,AWR, ADDM, TKPROF,STATSPACK, and tuning of SQL scripts using SQL Trace, Explain Plan, and Hints. Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users. Experience in creation of project presentations for progress meetings and other high level discussions.

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

EDUCAT I ON

RedHat/Linux Certification in Process

Oracle Solaris 10 Certification in Process

Enugu state University of Science & Technology Enugu, Nigeria

- Bachelor of Sciences in Industrial Physics

RE LATED EXPER I ENCE

CTBC Bank - Edison, NJ September 2014 – Present

Oracle Production Support Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Loading data from flat files to database using SQL*Loader, External Tables. Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Extensively used AWR, ADDM and explain plan for periodic performance tuning. Implementing Datapump, 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 Datapump import/export to move data between 9i and 10g/11g environments. Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Databases migrated to RAC for improved resiliency and performance. Security User Management, Privileges, Role, Auditing, Profiling, Authentication. Creating Materialized views and Materialized View Logs for Increased Performance and Data 3

Replication.

Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.

Provided valuable inputs for various performance tuning issues. Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. Refreshed/cloned databases using RMAN utility. Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform. Involved in converting a single instance database to Oracle 11g, 10g RAC databases. Installed ASM environment and migrated databases from NON-ASM to ASM. Used TOAD for database management.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning. Experienced in cloning the databases using HOT and COLD backups. Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3. Made optimal use of Oracle Support in resolving the SRs. 24 X 7 Production & Development database support and administration. Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, Tools: ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0. Emblem Health - New York, NY June 2011 – Aug 2014

Oracle Production Support Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Loading data from flat files to database using SQL*Loader, External Tables. Extensively used AWR, ADDM and explain plan for periodic performance tuning. Implementing Datapump, 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 Datapump import/export to move data between 10g and 10g/11g environments. Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

4

Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting

Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues. Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability. Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data. Involved in capacity planning and resource planning. Generated weekly performance reports to identify and solve the problems with performance. Diagnosed Oracle bugs and coordinated with Oracle support through Metalink+ to resolve them in timely manner.

Applied patches and worked closely with Oracle to make Application environment up to date. Responsible for data integrity, user security, daily monitoring for production and non-production systems. Used standard.

Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform. Involved in converting a single instance database to Oracle 11g, 10g RAC databases. Installed ASM environment and migrated databases from NON-ASM to ASM. Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs. 24 X 7 Production & Development database support and administration. Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, Tools: ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Contact this candidate