Experience Summary:

• 7+ years of experience as Oracle Database Administrator in financial, insurance, telecom, health and banking sectors.
• Providing 24/7 on call support for production, development and test 11g/10g/ 9i/ 8i databases on various platforms.
• Outstanding knowledge in installation and configuration of Oracle 8i, 9i, 10g and 11g on LINUX/UNIX, IBM AIX, SUN SOLARIS, HP-UX and Windows.
• Skilled in installing and configuring 10g RAC with multiple nodes on Sun Solaris and Linux environments.
• Expertise in leading the teams for Maintenance of 24/7 high-availability applications.
• Experience in managing very large databases.
• Proficient in Database Administration activities such as upgrades, patches, TAR support, cloning, backup and recovery, performance tuning, capacity planning, script development and documentation.
• Experience in Upgrading databases . (10g R2 to 11g, 10gR1 to 10g R2, 9i to 10gR1).
• Experience in using Oracle 10g features such as Data Pump, AWR, ADDM, ASM, OEM and Flashback Database.
• Experience in Managing/working/converting RAC Databases.
• Proficient in providing Oracle Database performance tuning services with Explain Plan, TKPROF, STATSPACK, AWR, SQL TRACE, 10g OEM and troubleshooting Oracle databases using SQL trace utilities.
• Experience in configuring and managing ASM.
• Performed cold, hot and RMAN backups and simulated various crash recoveries and developed RMAN scripts for database backup for both RAC and stand alone instances.
• Experience in using 10g features Data pump, Flash-Back recovery, AWR, ADDM, Grid monitoring.
• Created Shell scripts and scheduled the for monitoring Oracle Databases
• Up gradation and Migration of Database from 10g to 11g and applied patches when ever required.
• Experience in basic and advanced replication techniques such as Materialized Views/Snapshot and knowledge on Oracle Streams.
• Proficient in performing Data Migrations using export/import.
• Skilled in performing Cloning/Refresh databases with cold, hot and RMAN procedures.
• Skilled in database upgrades and applying Oracle patches.
• Involved in data modeling, capacity planning and load testing.
• Scripts (PL/SQL, SQL, PROC*C, shell) were developed to extract the customer data from Data Warehouse and loaded into Customer Data Mart for MDSS.
• Provided Ad-Hoc reports from the Data warehouse for management.
• Well conversant in translating business requirements into creation of database objects like tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.
• Management of schemas, objects, and partitioning the tables and indexes.
• Good experience in SQL and PL/SQL.

Certifications:

Oracle Database 11g Administrator Certified Associate (OCA) 
Oracle Database 11g Administrator Certified Professional (OCP)
Oracle Application Database Administrator Professional (E-Business Suit R12)

Technical Skills

Operating Systems HP-UX 10.x.11.x, Sun Solaris 5.8/5.10, Linux 2.x/3.x/4.x/5.x and Windows NT/95/98/00/XP/Vista, IBM AIX 4.x, 5L
RDBMS Oracle 8i, 9i, 10g and 10g RAC
Languages SQL, PL/SQL, Java, C, C++ and Unix Shell Scripting
Tools RMAN, OEM, SQL*Loader, EXPORT, IMPORT, Data Pump, TOAD
Tuning Tools Explain Plan, TKPROF, STATSPACK, SQL*Trace, AWR and ADDM 
Others EMC, NetApp, Veritas NetBackup, IBM Tivoli, HP Omni backup

Project Summary:

Confidential,Chatsworth, CA Sep 2010 - till now 
ORACLE DBA

The Company focuses on providing clients with executing solutions from a Concept to software applications and solutions, and cross-disciplinary domain expertise that allow its customers to build better businesses through the strategic use of technology.

Responsibilities:

• Involved in 24x7 support for production and development databases with on-call pager
• Continuous Performance monitoring and tuning of the databases and application using OEM and STATSPACK.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Upgrade and Migration of Databases from 9i to 10g R2 and applying patches whenever required.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Monitoring and Troubleshooting of Database Replication and Data Modeling issues and capacity planning using data modeling tools such as ERWIN.
• Experience in monitoring, tuning system resources and Enterprise Database Operations associated with the database performance, hit ratios, I/O, Lock contention.
• Experience in Identifying performance bottlenecks on high volume transaction systems.Reorganize database objects and design indexes to improve response of queries.
• Taking periodic Backup of the Database and the software using Recovery Manager and VERITAS Net Backup.
• Scheduling jobs through UNIX CRON scheduler.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• SQL Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
• Recovery of Database using oracle recovery manager RMAN (Performed full recovery and point in time recovery)
• Installation and configuration of Oracle Client software and Tools on databases.
• Automated the process of analyzing tables every night and maintained required documents.
• Write SQL scripts to monitor table space and extent growth.
• Performance tuning which includes creating indexes, analyze tables and indexes, explain plan.

Confidential,bowling green, KY Jan 2010 to Aug 2010
Oracle DBA

Provided all kind of high end support for 10 g databases on Solaris and Linux Migration, from Solaris to red hat at same time 9.2.0.5 to 10.2.0.3 – using an export /import and shell script combination

Responsibilities:

