Varun

Sr. Oracle Certified DBA

804-***-****

acpqup@r.postjobfree.com

Summary:

. 8+ years of experience as a Senior Oracle Database Administrator in

the Database Installation, Development and Production System Support

leading global teams in a wide variety of cutting edge environments.

. Extensive experience in Installation and configuration of Oracle 8i,

9i, 10g and 11g in UNIX/LINUX and Windows environment.

. Experienced in using 10g/11g features Data pump, Flash-Back Recovery,

AWR, ADDM, Grid Monitoring, Recycle Bin

. Experience in Installation, configuration of Oracle 10g RAC.

. 5 years of Extensive Experience in Installing and Upgrading Oracle

9i/10g/11g databases on production, test and development environments

on Solaris and Linux boxes.

. 3 years of Proficient Experience with Standby Database, Data Guard,

Replication.

. 3 years of experience in Installation and Involved in Implementing RAC

Database with 2 and 4 nodes.

. Effective in troubleshooting of database and performance problems.

. Good experience in SQL, PL/SQL.

. Experience with Data Modeling, Logical and Physical database design.

. Worked with development teams and data administration staff to enhance

Database and application performance.

. Management of schemas, objects & Partitioning the tables & indexes.

. Experience in different environments like HP-UX, SUN SOLARIS, Linux

and Windows.

. Knowledge on Oracle Support processes for technical requests through

Metalink and other Support Procedures

. Proactive Monitoring, identifying areas that need to be improved in

the application and database using Statspack, AWR, ADDM, and 10g OEM

Grid Monitoring

. Experience in Database Security and Auditing.

. Worked directly with Engineers on data modeling, logical/physical

schema design, SQL query tuning; and the application of data related

business rules while assisting in troubleshooting, debugging, and

issue resolution

. Performed backups and tested crash recoveries using conventional

cold, hot & RMAN backups.

. Proficient in performance tuning using Explain Plan, STATSPACK,

SQL_TRACE, TKPROF.

. Experience in basic and advanced replication using Oracle Streams and

experience in using OEM, TOAD, Data Migrations using export/import,

benchmarking using load testing tools

. Proficient in using OEM and RMAN.

. Result oriented, self-motivated, team player, ability to work

independently.

. Excellent written and verbal communication skills.

. Proven ability to adapt to demanding schedules and changing priorities

. Ability to function successfully in a highly stressful, 24x7 mission

critical environment.

. Strong analytical problem solving and good communication skills with

ability to work within team environment and independently when needed.

. Result oriented, self-motivated, Team player, ability to work

independently and within a team.

Technical Skill Set:

Operating Systems HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9,

10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x,

4.x, Windows 2003, Windows 2008

RDBMS Oracle 11g/10g/9i/8i

Languages SQL,PL/SQL C, C++, Perl, Korn, UNIX Shell

Scripting, Java.

Tools RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR .

Database Modeling Erwin 4.0, Rational rose, UML 2.0

Other EMC, NetApp, Veritas NetBackup

Professional History:

KINETIC CONCEPTS INC., TX

May'13 - Present

Position: Senior Oracle Database Administrator

Project: 24*7 On Call Production Support

OS: Linux Itanium, Redhat Linux

Softwares: 10g/11g/12C, OAM, OEM Grid Control, UNIX Shell Scripting,

UNIX Cronjobs, RMAN, TOAD

Responsibilities:

. Supporting Oracle Databases 11g RAC on Linux Itanium.

. Involved in 10g to 11g Upgrade

. Supported 11g Databases

. Performed Cloning, export/import and Patching.

. Designed the logical and physical database structure and the security and

database access strategies.

. Took Backups on scheduled time and monitoring scheduled Backups

. Performed backups and recoveries using RMAN conventional hot backups.

. Established and Document Backup and Recovery strategies and procedures

after evaluating various options including RMAN.

. Worked on SQL, PL/SQL Programming and SQL tuning.

. Experience AWR reports, Wait events and also Performance issues of long

running jobs.

. Created and dropped of users, granting and revoking rights as and when

required.

. Experience in monitoring and tuning system resources associated with the

database performance, hit ratios, I/O, lock, and latch contention.

. Tuning heavy data loads. Monitoring and Performance tuning.

. Used TKPROF, EXPLAIN PLAN and AWR for the Better performance.

. Monitered of database for growth and performance

. Monitered Database for fragmentation and correcting them.

