Charles Bate

Oracle Database Administrator- Cardinal Health

acgqvj@r.postjobfree.com

240-***-****

New Carrollton, MD

Goal oriented and results drive IT professional with over 6 years in the industry and 5 years of extensive

knowledge and proficiency in Oracle Database Administration in 10g and 11g databases. Track record in

operations, maintenance and provisioning of database application enhancements. Able to work

independently and efficiently in self- directed work environments or collaboratively in a team. I have

excellent skills and hands on experience in:

•Database installation and administration.

•Database Configuration, production support, upgrades and patches,

•Performance tuning using SQL Tuning used Tuning utilities like STATSPACK, TKPROF, EXPLAIN

PLAN, AWR, and ADDM.

•Database monitoring with VLDB (Very Large Databases) using Grid

•Backup and recovery.

•Space management.

•Database security.

•Database upgrade and migration, shell scripting and documentation.

•Oracle Virtual Machine (OVM)

•Excellent OS and database troubleshooting skills

•Exposure to Oracle High Availability involving Oracle RAC and Data guard.

•Capacity planning and efficient usage of the disk space.

•Excellent experience in installation, setup and configuration of Oracle 10g and 11g in Linux Red hat 5.0,

Sun Solaris, AIX, Windows and UNIX/Linux Environment

Work Experience

Oracle DBA

Cardinal Health Dublin, OHIO

January 2013 – present

Cardinal Health is a Fortune 22 company that improves the cost-effectiveness of healthcare. As the

business behind healthcare, Cardinal Health helps pharmacies, hospitals and ambulatory care sites focus

on patient care while reducing costs, improving efficiency and quality, and increasing profitability, my

responsibility was to manage multiple Oracle Database Servers that include the following:

Creating user accounts and appropriate privileges as well as maintaining database

security.

• Establish a backup and recovery strategy using daily hot backups, RMAN and

weekly full backup.

• Configured and implemented backup/recovery strategy using Oracle RMAN on SunOS

5.10 for daily database backups.

Ensured daily RMAN backups are completed and valid for restore and recovery.

Proactively performance monitoring, reporting, and tuning of Oracle databases to ensure

the highest standards of availability, resilience, integrity, security and performance

required by business systems.

• Utilize Automatic Workload Repository (AWR) to generate snapshots of key

performance data.

• Utilize Automatic Database Diagnostic Monitor (ADDM) to reduce DB time by

diagnosing key problems.

• Management and maintenance of backup and recovery procedures (RMAN and Data

pump)

• Responsible for improvement and maintenance of the databases to include rollout,

patches and upgrades

• Set up, configuration and troubleshooting oracle streams replications.

• Resizing, relocating and duplexing redo logs to either reduce log switching or eliminate

contention.

• Resizing, cloning, moving, Partitioning and stripping table spaces, Tables, Indexes and

rollback segments as the case might be.

• Data migrating using Import/Export, Data pump and SQL*Loader either interactively or

batch mode.

• Designed, tested, implemented and documented database migration procedures

including export/import, migration utility.

• Provide a 24/7 availability and coverage of technical assistance.

• Spearheaded special projects by instructing management on space projections for

budget purposes, and database concepts during database tuning and report analysis.

Oracle Database Administrator

Citigroup Glen Burnie, MD

February 2012 – December 2013

Citi group is a financial service company that works tirelessly to provide consumers, corporations,

governments and institutions with a broad range of financial services and products.

As a member of the teams at Citigroup, we build new databases for Dev, QA and Prod on AIX / UNIX /

LINUX servers and replicated data from the legacy 10g databases to the new 11g servers

As part of the great team in the project, we also developed data security and backup strategies and

provided solution for better performance to end-users.

Responsibilities:

•Performed Installation and configuration of Oracle 11.2.0.1 database on HP-UX platform.

•Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.

•Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using

Data Guard feature of Oracle 11g R2.

•Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11g R2.

•Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in

Oracle11gR2.

