Oracle Manager

Jean Mbouwe

ORACLE DATABASE ADMINISTRATOR

240-***-**** **********@*****.***

Professional Summary

Oracle DBA with 6 years of hands-on experience as an Oracle Database Administrator. I possess complete life cycle knowledge including Installation. Worked on Oracle 12c, 11g and 10g versions. Duties include backup and recovery, performance tuning, patches, migration, production support, installation and configuration, upgrades, security and auditing, Cloning and refreshes.

Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Worked on Data transferring with export/import utilities and Data pump.

Experienced in performance monitoring/tuning/troubleshooting.

Applying patches under UNIX platform.

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

Experienced in Oracle 12c, 11g Automatic Storage Management (ASM) required to fulfill the storage needs.

Installation and configuration of oracle Golden Gate.

Experience in using Golden Gate to support data replication in the Oracle database environment.

Proficient in Database administration activities such as user management, space management, Monitoring, Creating Database, Managing Oracle Instance and Datamasse Security.

Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, TKPROF, SQL TRACE, EXPLAIN PLAN for the better performance.

Performance Monitoring and Tuning of Database using Grid Control & Diagnostic pack (AWR, ASH ADDM)

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

Experience in taking backup and performing recovery.

Designed and implemented Oracle Real Application Clusters (RAC) on Linux.

Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.

Experience in conversion of Single Node Instance to multi-node RAC with ASM, and adding instance to existing RAC.

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 2 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).

Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.

Experience in applying PSU patch on standalone as well as RAC databases.

Experience in Golden Gate upgrade from 10.4 to 11.2.

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 12c, 11g RAC servers for the purpose of disaster recovery procedures.

Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 6 platform.

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

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

Installed Oracle 11g with ASM and OCFS2 File systems.

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

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

Proficient 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”.

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.

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

Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN.

Technical Summary

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 9, 10. AIX 5.x, 6.x.

RHEL 4.x, 5.x. Linux Enterprise Server 9, 10.

Windows 2008, 2012

RDBMS

Oracle 10g, 11g, 12c

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, WinSCP

Database Utilities

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

Professional Experience

Cotiviti - Atlanta, GA

January 2016 – Present

Oracle Database Administrator

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 11g to 12c.

Configure and implemented Oracle 11g ACTIVE DATAGUARD for Database Disaster Recovery by using DATA GUARD broker (DGMDRL)

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

Production support database on 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.

Re-wrote the shell scripts to monitor Golden Gate processes various states (like STOPPED/ABENDED/LAG/HUNG) to reduce number of alerts by grouping them together by environment

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, Streams, ASM, RMAN.

Configured deployed and administered 2 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 6.0, using ASM and Raw Devices on Oracle 11gR2.

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.

Capacity planning: Allocate system storage and plan future storage requirements.

Involve in 24x7 on-call support for 12 databases of 2.0 TB 2 Node production 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.

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

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

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.

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).

Provided valuable inputs for various performance tuning issues.

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

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, SQL*Trace, AWR, ADDM, ASH, SQL tuning advisor etc. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.

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

Upgrade and Migration of Database from 11.2.0.2 to 12.2.0.2 and applying patches whenever required.

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 6.

Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3

Performing monthly and annual performance reports for trend analysis and capacity planning.

Assist in SQL tuning and providing consultation such as adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Experience in writing UNIX/SHELL scripts for providing the reports.

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

Eastern Illinois University - Charleston, IL

March 2013 – December 2015

Oracle Production Support Database Administrator

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows 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.

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

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

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.

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).

Implemented Flashback technology of the Oracle 11g for a faster recovery of the databases and database objects.

Performed Data refresh activities using the export data pump utility.

Installation of 2 node and 3 node RAC, Migrating of database to RAC database. Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).

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.

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

Refreshed/cloned databases using RMAN utility.

Restoration of Data for users in the event of requirement or system crash.

Written SQL scripts to monitor tablespace and extent growth.

Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints. 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 on 2 Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g 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 11g IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Education

Master’s Degree in Chemistry

Oracle 12c Certified Associate (OCA)

Contact this candidate