. Customization and development of Unix shell scripts, Korn and Perl

scripts.

. Good Experience tranfering files by using scp, sftp, ftp and pscp.

. Partitioning strategies for very large tables.

. Diagnose and troubleshoot Database problems and failures

. Implementing range, list partitions, hash sub partitions.

. Creating and refreshing materialized views.

. Performing SQL*Loader jobs for data loading.

. Performed and Monitored Database using tools TOAD and OEM 10g

. Monitoring of database for growth and performance

JACOBS ENG, PASADENA, CA

Jun'11- May'13

Position: Senior Oracle Database Administrator

Project: 24*7 On Call Production Support

OS: AIX

Softwares: 10g/11g, OAM, OEM Grid Control, UNIX Shell Scripting, UNIX

Cronjobs, RMAN, TOAD

Responsibilities:

. Strong working experience in 24 X 7 Production database administration,

data warehouse systems and monitoring to ensure a proactive problem

recognition and resolution of very large database issues.

. Creating of databases for Testing, Development and Production on VLDB

systems.

. Converted a single instance database to Oracle RAC 10g

. Installed and Upgraded Oracle 11g database from Oracle 10g database on

test and development environments.

. Installation, Configuration and Administration of 4 node Oracle 10g RAC.

. ASM and CRS installation and new database creation for 10g RAC.

. Experience in configuring Oracle Advanced Security Option (ASO) and

Secure Sockets Layer (SSL) on both server and client machines.

. Implemented Streams on both 9i and 10g Databases, Export & Import on 9i

Database, DataPump in 10g Database.

. Performed Database Administration activities such as Upgrades, Patches,

TAR-Support, Cloning, Backup and Recovery, Performance Tuning, capacity

planning, script development, and documentation.

. Used RMAN for backup and recovery. Performed backup validations using

RMAN.

. Implemented and Involved in Hot, Cold and Logical backup plans

. Oracle 9i & 10g RAC Database setup and administration using Dell/EMC SAN

for storage and Oracle Recovery Manager (RMAN) for backups.

. Performance tuning for optimized results using tools like Explain Plan,

SQL*Trace and TKPROF, STATSPACK.

. Proactive database monitoring using 10g grid monitoring tool.

. Developer Environment Setup, Support, Cloning and Refreshes.

. Performed database cloning to setup test and development database

. Setup of Standby database for faster disaster recovery and data guard

setup for high availability.

. Used External Tables to Load data from flat files to database.

. Implemented different Partition methodologies to improve performance and

manageability.

. Diagnose and troubleshoot Database problems and failures

. Written Korn, Perl, shell scripts for digitization the process.

. Load balancing, databases/schema/table re-organization for faster

performance.

. Installation of Oracle version 10g on Solaris, HP-UX and AIX boxes.

. Database dot release upgrades using oracle universal installer and

catpatch.sql

. Upgrading of Database from 9.2.0.6 and to 10.2.0.2

. Was involved in developing a disaster recovery (DR) plan and Stand by

Database

. Continuous Performance monitoring and Tuning of the databases and

application using OEM Tuning Pack, Diagnostics Pack and STATSPACK

. Rebuilding of Indexes

. Conducting sizing & capacity planning for Oracle databases.

. Upgraded Discoverer Administrator from older version to new for

administrative tasks and also applied most recent OLAP patches.

. Experience in reading Alert. Log and User trace Files and Diagnosing the

Problem.

. Scheduling jobs through Oracle job Scheduler.

. Providing Solutions to the Problem Faced by end Users Or Programmers

. Automation of Startup Shutdown on all Production and Development

Database.

. Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of

Tables, Cold Backups.

. Used TOAD tool for querying and troubleshooting PL/SQL queries and codes.

PENN TREATY, Allentown, PA

Jan 2009 - June 11

Position: Senior Oracle Database Administrator

Project: 24*7 On Call Production Support

OS: Linux Itanium

Softwares: 10g/11g, OAM, OEM Grid Control, UNIX Shell Scripting, UNIX

Cronjobs, RMAN, TOAD

. Supporting Oracle Databases 10g RAC on Linux Itanium.

. Involved in 10g to 11g Upgrade

. Supported 11g Databases

. Performed Cloning, export/import and Patching.

. Designed the logical and physical database structure and the security and

database access strategies.

. Took Backups on scheduled time and monitoring scheduled Backups

