Prasad D Email & Phone Number

Hyderabad, Telangana, India

• Involving in database level deployments.• Troubleshooting the performance related issues• Involved in database upgradation from 11g to 19c.• Provided the solutions for issues after upgradation.• Applying latest patches in 11g,12c databases.• Refresh of Development/Test databases from production backup• Creating the new databases in 11g/12c based on client requirements.• Schema level refresh based on client request.• Resolving the log gaps between Primary and Standby database.• Co-coordinating with Server team during the server reboots.• Resolving issues in RMAN backups.• Create new users, user profiles and manage privileges and monitor user access to the databases.• Decommissioning of Databases followed by default checklist requested by the client.• Performing Schema refresh using exp/imp utility and Data pump.• Closely working with Testing and DEV team to trouble shoot their Issues such as lock, privileges, tablespace issues etc.• Monitored database usage and reported on database performance and system availability.• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner.

Hyderabad, Telangana, India

Guntur, Andhra Pradesh, India

• Monitoring and Maintenance of database running on RAC and Non RAC.• Monitoring Agents, Blackout and End Blackout agents in Grid control for required DB activities.• Installed and configured Oracle Enterprise Manager to monitor the Databases.• Monitoring the ASM disk groups, add and resize the disk groups, adding disks to the Disk groups.• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups.• Created and administered both Oracle Physical /Logical standby databases.• Experienced in taking logical backups using conventional Export/Import and Data pump (EXPDP/IMPDP).• Experienced in RMAN backups (Incremental/Full) and creating Databases for standby (duplicate) databases and cloning databases.• Experienced in cloning/renaming the databases.• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.