Manager Oracle

DESMOND NTAH

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

Oracle Database Administrator

Over 5 years’ of strong experience in Oracle database administration in a heterogeneous environment including Solaris, UNIX, and Windows.

Delivering Oracle Database performance-tuning services for customers using Explain Plan, Tkprof, StatsPack, and SQL Trace.

Excellent experience in Installation and configuration of Oracle 12c,11g, 10g versions on UNIX/LINUX and Windows environment.

Upgraded Databases from 10g to 11g and to 12c on various platforms.

Worked with customer for different RAC related issues including split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss.

Good Knowledge and hands on experience on Oracle Golden Gate installation, configuration and troubleshooting.

Extensive experience with implementation of Oracle Advance security Wallet Manager.

Proficient in Database administration activities such as user management, space management, Monitoring, Creating Database, Managing Oracle Instance and Database 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 performing point in time recovery at times of necessity.

Design and implement backup and recovery including disaster recovery structures.

Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.

Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.

Wrote scripts to inform the DBA team on the status, performance and space management of the database

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes

Installed and configured Oracle 10g, 11g, 12c on Sun Solaris AIX, UNIX/LINUX, HP-UX and Windows environment.

Synch -up database environments (DEV, QA) after each major release or production change.

Implemented One node RAC and four node 11g RAC clusters on Linux platform and AIX LPARs having GPFS cooked SAN Storage.

Provided support to the Database system Infrastructure area that had few critical Business Systems including TR, Bills Order and Tracking, Online Charges.

Co-ordinate with UNIX administrators and management team for space management, problem resolution, capacity planning, software version control, evaluation and support on various servers.

Established standby/cloned database via Data Guard for Database Disaster Recovery

Employed predefined UNIX scripts to cleanup database files such as outdated archived redo logs and trace files out of bdump, udump and audit directories.

Trouble shoot and Configured Sql*Net files according to client and server settings to transfer data.

Worked on export/import, data pump and SQL Loader.

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 multimode RAC with ASM..

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

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

Experience in maintaining Data Guard to provide high availability by implementing physical standby database and snapshot standby and worked with Oracle 11g features, 11g Grid Control.

Data warehouse analysis and design for diverse legacy system integration.

Process/workflow analysis, project management from analysis and design for implementation.

Conceptual data modeling, logical and physical data modeling.

Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.

Participated in planning and implementation of off-site Disaster-Recovery planning and testing

Huntington National Bank - Columbus, OH

July 2015 – Present

Oracle Database Administrator

Troubleshooting ORACLE RAC issues using ORACLE cluster ware and Database logs.

Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch.

Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.

Worked on setting up of Goldengate 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to Downstream systems

Installed Goldengate version 11 and version 12 with latest patches applied on DBFS filesystem and ACFS filesystem, also working testing new OGG 12.2 new features available.

Implemented Goldengate integrated replicat and coordinated replicat(available from OGG 12c) to improve the performance of data replication to targets

Troubleshoot and maintain ORACLE Data guard environment where TBs of log shipping and apply happen every day.

Troubleshoot Database Performance issues using OEM, AWR, ASH, TKPROF 10046 traces etc.

Developed custom scripts and implemented standard procedures to troubleshoot Live Production issues by leveraging ORACLE ASH and AWR Data.

Monitor Production Databases using various internal tools and custom scripts.

Optimal Database parameter, Capacity Design for Heavy loaded High End OLTP systems.

Database Capacity Management (Working with Storage teams for ASM Disks) using automated scripts/processes and Reports.

Experience managing Tablespaces, Data Files, Archive Logs, Redo Logs, and Standby Redo Logs and Logical Database Objects.

Performing tuning of application using CBO, SqlTrace, Tkprof, Explain Plan, Statspack, AWR and ASH/ADDM.

Proficient in writing UNIX Shell scripts to automate business process and daily backups.

Involved in capacity and resource planning.

Exposure to new 12c Features, Container and Pluggable Database, FAR-SYNC Instance, Cascade Redo Transport Destination, Allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file, etc.

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.

Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.

Migration of database from one server to another server.

Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.

Responsible for configuring datagaurd physical and standby database setup for high availability and handling synchronization issues between primary and standby.

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

Done migration of non ASM database to ASM database.

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.

Handling and debugging of high priority and sudden database service interruption issues like service interruption due to ORA-600 errors in the dump and database hung due to ORA 7445 errors and restoring the service to normal and providing efficient root cause analysis.

Upgraded standalone and RAC databases from 11.2.0.3 to 12c on QA database for proof-of-concept

Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.

Proficient in writing UNIX Shell scripts to automate business process and daily backup.

Experience with testing and pre-production and production of Oracle 10gR2 with 2 node RAC on Red Hat Linux with ASM

Vast Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.

Capacity Planning for OLTP environment- Allocating system storage and planning future storage requirements for the existing and new databases.

Proactive performance monitoring by implementing UNIX scripts and automated jobs (Grid) for alerts.

Refreshing databases and Migration of databases from various environments for Testing, Development work.

Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.

Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.

United Airlines - Chicago, IL

March 2013 – July 2015

Oracle DBA

Performed Installation and configuration of Oracle 11.2.0.3 database on HP-UX platform.

Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7 supports for all the production and development databases.

Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.

Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2..

Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.

Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.

Monitored the production Oracle alert logs for database errors and data issues.

Used EXPORT/IMPORT to do table level and full database defragmentation

Managed RAC Linux servers running Oracle in cluster environments.

Performed patching of Oracle databases with latest patches from Oracle.

Install and configure block change tracking to work with RMAN Merged incremental backups.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Operating Systems:

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 2010, 2012

RDBMS

Oracle 10g, 11g, 12c

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Toad, Putty, WinSCP

Database Utilities

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

PG Community College, Largo Rd, MD. - May 2017

Studies include:

Computer Engeneering

Programing Java

Security+

Contact this candidate