Oracle Database Administrator
I have over 5 years of hands-on experience in the daily administration of production Oracle 10g 11g, 12c databases as well as installation and configuration of both standalone and Oracle Real Application Cluster (RAC) databases, backup and recovery using Oracle Recovery Manager (RMAN), database migration and refresh using Oracle Data Pump, Oracle database replication using Oracle Data Guard and Oracle 12c Cloud Control configuration to monitor. Also responsible for patching, upgrade, performance tuning, database user security and data encryption. Areas of expertise include:
Oracle 10g, 11g,
SQL Server 2012 &
Hat 6.4 and 7
OEM Grid Control
Single and real
Sun Products Corporation Salt Lake City, UT
Oracle Database Administrator June 2016 – Present
Installed, configured and Maintained 10g, 11g and 12c Oracle databases on Operating Systems Linux, AIX and Windows platforms.
Implement Oracle Golden Gate (OGG) to replicate data from front-end OLTP databases to back-end Data Warehouse systems. Troubleshoot typical OGG technical problems using GGSCI/ Logdump /discard file analysis etc.
Set up test databases for development team using RMAN duplicate tool. And Supported development teams for all the database-related issues.
Performed Replication using materialized views with a complete refresh/Fast refresh.
Configuring, Monitoring and maintaining 3 nodes RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
Creating, granting and monitoring user access rights and privileges through roles and profiles.
Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
Provided SQL statement tuning, optimized ETL procedures and removed load and query performance bottlenecks using tools such as Explain Plan, SQL Trace, TKPROF, SQL Tuning Advisor, SQL Access Advisor, SQL Profiler, SQL Optimizer, TOAD and OEM.
Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
Extensively used Datapump, conventional export/import utilities for database refreshes on regular basis, logical backups and migration of databases.
Capacity planning: Allocate system storage and plan future storage requirements.
Installed and Configured OEM 12c to monitor and administer databases.
Performed database backup, recovery, cloning /duplication using RMAN and FLASHBACK features to handle efficient database recovery.
Knowledge in Oracle Data warehouse DBA skills related for administration and management of VLDB environments, Oracle OLTP.
Equifax Atlanta, GA
Oracle Database Administrator November 2013 – May 2016
Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities on Oracle 11gR2.
Setup and maintenance of Physical Standby Database for 45 production databases. Used Active Data Guard feature to offload reporting duty from production database.
Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
Experience in installing oracle software, creating standalone databases migrating from multiple Oracle 10gR2 database to oracle 12cR2 on virtual machine (VM Ware) under different operating system such as Linux, sun Solaris and windows.
Upgraded the Databases from Oracle 10g/11g to 11g and 12c and applied patches according to the client requirement in RAC and NON RAC environments with ASM and Non ASM storage Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Experience in automating jobs using the UNIX shell script, Cron Utility, ORACLE_SCHEDULER and Autosys.
Provided 24X7 support for all the production and development databases. Supported off-hour on call support for database related issue
EDUCATION & CERTIFICATIONS
BS /Ed in Political Science
Imo State University
Diploma in Mass Communication
Oracle Certified Associate
Oracle SQL Fundamental 12c
Institute of Management & Technology