EXPERIENCE SUMMARY:

• Sr. Oracle RAC/Apps DBA with 5.7 years of experience in this field.
• My technical skill stands on Oracle Application and Core DBA domain in UNIX/LINUX/IBM AIX environment.
• Leading a team of 4 DBA’s and managing more than 30 production servers.
• Installation of OEL/Redhat, Oracle Clusterware, and Oracle databases.
• Installation of mutli node / single dataguard.
• Upgrade of databases to 12c (12.1.0.2 RAC Database)
• Grid control installation and agent management.
• Upgrading Oracle EBS 11i to R12 (Oracle E - Business Suite)
• Analyzing existing system and planning the right path for upgrade
• Analyzing patches for upgrade and possible impact
• Upgrade downtime reduction
• Planning go-live and resource management
• Presently leading a team of 4 DBA’s.
• 12c/11g/10g RAC-Non RAC database support.
• Monitoring RAC Databases and Cluster services.
• Working on three node Dataguard and Troubleshooting DG issues.
• RMAN backups, restore and PITR recovery (Tape, Disk).
• Grid Installation and support.
• Dataguard Switchover and Failovers with DGBroker (12c/11g/10g RAC)
• Maintaining archiving, monitoring, replication, integrity and security for database and application.
• Monitoring ASM instances.
• Addition/Removal of ASM disks/diskgroups.
• RDBMS patches (One-off/CPU/PSU)
• Complete Database Health check
• Managing Tablespaces/Archives
• Taking logical backup through export/import
• Performance and Tuning.
• Oracle Streams
• Creating and designing (logical and physical) new database as per requirement.
• Large Table Partition, Indexes managing, Merging Partitions.
• OEM metrix setups, addition of new targets, hosts, databases, scheduling jobs, blackouts.
• Monthly/Quarterly application patching.
• Oracle Sysadmin Support
• Code Migration using FNDLOAD, WFLOAD
• AD Utilities (Adpatch, adadmin, adconfig, arctrl, admgrpch, adsplice etc)
• Monitoring concurrent managers.
• Working on PCP and Shared Appl TOP
• Quarterly Migration activities.
• Troubleshooting forms server, Apache server, Report server.
• Printer issues troubleshooting.
• Knowledge on ASCP collection and troubleshooting ASCP issues.
• Support for discoverer application and grid control application.
• Apache, Forms, Conc. Managers, Report Servers, Database related issues, apps login, Connectivity and TNS/Listener issues, DBLinks and Autoconfig issues.
• Compilation of Forms/ Reports/ Jsp’s/ Messages for Particular/All products.
• Cloning large database using RMAN and doing point in PITR for homogenous and heterogeneous node configuration.
• Successful recoveries
• Cloning using expdp/impdp between dissimilar platforms.
• Cloning selective data.
• Preserving selective data before cloning and restoring them after cloning.
• Monthly 4 oracle apps instances cloning.
• Usage of autoconfig and rapidclone.
• Cloning DMZ servers.
• Oracle Enterprise Manager
• Oracle Discoverer
• Oracle Application Server
• Oracle Golden Gate
• AventX support and configuration.
• Noetix support and configuration.
• Vertex patch application.

STRENGTHS:

• Flexible in Work Shifts and fast in learning.
• 24*7 On call weekly rotation.
• Good knowledge, grasping capability, sincerity, commitment and dedication.
• Self Confidence, go-getter, strong will power and determination.
• Ability to manage several assignments simultaneously and meet deadlines.
• Effective personal communication skills and a good team player.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Upgrade of Oracle Database 11g (11.2.0.3) to 12c (12.1.0.2)
• Confidential corporation has multiple RAC Databases, one being at 11.2.0.3 now upgraded to 12.1.0.2
• The target of this project was to upgrade the 1.1TB RAC instance from 11.2.0.3 to 12.1.0.2.
• The project includes 7 upgrade cycles of the pair and several cloning.
• 30+ RAC/Non RAC database Production support.
• 70+ RAC/Non RAC QA/Test database support
• Primary sketch of the upgrade process
• Pilot upgrade
• Major issue resolution with Oracle
• Development and QA upgrades
• Modification of existing cloning process
• Downtime reduction strategy implementations
• Maintenance
• Cloning both DB and Appl.
• Patching both DB and Appl.
• Code migrations
• Alert Management and Monitoring
• Running rda, raccheck, awr, ash, addm reports for oracle SR.
• Doing health check on all database and applications.
• Code Migrations
• User setup
• Alert monitoring and correction
• RDBMS cloning using RMAN.
• RDBMS software cloning using OUI, Rapid Clone.
• EBS software cloning using Rapid Clone and Autoconfig.
• RDBMS patching.
• EBS patching, forms patching

Confidential

Responsibilities:

• 11g / 10g RAC - Non RAC database and application support.
• Cloning Database and application as per requirement.
• Performance tuning via OEM
• PSU-CPU-One off Patching.

Confidential

Responsibilities:

• Attending regular calls for planning, reporting and preparation with customer.
• Coordinating with third parties such as storage team, unix team, oracle support group, third party software vendor for compatibility issues with their software and the new database.
• Execution of the technical work.
• Detailed documentation of the upgrade process with team.
• Assessment and documentation of the changes required in existing procedures due to the upgrade. (Changes required in Oracle EBS due to this upgrade)
• Performing stress testing using Real Application Testing to ensure the upgrade is not negatively impactful to business.
• Measuring user end jobs timing to ensure there are no negative impacts compared to present performance.
• Resolution of issues caused by upgrade through SR or by performance tuning. (One off patches, hidden parameters)
• Execution of the go live.

Confidential

Responsibilities:

• Maintenance
• Cloning both DB and Appl.
• Patching both DB and Appl.
• Code migrations
• Alert Management and Monitoring
• Running rda, raccheck, awr, ash, addm reports for oracle SR.
• Stopping and Starting middleware seevices and troubleshooting application related issues.
• Doing health check on all database and applications.
• Code Migrations
• User setup
• Alert monitoring and correction
• RDBMS cloning using RMAN.
• RDBMS software cloning using OUI, Rapid Clone.
• EBS software cloning using Rapid Clone and Autoconfig.
• RDBMS patching.
• EBS patching, forms patching.
• Performance Tuning.