M. Nandan Varma

• Created Servers on OCI.
• created volumes and attahced the file systems in OCI
• Involved network configuration in oCI(ingress and egress rules)
• applied the DB CPU patches at OCI level
• Performing database refresh and apps refresh as and when required.
• Creating the users and assigning the responsibilities at applications level.
• Resolving Concurrent Manager issues
• Provide the technical assistance to the developers
• Resolved db Connectivity issues using Toad and sql developer utilities.
• Resolved several application services Start-up and shutting down issues
• Creation of application user accounts and assigning the responsibilities

• Delivered 24/7 production support while troubleshooting incidents across environments.
• Executed instance cloning aligned with project specifications for streamlined deployments.
• Oversaw incident and change control management through ServiceNow for improved workflow.
• Implemented Oracle Application patches using adpatch and ADOP to maintain system functionality.
• Identified, analyzed, and applied CPU/PSU patches to enhance system performance.
• Guided new team members by providing mentorship on priorities and issue resolution.
• Engaged with Oracle support to address database and application challenges effectively.
• Ensured compliance with security protocols in password management and access control.

• Supported RAC administration with ASM through patching, cloning, and troubleshooting tasks.
• Upgraded EBS database from 11.2.0.3 to 19c, ensuring improved performance.
• Installed multiple RAC database versions: 11g, 12c, and 19c.
• Oversaw production databases with OEM 12c for comprehensive management.
• Cloned Applications R12.1 and R12.2 across multiple environments including PROD to TEST and DEV.
• Managed routine maintenance activities, encompassing patching and cloning processes.
• Executed schema refreshes using expdp and impdp methods efficiently.
• Facilitated addition of disks to existing disk groups for enhanced performance.

• Implemented 24/7 production support and troubleshooting for incidents across multiple environments.
• Oversaw daily management of business databases to ensure optimal performance.
• Conducted regular monitoring of OEM12c for alerts related to blocking sessions and resource utilization.
• Handled patching, cloning, and scheduled maintenance for PATCH, DEV, UAT, and PROD instances.
• Utilized diverse methodologies for instance cloning based on specific client requirements.
• Monitored and addressed issues with tablespace space, locking sessions, and extended concurrent jobs.
• Resolved database locks by effectively managing blocking sessions.
• Ensured compliance with SLAs regarding ticket response and resolution times.