Anurag Ranjan

• I have configured the Goldengate for homogeneous and heterogeneous.
• Expertise on Oracle Real Application Cluster Administration (RAC) 10g, 11g, 11gR2,12c and 19c.
• I have installed and configured Oracle RAC and Oracle data guard setups across Linux.
• Expertise on Oracle data guard technology (physical Standby) on 10g, 11g, 11gR2,12c and 19c
• Expertise on database migration. (from Linux to Linux and Unix to Linux)
• Basic understanding of Oracle cloud infrastructure.
• Configured network architecture (VCN, Subnet, IG, Service Gateways, NSG, Route table, Security rules etc) for new environment in OCI cloud.
• Administration of Oracle Database, Compute instances, Oracle Integration cloud and other activities like backup policies, Configuring RMAN Backup, user, role, and policy creation in OCI.
• Expertise on Oracle Automatic storage management
• Expertise skill with oracle utilities like export, import, nid.
• Database creation, patching, upgrade, and migration
• Bulk loads and data migrations (imp/exp and datapump)
• Worked on DR scenario (database switchover and switchback)
• Shell Scripting at basic Level
• End to end planning and execution of Exadata Bundle patching and Exadata OS image upgrade.
• Experience In sql and Plsql Performance Tuning
• Having hands on experience with Oracle Exadata database machines X2-2/X4/X5/X6 versions.
• Working with Oracle Support for different H/W issue on Exadata
• Key strengths - Sharp communication skill, Analytical Skills, Commitment, Ability to learn on the job and Flexibility.
• Have an experience of performance tuning of sql/plsql .

• Perform File Copy / RMAN cloning of databases

• Object Management - creation and maintenance of table partitions, materialized view, indexes.

• Monitoring disk space utilization, tablespace utilization, and database.

• Perform Performance Tuning on long running Queries.

• Oracle 10g, 11g,12c Database Installation, Configuration, Troubleshooting, Administration

• 10g/11g ASM/RAC/CRS, Data-guard, OEM-12c Cloud Control implementation/ configuration.

• Backup and Recovery strategy planning, Security Enhancement and auditing measures.

• Implementation of AUD$ partition on Oracle RDBMS 10g, 11g.