IdentityInstallation and maintenance of Oracle Databases (10g/11g/12c).
Creating shell/RMAN script and scheduling them using Crontab.
Backup and recovery using RMAN.
Recovery Catalog Creation and Maintenance.
Clone Production instance for Test, Development, UAT and QA using RMAN/User managed/Cold Backup.
Upgraded Oracle Database 10.2.0.1 to 11.2.0.4 using DBUA/Manual method.
Applied One-Off Patch/ CPU/PSU/Patchset on Test and Production system.
Using Export/Import (and Data pump), SQL*Loader.
Creating and maintenance of physical/logical/snapshot standby databases.
Performed switchover, failover(with and without broker) and Fast Start Fail Over of standby databases.
Backup and recovery in Data Guard environment
Rolling forward a standby database using RMAN Incremental Backup
Configured cascaded standby database.
Performed rolling upgrade using existing physical standby database.
Configured automatic client failover in data guard environment
Installation of Oracle RAC Database and Oracle Clusterware.
Administering Oracle Clusterware using crsctl, srvctl, ocrconfig, ocrdump
Adding/deleting nodes in existing Oracle RAC Cluster
Applying PSU to Oracle GI & Oracle RAC DB
Upgraded Oracle GI & Oracle RAC DB from 11.2.0.3 to 11.2.0.4 & 11.2.0.4 to 12.1.0.2
Optimize Oracle resource utilization by tuning queries, recommending indexes, and configuring database instance parameters
Removal of Row Chaining and Migration.
Performance measurement using AWR/ADDM/ASH/Statspack/explain plan/Tkprof
