Oracle Data
Resume:
Charles Bate
Oracle Database Administrator- Cardinal Health
********@*******.***
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