Resume

Sign in

Oracle Manager

Location:
Silver Spring, Maryland, United States
Posted:
November 30, 2017

Contact this candidate

Nwancha Therese Mambo

(Oracle Database Administrator)

(202) *******

ac3jjb@r.postjobfree.com

Summary

Over 5 years of comprehensive experience in designing and administering database solutions that improve business efficiency, utilizing strong background in Information Technology Management of 10g/11g/12c on Oracle Database Administration. Has extensive experience in Datapump, Dataguard, Golden Gate among other Oracle Application and platforms – Sun SOLARIS, HP UNIX, RH Linux and Windows Server to provide data security, hardware support and system stability. Able to perform upgrades, patch maintenance, and integration with on oracle database environments to improve timeliness of reports, analyzing inventory, and cost reduction.

Highlights

Technical Skills

Operating Systems HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS Oracle 12c, 11g, 10g

Languages SQL, PL/SQL, UNIX Shell Scripting, PERL

Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

RTechnically proficient in the installation, configuration, upgrade, and implementation of various database tools

RExcellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.

RImplemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicat rebuild and abend.

RSupported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF. Performing monthly and annual performance reports for trend analysis and capacity planning.

RPerformed database replication through Golden Gate.

RSupported a large number of Development Databases.

RProficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.

RExpert in implementing oracle streams, and two types of standby databases supported by dataguard, logical standby and physical standby databases.

RHands on experience in Performance Tuning and Memory (SGA) Tuning.

RProficient in logical backups Export/Import and Datapump. 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.

RUNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Professional Experience

Oracle Database Administrator – Nabors Drilling Services - Houston, TX June 2014 – Present

Provide technical support on multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments

Maintain optimal performance of the Oracle 11g and 12c (Multitenant and NON-CDB) Databases through installation, configuration, Maintenance and Support

Efficiently apply the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch

Upgraded the RAC and standalone databases from 10g to 11g to 12c as part of performance improvement by utilizing the new features

Performed Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP (Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level

Successfully build Oracle Standby databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.

Implemented archive and Purge strategy for archiving the inactive data in the historical database and purging the archived data from the primary database as a part of performance improvisation using Goldengate and exp/imp using partitions.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts

Utilize technical proficiency in Golden Gate to perform database replication as well as implementing archive and Purge strategy to manage historical database

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests

Supported development teams with SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF

Maintained high performance by troubleshooting various database optimizations via all-round diagnosis like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls

Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Oracle Database Administrator – Coca Cola - Atlanta, GA July 2012 – May 2014

Leveraged knowledge of various database tools to manage databases from planning and testing stages through implementation and support

Successfully cloned/migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2

Converted Non RAC single instance to Real Application Cluster (RAC) database instances as well as managing disk and disk group in ASM while installing 11gR2 RAC

Stabilized database performance by scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs

Minimized downtime through close monitoring of the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files

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

Tools/ Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN RHEL 3.X, 4.X; Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS.

Education

Oracle Database Administration Certified (OCA)

University Of Buea – Diploma in Nursing

References

Available Upon Request



Contact this candidate