Resume

Sign in

Oracle Database Administrator

Location:
Lanham, Maryland, United States
Posted:
September 12, 2018

Contact this candidate

Resume:

AGHADIUNO

ac60y3@r.postjobfree.com

WWW.LINKEDIN.COM/IN/ESTHER-AGHADIUNO

410-***-****

PROFESSIONAL

SUMMARY

SKILLS

ESTHER

I am an IT professional with 7 years of experience as an Oracle

Database Administrator. I have supported production and project

environments. Experience in database development and

production environments. Areas of expertise include maintenance,

security and backup, and recovery. Proficient in Performance

Tuning, Patching And Configuring.

Experience in Oracle (12c, Created RAC Database on

11g, 10g) Multi-tenancy, Test Hosts refreshed them with

DataGuard, ASM, RAC the latest snapshot of data

database, Grid, OEM, CPU from Prod Environment.

patches, Oracle installation, Recovering the database

database Upgrades, from Block corruption.

Migration, Backup, Recovery, Performed SQL and PL/SQL

troubleshooting, SR (TAR) tuning oracle contention and

support, Golden Gate, monitored production

configuring new & leas-rolling. database using Automatic

Proficiency with Installation Workload Repository (AWR),

and maintenance of Automatic Database

replication tool Golden Gate Diagnostic Monitor (ADDM)

by creating extract process, and Automatic Session History

extract pump, and replicate. (ASH).

High ability to analyze and Experience in applying oracle

understand the AWR reports patch set, Patches, Critical

and can fine tune the Patch Update (CPU)/Patch

databases for maximum Set Update (PSU) and One-off

performance. Patches using OPatch and run

Provided valuable inputs for Installer.

various performance tuning Upgrading and Migrating

issues. Proficient in Databases from lower versions

performance tuning using to higher versions.

Explain Plan, TKPROF, AWR, Experience in database

ADDM. migration by designing and

Performance Tuning of the implementing database

database (Memory Tuning,

I/O Tuning)

Expertise in Performing Tuning

Database - Tuning involved

I/O, Memory, CPU utilization,

SQL Tuning, SGA tuning,

Shared Pool tuning, Buffers

and Disk I/O tuning using

Oracle's regular performance

tuning tools like Explain Plan,

STATSPACK (perfstat), SQL

Trace, TKPROF.

Proficiency and expertise in

SQL Server Replication,

Backup/Recovery, Disaster

recovery and planning.

Administering SQL Server High

Availability and Disaster

Recovery strategies.

Worked on configuring SQL

Server with minimum

privileged access.

Implemented the new SQL

Server 2012 mechanisms like

data compression, online

indexing, Contained

Databases, security principals.

Installed, configured, and

maintained Oracle 10g and

11gR2 on Linux and also

Upgraded from Oracle 10g to

11g.

Extensive Experience with

RMAN Backups, Hot Backups

and Logical Backups.

Extensively implemented

Datapump, conventional

Export/Import (Oracle 11g,

10g) for migration and logical

backup of database.

Strong skills in applying

security patches (Patch set,

logical and physical storage

structures.

Performance Monitoring and

Tuning of Database,

Application, System Global

Area, I/O, Rollback segments

using self-developed scripts,

Oracle Enterprise Manager,

Spotlight on Oracle, Toad,

AWR, ADDM, ASH reports and

Application tuning using

Explain Plan, SQL Trace, Tkprof

Utilities and statspack.

Experience in optimizing

database access and

allocates/re-allocates

database resources for

optimum configuration,

database performance and

cost.

Extensive experience in daily

batch and report monitoring,

space management, index

rebuilding, statistics collection

and other Oracle

housekeeping tasks.

Developed database support

processes and automated

tasks through tools, PL/SQL

and UNIX Shell Scripting.

Oracle SQL

Net, SQL, PL/SQL, writing

triggers, functions and PL/SQL

procedures, Functions,

creating Tables, Views and

Indexes. OPERATING SYSTEMS:

Red Hat Linux RHEL 5.x and

Windows 2012

RDBMS: Oracle 12c, 11g, 10g

LANGUAGES: SQL, PL/SQL

SOFTWARE/ APPLICATIONS/

TOOLS: DBCA, DBUA, RMAN,

Critical Patch Updates (CPU) /

Patch Set Updates (PSU))

using runInstaller and Opatch.

Independently built new 11g -

12c Databases from scratch

on RHEL, OEL and Windows

platforms from planning,

testing through Release

Management to validation

Worked closely with support

teams including Developers,

