Professional Summary
* *****’ of experience in the field of Database Technology Oracle with experience in designing, developing and implementing Databases.
Expertise in Oracle Database Administration for Oracle 19c, 12c, 11g with experience in very large-scale database environment (VLDB) and mission critical large OLTP and OLAP systems.
Experience in Real Application Cluster (RAC) administration with Auto Storage Management (ASM) on Oracle 11g&12c RAC Grid infrastructure and standalone 12c new features.
Hands on experience with managing ORACLE rdbms on various flavors of UNIX such as Oracle Enterprise Linux 6.x, 5.5,IBM AIX 5.3 & 6.1 and REDHAT LINUX 5.7, 6, 6.5, 7.
Administer over 100 databases across Development, QA, UAT and PROD environments via use of command line and Oracle Enterprise Manager Cloud 12c.
Good knowledge on shell scripting.
Extensive experience designing and implementing backup and recovery strategy using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/ColdBackups.
Working with Oracle Support to fix the production issues and also to get the merge patches.
Documentation of all my work, procedures and troubleshooting.
Work on on-call support schedules and 24/7 hour availability.
Experience with ETL tools to gather data from various sources and load into distinctive targets.
Upgrade 12c database to 19c
Successfully implemented Physical Standby Database using Oracle DATAGUARD feature for High availability and DR configuration.
Experience Summary
Bank of America Phoenix AZ
Jan 2019 – Present
Sr. Oracle Database Administrator/Mssql server DB
Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
Oracle Installation, Configuration and Migration
Migration of databases to 19C from Oracle 12c.
Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup.
Installed, patched, and managed Oracle Database versions 11g on Red Hat Linux.
Good knowledge on shell scripting
Experience working on AWS EC2 instances
Supported multiple databases including RAC production database, a Data warehouse database and some Development and Test databases.
Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
Ensure night cron jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases
Good understanding of Golden Gate components like Integrated Extract, Replicat, Trail Files, GGSCI commands.
Configured Oracle 11g Physical Standby Database for DR purpose using ORACLE Dataguard.
Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.
Worked on setting up/installation and configuration of release 11g R2 RAC with ASM.
Installed and configured 3 node oracle 11gR2 RAC.
Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
Experience with ETL tools to gather data from various sources and load into distinctive targets.
Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
Experience with ETL tools to gather data from various sources and load into distinctive targets.
Monitoring database performance and database operation to prevent downtime and slowness of the services.
Worked closely with the system operations team on database deployment processes and database capacity planning.
Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
Strong experience in Space and User Management, Capacity planning, standby setup, Backup & recovery (Import/Export, Datapump, RMAN)
Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE and SQLT
Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).
Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
Production support for Oracle database 10g/11g/12c/.
Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
Expert in monitoring database using Oracle Enterprise Manager (OEM) and Toad.
Creating users granting privileges as need with BI team using management studio.
Doing installation, configuration patching of sql server db.
Creating index rebuild jobs and some maintainers jobs for performance purposes.
Doing dinodo for virtualization
Deploy new related task as need by developers.
Using Edwin for data modeling and revers engineering
Creating tables, views and objects related to the business purposes.
Caterpillar - Peoria, IL
April 2015 – Dec 2018
Oracle Database Administrator
DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on Linux and Unix servers. Database sizes range from 4GB to 9TB.
Performed Installation and configuration of Oracle 12c database on Unix and Linux platform.
Performing schema management, database sizing, maintaining privileges of users and user profiles and implemented Oracle Advance Security.
Installed Oracle 10g and 11gR1,11gR2 database on Redhat Linux 6,
Applied Bug fixes patches and Quarterly Security Patches for the stand-alone databases and 2-node RAC databases within the maintenance window.
Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
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).
Setting up physical Standby Data Guard for disaster recovery.
Created Various Disk groups for OCR, Voting Disk, and archived logs with normal redundancy for High Availability.
Performed Cloning RAC database using RMAN to refresh the data from the Production database to the Lower Environment on demand.
Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages.
Installed and configured Golden Gate for replication.
Responsible for Database Backup and Recovery, daily monitoring of database & network issues
Deployed Grid Control to monitor and manage all the databases on clients.
Used Shell Scripts to automate database operation and schedule jobs using CRONTAB.
Involved in capacity planning.
IT Global Services LLC AZ
Jan 2016- April 2015
MSSQL Database Admin
Installation, configuration, patching and migration of sql server db.
Creating new users, granting privileges to access database table and newly related objects.
Performing restore and refreshes as need by business . Implement newly created store procedures and linking them to their respective tables for performance related issues.
Creating maintainers jobs and monitoring them if any failed job is required restart.
Modify tables using ewin and doing data cleansing by implementing reverse engineering and forward engineering.
Using query store for modifications of and implementation sql queries .
Creating db links to link two database at a time and modify objects to database .
Configure monitoring and creating new alert notifications
Education
BSc Computer Science, University of Bamenda
OCA Oracle Certified Associate
Sql Fundamentals Associate
Ms SQL Administration
AZ500