Bonaventure Nkwam

240-***-****

acvu6p@r.postjobfree.com

SUMMARY

Results-driven, reliable, resourceful, and professional Oracle Database Administrator with over 7 years of IT experience in designing, implementing and maintaining Oracle 10g and 11g RDBMS. Knowledge of System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g & 11g in Production, Staging, and Development environments. Highly motivated, enthusiastic, and dedicated to providing excellent client support.

TECHNICAL SKILLS

Oracle 10g/11g Database Administration

Enterprise Manager/ Grid Control Administration

Data Integrity & Security

Upgrade & Patch Application

Data Load & Migration

Performance Tuning & Capacity Monitoring

Backup & Recovery (RMAN)

Data Guard Administration

Automatic storage management

Real Application Cluster Administration

Project Documentation for Requirement Spec (FRS)

RDBMS: Oracle database […]

OEM, Oracle Data guard, Toad, Export/Import, Data Pump, AWR, ADDM, statspack, TKPROF, Spot light, VERITAS Cluster / Net backup, RMAN, SQL expert, RAC

Oracle EBS / Middle Tier 11.0.3, 11i, R12 / Oracle 9iAS, 10gAS, Apache, Web Sphere RDBMS Oracle (8.x, 9.x, - 10g), 11g 12c

LANGUAGES: Oracle SQL, Linux Shell Scripting

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

SOFTWARE/APPLICATIONS/TOOLS: SQL*PLUS, DBCA, DBUA Netca, Net Manager, Recovery Manager (RMAN), Data Pump (expdp, impdp), SQL*Loader, Oracle Enterprise Manager (OEM), Grid Control TUNING TOOLS: SQL TRACE, AWR, and ADDM

WEB TOOLS: HTML, XML

WORK EXPERIENCE

Gateway Health Plan Pittsburgh, PA September 2012 to Present

Oracle DBA

Installation, configuration and upgrading of Oracle database server software and related products

Install and configure Oracle 11g RAC with Grid Infrastructure (GI) on 4 nodes on Red Hat Enterprise Linux 5.7, upgrade production databases from 10.2.0.2 to 10.2.0.4 and 10.2.0.4 to 11.2.0.2 on RHEL 5.7/5.9 and applied quarterly Critical patch updates and patch set updates as needed provide 24/7 on-call support on a rotation bases and developed ad hoc shell scripts to provide temporary work-around for issues in production database Performed capacity planning for the database and added nodes to RAC database to make 2 node RAC Performed database Audits/fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular bases on user operations involving sensitive database objects analyzed EXPLAIN PLAN,TKPROF,SQLTRACE and used ANALYZE, HINTS for performance enhancement.

Implement database security

Perform backup and recovery according to policies and procedures using RMAN utility

Execute performance tuning using ADDM/AWR reports

Ran AWR, ADDM, ASH reports to analyze the database behavior and implemented new strategies for Database performance tuning

Perform data migration using Oracle Export/Import utility

Perform Plan growth and changes (Capacity Planning)

Configure database network such tnsname and listener

Apply CPU critical patch to GI and RDBMS database

Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.

Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC

Utilize grid control and database control to manage databases

Setting up Physical Standby Database Data Guard for Disaster recovery and implemented failover and switchover mechanisms

Migrated Non ASM file system to ASM File system for better space management.

Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM) Installed and configured cloud control 12c to monitor all databases.

Data Refresh from Test to Production and Development environments using RMAN Duplicate Database.

Experience with Oracle Very Large Databases (VLDB) of 1TB to 8TB. Implemented security features like Auditing and user management in Oracle 11gR2 and SQL Server Databases.

Working with VERITAS, SAN and EMC Net Backup Technology to take the hot and cold backups.

Involved Oracle query tuning for a data warehouse and STAR schema design and use of bit-map indexes.

Managed the Very Large Tablespaces and tables in 12 TB size of Database. Created Database Schema, development, administration and testing using Oracle.

Maintain database integrity & security (Grant, Create User Role & Privileges)

Identified bugs and applied required patches like CPU, PSU Patches as per the oracle recommendations.

Performed daily database administration tasks: User management, Space monitoring, Performance monitoring, Alert Log monitoring and backup monitoring

Developed Shell-Scripts for RMAN, Hot and Cold backups.

Refresh the database from PROD to UAT, QA, and DEV using RMAN

Provided on-call support for production-related database problems. Environment: Oracle 11g R2 RAC, SQL Server, Solaris, HP-UX, AIX, Red Hat Enterprise Linux 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, Toad, Spotlight, PL/SQL, Shell scripting.

ENVIRONMENT: Oracle 11g, 10g, Linux, Solaris, ASM, Data Guard, RMAN, OEM

