Oracle Database Administrator
Resume:
AGHADIUNO
*********@*****.***
WWW.LINKEDIN.COM/IN/ESTHER-AGHADIUNO
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