Manager Data

Gisele Nkwang

ORACLE DATABASE ADMINISTRATOR

443-***-**** ************@*****.*** Marietta, GA 30067

PROFESSIONAL EXPERIENCES SUMMARY

Highly skilled oracle database administrator with 6 years of experience in Oracle database versions 10G, 11G and 12C in development and production environments.

Extensive experience in tuning and troubleshooting different components of the database and identifying performance issues on OS, Storage, network, application etc.

Highly Experienced in Online/Offline Backup and Recovery technologies and Cloning of databases using RMAN.

Worked on Data transfers using export/import utilities and Data pump.

Highly experienced in performance monitoring/tuning/troubleshooting using AWR, ADDM, ASH, OEM, SQL Tuning advisor, SQL access advisor etc

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 12c on ASM file systems.

Proficient in Database administration activities such as user management, space management, Monitoring, Creating Database, Managing Oracle Instance and Database security and Materialized Views.

Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).

Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.

Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).

Configured and maintained Data guard with Physical, Logical & Active standby databases on Oracle 12c, 11g, 10g RAC servers for disaster recovery procedures.

Configured Manager, Replicate and Extract processes and implemented unidirectional replication using Oracle 11g Golden Gate on linux platforms.

UNIX shell scripts for hot backups, SQL*Loader, export and import of database.

Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Applied security patches Patch set, Critical Patch Updates (CPU), Patch Set Updates (PSU) and One-off Patches using runInstaller and opatch as well as RAC databases.

Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS:

Red Hat Linux RHEL 5.x/6.x/7.x, AIX 6.x, Solaris10/11and Windows 2000-20xx

RDBMS:

Oracle 10G/11G/12C

LANGUAGES:

SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash Scripting

SOFTWARE/ APPLICATIONS/ TOOLS:

Oracle Enterprise Manager (OEM), Oracle Data Guard, Agents, RAC, ASM, Sql Developer, TOAD, Exp/Imp, DBCA, DBUA, Recovery Manager (RMAN), DataPump(expdp/impdp), SRVCTL, SQL*Plus, Recovery catalog, Crontab, Golden Gate, Data Guard, TDE, Data Redaction etc.

TUNING TOOLS:

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, SQL Tuning advisor, ADDM, Oracle Database Replay, SQL Access Advisor etc

PROFESSIONAL EXPERIENCES:

Cotiviti - Atlanta, GA June 2017 – Present

Role: Oracle Database Administrator

Responsibilities:

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.

Upgrading Grid Infrastructure and databases from 11.2.0.3 to 11.2.0.4

Configured and implemented Oracle 11g active data guard for Database Disaster Recovery by using data guage broker (DGMDRL)

Installed and configured 4 node server-side load balancing Oracle RAC 11g, 12c databases on Linux with ASM and Data Guard.

Production support database on 10g, 11g and 12c versions with standalone and RAC environment.

Set up user profiles and roles as per the access level of user for the data and application security.

Installation and configuration of Oracle Golden gate.

Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, ASM, RMAN.

Table created with Daily Range partition, indexes and script automated which add/remove partition as per client requirement.

Monitoring and optimizing the performance of the database/application using OEM.

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. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

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.

Installed Oracle 11g on Linux platform using ASM.

RMAN point in time recovery and Instance recovery done on 11g.

Developed compliance reports and performed auditing at higher levels.

Provided valuable inputs for various performance tuning issues.

Proficient in performance tuning using Explain Plan, AWR, ADDM, ASH. Performance Tuning of the database (Memory Tuning, I/O Tuning)

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Eastern Illinois University - Charleston, IL August 2013– Jun 2017

Role: Oracle Database Administrator

Environment: RHEL 6.x, Solaris 10, AIX 6.x/7.x, Oracle 11G/12C, Oracle RAC (11g/12c), Data Guard, 13C OEM, RMAN, ASM, SQL Developer, TOAD, SQL*Plus.

Responsibilities:

Upgraded oracle databases from 10G & 11G to 12.1.0.2 across all SDLC using datapump, transportable tablespaces, DBUA and manual in-place techniques.

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

I Set up user profiles and roles as per the access level of user for the data and application security

Applied PSU, and interim opatch) patches on all the databases.

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

RMAN point in time recovery and Instance recovery done on 11g.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

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

Performed Data refresh activities using the export data pump utility.

Excessively worked on performing database backup and recovery using RMAN. Key player in troubleshooting backup issues. Taking the RMAN incremental and cumulative backups.

Good hands on performance tuning related issues with Experience in query analyzing and Performance Tuning for the SQL queries, which are running slow, consuming high resources.

Refreshed/cloned databases using RMAN utility.

Written SQL scripts to monitor tablespace and extent growth.

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

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Performing troubleshooting, administration, monitoring, tuning, and operational functions on Oracle databases for multiple projects.

Implementing and maintaining database security (create and maintain users, roles and assign privileges)

Education & Certification

Bachelor’s Degree in Business Management 2012

University of Buea

Oracle Certified Associates (OCA 12C) 2019

SQL Fundamentals 2019

Oracle University

Contact this candidate