Costco. Pittsburgh, PA July 2010 to August 2012

Remote Oracle DBA

Supported 50+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases

Planned, installed, configured, managed and troubleshot Oracle 10g and 11g databases on Linux and Windows platform.

24 X 7 Production Oracle database support, administration and on call rotation

Managed and monitored database storage usage (Capacity Planning)

Cloned database with RMAN and without RMAN.

Installation and configuration of oracle 10g and 11gR2RACdatabases.

Upgrading databases from 10g to 11.2.0.3.

Configured initial and incremental load using golden gate.

Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate with zero downtime.

Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption) Responsible for setup and implementation of 2 Node RAC on IBM-AIX in 10g and 11g R2 using VERITAS Cluster Server

Performed bulk load into the database using SQL Loader

Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.

Monitoring space requirement for production databases

Configured Oracle grid control to manage the entire database in single centralized location Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control. Creating table spaces, tables, and users for custom applications

Automation of Startup Shutdown on all Production and Development Database. Implemented oracle high availability solution using Oracle Physical & Logical Standby

Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some of the activities performed for better performance

Worked on schemas creation and maintaining large partitioning tables. Creating and dropping of users, granting and revoking permissions to users/roles as and when required.

Performed physical backups using RMAN Utility

Performed data migration using Oracle Export/Import Utility

Set up database auditing

Installed and configured Golden Gate director server/client for monitoring golden gate processes.

Application Tuning: Identifying the sql's causing I/O bottlenecks, sql's of high cost and giving recommendations to the development teams accordingly.

Database backup & Recovery with export and import for non archive and archive database with RMAN commands Developed Scripts for transferring data from production server to testing/development servers

Upgraded OWB repository from 10g to 11.2.0.3

Diagnosed and troubleshoot typical SQL Tuning issues using

SQLTXPLAIN.SQL Shell scripting and PL/SQL programming to resolve business problems of various nature

Maintained and upgraded databases Developed and maintained the applications by utilizing ASP.NETand software

Worked on database refresh using hot backup and rman backups.

SQL explain plans and query performance, session tracing

Managed database objects such as procedure and functions

Worked on rolling patch apply throughout the environment with no downtime.

Planned and implemented a backup and recovery strategy using RMAN and Data Guard

Monitored system resources and takes action to keep the system at optimal performance using Grid Control.

Communicated and coordinated with Oracle using My Oracle support for major database issues/ database problems

Environment: Oracle 10g/Oracle 11g/RAC, Linux, Solaris 10, Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard.

TCF Bank Chicago, IL November 2007 to July 2010

Junior Oracle Database ADMIN

Installed Solaris 10 server

Involved in installation, configuration and support of Oracle 11g RAC. Involved in 24x7 Oracle Production Database Administration. Refresh/Cloning of Database and applications for development and testing purpose

Created directories and files in UNIX

Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g

Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Statspack.

Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration

Inserted and edited text into files using the vi editor

Design, document, implement, and maintain all backup, recovery including disaster recovery procedures

Assigned dynamic internet protocol addresses into Solaris10 server

Performed User Management, creation, monitoring and management of database users, altered passwords of users and granted and revoked system/object privileges, roles, audited user actions in the database

Troubleshot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) for optimum database performance

Created physical standby database (for disaster recovery) from hot backup of primary database

Resolved gaps between primary and standby databases (Gap Resolution) Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.

Creating Tables, indexes, & triggers to assist developers

Managing, troubleshooting and resolving oracle database, RAC and applications issues

Refresh/Cloning of Database and applications for development and testing purpose

Was involved in developing a disaster recovery (DR) plan

Used to perform back up and recovery using Veritas NetBackup integrated into RMAN.

Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts

Reading Alert Logs and User trace Files and Diagnosing the Problem.

Writing UNIX shell Scripts and Scheduling through crontab.

Providing Solutions to the Problems Faced by end Users or Programmers

Scripts for Analyzing of Tables and Rebuilding of Indexes.

Automation of Backups

Interfacing with Oracle Corporation for technical support

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc for easy and effective management of Oracle networking

Migrated databases from Oracle 10g on Solaris 10 to Oracle 11g on Linux

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

Configured listener for external procedure calls.

Created and managed user, table spaces, data files and archive log

Performance tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise manager and monitored the Stats pack report generated from snapshots taken at the peak business hours.

Environment: Oracle 9i, 10.2.0.2, 11.1.0.7, Maestro 7.0, HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3, WebSphere, Solaris5.9, Informatica Power center 8.1x and 8.6.

EDUCATION

Associate’s in Media Arts and Animation

The Art Institute of Washington – Arlington, VA

CERTIFICATION - Oracle Certified Associate

Contact this candidate