Oracle DBA

EMMANUEL N. AMBE

**** ******** **, *** ***. Raleigh NC 27607.Cell: 301-***-****.

****.*****@*****.***.

PROFESSIONAL SUMMARY

A versatile, detailed-Oriented Oracle DBA professional with over 6 years of diligent experience in Oracle and 8 years in whole in the field of IT. I have supported the complete life cycle of the SDLC. I have worked on Oracle versions ranging from 9i, 10g, 11g, and 12c. I have done database administration duties including production support, installation, and configuration, database upgrades, patch management, database migration, backup and recovery, performance tuning, database cloning, golden gate and security management. I have supported customized Applications like HR, FIN and PEOPLESOFT HR / PEOPLESOFT FIN with on-call rotation.

An Oracle DBA effective at collaborating with other staff, supervisors and program directors. Self-motivated, patient and reliable with excellent oral and written communication skills. Conscientious staff bringing years of experience in the DBA field. Displays perseverance in the face of challenges.

TECHNICAL KNOW-HOW SUMMARY

•Have ample knowledge in implementing policies, procedures for disaster recovery and archival processing to ensure data protection.

•Experienced in Performance Monitoring tools like OEM, AWR report, DBMS_PROFILER for troubleshooting some PL/SQL codes.

•High ability to analyse and understand the AWR reports and can fine tune the databases for maximum performance.

•Expertise in implementing partitioning methodologies (Range, List, Hash, Composite partitioning) on tables and INDEXES for high performance.

•Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, OEM GRID, SQL TRACE Utilities

•Experienced in Installation, configuration, Upgradation and applying Patches (CPU, PSU and Grid) to Oracle Databases and its related products on UNIX and Windows servers.

•Experienced in RAC, DATAGUARD and GOLDEN GATE/ORACLE STREAMS configuration for high availability. Hands on deck with Golden Gate setup for 5+ years now. Managed the clustered environment for 5 years.

•Efficient in Database migration across 11g,12c databases, different platforms with the help of Golden Gate.

•Have profound Understanding of Oracle Architecture and have been involved in Creation, Migration, reorganization and connectivity configuration of Oracle Databases.

•Expertise in the creation of Data Guard database on different server, switching standby database mode to read-only, recovery mode and Snapshot Standby Database as well as shipping and applying archive logs from production to standby. (log gap scenario)

•Efficient in building catalog for RMAN repository and extensively worked on Backup & Recovery strategies using RMAN utilities, Logminer, Datapump and EXP/IMP.

•Efficient in building RMAN and User managed database cloning.

•Sound knowledge of logical backup export/import objects, tablespace and at database level.

•Great understanding and experience in Oracle ASM concepts, administration and well experienced in ASM disk group creation and disk addition activities.

•Good shell scripting Skills and OS knowledge.

•Profound understanding of creation and Maintenance of DB objects. Tablespaces and datafiles.

•Handling user management, tablespace management and performance issues.

•Creating and refreshing materialized views.

•Good hands on deck with Oracle Software cloning to a different Unix Server

•Performance tuning tools consisting of, Explain Plan, iostat, sar, vmstat. Top and SQL tuning of production databases and programs.

•Configured ORACLE ENTERPRISE MANAGER (OEM) Grid Control (11g, 10g) for monitoring multiple databases and application servers.

•Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

•Expertise in maintaining Database Security using auditing.

AREAS OF EXPERTISE

Data Migration Customer Service Data Security Business and Systems Analysis Performance Tuning Data Guard 24/7 Production Support Capacity Monitoring Backup and Recovery Administration Database Creation and Configuration Patching and Upgrade Cloning and Refreshes RAC Golden gate for replication

TECHNICAL ACUMEN

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 95/98/NT/2000.

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

TWS Scheduler

ADF

APPLICATIONS

HR, FIN, PEOPLESOFT

PROFESSIONAL EXPERIENCE

AT&T, DALLAS, TX.

Oracle Database Administrator 01/2014 – 04/2018

Conducted Oracle database administration tasks for the customer, in charge of improving database performance, restoring, and implementing recovery processes while overseeing performance tuning and performing regular system backups.

Administered operating system tuning by utilizing top command to see load average, CPU, memory, and Zombie processes; which includes database and applications through ASH, AWR, ADDM, EXPLAIN PLAN, TKPROF, SQL Trace.

Expertly managed database creation and configuration through Database Configuration Assistance (DBUA) and scripts.

Installing, upgrading and implementing quarterly patches on version 9i, 10g, 11g, 12c of more than 80 medium large-scale executions while supervising projects from business requirements analysis to the delivery of support and solutions.

Utilized data pump in performing numerous schema, object, and overall database refreshes.

Organized tablespace threshold alerts and checks for password expiration using a database and OEM grid control.

Served as database administration (DBA) responsible for tablespace and database migrations across endian format utilizing RMAN for file conversion; database backup and recovery base on the backup window and SLA through recovery manager (RMAN) and user managed; logical backups using data pump, and backup scheduling and job monitoring through crontab.

Execution of standard auditing, fine-grained auditing, and valued based auditing base on company SLA. Created users and expired their passwords when need be as well as delegating necessary roles and privileges.

Proficiently used Transparent Data Encryption (TDE), Data Masking, and Data Redaction in implementing advanced security measures to restrict access to sensitive data.

Made significant contributions in configuring GOLDENGATE for real-time replication, DATAGUARD for disaster recovery, and RAC for scalability.

Expert in SQL Server DB Mirroring, Log shipping, Replication, Data migration

Experience in Backup Recovery models for MS SQL server.

Performed Tablespace Point in Time Recovery and RMAN Table point in time recovery.

ENVIRONMENT: Oracle 12c RAC, 11g RAC, 10g RAC, 9i, AIX, LINUX, OEM, Grid Control, RMAN, ASM, SQL server 2008/2012/2014 Windows XP/Vista/Win7.

US FOOD, MINNESOTA, MN

Oracle Database Administrator 01/2012-01/2014

Utilized explain plan and Oracle optimizer to improve SQL statements performance, handled and monitored tablespace and data files mount point growth.

Conduct user requirements and troubleshooting activities and promptly addressed connectivity issues.

Led the execution and maintenance of daily backup and archived data tape, while developing user accounts as well as system and user-level database objects.

Experience in advanced primary database storage structures and objects, operating system security for database users.

Tracked database instances and storage space for production environments and developed storage requests to UNIX groups.

Provided significant contributions to a team that configured GOLDENGATE for real-time replication and DATAGUARD for data disaster recovery.

Observed RMAN backup operations and schedules as required, while controlling database and schema refresh from production to creation.

Fulfilled on-call DBA functions every month and assisted end users on Oracle related issues.

Utilized DDL scripts to define a table using Create or Alter command and DML scripts to modify table records using insert, update and delete statements to query databases.

Performed general DBA tasks like user management, tablespace management, and security management of the databases.

Performed general tasks like database patching, OEM Agent installations/patching.

Involved in the data migration from Oracle 10g to 11g on both RAC and NON-RAC databases.

Experienced in performance tuning of high volume databases using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, ADDM. Also used OEM Grid Control to monitor the performance.

Used import/export, Data pump to refresh databases, tables, schemas from production when requested by the application team.

Monitoring disk space utilization, sizing and capacity planning.

EDUCATION AND CREDENTIALS

Bachelor’s in law 09/2005 – 2009

University of Dschang

Oracle Certified Associate

Oracle Institute

Contact this candidate