ORACLE DATABASE ADMINISTRATOR

Livinus Okafor

adaor7@r.postjobfree.com

Phone: 612-***-****

An accomplished and a seasoned Database Administrator and a security expert with over 7+ years of extensive experience with extensive knowledge and proficiency in database design, Monitoring & Tuning, Migration, Upgrades, Backup & Recovery, Cloning, Replication, and Security Implementations. I'm also proficient in an assortment of technologies including Oracle 10g, 11g and 12c, and MS SQL Server. Possess remarkable communication and detail-oriented skills with a great aptitude for problem solving. Proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions. An energetic achiever who can successfully manage multiple priorities and perform tremendously well under pressure where accuracy and attention to details is key

AREAS OF EXPERTISE INCLUDE:

Installation, Upgrade, Patching and Configuration

Database Security

Performance Monitoring and Tuning

Backup and Recovery using RMAN and Maintenance plan Wizard

Oracle Data Guard

RDBMS: Configuration and Installation of Oracle 10g, 11g, 12c.

Languages: HTML, SQL, UNIX Shell Scripting (Solaris8/9/10), MySQL, LINUX (Red Hat), MS Windows Servers 2008, 2012, 2014 and 2016.

Monitoring and performance tuning using AWR, ADDM, OEM console, Grid Control, SQL Developer, Explain Plan, Optimizer Statistics

WORK EXPERIENCE

ORACLE DATABASE ADMINISTRATOR

HONEYWELL Minneapolis MN Feb 2016 to Present

Performing Day-to-Day DBA tasks: performance tuning, system security, database Installation configuration, patching, technical database support in 24X7 environment to ensure System performance and stability.

Implement a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. Utilize block change tracking which reduces backup time from 10hrs down to 36mins.

Monitoring Oracle database services on a UNIX/ Linux Operating System environment, and on OEM.

Install and administer Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

Restoration and Recovery of database from offline, online using RMAN and Data Pump backup.

Table space monitoring, Performance monitoring and tuning for performance improvement.

Performed administrative activities like user creation and administration, profiles, privileges and roles administration, space and schema management.

Work with developers to diagnose Database related application problems, provided development support to maintain application schema and distribution of data.

Managing, troubleshooting and resolving Oracle database and application issues.

Performed database Refreshes and Cloning from production environments using RMAN Duplicate and Data Pump impdp/expdp.

Ensure daily data concurrency and consistency on production, test and development databases.

Strong enforcement of database security through Authentication, Authorization, Auditing and TDE for advanced security.

Apply patches and worked closely with Oracle to make Application environment up to date

Work hand in gloves with the IT team to ensure high availability, and no data lose through data guard

Perform SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) reports

Performed DB health checks for production and testing databases.

Responsible in risk analysis and applying Oracle security patches on databases.

Performance tuning and SQL tuning.

Shell scripting to automate batch jobs, database backup and other processes.

Designed and implemented highly available production systems using Active Data Guard, RAC, ASM Storage and Oracle Enterprise Manager (OEM)

Excellent experience in Installation, configuration, Maintenance of Oracle 10g, 11g, 12c on Operating Systems Solaris, Linux, AIX and Windows platforms.

Database upgrades, resource capacity planning, platform migrations, application consolidations and data center rationalization.

Logical Volumes layouts, Disk layouts and Capacity planning.

Cloned databases in Test, Development and production environments using RMAN and DATAPUMP utilities for various Database sizes.

Enhance end users understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.

Provide 24X7 on call rotation support

ORACLE DATABASE ADMINISTRATOR

General Electric Minnetonka MN June 2012 to Feb 2016

Created and updated the documentation as needed

Backup and restoration of key spaces and snapshot management.

Review daily backup reports closely and ensure successful backups.

Attend operations and project meetings without fail to ensure successful delivery.

Troubleshoot Exadata machine using 12c cloud control and work with Oracle Support for hardware and software issues.

Manage Oracle Database Infrastructure for Employee, Facilities, Management and HR solutions.

Implement database disaster recovery solution for application.

Perform DR and Restoration drills for Production environments as per Audit and compliance.

Create oracle database on configure servers using both the DBCA and Database Creation Scripts

Use AWR/ADDM for 10g statistics management and database tuning following creation of new databases periodically and thereafter

Deployment of application objects via change control process.

Responsible in risk analysis and applying Oracle security patches on databases.

Performance tuning and SQL tuning.

Responsible for monitoring fragmentation at segment and database level for performance and space.

Create database objects such as tables, views, sequences and triggers

Create user account and assign appropriate privileges

Responsible for monitoring and troubleshooting the database environment

Tablespace monitoring, performance monitoring and tuning for performance improvement

Contributed towards Data Guard unidirectional DML replication setup.

Develop scripts to automate the database monitoring and housekeeping activities and send email alerts.

Tuning SQL queries which impacts database performance

Responsible to ensure all the tickets are attended as per SLA and up to customer satisfaction.

EDUCATION/TRAINING

Dunwoody Collage of Technology – Minneapolis MN

Automated Systems and Robotics - A.A.S

OCA Certified - Oracle University

Contact this candidate