SAs, Network, Backup,

Storage and Security

Collaborate with Oracle my

support by submitting Oracle

SRs to resolve complex

incidents

Automated routine DBA tasks

like database backup and db

stats by using Grid control

/Crontab.

Upgraded Oracle Databases

from 10g to 11g and 10gRAC

to 11gRAC.

Added and relocated the

OCR Mirror and Voting Disks to

existing RAC Setups to prevent

Single Point of failure and

scheduled & tested their

physical and logical backups.

OEM Grid Control, Oracle

Data Guard, Oracle

Management Service (OMS),

Real Application Clusters

(RAC), ASM, SQL Navigator,

TOAD, Data Pump (expdp,

impdp),SRVCTL,SQL

Plus

TUNING TOOLS: SQL TRACE,

TKPROF, EXPLAIN PLAN, AWR,

and ADDM

Application Development,

ASM, Auditing, Automation,

Backup, Business solutions, c,

excellent communication,

draw, CPU, encryption, DBA,

Databases, Database,

database management,

designing, Disaster recovery

and planning, Disaster

Recovery, documentation,

features, Flash, indexing, Linux,

Logging, managing, Memory,

Access, Windows, Migration,

Navigator, Network, OCR,

OPERATING SYSTEMS, Oracle

9, Oracle Enterprise Manager,

Oracle, db, Oracle Database,

PL/SQL, Oracle SQL,

organizing, Page 6, processes,

RDBMS, Red Hat Linux, SAP,

SARs, servers, scripts, Sql, SQL

Server, SQL

Loader, statistics, Tables,

TOAD, Troubleshoot,

Troubleshooting, Unix, UNIX

Shell Scripting, UNIX scripts,

Upgrades, Upgrading,

Upgrade, Utilities, validation,

View

Team leadership: configured

Golden Gate, Data Guard for

High Availability, for Disaster

recovery and Scalability.

Strong verbal communication

WORK HISTORY JULY 2016-AUGUST 2018

Oracle Database Administrator Cigna Sunrise, FL

Oracle HA Stack: Install, Configure, Setup, Maintain and Support

Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby

database for Test, Development and Production for various

home-developed applications like Portfolio Management

Systems and vendor applications like SAP Business solutions.

Initial load - direct load, direct bulk load, file to replicat, file to

database utility; avoiding and handling Collisions during initial

load.

Configure and build Golden Gate Extracts/Replicate for multiple

databases.

Data selection, filtering, transformation and column mapping,

and Built-in functions in GoldenGate.

Commit change number (CSN), checkpoint file and checkpoint

table.

Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node

production 10g and 11g RAC databases using Oracle 12c Cloud

Control for Alert Monitoring and Notification.

Upgrade DBs from 11.2.0.4 to 12.1.

Migrate to Multitenant Architecture using CDB and PDB of

applications that otherwise have their own instances and qualify

to be PDBs.

Troubleshoot and resolve slowness or performance issues with

extensive investigation and follow-up with respective application

teams with RCA and proposed solutions.

Resolve lock/latch and resource contention issues during

production hours.

Configure Dataguard and Broker for administration of seamless

switchovers.

Upgrade GI and DBs from 11g to 12c with physical standby DBs in

place.

Utilize SPM SQL Baselines, SQL Profiles and SQL Tuning Advisor for

troubleshooting and providing tuning recommendations to

application teams.

Generate and analyze EXPLAIN PLAN, SQL.

TRACE, TKPROF trace files to identify root cause of SQL

performance issues.

Analyze AWR, ASH and ADDM reports and draw conclusions that

aid in troubleshooting performance issues.

Used import/export utilities for cloning/migration of small sized

databases and Datapump import/export to move data

between 9i and 10g/11g environments.

Applying upgrade patch, maintenance and interim (opatch)

patches on all the databases.

Refreshing Dev and Test instances with data from Production on

a regular basis.

Monitoring and Troubleshooting GoldenGate Replication issues.

Day-to-day usage of Oracle 11gR2 features - Real Application

Testing, automatic SGA tuning, enhanced RMAN with Flash

Recovery Area, Block Change Tracking, Merge backup, Oracle

Data Pump, big file tablespaces, new EM Grid Control,

Database Control, Studio Control, AWR, ADDM, SQL

Tuning/Access Advisors, SQL Performance Analyzer, Database

Replay, SQL Plan Management, SQL Tuning Automation,

Flashback Database, compression techniques and several

others.

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.

Perform LOB Compression, SecureFile and Deduplication in a

cost-saving effort.

