Summary

A professional IT consultant with over 7+ years of experience working on various level of infrastructure as a Database Consultant with hands on experience working on flavors of Linux and UNIX servers; RHEL, HP-UX, AIX working on Administration.

Extensive experience on installation, Configuration, Updating, Support, and Maintenance of RHEL, AIX and windows Servers, Linux, AWS.

Worked on full Database operations process like Code review, unit test automation, Build & Release automation, Environment, Service, Incident and Change Management

Installed Oracle 11g, 12c, 18c, 19c for QA, UAT and PROD environment in Solaris 10x and Redhat 7x servers.

Configured and administered databases on RDS, EC2 etc. instances running in AWS

Migrated databases from oracle to AWS, Postgres, and SQL Server

Implemented extensive performance tuning ad troubleshooting at the Network, operating system, Database, and application levels

Upgraded from 10g to 11g, 12c, 18c and 19c

Worked extensively in the configuration and administration of Dataguard.

Good knowledge with Golden gate for real time replication

Configured a 4 node RAC to eliminate single node dependency and ensure load balancing

Initiated patches from QA and UAT lower environments to PROD environment instances in Solaris 10x and Redhat 7x servers.

Initiated RMAN Oracle Database backup for QA/DEV/PPRD Oracle instances.

Extensive experience in installation and implementing OEM 12c and 13c.

Professional Experience

Client: AT$T Atlanta, Georgia

Duration: April 2018 - Current

Role: Oracle Database Administrator

Responsibilities:

Worked on different Database technologies such as Postgres, MS SQL server, AWS with a bias in Oracle Database Administration. Managed and supported databases in across full system development life cycle.

Data Refresh in Test and Integration Databases using Transportable Table spaces, data pump

Worked extensively on troubleshooting lagging jobs in the database both DBMS and USER’S scheduler jobs.

Recompiled invalid objects such as packages, procedures, triggers

Worked on RAC databases as well as ASM to support QA/DEV/PPRD Oracle instances.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Performed dba related activities such as Upgrades, Patches both PSU and database patches, Cloning, Backups and Recovery, Performance Tuning Critical Patch Update/Patch Set update and One-off Patches using OPatch.

Also implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Data pump as well as conventional Hot/Cold Backups.

Worked extensively on Cloning /Duplicate of databases using RMAN.

Exposed to v$ performance views and command line skills to identify information about sessions, wait events, system performance

Deploy codes to the development environments to ensure business growth using builds sent by developers

Exposed in troubleshooting and maintaining Oracle Data guard for Disaster Recovery.

Disk Space Management involving managing archives, space allocation to various tablespaces and capacity planning for new applications.

Configured a physical standby and logical standby databases for Dataguard ensuring high availability

Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention

Excellent analytical, problem solving, communication and interpersonal skills

24x7 on-call rotation for the Oracle DBA environment including managing the incident ticket queue, responding to proactive monitoring alerts, execution of change controls, routine maintenance, shell scripting, performance monitoring, Oracle tuning, and system diagnostics

Configured Bi-directional and Uni-directional Golden gate replication

Worked on a 4Node RAC to ensure load balancing and eliminate single node dependency

Configured and administered +ASM

Performed Oracle backup/Recovery Functions within medium size to large size database(s)

Exposure to Database cloning and other replication strategies across data centers.

Performed software/database upgrades within 11g, 12c and 19c in order to stay complaint with oracle support versions and security patches.

Worked closely with Oracle Support in resolving Critical issue.

Mentored DBA’s on the Process/Procedures set against Servers/databases

Daily Health Checkup of all the Databases using Oracle Enterprise Manager 13c.

Environment: RedHat Linux 6.x, 7.x, Unix, Oracle 10g/11g HP-UX11, Sun Solaris 10.0, RMAN, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN, TOAD, SQL Developer, beyond compare, Data Guard.

Professional Experience

Client: Universal Cargo Services, Los Angeles, CA

Duration: Feb 2014 – April 2018

Role: Oracle Database Administrator

Responsibilities:

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.

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.

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 and 11g using O patch utility.

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 Cluster ware 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

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 production with the test environments 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 types 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 3TB.

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

Responsible for Installation/configuration and maintenance of Oracle Physical and Logical database within 10g/11g

RAC Installation, Configuration and Maintenance under 10g/11g

SQL tuning/Performance monitoring of Server/databases.

Implementation of Backup and Recovery strategy

Environment: RedHat Linux 6.x, 7.x, Unix, Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RMAN, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN, TOAD, SQL Developer, beyond compare, Data Guard.

Professional Skills

Operating system:

RedHat, Solaris, AIX, HP UX, WINDOWS

Database Tool

TOAD, SQL DEVELOPER, RMAN

Cluster Server:

Oracle Rac

Languages:

SQL, PL-SQL, T-SQL, Bash script.

Database versions

Oracle 9i,10g,11g,12c,19c

Education:

Bachelor's degree Computer Science

University of Yaounde I - Yaounde

October 2009 to August 2012

CERTIFICATION

Contact this candidate