GINALORE TAKA

Title: Oracle Database Administrator

Phone: 571-***-****

Email: adhoo8@r.postjobfree.com

PROFILE

A talented and resourceful Oracle DBA professional with over 5 years of experience who possess a solid experience in working with Oracle 10g, 11g, 12c and 19c versions across a complete life cycle of SDLC. Areas of work include production support, installation and configuration, database migration, backup and recovery, performance monitoring and tuning, database cloning, security management, database upgrades, and patches.

SKILLS SUMMARY

High Availability – Real Application Clusters (RAC).

Disaster Recovery – Data Guard (physical, active, snapshot and logical standby).

Backup and Recovery – RMAN, User-managed backup (hot and cold), full and incremental.

Database migration – Data pump, transportable tablespaces, RMAN, Dataguard, Golden Gate

Oracle database security – User account management, audit, TDE.

Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance.

Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ADDM, ASH, Recycle Bin. Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN.

Planned, installed and upgraded multiple Oracle databases from 11.2.0.4 to 12.2.0.

Experience in applying patches/ patch sets to the databases using OEM 12c and scripts.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and Real time replication using Golden gate.

High ability to interpret, analyse, understand the AWR reports, and fine-tune the databases for maximum performance.

Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.

Performed database monitoring and tuning to ensure databases run at peak performance; troubleshooting production performance issues.

Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.

Planned, implemented and maintained Database Security using auditing and High level Security using Transparent Data Encryption (TDE),

TECHNICAL PROFICIENCIES

Operating Systems

Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1

RHEL 5.11, RHEL 6.7, RHEL 7.3, Nutrinax VMs

Windows Server 2008, 2012 R2

Application

Oracle Forms, Weblogic

RDBMS

Oracle 10g, 11g, 12c

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Toad, Putty, NX client, WinSCP.

Database Utilities

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

WORK EXPERIENCE

Oracle Consultant Feb 2018– OCT 2020

Technical Support Analyst Lehi, Utah

Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.

Used OEM 13c to educate customer on administration like patch, monitoring/tuning, agent deployment on hosts, adding targets, stop/start databases, stop/start listeners.

Complete installation and configuration of Oracle Enterprise Manager 13c on RHEL 7 including database software installation, repository database creation and cloud control 13c installation.

Planned and deployed PSU, CPU patches for standalone databases, Oracle RAC including rolling patch, in-place and out-place patch implementation.

Used OEM 13c to create patch plan, deployed CPU and PSU patches to test, dev and prod systems. Worked with Oracle support to resolved patch conflicts.

Implemented, tested backup strategy with RMAN. Cloned and recovered critical/non-critical datafiles with RMAN and performed point-in time recovery using RMAN.

Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.

Expert in database planning, scaling, and capacity planning activities.

Planned, configured, managed Oracle Data Guard, Oracle Enterprise Manager (OEM), Automatic Storage Management (ASM), Recovery Manager (RMAN), and Real Application Cluster (RAC).

Setup a physical standby database in Oracle Data guard. Configured data guard broker (DGMGRL) to administer and manage data guard configuration.

Worked on Multitenant Databases (Oracle 12c Container and pluggable databases). Cloned PDBs from PDB$SEED, unplug and plug PDBs from one CDB to other CBDs.

Performed Point-in time recovery on table using RMAN in Oracle 12c.

Planned and migrated multiple databases ranging from 40GB to 120TB from on-premises to Oracle Exadata on Oracle Cloud. Used RMAN, TTS, Data pump, OGG to migrate databases in real time.

AT&T March 2015– Jan 2018

Oracle Database Administrator Dallas, TX

Supported multiple databases for production, development, and test and staging purposes.

Applied CPU patches to multiple Oracle databases using the Opatch utility.

Refreshed Dev and Test instances with data from Production per request.

Created Materialized views and Materialized View Logs for Data Replication.

Worked with optimizer Hints and Explain Plan estimated performance and to generate optimal solutions for slow running queries.

Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.

Implemented oracle 12c active standby database for test database environment

Tuned database performance and optimized slow running queries using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.

Diagnosed Oracle bugs and coordinated with Oracle support to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, tablespace usage report using crontab.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

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

Monitored and optimized the performance of the database/application using OEM along with customize shell scripts.

Capacity planning: Allocate system storage and plan future storage requirements.

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

Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).

Performed monthly and annual performance reports for trend analysis and capacity planning.

Assisted in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Worked on both Nutrinax VMs, RHEL and UNIX environments.

Troubleshot various database performances by proper diagnosis at all levels.

Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2008, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

EDUCATION

Bachelor Degree in Technology, University Of Bamenda, NW Cameroon.

CERTIFICATION

1.Oracle Certified Associate

2.AWS Certified Solutions Architect – Associate

3.Scrum Master Accredited Certification

Contact this candidate