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 wif Standby Database, Data Guard, Replication.
• 3 years of experience in Installation and Involved in Implementing RAC Database wif 2 and 4 nodes.
• TEMPEffective in troubleshooting of database and performance problems.
• Good experience in SQL, PL/SQL.
• Experience wif Data Modeling, Logical and Physical database design.
• Worked wif 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 dat 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 wif 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 wif ability to work wifin team environment and independently when needed.
• Result oriented, self-motivated, Team player, ability to work independently and wifin a team.

TECHNICAL SKILLS

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.0Other: EMC, NetApp, Veritas NetBackup

PROFESSIONAL EXPERIENCE

Confidential, TX

Senior Oracle Database Administrator

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

OS: Linux Itanium, Redhat Linux

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

Confidential, CA

Senior Oracle Database Administrator

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.

OS: AIX

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

Confidential, Allentown, PA

Senior Oracle Database Administrator

Responsibilities:

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

OS: Linux Itanium

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

Confidential, PORTSMOUTH, NH

Senior Oracle Database Administrator

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 wif EMC SAN)
• Was involved in developing a disaster recovery (DR) plan
• Perform SQL tuning and assist developers wif 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 dis 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.

OS: Linux Itanium, AIX, RedHat Linux

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