• Accomplished Oracle DBA with 6 years of experience and having expertise in performance tuning, crisis management, maximize productivity and increase high availability with reliability with a complex problem solving skills and communication skills. Areas of expertise include:
• Database Designing Database Implementation Database Cloning
• Database Upgrade Database Refreshes Database Migration
• Database Patching Data-guard Configuration Capacity Planning
• Backup Configuration Performance Tuning Database Replication

PROFESSIONAL EXPERIENCE

ORACLE DBA

Best Brains is a learning center which provides instructions in Math, English, Abacus and General Knowledge to students all under one roof. Supported a ten-terabyte warehouse played a lead role in the database migration from stand-alone databases to RAC instances. Involved in cross platform migration. Performed RCA on database failures and resolved performance tuning related issues.

Key Contributions:

• Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g RAC with ASM.
• Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces TTS , Datapump, SAN Synchronization SRDF.
• Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4 to 11g/11g RAC.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
• Comprehensive documentation of all activities
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Setup, reconfigured and monitored single instance and multimode RAC to RAC Dataguard for DR.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Created Database Clones from to do refresh on prod to dev using NetApp SnapManager Utility
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR Statspack , ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects tables indexes and tablespaces to improve the performance.
• Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat, etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Intensively used latest 10g/11g Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, and backup logs to send notification emails.
• Migrated data to a new ASM Diskgroup to improve the IO performance of the database.
• Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.
• Worked with Storage team in integrating the SnapManager software with the oracle servers.
• Recovery of Database Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption from previous RMAN backups
• Performed capacity planning, space monitoring like tablespace growth, ASM disk space.
• Resolve critical issues by raising SR with Oracle Support and Root Cause Analysis RCA .

ENVIRONMENT: RHEL HP-UX, Oracle 11g/10g/9i/12c, RAC, ASM, Dataguard, DGMGRL, RMAN, PL/SQL, UNIX Scripting, OEM Grid Control, EMC SAN, Toad, Datapump, SQL Loader, Putty, NetApp SnapManager.

Confidential

ORACLE DBA

Founded in 1890, CMS Energy is a public utility company supplying electric power and natural gas to Metro Detroit and most of Michigan. I was recruited as a consultant in IT support team as Oracle DBA to provide production support over 250 databases. I was involved in installing and upgrading various production databases and also created an effective backup strategy for the databases.

Key Contributions:

• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Experienced working on Oracle 11g/10g RAC databases which includes upgrade of the database to the latest version 11.2.0.2
• Installed and configured clustered operating system, configured grid, setup RAC instances, migrated application code and system utilities from Solaris 8 to Linux.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Monitoring, identifying areas that need to be improved in the 4-node RAC database using AWR, ADDM, Grid Control
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Plan, develop and Schedule of the production refreshing, dependency checking and setting up the initialization parameters for standby database as well as tuned SPFILE parameters.
• Experience in working on performance issues on BI production databases, large OLTP systems
• Utilized RMAN for backup and Recovery strategy
• Implemented disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration
• Experienced working on non-prod databases which are resided on Virtual Machines and understanding the working process.
• Worked with different middleware IDM teams to resolve their issues from the database side.
• Refreshed non-production environment with production using Datapump RMAN
• Applied patches and database re-organization using oracle enterprise manager OEM .
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily alert logs
• Database Capacity Planning configuration redo and stream sizes , design staging schema.
• Experience in Identifying the queries utilizing high system resources and advising the solution for those.
• Regular DBA activities like Undo-segments, Rollback-segments, database auditing, space management, database issues, locking, managing user groups and tuning.
• Refreshing schema's in non-production environment with production backup.

ENVIRONMENT: Oracle 10g/11g, RAC, OEM, AWR, Statspack, ADDM, RMAN, Golden Gate, Red hat Linux 2.6, Virtual Machines, Toad, Datapump, SQL Developer, PLSQL, EMC

Confidential

ORACLE DBA

Independent Health an NCQA accreditation and is one of the country's leading health plans for customer service and satisfaction. Independent Health has become one of the major forces in the provision of employee health care benefits in the northeast, operating health plans in the eight counties. Recruited as an Oracle DBA to support over 400 Oracle databases running on 9i, 10g, 11g, RAC and ASM

Key Contributions:

• Involved in regular day to day activities for production databases running on RAC and Non RAC. Installation of Oracle 11G, 10.2.0.1 and upgrading them to 10.2.0.3 and 10.2.0.4 by applying oracle patch sets. Created Quarterly Performance reports for production Databases to find out the bottle necks of performance. Created Quarterly Health check reports for production database. Upgrade database from 10G to 11G.
• Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Applying PUS patches for both RAC and Non RAC databases.
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
• Maintained the RAC set up, Performance Tuning, coding and Monitoring for Oracle Application Clusters Installed and configured Oracle Enterprise Manager to monitor the Databases. Monitoring the ASM disk groups, add and resize the disk groups. Resolving the tickets by meeting the SLA. Refresh the Database using RMAN and exports/imports
• Applied BUG patches which are caused by Ora 600 and Ora 7445.
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
• Performed switch over and fail over on Standby database.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
• Resolving the locks on the database.
• Monitoring performance using AWR reports and ADDM Reports.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
• Provide technical support and assistance to all database end-users and Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

ENVIRONMENT: HP UX, Solaris, Linux Oracle 9i, 10g, 11g, RAC, ASM, OCFS2, NetApp

Confidential

ORACLE DBA

Sprint is a wireless and wire line voice and data telecommunications company serving customers in the United States, Puerto Rico and the U.S. Virgin Islands. I was recruited as a consultant to tune the databases and the application in the environment and also provided support for both prod and non-prod databases.

Key Contributions:

• Involved in SQL tuning and refreshing statistics of database objects. Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Used Export/Import and Datapump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Performed backup validations using RMAN, Database monitoring, troubleshoot and resolve the issues.
• Oracle Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Roles, Functions for the user.
• Performance tuning of Oracle Database, applications and queries.
• Experience in testing and validating backups using Recovery Manager.
• 24x7 Production Oracle Administrations.
• Maintaining production, development test databases and applications.
• Upgraded Oracle server Database Version 8.1.7.4 to 10g 10.2.0.4 on Solaris.
• Upgraded Oracle Database 9.2.0.8 to 10g.
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• 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 and STATSPACK.
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9i.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Experience in using Flash-Back Recovery, AWR, ASM, ASH and ADDM.

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

Confidential

Graduate Engineering Trainee

Team Lease recruited me as a GET to work as an Oracle DBA to support over forty RAC and Non-RAC databases.

Key Contributions:

• Installation, maintenance and tuning of Oracle 10g, 11g, 10g RAC databases on redhat-4, IBM-AIX 5.3.
• 24x7 production support for Oracle 10g, 11g, 10g RAC databases.
• Installation and Administration of Oracle 11g RAC database.
• Configured a test database on oracle 11g RAC and experimented with load balancing.
• Installed and configured Oracle 10g RAC 2 node cluster using ASM.
• Upgrade of database from 10g to 11g on Linux, UNIX and HP Operating Systems.
• Applied patches for both versions of databases 10g and 11g successfully.
• Ensured high availability, data protection and disaster recovery using Data Guard primary and standby databases .
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Worked on export data pump/import data pump, normal import/export and SQL- loader.
• Setting up and administering Hot and Cold backups.
• Worked on ASM installation, configuration of ASM and using ASM instance.
• Configuring RMAN and Flashback Recovery.
• Utilized backup and recovery strategies using RMAN.
• Cloning of databases using RMAN, DBCA and even manually.
• Created, scheduled db maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day to day tasks.
• Extensive Performance Tuning, Memory SGA Tuning, Net backup, RAW Devices.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Analyzed database performance using AWR and ADDM.
• Analyzed query cost using tools like TKPROF, Explain plan.

• Data Modeling, Database Design and Creation using ER-Win, Visio.
• Responsible for Load balancing and Performance testing of the database servers and application servers their analysis and documentation of results.

ENVIRONMENT: Oracle 10g,11g, 10gRAC, Red hat 4,IBM AIX 5.3, Toad, PL/SQL , SQL Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM, NetApp, Erwin 4.1.2, MS Access

TECHNICAL SKILLS

• Programming skills: SQL, PL/SQL, T-SQL, UNIX Shell Scripting , C , C , Html and XML, ASP.NET, PHP, JAVA,
• Database knowledge: Oracle 9i, 10g, 11g, 12c, RAC, MS Access, File Maker
• Database Tools/Utility: ASM, RMAN, Golden Gate, OEM, Data Pump, Data Guard
• Oracle Net Configuration: Netmgr and Netca
• Performance Tuning: AWR, ADDM, EXPLAIN PLAN, Memory Advisor, Data Dictionary Views, MTTR Advisor, Segment Advisor
• Other Tools: Team Track, Magic, BMC Remedy
• Storage Technologies: EMC, NetApp, VERITAS Net Backup
• Operating System/Server: Linux, Windows, IBM AIX, Sun Solaris, HP-UX