Experience using enhanced features in 12c like - Real

Application Testing, Table and partition recovery using RMAN,

Invisible columns, DDL Logging.

Resolved RAC issues, OCR related issues, rebooting of faulty

nodes, relocating the switched over services.

Implemented Oracle TDE to provide transparent encryption of

stored data to support submission efforts with release of Oracle

11g R2.

Extensively used Oracle 11gR2 features - Real Application

Testing, automatic SGA tuning, enhanced RMAN with Flash

Recovery Area, Block Change Tracking, Merge backup, Oracle

Data Pump, big file tablespaces, new EM Grid Control,

Database Control, Studio Control, AWR, ADDM, SQL

Tuning/Access Advisors, SQL Performance Analyzer, Database

Replay, SQL Plan Management, SQL Tuning Automation,

Flashback Database, compression techniques and several

others.

Monitoring and Troubleshooting of Database Replication issues.

Performance Tuning of Oracle Database Objects using tools like

EXPLAIN PLAN, SQL.

TRACE, TKPROF, STATSPACK for optimized results.

Working with Application Development team to address any

issues they encounter and provide support and resolution action

plan.

Database monitoring/maintenance, replication process and

performance tuning are done using OEM (Oracle Enterprise

Manager).

Produced ad hoc reports and documents for senior team

members.

Copied, logged and scanned supporting documentation.

Verified data integrity and accuracy.

Designed, developed and tested embedded software

applications for use in the industry.

MAY 2012-JUNE 2016

Oracle Database Administrator CareSource Dayton, OH

Monitored different databases and application servers using

Oracle Enterprise Manager (OEM) 10g Grid Control.

Loading data from flat files to database using SQL.

Loader, External Tables.

Automated the processes like moving files, managing alert log,

efficient backup by developing UNIX scripts.

Extensively used AWR, ADDM and explain plan for periodic

performance tuning.

Implementing Datapump, conventional export/import utility of

Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to

improve the performance.

Used import/export utilities for cloning/migration of small sized

databases and Datapump import/export to move data

between 9i and 10g/11g environments.

Implemented proactive monitoring using Tuning Pack,

Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN

PLAN.

Database monitoring/maintenance, replication process and

performance tuning are done using OEM (Oracle Enterprise

Manager).

Databases migrated to RAC for improved resiliency and

performance.

Security User Management, Privileges, Role, Auditing, Profiling,

Authentication.

Creating Materialized views and Materialized View Logs for

Increased Performance and Data Replication.

Knowledge in Golden Gate installation & Configuration setups in

both windows/Linux environments.

Provided valuable inputs for various performance tuning issues.

Expertise in Performing Tuning Database - Tuning involved I/O,

Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool

tuning, Buffers and Disk I/O tuning using Oracle's regular

performance tuning tools like Explain Plan, STATSPACK (perfstat),

SQL.

Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle

Databases on Unix/Linux platform using database tuning, Tkprof,

Explain plan, AWR and ADDM reports, Advisors as SQL Tuning,

SQL Advice, Undo, Segment, MTTR, Memory.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle

10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for

improving the security and functionality of the databases.

Involved in the installation, configuration and extended support

to Oracle.

Involved in converting a single instance database to Oracle 11g,

10g RAC databases.

Installed ASM environment and migrated databases from

NON-ASM to ASM.

Used TOAD for database management.

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).

Worked closely with the Oracle developers for the better

performance in Applications in writing the Packages, Triggers

and Indexes on the tables.

Database refreshes using expdp, impdp, RMAN Duplicate and

cloning.

Experienced in cloning the databases using HOT and COLD

backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the

data from 11.1.0.7 to 11.2.0.3.

Made optimal use of Oracle Support in resolving the SRs.

EDUCATION

CERTIFICATIONS

KEY SKILLS AND YEARS

OF EXPERIENCE

LOCATION AND

AVAILABILITY

24 X 7 Production & Development database support and

administration Page 6.

2008

Associate Degree: Information Technology

University Of Lagos,

2004

History and International Relations

ABIA STATE UNIVERSITY, BACHELORS OF ARTS,

GPA: 2.1

Oracle Certified Associate

DATABASE (7 years), ORACLE DBA (7 years), PL/SQL (3 years), SQL (3

years), AIX (3 years), MYSQL (3 years), SQL Server ( 3 years), GOLDEN

GATE (2.5 YEARS), DATAGUARD AND RAC (3 YEARS)

CURRENTLY IN MARYLAND. WILLING TO RELOCATE ASAP.



Contact this candidate