Data Oracle

Lilian Udensi

**********@*****.*** 202-***-****

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,

12c

SQL Server 2012 &

2014

Unix/Linux Red

Hat 6.4 and 7

AIX

Windows Server

TOAD

OEM Grid Control

Performance

tuning

RMAN

RAC

Dataguard

Goldengate

Upgrades and

patches

AWR

ADDM

STA

SAA

ASH

AWS Cloud

Single and real

application cluster

Database security

Data encryption

Database backups

Data migration

Data pump

Transportable

Tablespaces

SQL*Plus

PL/SQL

T-SQL

SQL*Loader

Exadata

Remedy

Strong

Data Warehouse

VLDB

environments

OLTP,

DB Artisan

Excellent written

and verbal

communicator

Microsoft Office

Suites

Remedy,

Service Now

AWS cloud

Crontab

ORACLE

SCHEDULER

Amazon Aurora

Documentation

interpersonal skills

PROFESSIONAL EXPERIENCE

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

Contact this candidate