Oracle Database Administrator
Resume:
Varun
Sr. Oracle Certified DBA
*****.****@*****.***
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