Sandeep Kumar Avasarala Email and Phone Number

• Supporting pool of customers as Primary DBA and handling a shift. • Supporting the development and testing team during implementation of the project and on all DBA related issues.• Worked on multiple upgrade projects from R12.1.3 to R12.2.7 & 11.2.0.4 to 12.1.0.2. • Working on different technologies like EBS Applications, OBIEE, DEMANTRA, OTM, Goldengate, etc., • Maintenance activities like patching, cloning, Code Migrations & Deployments on R12.2, R12.1 & Weblogic environment. • Documenting all the installation, upgrade projects & server build activities. • Performed performance tuning and improved query response time.• Worked on Disaster Recovery activities for multiple customers.• Implemented SSO on Oracle EBS 12.2.5 environment.• Working on user tickets which have been raised by Service now tool and managing service requests raised for Oracle.• Supporting functional & technical team during implementation of the project and on all DBA related issues.

• Upgraded database from 11g to 12c.• Implementation of EBS and upgrading from 12.1.3 to 12.2.5.• Supporting the development and testing team during implementation of the project and on all DBA related issues.• Upgraded JRE on client request for Oracle EBS R12.1 & 12.2.• Maintenance activities like patching, cloning, Code Migrations & Deployments on R12.2, R12.1 and Weblogic environment. • Working on user tickets and managing service requests raised for Oracle.• Cloning R12.2 Instances for Test and Development purpose using Rapid Clone.• Weblogic administration and deployments.• Coordinating with Oracle Technical Support (Meta-link) for SRs we raised.• Being an active team member coordinating with onsite/offshore DBA/Developers for smooth operation.

Implementation and support ERP Application, Database.Versatile multiple DB skills as DBA and E-Business Suite Administrator with exposure to production support, implementation and consulting operations.Excellent exposure to all latest E-Business Suite technologies like R12.1 & R12.2. Excellent knowledge of Oracle R12.1 & R12.2 architecture and administration, good understanding of new features.Involved in Application Upgrade from R12.1.3 to R12.2.3.Good working experience on ASCP, Weblogic & Demantra.Good experience in Backup and recovery using Cold, Hot and RMAN.

Implementation and Technical Support for the ERP Application, Database.Cloning, Rapid Clone, Manual Clone consists of Single-Node, RAC-Node, Hot Cloning, RMAN- Cloning.Backup and Recovery: COLD, HOT, RMAN Backup Managed hot & cold backups of databases using custom shell scripts.Patching, Application, Database, Patch Analysis, Applying Critical Patch Updates single node, Multi-Node RACRaising and monitoring critical SR’s Oracle applications front End Support, Profiles, Responsibility, Concurrent Programs Printers, Monitoring Concurrent requests, setting up trace and troubleshooting, Create users, groups and directory structures with appropriate permissions.Recovering lost/deleted records from a table using utilities like EXP/IMP, LOGMINER, and RMAN Backups.