Skills Summary

Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances.

Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.

Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.

Worked with customer for different RAC related issues: [hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on].

Troubleshoot performance issues for the RAC instances (GC events).

Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.

Resolved/Diagnose Node Eviction.

Handled Multiple issues with Data Block corruption on ASM Disks.

Add or Remove Node from RAC.

Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.

Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions.

Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (9i to 10g), (10g to 11g) and (11g to 12c).

Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)

Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB

Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g..

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.

Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.

Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.

Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.

Configuration and Management of Data Guard on RHEL, OEL.

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

Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).

Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).

Proactively monitoring the database's health and taking preventive or corrective actions

Proficient in Database Design (Physical and Logical Database Design) and Normalization.

Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).

Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.

Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.

Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.

Automated many common tasks using crontab including Backups,

exports and imports.

Experience Oracle Application database

Experience in database modeling as well as Exadata servers

Work Experience

VECTREN - EVANSVILLE, IN

February 2016 – Present

Oracle Database Administrator

Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions

Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification

Upgrade DBs from 11.2.0.4 to 12.1.

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.

Resolve lock/latch and resource contention issues during production hours

Configure Dataguard and Broker for administration of seamless switchovers.

Upgrade GI and DBs from 11g to 12c with physical standby DBs in place

Utilize SPM SQL Baselines, SQL Profiles and SQL Tuning Advisor for troubleshooting and providing tuning recommendations to application teams.

Generate and analyze EXPLAIN PLAN, SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.

Analyze AWR, ASH and ADDM reports and draw conclusions that aid in troubleshooting performance issues. Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Monitoring and Troubleshooting GoldenGate Replication issues

Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tunig Automation, Flashback Database, compression techniques and several others

Usage of enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging, Redo Log reduction on GTTs using temp_undo_enabled.

Peform LOB Compression, SecureFile and Deduplication in a cost-saving effort

Experience using enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging

Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tunig Automation, Flashback Database, compression techniques and several others

Monitoring and Troubleshooting of Database Replication issues

Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results

Working with Application Development team to address any issues they encounter and provide support and resolution action plan

CARESOURCE - DAYTON, OH

November 2012 – February 2016

Oracle Database Administrator

Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.

Worked on disaster recovery of exadata dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.

Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.

Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.

Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.

Performed troubleshooting of database using AWR and ADDM reports.

Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.

Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually

Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.

Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Installed Oracle and grid software on standalone servers on ASM and file system.

Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Education

Master II of Science in Environmental Science

Option: Man and Environment

University of Douala

Master I of Science in Environmental Science

Option: Man and Environment

University of Douala

Bachelor of Science Degree in Geography

VNN

VAMON N. NGWA

Email: ac7vgq@r.postjobfree.com

Phone: 301-***-****

Contact this candidate