SUMMARY:

• Over 13 years of IT experience working on Oracle Database in Production Support, Application support.
• Oracle Certified Professional 11g.
• Exposure to Goldengate, Configuring extract Manager & replicate process.
• Expert in Oracle 11g, 10g, Oracle 9i and SQL server.
• Experience working on Oracle 12c, 12C OEM, 11gR2, 10g RAC, ASM & Data Guard, RMAN.
• Build, configure and maintained Oracle Databases.
• Extensively worked on Oracle 10g and 11g production support activities in HA environment.
• Experience in Oracle Server Installation, Database Configuration, Troubleshooting on HP UX, Solaris, Aix, Linux.
• Experience in implementing and maintaining Database Security Guidelines.
• Experience in designing and implementing Backup and recovery Strategies. Experience in administering tasks like monitoring, error checking and running health checkup.
• Expert in performing Database Backup and Recovery, Database cloning using RMAN, Database Creation/Migration/Upgrade, Export/Import data, Storage allocation, Database Reorg, Database and SQL Tuning, Capacity Planning, Managing Users, and Creation of physical database objects from logical model.
• Experience in Planning Database, Sizing table space, create database, scripts, Monitor databases, interact with developers, Oracle Install, Upgrade, 24x7 DBA support, Disaster recovery Automate daily jobs, Schema management, SQL loader, Export/import Database, Tune database.
• Experience in Configuration of RMAN.
• Exposure to Oracle Utilities and Tools like OEM, Import - Export, DBCA, RMAN, Netapp.
• Experience and exposure to Oracle features like Partitions, Materialized views, Indexes.
• Experience in handling large databases (size in TB) and also large number of databases in multi OS environments & OLTP, DSS.
• Experience in migrating databases on cross platform.
• Experience in Leading US and global project for Database Administration in banking and telecom domain. Coordinating with Support Managers in US and UK being a global team member.
• Documenting the processes.
• Worked extensively on Remedy, GSD as ticketing system to accept user/client ticketing requests as well as on “Tivoli” monitoring system according to the ITIL standards.
• Experience in Performance Tuning databases using various techniques. Collected performance statistics memory usage, data storage, data manipulation, physical / logical storage, network traffic and implement / manage parallelism for optimum performance using Explain Plan, SQL Trace, AWR & ADDM.
• Experience in monitoring and supporting RAC databases, ASM, CRS patching.
• Writing sql and plsql objects like tables, stored procedures, functions, packages, triggers,etc.

TECHNICAL SKILLS:

RDBMS: Oracle 12C, 11gr2, 10g, Oracle 9i, Oracle Goldengate

Operating Systems: Sun Solaris 8/9, Aix, HP UNIX, Linux.

Languages: SQL and Exposure to Shell Scripting.

Tools: Toad, SQL*plus, OEM, Addm, Awr, Statspack, RMAN, SQL*Loader, Goldengate, Remedy, ERWIN, Control M, Patrol, NDM - connect direct.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Support OSM, ASAP and UIM database operations.
• Monitoring database health and provide recommendations.
• Performance tuning of database, plan baselining based on different situation.
• Understand existing systems and client processes and help operations team in critical changes during after hours .
• Database backup configurations, 10g,11g and 12c (CDB and PDB) DBA support.
• Trouble shooting the runtime issues and helping development teams for better performance of their changes.
• Raising /follow up on platinum SR with oracle support for issues during oracle hexadata database support.
• DBA level performance tuning, monitoring plan changes and usin SPM to fix plan change.
• Used AWR, explain plan for performance related issues.
• Support oracle real application cluster and data guard.
• Refresh of production data to preprod environments using export/Import & RMAN.
• Ensuring regular hot backups & archive backups.
• Understand, modify automations in shell script.
• Support and Rebuild physical and logical standby databases as per requirement.
• Prepare Method of Process (MOP) and get approvals on same from CAB (Change management).

Environment: Oracle 10g, 11g, 12c, 12C OEM, GoldenGate Solaris, linux, Unix, netapp, Shell scripting

Confidential, San Jose, CA

Senior Oracle DBA

Responsibilities:

• Work in Staff augmentation mode.
• Understand existing systems and client processes.
• Database build and environment readiness activities and process documentation.
• Data guard set up and process documentation.
• Database backup configurations, 10g,11g and 12c (CDB and PDB) DBA support.
• Using data guard provides possibilities to minimize the time of migration and down time of the system.
• POC and scoping for offshore-onsite support model in IS area.
• Trouble shooting the runtime issues.
• Raising /follow up on SR with oracle support for issues during database support.
• Configured Goldengate unidirectional topology for Dangerous Goods database.
• Configure Oracle Goldengate processes like Manager, Extarct & Replicat.
• Monitoring Goldengate, verifying lag & taking remedial actions
• DBA level performance tuning.
• Used AWR, explain plan for performance related issues.
• Patching and upgrade in different environment as per requirement.
• Support oracle real application cluster.
• Implementing backup policies using RMAN.
• Refresh of production data to Dev/QA environments using export/Import & RMAN.
• Ensuring regular hot backups & archive backups.
• Understand, modify automations in shell script.
• Support and Rebuild physical and logical standby databases as per requirement.
• Prepare Change Requirement Form (CRF) and get approvals on same from CAB (Change management).
• Prepare SPP (Service Protection Plan) planning and fulfill support requirements for smooth SPP.

