EMMANUEL TABALI

Oracle Database Administrator

Phone: 240-***-****

Email: adbmog@r.postjobfree.com

Willing to relocate: Yes

Authorized to work in the US for any employer

Summary

* ***** ** ****rience as an Oracle Database Administrator and performed different tasks like Database Designing, Administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database refresh, database migration, database security etc.in production as well as development databases on different platforms.

- I Performance Monitoring and Tuning of Database using Grid Control & Diagnostic pack (AWR, ASH ADDM etc.)

-Supported multiple databases for production, development, test and staging purposes on Sun Solaris, Linux and Windows environments.

-Done Upgrade and patching using DBUA, O patch Utility and customized scripts

-Configured and administered high availability technologies like Golden Gate for real time replication.

-Used Delphix to clone and refresh databases in minutes for almost no storage which helped to Speed up development projects and Provide backup and recovery protection eliminating long resource heavy weekly backups

-Configured and administered a Physical, logical, snapshot and active standby Data guard

-Experience using enhanced features in 12c, 18c and 19c like – Real Application Testing (RAT), Invisible columns and DDL Logging

-Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

- Worked with customer for different RAC related issue: [hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on]

-Worked with a skilled team in configuring and managing Golden Gate installation on both windows/Linux environments

-Have experience using Informatica to manage my Databases

-I have experience working with oracle 18c and 19c and I have done migrations on oracle and other platforms.

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

-ve lots of experience working with Unix and PythonUsed primavera to manage projects of any size with this cloud-based, robust, and easy-to-use solution for globally prioritizing, planning, managing, and executing projects, programs, and portfolios.

-Worked on other platforms such as AWS, POSTGRES

- Extensive experience with implementation of Oracle Advance security Wallet Manager.

- Design and implement backup and recovery including disaster recovery structures.

-Used tools such as SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines

- Worked with Oracle to resolve Ora-00600, Ora-07445 issues and resolutions

- Good working knowledge with XML files, Loading and unloading

- Patches, keeping applications software bug free and improving data integrity.

- Upgrades, troubleshooting database issues, critical security updates and User Issues using Meta link.

- Expertise in Oracle performance tuning using STATSPACK, TKPROF, Explain plan.

- Management of 10 to 400+ databases with sizes ranging from 20GB to 24TB and a mix of single instance/RAC Environments

-Migrated databases to RAC for improved scalability, availability and overall performance.

- Experience in Database Migration using Data pump utility, Transportable tablespaces

- Proficient in Oracle19c, 18c, 12c, 11g R1, 11g R2, Oracle 10g R2, 10.1.0.x, Oracle 9.2.0.x, Oracle 8.1.7.x

- Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured Listener for external procedure calls.

- Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables.

-Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, and backup logs to send notification emails

-Worked on administering oracle advance technologies and machines like Exadata, x5, x6, x7

-Installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

- Proficient in Database administration activities such as user management, space management, monitoring, Creating Database, Managing Oracle Instance and Database security and Materialized Views.

-Applied Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch utility.

-Hands on experience working on High Availability Environments.

- Responsible for 24x7 on-call support and monitoring and production deployments.

- Goal Oriented, Good Co-ordination and Co-operation with the Team and Management. Adept at learning and adaptable to complex work environment

-Documentations

Primary Skills

●Database creation

●Database maintenance

●Database Patching and Upgrade

●Database backup and recovery

●Database migration

●Database Design

●Database Development

●Cloning/Refresh

●Linux

●PL SQL

●Informatica

Other Skills

●RAC

●Golden Gate

●Data guard

●Upgrade and patching

●RAT

●PREMAVERA

●Performance Tuning

●Python/Perl

●Delphix

●AWS

●Reporting skills

●professionalism

●Process improvement

●Effective time management

●Organized

●Excellent Multi-tasker

●Quick Learner

●Effective Team Player

●Time management

●Fluent in English, French, Pidgin, speaks some Spanish

●File/records maintenance

●Results-oriented

●Training and development

●Excellent communication

Experience

Oracle Database Administrator

Universal Cargo Services - Los Angeles, CA – Feb 2016 – November 2019

●Usage of enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging, Redo Log reduction on GTTs using temp_undo_enabled.

●Worked with oracle 18c and 19c (management, tuning, migration etc.)

●Used Delphix to clone and refresh databases to speed up production and provide better backup and recovery options

●Experienced in configuration of ASM for RAC and NON- RAC environments.

●Configured Repository and clients for GRID Control and implemented DB Control for some databases.

●Performed database real-time replication through Golden Gate.

●Installed and configured Golden gate software to achieve unidirectional replication and created Golden gate database users with their necessary privileges.

●Managed databases using informatica

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

●Test backups periodically to ensure minimal recoverability time to meet business objectives.

●Used cross platform transportable table space (TTS) to transport table spaces across platforms.

●Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

●Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

●Performed patching on Oracle Database Server 10g,11g and 12c using O patch utility and customized scripts.

●Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.

●Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.

●Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc.

●Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace.

●Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.

●Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.

●Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

●Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

●Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

●Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to

5TB.

●Migration of databases to 12C from Oracle 10g&11g.

●Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes. Implemented.

●Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

● Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.

●Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,

●Experienced with ASM, adding, deleting disks to the disk group.

● Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.

●Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

●Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.

●Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming

queries

●Tools Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, primavera, Python, Perl, Service Now, Jira, SQL Developer, RAT, Primavera, Delphix Etc.

Oracle Database Administrator

CareSource -Dayton, OH - June 2014 – Feb 2016

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

Worked on disaster recovery of data guard physical standby Failover/switchover/loss of service / rebuild/corruption/loss of datafile testing.

Automated monitoring the databases, performance parameters, backup and recovery activities by running

Configured and administered golden gate

Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.

Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high

availability.

Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.

Performed troubleshooting of database using AWR and ADDM reports.

Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually

Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Installed Oracle and grid software on standalone servers on ASM and file system.

Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM

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

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

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

databases.

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

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

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, TOAD, SQL Developer.

Education and Training-

University of Yaounde 2 Soa - - Yaounde Cameroon MBA

Foreign Policy and Diplomacy

University of Buea - - South West Region Cameroon Bachelor of Science

Political Sciences

●Minor in Law

Mountain Computer Training Institute

●Database Administration

Certifications

●Oracle Certified Database Administrator (OCA)

●Oracle SQL Fundamentals

●Scrum Master

●CPR and First Aid

Languages

English

French

Spanish

Pidgin English

Speaking

Excellent

Excellent

Good

Excellent

Reading

Excellent

Excellent

Good

Excellent

Writing

Excellent

Excellent

Fair

Excellent

Reference

Name

Genocia Bah

Clovis Mbufung

Address

Virginia

New York

Tel

240-***-****

240-***-****

Email

adbmog@r.postjobfree.com

adbmog@r.postjobfree.com

Relationship

Colleague and Lead Oracle DBA

Supervisor

Contact this candidate