. Performed backups and recoveries using RMAN conventional hot backups.

. Established and Document Backup and Recovery strategies and procedures

after evaluating various options including RMAN.

. Worked on SQL, PL/SQL Programming and SQL tuning.

. Experience AWR reports, Wait events and also Performance issues of long

running jobs.

. Created and dropped of users, granting and revoking rights as and when

required.

. Experience in monitoring and tuning system resources associated with the

database performance, hit ratios, I/O, lock, and latch contention.

. Tuning heavy data loads. Monitoring and Performance tuning.

. Used TKPROF, EXPLAIN PLAN and AWR for the Better performance.

. Monitered of database for growth and performance

. Monitered Database for fragmentation and correcting them.

. Customization and development of Unix shell scripts, Korn and Perl

scripts.

. Good Experience tranfering files by using scp, sftp, ftp and pscp.

. Partitioning strategies for very large tables.

. Diagnose and troubleshoot Database problems and failures

. Implementing range, list partitions, hash sub partitions.

. Creating and refreshing materialized views.

. Performing SQL*Loader jobs for data loading.

. Performed and Monitored Database using tools TOAD and OEM 10g

. Monitoring of database for growth and performance

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

LIBERTY MUTUAL GROUP, PORTSMOUTH, NH

Nov' 06 - Dec'08

Position: Senior Oracle Database Administrator

Project: 24*7 On Call Production Support

OS: Linux Itanium, AIX, RedHat Linux

Softwares: 10g, OAM, OEM Grid Control, UNIX Shell Scripting, UNIX

Cronjobs, RMAN, TOAD

Responsibilities:

. Advised and made recommendations to improve the overall database design

. Monitored performance and availability of the VIS application (a high-

availability web-based application running Oracle9i RAC on HP-UX cluster

with EMC SAN)

. Was involved in developing a disaster recovery (DR) plan

. Perform SQL tuning and assist developers with coding PL/SQL.

. Continuous Performance monitoring and Tuning of the databases and

application using OEM Tuning Pack, Diagnostics Pack and STATSPACK

. Reviewed the procedures and methods used to manage the staging and

production data feeds all via materialized views (replication)

. Supported installation and configuration of Oracle WebDB, Oracle OAS and

Oracle 9iAS

. Automation of tasks like backup/refresh and other jobs using.

. Configuration of Workflow Notification Mailer, OAM, OEM10g.

. Applying Oracle Applications patches (Maintenance Pack, Interoperability

patch, Family pack, one of Patches etc).

. Oracle Applications Systems Administration. RMAN used in recovery, hot

and cold backup of Oracle10G database.

. Installed and Configured Single Sign On and Implemented SSL Security.

. Registered customized applications, Apps. Users, created

responsibilities, customized menus, attached menus to responsibilities

and finally this to users.

. Planning and Administration of backup and recovery strategies.

. Oracle 10g Database Implementation/Upgrade/Support.

. Oracle 10g Application Server Implementation/Upgrade/Support.

. Oracle OID Implementation and Support.

. Oracle DataGuard Implementation for HA and remote DR site.

. Development of automated RMAN scripts for both backups and cloning of

Oracle Databases.

. Performance tuning of Oracle Database, applications and queries.

. Creating of databases for Testing, Development and Production.

. Taking periodic backup of the database and the software.

. Installed and Implemented Backup & Recovery procedures.

. Used RMAN for backup and recovery. Performed backup validations using

RMAN.

. Implement Hot, Cold and Logical backup plans

. Performance tuning for optimized results using tools like Explain Plan,

SQL*Trace and TKPROF and Statspack.

. Developer Environment Setup, Support, Cloning and Refreshes.

. Installation Configuration and Maintenance of 10g RAC, Stand by database.

. Performed database cloning to setup test and development database

. Setup of Standby database for faster disaster recovery and data guard

setup for high availability.

. Written shell scripts for digitization the process.

. Load balancing, databases/schema/table re-organization for faster

performance.

. Installation of Oracle version 10g on Solaris, HP-UX

. Database dot release upgrades using oracle universal installer and

catpatch.sql

. Migration of Database from 9i and to 10g

. Was involved in developing a disaster recovery (DR) plan

. Continuous Performance monitoring and Tuning of the databases and

application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc

. Monitoring Alert. Log and User trace Files and Diagnosing the Problem.

. Scheduling jobs through Oracle job Scheduler.

Contact this candidate