PRIMUS AFUNWI

Oracle Database Administrator

Phone: (240) 264 - 9416 Email: ac4whs@r.postjobfree.com

EDUCATION

MASTER 1. MINING GEOLOGY

UNIVERSITY OF YAOUNDE

EXPERIENCE

Cigna Healthcare - Raleigh, NC // July 2015 – Present

Oracle Database Administrator

Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.

Performed Replication using materialized views with a complete refresh/Fast refresh.

Development of policy and procedures as they relate to database maintenance, security and archiving.

Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.

Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.

Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.

Creating, granting and monitoring user access rights and privileges through roles and profiles.

Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.

Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.

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.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements

Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.

Installation of 12c OEM and customize it to our needs.

Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.

Automated the Data Replication process using Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

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.

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.

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

Efficiently performed installation, setup and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

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 and Oracle 10.2.0.5 RAC databases.

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

Cardinal Health Inc - Dublin, OH // March 2012 – June 2015

Oracle Database Administrator

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

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

Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Installed and administered Real Application Cluster (10g, 11g, 12C RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.

Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.

Applied patches (PSU and CPU patches) and worked closely with Oracle to make Application environment up to date.

Involved in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.

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

Plan and schedule RMAN backups (hot, cold and incremental backups)

Setup 12c Oracle Enterprise Manager (OEM)

Implemented Transparent Data Encryption (TDE) for database security.

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.

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.

Automated the Data Replication process using Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.

Responsible for setup and implementation of 2Node RAC on IBM-AIX in log and 11gR2 using Veritas clusterserver.

Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Efficiently performed installation, setup and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

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 and Oracle 10.2.0.5 RAC databases.

Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

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.

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.

SKILLS SUMMARY

5 years of experience in the field of Database Technology with experience in designing, developing, implementing Databases, Web development and Application development.

Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)

Extensively worked on Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.

Good experience in installation and rolling out operations on 12c databases for test, development and QA environments.

Expertise in upgrade process from 10g, 11g to 12c and data migration from Non-ASM to ASM and Non-RAC to RAC.

Highly skilled in administering Oracle ASM disk groups (mirroring, compatibility, and configuration) with Oracle ASM Configuration Assistant (ASMCA) including installation of Oracle ASM library modules.

Effectively deployed active data guard standby on 11g database for test and production environments and performed switchover drills for immediate availability.

Implemented FSFO (Fast start failover) on databases through Data Guard Broker. Configured disaster recovery site and Snapshot standby databases.

Configured and administered 10g and 11g 2/3 node RAC database clusters through Oracle Clusterware utilities and High Availability Services.

Efficient understanding on Oracle Cluster Resources and configuring the hosts with appropriate cluster service tools like CVU, OCRCONFIG,CRSCTL and SRVCTL, monitoring the cluster resource daemon and the status of CRS and HAS.

Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.

Strong Knowledge of 11g advanced features like ASM, AWR, ADDM and FLASHBACK.

Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.

Experienced in Installation of high availability RAC environment (2, 3, 4 and 5 node clusters) and upgraded standalone databases to 11g RAC environment.

Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.

Migrated databases from Non-ASM file system to ASM file system using RMAN.

Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).

Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database.

Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.

Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.

Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.

Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.

Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).

Used TKPROF utility and Explain Plan for tuning SQL queries.

Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation

Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.

Comprehensive knowledge and hands on expertise with Oracle Enterprise Manager (OEM) grid control infrastructure and TOAD.

Expertness in Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, OEM and analyzing SQL trace dumps for […]

Well experienced in Query Optimization and identifying high load SQL statements methods through PL/SQL stored procedures, (DBMS_*, UTL_ SQLPLUS, SQLloader, with triggers and indexing strategies.

TECHNICAL PROFICIENCIES

OPERATING SYSTEMS

Red Hat Linux RHEL, AIX, Solaris, Windows 2010

RDBMS

Oracle 12c/11g/10g

LANGUAGES

SQL, PL/SQL

SOFTWARE/ APPLICATIONS/ TOOLS

DBCA, DBUA, Recovery Manager (RMAN), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Contact this candidate