Environment: Oracle 10g, 11g, 12c, 12C OEM, GoldenGate Solaris, linux, Unix, netapp, Shell scripting

Confidential

Senior Oracle DBA

Responsibilities:

• Represent DBA and support DB changes in CAB (Change Authorization Board).
• Analyze, estimate and providing approvals for DBA changes in Change control board.
• DBA level performance tunning.
• Specially Hired for Olympic 2012.
• Used AWR, explain plan for performance related issues.
• Coordinating offshore team for offshore team building and establishing support capability.
• Patching and upgrade in different environment as per requirement.
• Support oracle (RAC) and veritas (VCS) clusters.
• Support and Rebuild physical and logical standby databases as per requirement.
• Prepare Change Requirement Form (CRF) and get approvals on same from CAB (Change Authorization Board).
• Prepare SPP planning and fulfill support requirements for smooth SPP.
• Open and follow up on Service Request with the Oracle.
• Implementing backup policies using netapp backup scripts.
• Refresh of production data to Dev/QA environments using export/Import, cold backups.
• Ensuring successful execution of regular hot backups backups.
• Sizing tablespace and undo segments.
• Understand, modify automations in shell scripts & pearl script
• Planning and scheduling backup and recovery procedures.
• Monitor all Ref and Live environment databases.
• Monitoring & automation of rebuilding the indexes at regular intervals for better performance.
• Automation of day to day tasks & scheduling jobs.
• Security Management by allocating proper privileges.
• Timely creating/rebuilding indexes, analyzing the schemas/objects.
• Sql Server database general support and maintenance.

Environment: Oracle 10g, 11g, 12c OEM, Solaris, Unix, netapp, RAC, VCS, Dataguard, Shell script, pearl script

Confidential, Salinas, CA

Senior Oracle DBA

Responsibilities:

• Analyze risk and finalize approach for upgrade/migration of Confidential application database from Current version 9.2.0.* to 11.2.0.3.
• Understand existing systems and client processes.
• Study of different (in place and out place) migration/up-gradation approaches and support during live upgrade.
• Use Recovery Manager for database backup and restore.
• Minimize the time of migration and down time of the system.
• Installation and patching of 11g R2 with the client defined processes and up-gradation of databases.
• Trouble shooting the runtime issues during upgrade and migration.
• Raising /follow up on SR with oracle support for issues faced during upgrade and migration.

Environment: Oracle 8i, 9i, 10g, 11g, RAC, Dataguard, solaris, Unix, HP UX

Confidential, Salinas, CA

Oracle DBA

Responsibilities:

• Providing 24*7 technical support to maintain around 12 production database environments.
• Providing on-call support for critical issues on a rotational basis.
• Data warehouse DBA support.
• Handled planned/ Un-planned outages on production database servers.
• Leading offshore DBA team.
• ASM instance installation & configuration.
• Support in Disaster recovery activities.
• Refresh of production data to QA environments.
• Used AWR for performance related issues.
• Ensuring regular hot backups & archive backups.
• Used RMAN for database backups.
• Space management and capacity planning for future requirements.
• Sizing tablespace and undo segments.
• Used Oracle Export & Import utilities to upgrade and copy database.
• Planning and scheduling backup and recovery procedures.
• Monitor all development / testing / Production databases.
• Monitoring & automation of rebuilding the indexes at regular intervals for better performance.
• Alert logs monitoring using grid control.
• Tuning of SQL statements and performance tuning.
• Automation of day to day tasks using shell and pearl scripts.

Environment: IBM - AIX, ORACLE, SAS, data warehouse, Control M, Patrol, NDM - Connect Direct, Shell & perl script

Confidential

Oracle DBA

Responsibilities:

• Oracle sql and plsql development on Unix.
• Creating database objects as stored procedure, functions, triggers etc.
• Handled planned/ Un-planned outages of production servers and maintained different jobs.
• Involved in database design & data modeling activities.
• Writing different packages for data mapping as per business/user request.
• Automation of different business activities using shell script and plsql objects.
• Routine crosschecking of the job failure tickets & taking corrective actions.
• Facilitate junior team members in resolving tickets in GSD.
• Performance tuning of sql and plsql objects.
• Prepare and review the action plans for performing scheduled activities.
• Space management of data files and table spaces.
• Performed user creation with defined roles and profile.
• Resolve day to day user requests like archival error, space issues, etc.
• Perform change for changing any database parameters.
• Handled undo management issues.

Environment: UNIX, Oracle 10g & 11g, ERWIN, Team forge - SVN.