• Up gradation of database from 9.2.0.5 to 10.1.0.5 and from 9.2.0.5 to 10.2.0.3
• Modifying the database structures as necessary to accumulate application growth
• Responsible for Managing Database Files, schema objects, table spaces, objects and disk spaces.
• Installation of Oracle 10g Grid and respective agents on databases, application servers.
• Responsible for RMAN backups and created RMAN scripts for full / incremental backup, DATAPUMP scripts
• Set up of ADDM and AWR report. Working with developers to resolve performance issues and support production release
• Responsible for database , schema refresh and roles, privileges , permissions

Environment : Oracle 10g, 9i, Red Hat Linux 4.x, Solaris 10, SQL *, CA Erwin, Dynamic shell scripting, TOAD

Confidential, MA Aug ‘08 – Nov’09
Oracle DBA

Responsibilities

• Involving in 24/7 support for both production and development databases.
• The work involves overall Oracle database maintenance, performance tuning, backup, recovery and other database related activities.
• Installed Oracle 9i, 10g and 11g databases on SOLARIS and LINUX and applied patches and upgraded 20 production databases from Oracle 9.2.0.7 to 11.1.0.6 and from Oracle 10.2.0.1 to 10.2.0.4.
• Installing and supporting 10g 2-node RAC on Linux environment with ASM as storage.
• Installing and upgrading of CRS, ASM, 10g RAC binaries on new servers and involved in configuration of F5.
• Using STATSPACK, AWR and ADDM to check health of database.
• Using tools such as TKPROF, STATSPACK, EXPLAIN PLAN and TRACE FILE to tune SQL queries and enhance performance.
• Configuring and managing ASM instance and migrating database from NON-ASM to ASM.
• Configured Data Guard Broker for 10g databases and performed failover failback activities using DBMGRL and with OEM.
• Implemented the Oracle 10.2.0.3 physical Data Guard in Maximum Performance Mode.
• Created standby database for 2-node RAC on test environment.
• Performing BCP exercises on a quarterly basis.
• Using Oracle 10g features like Data Pump, Flashback database and ASSM.
• Performed database Cloning with and without RMAN to setup test and development databases.
• Sizing and capacity planning for Oracle databases.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Using Oracle OEM to monitor database and generate reports.
• Providing replication by creating and refreshing materialized views and implemented advanced replication using Oracle Streams.
• Refreshing Test / Stage / UAT /CAT databases from the production environment using import/export technology.
• Developed shell scripts to automate the processes and to proactively monitor the database.
• Applying critical patch updates (CPU) released by Oracle quarterly.
• Implementing security measures by using proper authentication and authorization mechanisms, user management, assigning privileges and roles, and using auditing at different levels.
• Maintaining schemas, objects and partitioning tables, implementing Range and List Partitions.
• Importing data from flat files into database using SQL*Loader and External Tables.
• Diagnose and troubleshoot database problems and failures.

Environment: SUN SOLARIS 5.8/5.10, Linux 2.6, Oracle 11g, 10g and 9i

Confidential, West Palm Beach,FL Jul ‘06 – Aug‘08
Oracle DBA

Responsibilities

• Installed and created Oracle 9i and 10g databases for production, development and testing on Solaris and Linux environments.
• Involved in 24/7 on-call support for 2-node production RAC database.
• Involved in the process of tuning and refining SQL queries and used TKPROF, Explain Plan, STATSPACK and analyzed AWR reports to improve the performance.
• Applied patches and upgraded databases from 10.2.0.2 to 10.2.0.3 and 9.2.0.6 to 10.2.0.2.
• Involved in installation and managing ASM instance and created databases using ASM.
• Configured and maintained standby database in OLTP environment for production database in maximum protection mode.
• Involved in Capacity Planning and optimal setting of storage parameters.
• Performed Cloning of databases from production environment to test environment using RMAN.
• Setup RMAN catalog for all the Oracle databases, performed backup and recovery using RMAN and implemented Point In Time Recovery (PITR) to recover from user errors.
• Monitored and tuned system resources associated with the database performance, hit ratios, I/O, lock and latch contention.
• Used Flashback databases as a fast alternative to performing incomplete database recovery.
• Provided Export/Import capability by using Data Pump.
• Used different security mechanisms and performed auditing at various levels.
• Implemented various replication techniques like Materialized Views/Snapshot and Oracle Streams.
• Partitioned large tables like Range and List partitions to improve performance.
• Performed database administration activities like user and roles administration, schema management and checking alert log of all the databases.
• Monitored CPU usage, I/O contention, memory paging and identified the resource and performance bottleneck.
• Developed PL/SQL functions, procedures and triggers.
• Wrote SQL scripts to monitor table space and extent growth and accuracy of statistics at different levels.
• Developed Shell scripts to automate backups.
• Scheduled jobs through Oracle Job Scheduler and through Cronjobs.
• Diagnosed to troubleshoot database problems and failures.
• Performed SQL * Loader jobs for loading data from flat files.
• Interacted with Oracle Support services when required and applied security patches downloaded from Metalink.

Environment: Linux, Sun Solaris 5.8/5.10, IBM-AIX, Oracle 9i and 10g

Education:

M.B.A. in Information Technology