SUMMARY

• An Oracle DBA with 12 years of IT experience in Oracle ( 8i, 9i, 10g, 11g) 10g/11g RAC, Streams, Golden Gate, Data guard, designing, installing, administering, upgrades and migrations, backup, recovery, performance tuning, deployment, customization and daily maintenance etc.
• Spanning in to domain like banking and health care. In variety of operating systems like UNIX (Solaris), LINUX in production as well as development environments of Very Large Databases (VLDB).
• A highly motivated and ambitious individual possessing excellent management skills and having ability to work with minimum of supervision.
• Having a proven ability to lead by maintain client/customer relationships by providing timely, superior quality products and services.
• Willingness to learn new technologies and ability to learn quickly.
• Oracle DBA - Experience in 24/7 on-call support.
• Extensive experience in implementation, maintenance, installation, administration of Oracle databases 11g/10g/9i/8i across various operating systems.
• Experience in DBA daily activities including schema and user management, space management and monitoring.
• Expertise in creating Oracle Objects, Table Partitions, Views and Materialized Views.Hands on experience in Upgrading and migrating databases to higher versions, applying patches and patch sets (CPU’s/PSU's).
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Datapump. Expertise in analyzing Statspack, SQL trace, TKPROF and explain plan.Extensively used AWR, ADDM and SQL Tuning Advisor.
• RAC & ASM - Installed Oracle 10g/11g RAC software with ASM & OCFS2 File systems. Good experience in 11g R2 grid infrastructure.Excellent experience in configuring and tuning of RAC, CRS and ASM for high availability of data bases and load balancing. Skilled in dealing with Managing & Maintenance of ASM Disk groups. Installation & maintenance of Database Administration in RAC and ASM environment.
• Standby (Data Guard), Streams and Golden Gate- Hands on experience in administering Data Guard, Streams and Golden Gate.
• OEM - Solid experience in Oracle Enterprise Manager (OEM), Grid Control. Installed and upgraded 10g/11g/12c OEM agents and fixes, configured targets in grid. Trouble shooting targets status on grid console and agent side and setting up blackouts for agents.
• Performance Tuning - Experienced in Database, SQL Tuning

TECHNICAL SKILLS

Operating Systems: SUN Solaris 5.10/5.9/5.8/5.6/2.6, Red Hat Enterprise Linux 5/6

RDBMS: Oracle 11g(11.2.0.3) / Oracle10g R2(10.2.0.5) with RAC/ASM, Oracle10gr1 (10.1.0.2.0 ), Oracle 9i v9.2.0.7, Oracle 8i v 8.1.7/8.1.6/8.1.5.

GUIs & Languages: Oracle 10g/9i Client, TOAD, SQL*PLUS, VERITAS Net Backup, Quality Central.

Others: Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM GRID Control, AWR,ADDM, TKPROF, Toad.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Oracle Golden Gate Expert & DBA

Responsibilities:

• Responsible for RAC 10g/11g/12c database, client installation Software for 9i, 10g and 11g /12c Enterprise Edition.
• RAC Database and SQL tuning
• Database Capacity Planning
• 10g/11g/12c RAC Database Up-gradations.
• Apply CPU, DST, RDBMS patches to RAC Databases as per the requirement.
• Supporting OS Patching activity for all RAC Servers.
• Migrate RAC databases across Database servers.
• Create databases for development, testing and production (including RAC databases and NON-RAC databases).
• Perform refreshes from RAC to RAC and non-RAC database to a RAC environment.
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and manage RMAN backup.
• Performed Golden Gate installation 11.2.1.0.18/ 11.2.1.0.31 / 12.1.2.1.0 & 12.1.2.1.10
• Performed Golden Gate upgrades from Version 11.2.1.0.18 to 11.2.1.0.31
• Performed Golden Gate upgrades from Version 12.1.2.1.0 to 12.1.2.1.10
• Performed Golden Gate configuration changes to Manager / EXTRACT and REPLICAT.
• Troubleshooting Golden Gate EXTRACT and REPLICAT issues
• 24*7 production Support for mission critical production systems
• Monitoring space, wait events, locks and long operations in the database
• Environment: Oracle 11g, RAC, Golden Gate, HP quality center, ASM, AWR, EXP/IMP, Data pump, Data Guard, Golden Gate, TOAD, SQL Trace/ TKPROF, PL/SQL, Shell Scripting, cron jobs.

Confidential - Providence, Rhode Island

Oracle Lead Database Admin

Responsibilities:

• 10g/11g RAC Database Up-gradations.
• Responsible for RAC 10g/11g database, client installation Software for 9i, 10g and 11g Enterprise Edition.
• RAC Database and SQL tuning
• Database Capacity Planning
• Apply CPU, DST, RDBMS patches to RAC Databases as per the requirement.
• Supporting OS Patching activity for all RAC Servers.
• Create databases for development, testing and production (including RAC databases and NON-RAC databases).
• Perform refreshes from RAC to RAC and non-RAC database to a RAC environment.
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and manage RMAN backup.
• Clone RAC databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• Implemented Disaster Recovery Plan.
• Basic Administration of Data guard database.
• Supported SAN Migrations: Moved ASM disk groups from one server to other server.
• Breaking up RAC for few instances.
• Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
• Used Oracle 12c grid control and installed, upgraded and troubleshoot OEM agents.

Environment: \Tools: RAC/ASM, Oracle 10g,11g, Oracle Enterprise Manager 10g/12c Grid Control, Putty, RH Linux 5.2/6.2, VERITAS Net Backup, BLIB, BC and RMAN

Confidential

Project Lead

Responsibilities:

• Responsible for RAC 10g/11g database, client installation Software for 9i, 10g and 11g Enterprise Edition.
• RAC Database and SQL tuning
• Database Capacity Planning
• 10g/11g RAC Database Up-gradations.
• Apply CPU, DST, RDBMS patches to RAC Databases as per the requirement.
• Supporting OS Patching activity for all RAC Servers.
• Migrate RAC databases across Database servers.
• Create databases for development, testing and production (including RAC databases and NON-RAC databases).
• Perform refreshes from RAC to RAC and non-RAC database to a RAC environment.
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and manage RMAN backup.
• Clone RAC databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• Implemented Disaster Recovery Plan.
• Basic Administration of Data guard database.
• RAC Instance migration from one server to other server using Quality Center Tool.
• As part of maintenance activity changed few OCFS2 parameters.
• On RAC systems did CRS upgrade,ASM upgrade, DB Upgrade and OEM Agent Upgrade.
• Supported server upgrades.
• Supported SAN Migrations: Moved ASM disk groups from one server to other server.
• Breaking up RAC for few instances.
• Added new clusters to the existing clusters ( Added 4 nodes to the existing 3 node cluster )
• Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
• Used Oracle 12c grid control and installed, upgraded and troubleshoot OEM agents.

Environment: \Tools: RAC/ASM, Oracle 10g,11g, Oracle Enterprise Manager 10g/12c Grid Control, Putty, RH Linux 5.2/6.2, VERITAS Net Backup, BLIB, BC and RMAN

Confidential

Sr. Analyst Admin

Responsibilities:

• Oracle 11gR2 RAC BUILD.
• Oracle ASM Instance Creation and Configuration 11gR2.
• Oracle RAC Database Creation 11gR2.
• Oracle RAC Database Home Software Installation.
• Interaction with Prod Support/Application teams on for daily application to database adherence.
• Oracle User, Roles, Profiles Administration.
• Oracle database admin to standalone & clustered (RAC & VCS) instances both ASM/non ASM.
• Refreshed jobs, maintenance jobs scheduled through Autosys. Adhoc User issues.
• Applied CPU, One-Off and Bug Patches to databases.
• Database Creation(s), Binaries Installations and Build Activities.
• Autosys Scheduler, Monitoring/Performance reports analysis and app adherence.
• RMAN setup and issues while routine maintenance.
• Extensive Performance tuning.
• Oracle Golden Gate Administration and handling the routine issues.
• Oracle Streams Administration.
• Backup Job Setup, APEX installation and Maintenance/Administration.
• Handled Performance issues, analyzing the AWR, Performance/Trending reports. Historic data performance analysis.
• Worked with Oracle Corporation on Service Request.
• Automation as required and Documentation as deemed.

Environment: \Tools: Oracle 9i,10g,11g, Oracle Enterprise Manager 10g Grid Control, TOAD 9.1, SQL*Net8 TKPROF, Putty, Linux 2.6.9, Sun Solaris 5.10, VERITAS Net Backup, BC and RMAN

Confidential

Sr Oracle DBA

Responsibilities:

• Interacted with several teams like Web services, application, System-Admins and Documenting the steps involved and rolling out the action plan.
• Responsible for database, client installation Software for 9i & 10g Enterprise Edition.
• Database Capacity Planning.
• Up-gradation of 9i database to 10g using DBUA.
• Apply CPU, DST, RDBMS patches as per the requirement.
• Migrated databases across Database servers (Non-RAC to RAC and RAC to RAC).
• Rename of database using NID.
• Created databases for development, testing and production (including RAC databases and NON-RAC databases).
• Performed refreshes from non-RAC database to a RAC environment.
• Worked on a Project to upgrade several GEHC 9i Databases to 10g on Linux.
• Security Administration including the management of profiles, roles, users and their privileges.
• Worked on DBA tools viz...10g Grid, Quest Central, HP QualityCenter, Appworx and NGS Squirrel.
• Configured and managed RMAN backup using GRID.
• Cloned databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• Implemented Partitioning on OLAP system.
• Object/Schema level re-org whenever the fragmentation is found.
• Implemented Disaster Recovery Plan.
• Added/configured the database for database monitoring in Grid.
• Worked on Restore and Recover of databases.
• Basic Administration of Data guard database.
• Experience in opening, managing, and resolving Oracle Service Requests.
• Developed UNIX shell scripts to carry out routine checks on databases.
• Administrate RAC service with SRVCTL.
• Managed the Cluster Services in case of any abnormal failures.
• Instanced migration from one server to other server using QualityCenter Tool.
• Implemented Critical Patch Updates which Oracle provides for each server.
• Converted table spaces from Non-ASSM to ASSM.
• As part of maintenance activity changed few OCFS2 parameters.
• Cloned RDBMS homes from one server to other server.
• On RAC systems did CRS upgrade,ASM upgrade, DB Upgrade and OEM Agent Upgrade.
• Supported server upgrades.
• Supported SAN Migrations: Moved ASM disk groups from one server to other server.
• Broke up RAC for few instances.
• Added new clusters to the existing clusters ( Added 4 nodes to the existing 3 node cluster )
• Cloned from cluster database to Normal database and Cloning from Normal database to cluster database.
• Performed number of Media recoveries, tablespace and datafiles recovery and point in time recoveries.
• Automated several routine DBA tasks and scheduled these jobs in CRON and other scheduling tools like Appworx, 10g Grid Control.
• Created monitoring base line templates in Oracle 10g Grid based on different thresholds as per the database requirements
• Created Backup jobs in OEM Grid for databases.
• Documented the SOP and capture the evidences during Change control in Production databases and Validated Systems.
• Customized Gather stats of as per requirement on for objects statistics (performance tuning) using DBMS STAT for Siebel application and other applications like Agile, Generix, SA, Self Service Portal, SOAF, Magic, Orion, are few to name.
• Implemented Histograms.
• Analyze objects periodically to optimize the SQL queries on a pro-active measure and take necessary tuning recommendations.
• Primary responsibility for SQL Query tuning of SIEBEL application.
• Interacted with the load testing team and creating Load test reports, generation of AWR reports/ADDM reports.
• Accountable for the analysis of AWR/Stats Pack, ADDM reports.
• Analysis of Query tuning from TKPROF and Explain Plan.
• Memory tuning for the database(s) based on the type of the application which database hosts.
• Optimized SGA and Disk I/O using Oracle Enterprise Manager and by monitoring the statspack report generated from snapshots taken Confidential the peak business hours.
• Responsible for Analysis of Instance level tuning followed by recommendations.
• Responsible for shared pool tuning saving production systems 20% in parse overhead.
• Responsible for sql tuning reducing the production system data load run time from 8hrs to 20mins.
• Responsible for database level and sql tuning that reduced the production system load run time from 6 hrs to 17mins.
• Responsible forKronos application performance improvement. Database and sql tuning helped to resolve the issue.
• Created the partitions on tables and indexes for managing large tables.
• Created Customized Shell Scripts for database performance monitoring like cache hit/miss on different SGA components.

Environment: \Tools: Oracle 9i,10g Oracle Enterprise Manager 10g Grid Control, TOAD 9.1TKPROF, Exceed, Shell secure, Putty, Linux 2.6.9, Sun Solaris 5.10.