PATRICK ADESO CHOH

Oracle Database Administrator

Tel:+1-412-***-****

Email: adadxk@r.postjobfree.com

PROFESSIONAL SUMMARY

Oracle Database 12c certified Administrator with over seven years of work experience, and expert level proficiency in handling technologies such as: Oracle 10g,11g, 12c, Mysql, DB2, MS sql server, java, XML, Windows, Linux, Unix and Sun solaris.

Experienced in managing Oracle databases to enhance database performance (performance tuning), migrate data, perform patch and upgrades, implement backup and recovery procedures and provide high availability solutions by configuring Data guard, Goldengate and RAC.

Possess extensive skills in designing, coding, testing, and supporting next generation database solutions across diverse industry clients and within the different phases of the system development life cycle(SDLC).

Talented communicator and analytical thinker, adept at working in both individual and team settings, and creating strong collaborative relationships with coworkers.

I am also a keen traveler and have no issues with relocating to a different part of the world if required to do so. My professional experience and qualifications below speak for themselves, and should you require any additional information or references, I will be happy to provide them upon request.

PROFESSIONAL EXPERIENCE:

Lenovo – Hanover, MD U.S.A November 2016 – Present

Oracle Database Administrator

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

Providing DBA support to the development, test and QA teams as well as handling database release schedules.

Maintaining sound backup and recovery policies and procedures using RMAN.

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

monitor the database performance.

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

Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.

Generated and automated Statspack/AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.

Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Knowledge and experience in Unix shell scripting.

Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer, Foglight.

Defining the standards, to maintain the health of the server. RAC to RAC physical standby configuration of data guard for Disaster recovery requirement.

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

Configured Goldengate for real time replication, both Uni and Bi-directional

Configured Dataguard for Disaster recovery: Physical, Logical and snapshot standbies.

Installed and Configured OEM grid control for maintenance administering the databases.

Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.

Performed full and incremental backups using RMAN for development and production databases.

Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.

Florida Blue - Jacksonville, FL, U.S.A

April 2012 – October 2016 Oracle Database Administrator

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

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Strong skills in applying security patches like CPU, PSU, and One-off Patch

Successfully upgraded the databases from 11g to non CDB 12c.

Created Oracle Wallets and implemented Tablespace level TDE security.

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

Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

EDUCATION:

ORACLE UNIVERSITY - BRONTECH SOLUTIONS, 7339 Hanover Parkway, Greenbelt U.S.A

Certificate achieved: Oracle Database 12c Administrator certified Associate.

CHARTERED INSTITUTE OF PURCHASING AND SUPPLY (CIPS) UK.

Graduate/Professional diploma in Procurement & Supply chain management.

(B.A (Hons) Degree in Procurement and Supply Chain Management)

Contact this candidate