CALISTA E. TEBIT

Oracle Database Administrator

aczzts@r.postjobfree.com 301-***-****

PROFESSIONAL SKILLS

I have 4 years of experience as an Oracle Database Administrator. I possess complete life cycle

knowledge including Installation and configuration. Worked on Oracle 12c, 11g, and 10g versions. Daily

database administration tasks include production support, database upgrades, patch administration,

migration, installation and configuration, backup and recovery, performance tuning, database

cloning, and security management.

Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.

Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard

and replication using Streams.

Experience in Oracle (12c, 11g, 10g) Multi-tenancy, DataGuard, ASM, RAC database, Grid,

OEM, CPU patches, Oracle installation, database Upgrades, Migration, Backup, Recovery,

troubleshooting, SR (TAR) support, Golden Gate, configuring new & leas-rolling.

Proficiency with Installation and maintenance of replication tool Golden Gate by creating

extract process, extract pump, and replicate.

High ability to analyze and understand the AWR reports and can fine tune the databases for

maximum performance.

Experience in system Monitoring and Database Performance Tuning using Explain plan,

SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)

Provided valuable inputs for various performance tuning issues using AWR, ASH and ADDM.

Performance Tuning of the 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.

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.

sky

1

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for

migration and logical backup of database.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch

Set Updates (PSU)) using "runInstaller" and perl based utility "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.

Created RAC Database on Test Hosts refreshed them with the latest snapshot of data from Prod

Environment. Recovering the database from Block corruption.

Performed SQL and PL/SQL tuning oracle contention and monitored production database using

Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and

Automatic Session History (ASH).

Experience in applying oracle patch set, Patches, Critical Patch Update (CPU)/Patch Set

Update (PSU) and One-off Patches using OPatch and run Installer.

Upgrading and Migrating Databases from lower versions to higher versions.

Experience in database migration by designing and implementing database 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 rebuilds,

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

Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of

databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell

scripting, CRON jobs.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques

to ensure business continuity.

Expertise in maintaining Database Security using auditing.

TECHNICAL SKILLS

sky

2

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1

Operating Systems RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows

95/98/NT/2000

RDBMS Oracle 12c, 11g, and 10g

Languages SQL, PL/SQL, UNIX Shell Scripting, PERL

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad,

Tools Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team

Viewer, LogMeIn and Cisco VPN Client

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM,

Database Utilities Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export,

Import

PROFESSIONAL EXPERIENCE

Cardinal Health - Dublin, OH APRIL 2015 Present

Role: Oracle Database Administrator2

DBA supporting three major projects from Development to Production via Tech-Test environments,

involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes

range from 4GB to 2TB (in ODS & EDW environments).

Responsible for Build Work in various servers which has 3 Node RAC & Non - RAC, High

Availability, Golden Gate Technologies.

Experienced in Golden Gate Installation and Configuration for database replication purpose.

Solid experience with different versions of Golden Gate installation, configuration,

Administration, heartbeat monitoring etc.,

Supported 400+ databases including RAC production database, a Data warehouse database and a lot

of Development and Test databases and upgraded from 10g to 11g.

Provided Production & test environment support while coordinating with Unix Team and

storage team to configure the OS infrastructure for Oracle Databases.

Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw

Devices and 11g CRS on IBM AIX 6.1.

Performed conversion of Single Node Instance to multi node RAC with ASM, and adding

instance to existing RAC.

Installed and configured 6 node oracle 11gR2 RAC for production environment.

Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.

Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate

EXTRACT and REPLICATE issues.

Implemented and administered Oracle Golden Gate (v10) for Database Replication between

production and reporting node, by using Oracle Streams in parallel to secure data and having

the availability of the database during regular the upgrade or maintenance operation.

Implemented Data Pump, Export and Import on day to day basis as per development and test

servers.

Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters)

with AWR (Automatic Workload Repository) reports and ASH (Active Session History).

Monitoring database performance and database operation to prevent downtime and slowness

of the services.

sky

3

Worked closely with the system operations team on database deployment processes and database

capacity planning.

Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental

backups & Import/Export).

Cloning RAC to RAC and RAC to NON RAC using hot backup and RMAN.

Expertise in configuring and managing the Concurrent Managers, Workflow Notification

Mailers and monitoring their operation

Strong experience in Space and User Management, Capacity planning, standby setup, Backup

& recovery (Import/Export, Datapump, RMAN)

Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN,

TKPROF, AWR, ADDM, SQL TRACE and SQLT

Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).

Applied database patches using Opatch utility & building Clone instances for Development

and Test teams.

Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata

servers.

Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized

views refresh and db exports.

Maintained DATA GUARD to provide high availability by implementing physical stand-by

database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and

Automatic Storage Management (ASM).

Troubleshooting Space Management & User accounts and privilege issues while coordinating

with Unix and application teams.

Performed proactive database maintenance procedures to ensure optimal performance and uptime

and implemented shell scripts for automation of day to day activities.

Identify Top SQL that are consuming heavy resources and provide support to the development

team in identifying SQL queries that are consuming high resources and interact with the

development team to see if these queries can be fine-tuned further.

Regular Security Patching and Critical patch Updates (CPU) and Patch set updates (PSU) on

Oracle databases and interim patches for various bug fixes on database products.

Production support for Oracle database 10g/11g RAC.

Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle

Management Server for maintenance and monitoring of production databases.

Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL

tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.

Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers,

Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day

operations.

Expert in monitoring database using Oracle Enterprise Manager (OEM).

Tools Used: Oracle RMAN, Oracle 10g (9.2.0.8), DBMS STATS, Data pump, SQL TRACE, TKPROF,

EXPLAIN PLAN

Weis Market Inc - Sunbury, PA Jun 2013 Dec 2014

Role: Jr Oracle DBA

sky

4

Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long

duration.

Monitored Database growth and provide Database capacity planning for applications expansion

or necessary re-organization of tables and indexes as and when required.

Performing Database Administration activities like space management, user and roles administration,

schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on

multiple platforms.

Performed up-gradation of 10g to 11g.

Performed traditional Cold backup in appropriate environments via OS commands as well as logical

exports.

Automated routine DBA tasks like backup's and stats by using Grid control job's

Provided Assistance to application team at the time of SQL tuning in applications. Administration of

RAC and DATAGUARD databases in Oracle 11g.

Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.

Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best

practices, optimizations and data guard and cloning techniques -- restore and recovery .

Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-

over purposes. Created, relocated and removed Services as needed in an Oracle RAC

configuration

Adding and removing nodes to existing Oracle database RAC configurations

Worked closely with diverse application development groups and served as single point of contact

for testing, tuning and implementing projects / solutions in production environment

Cloned and maintained multiple Oracle Database environments for Development, Testing &

UAT.

Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases .

Applied various database / applications PSU / CPU patches as required. Also applied monthly

vertex updates.

Performed activities like monitoring the database and provide maximum uptime.

Created and granted users the privileges and roles and resizing the datafiles to manage database

growth.

Defined and implemented database backup and security strategies, tested the backups periodically

for consistency and reliability

Identified long-running database queries, refining queries for better performance, and working

with end- users to implement changes

Created primary database objects (tables, views, indexes) once application developers have designed

an application

Monitor database systems and provide technical support for database system issues and application

performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well

as UNIX shell scripts.

Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures,

Functions, etc.,.

Environment: RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle

Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2,

Autosys, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader

EDUCATION

sky

5

PGCC

-Information Technology

sky

6

Contact this candidate