Stanley Ndunagu

Oracle Database Administrator

Phone: 443-***-****

Email: ac72es@r.postjobfree.com

Professional Profile

I have over 5 years of experience as an Oracle Database Administrator. I have complete life cycle knowledge including Development, Test, UAT, and Production. I have worked on Oracle 12c, 11g, and 10g database versions where duties included production support, installation, configuration, upgrades, patch management, migration, backup and recovery, performance tuning and security.

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

Extensive experience with implementation of Oracle Advance security (transparent data encryption, data redaction, data masking) and Wallet Manager.

Expertise in Migration and upgrades of oracle databases.

Experienced in applying patches including Patch sets and CPU/PSU, One-Off patches on oracle Databases using OPatch Utility.

Planning, scheduling and managing Backups, Database Recovery, taking Logical Backups with data pump using (expdp/Impdp utility). Installation, implementation and managing RMAN.

Performance Tuning of test and production database, monitoring system. Tuning and diagnosing of database performance by query Optimization and trace facility Monitoring users, free spaces, table spaces and indexes

Proficient in installation and working with Data Guard for production system in case of disaster recovery, maintained primary and standby databases; and Data Guard Broker.

Experienced in system Monitoring with tools like Oracle Enterprise Managers (OEMs), and Database Performance Tuning using Explain plan, SQL Trace, gathering statistics using Statspack, TKPROF, AWR, ADDM and ASH reports.

Proficient in maintenance of Production, Testing, Development, RAC, Standby databases/ Data guard for OLTP and DATAWAREHOUSE environments.

Proficient in flashback technology and other features such as log miner, Automatic Storage Management (ASM).

Expertise in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using cronjob to perform daily backups.

Performed full and incremental backups using RMAN. Expert in performing manual recovery, using RMAN with and without a recovery catalogue.

Performed Data Archiving whenever required for moving data to a separate storage device.

Experienced in Space Management, Resource management and Capacity Planning.

Education

Bachelor of Science in Food Science and Technology

Imo State University Owerri (IMSU) Owerri, Nigeria. August 2006

Work Experience

PFIZER - Groton, CT January 2015 – Present

Oracle Database Administrator

Responsibilities:

Configured databases using scripts and dbua, maintained Oracle 11g and 12c databases on Linux OS and Upgraded from Oracle versions 11g to 12c using applied PSU patches.

Database refreshes, Table refreshes and schema refreshes using Data pump expdp/impdp utility. RMAN Duplicate and cloning using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.2.0.1 to 11.2.0.3.

Planning Backup/Recovery Strategies using RMAN, scheduling Backups, taking Logical Backups with Export/Import Utility (Data Pump) and Transportable Table spaces.

Designed, developed, and implemented database security management, monitoring methods, and performance tuning. Provided technical support for all application administrators and users.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Provided valuable inputs for various performance tuning issues. Explored 12C features including multi-tenant architect.

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM, ASH and monitor the database performance on daily basis.

Responsible for maintaining and managing of 2 node RAC on Linux in 11g database.

Implemented Data Guard for disaster recovery, created and physical standby databases in 11g for production database.

Installation, Configuration and Troubleshooting Golden Gate 12c software.

Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.

Create database Objects, Tablespaces, Schemas, users and granting roles and privileges for security as needed.

Schema migrations from Development to Production using data pump.

COSTCO - Seattle, WA August 2012 – January 2015

Oracle Database Administrator

Responsibilities:

Installed oracle software, configured, and maintained Oracle 10g and 11g R2 on Linux OS and Upgraded from Oracle 10g to 11g database versions.

Involved in checking and managing tablespace growth, monitoring the data file growth and extents.

Involved in export and import of database objects in order to copy them from one database to another & for backup the tables using data pump.

Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.

Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analysing by ADDM (Automatic Database Diagnostic Monitor)

Rebuilding indexes or analysing the index as per the fragmentation level and minimize the performance issues.

Refresh/Cloning of Database from production environment to test environment and application of patches.

Configured Data guard, with physical-standby database using hot backup and manually registered archive logs on standby database.

Setup & test backup on databases. Writing RMAN scripts embedded in shell scripts. Recover full database by applying archive and redo logs. Duplicate database using RMAN on remote host.

Imp/exp used for load data into users on daily bases. Import schemas as part of recovery process in times of logical corruption. Export statistics from production to test.

Monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs in crontab. Used OEM on 11g databases. Maintenance of indexes.

User management includes, create/alter users, granted roles, and assigned resource profile; assigning the users to groups and grant necessary privileges to the relevant groups. Auditing database objects for DML operation.

Applied bug patches according to the Oracle Critical Patch alerts.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.

Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using ADDM, Explain Plan, and SQL tuning advisor.

Implemented the resizing the online redo logs in production and in standby database.

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Scheduling the Physical backups (hot & cold) with crontab using RMAN utility and monitoring the scheduled jobs.

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

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

Provided 24X7 support for production, test and development databases.

Soft SKILLS

Excellent written and oral communication skills as proven during my presentation on Data guard and Golden gate Oracle project presentations that awarded me the employee of the month on my Data guard presentation.

Excellent decision-making skills; excellent problem-solving skills.

Ability to work well with a global team to provide around-the-clock progress.

TECHNICAL SKILLS

Databases: Oracle 12C/11G/10G.

Operating Systems: Linux and Windows.

Tuning Tools: TKPROF, EXPLAIN PLAN, ASH, STATSPACK/AWR, and ADDM.

Languages: SQL, PL/SQL.

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, Oracle SQL Developer.

Contact this candidate