•Implemented recovery strategies whenever required and successfully recovered databases in case

database crash, media/disk failures by using RMAN

•Scheduling the Physical backups (hot & cold) in CRON job using RMAN utility and monitoring the

scheduled jobs.

Facilitated RMAN incremental backups by using Block Change Tracking algorithm

•Recovered data from logical failures using flashback and point in time recovery.

•Cloned production databases as needed for testing, development using RMAN and Grid Control

•Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant

necessary privileges to the relevant groups.

•Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and

viewing Alert log files & Trace files.

•Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free

space, used space, fragmentation etc.

•Performed space management, capacity planning, disaster recovery and overall maintenance of the

databases.

•Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries

•Maintained the data integrity and security using integrity constraints and database triggers.

•Provide 24X7 supports for all the production and development databases.

•Maintain record of daily data communication transactions, problems and remedial action taken, and

installation activities.

•Ensured that standby database is always in sync with production database by checking archive logs

sequences.

Environment: Oracle10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL

TRACE, TKPROF, EXPLAIN PLAN

Oracle Database Administrator

Hellmann Worldwide Logistics GmbH Hamburg, Germany

January 2009- 2012

Hellmann worldwide logistics is a global logistics and financial services company. Hellmann Group has a

significant presence in each of the world's major logistic markets.

Responsibilities:

•24x7 Production Database Administration and support

•Engage in overall maintenance of Oracle database, performance, tuning, backup, recoveries and other

database related activities.

•Actively involves in system administrator tasks like creation of users, file systems, volume groups and

logical volumes etc.

•Taking Backups on scheduled time and monitoring scheduled Backups.

•Creating and dropping of users, granting and revoking rights as and when required

•Checking of Oracle files for abnormal behaviors

•Day to day performance monitoring and tuning of database.

•Monitoring of database objects like rollback segments, temp segments and tablespaces

•Diagnose and troubleshoot Database problems and failures

•Establish and Document Backup and Recovery strategies and procedures after evaluating various options

including RMAN.

•Involved in the Design (Logical & Physical) of Databases.

•Preparing Backup and Recovery plan.

•Involved in the installation of Oracle 10g on Solaris and UNIX platform

•Creation and maintenance of database

•Handling day-to-day activities.

•Storage and space management including tablespaces and data files.

•Management of table space growth, monitoring data files additions, extent growth

•Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and

viewing Alert log files & Trace files.

•Monitoring of database for growth and performance

•Defined backup procedures using daily hot backups and weekly cold backup.

•Oracle database administration on Solaris platform

•Using TKPROF, EXPLAIN PLAN for the Better performance

•Monitoring Database for fragmentation and correcting them

•Creating and implementing backup and recovery strategies

•Setting up and maintaining user accounts and profiles

•Space management

•Maintained DATAGUARD/STANDBY Databases.

• Ensuring proper online and offline backup, periodical reading and checking of backups taken.

•Monitoring Growth of tables and undertaking necessary re-organization of database as and

When required.

• Creating Databases and all database objects. Database Designing (Designing Table spaces and Rollback

Segments)

Environment: Oracle 11g/10g, AIX 5.2,5.3, Imp Exp 32, Grid Control (OEM), Enterprise Manager

Console, SQL PLUS, SQL Developer, Putty, RMAN, Data Guard, ASM, TKPROF, Explain plan, AWR,

ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Additional Information

TECHNICAL SKILLS:

Operating System: Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional), Red Hat Linux RHEL

3.x, 4.x, UNIX, Sun Solaris 2.5, 2.6, 8, 9, and 10.

Databases: Oracle 11g/10g/9i/8i,

DBA tools: SQL Navigator, SQL*Loader, Sql *Plus, 11g OEM, Grid RMAN, DBCA, 11g Data Pump,

Toad, Data Guard, Export / Import, TKPROF, Stats pack

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH, Languages: SQL,

PL/SQL, C, C++, UNIX Shell Scripting.

Contact this candidate