Bonaventure Nkwam
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