• Good exposure in Oracle Architecture including physical and logical structures in 24/7 support.
• Installing RDBMS software for standalone and RAC environment.
• Hands on experience on configuring OEM 12c.
• Worked on Grid Infrastructure installation and administering ASM disk groups and volumes.
• Installing 12.1.0.2 RAC installation and Good knowledge on 12c New Features and currently leading 12c upgradation project.
• Experience on Upgradation from 11gr2 to 12c with manual and DBUA method.
• Experience on Cloning from 11.2.0.3 to 11.2.0.4 on different server and same server.
• Experience on Golden Gate Configuration and Implementation.
• Performed Backup and Recovery using RMAN including level 0, level 1 and full backups and prepared scripts for the RMAN.
• Logical Backup of databases using Import/Export and Data Pump.
• User managed Backup and Recovery (Cold & Hot).
• Good Exposure in Configuration, Maintenance and Administration of Standby databases.
• Performed Schema, Table and table partition refresh.
• Adding targets to OEM cloud control by installing Oracle agents in windows, linux environments.
• Performed Database Cloning using duplicate command without backup.
• Experience in applying database Patches (PSU) and Patch sets.
• Worked on automatic Refresh Script to refresh the database from production every day.
• Worked on Performance Tuning using utilities like AWR, ADDM and ASH and SQL tuning advisory.
• Database objects rebuilding for improving the query performance and to recover the DB space.
• Deploying and operating AWS specifically VPC, EC2, EBS, IAM, ELB, Cloud Formation and Cloud Watch using AWS Console.
• Experience on RDS service in AWS.
• Excellent communication and interpersonal skills. Ability to work efficiently as a part of the team and individually and the ability to get work done with other support teams.