Srinivasu Nalla

· Support and maintenance of Gilead-Kite Production EBS & ASCP Applications and third party tools like Flex deploy tool ,CCG & AACG in 24*7 Environment

· Regular Day-to-Day activities like Production Health Checks, Working on SNOW tickets, Issues raised by end users & DEV teams.

· Performed 2021 APR CPU Patching of Apps( 12.2.8 Tech Stack with AD Patches) & Databases (12.1.02 Proactive BP)

· Involved in DR Drill of EBS & ASCP systems

· Clones/Refreshes/Env Builds of 12.2.8 instances with SSL, DMZ, SSO & TLS Configurations.

· Performed High Availability of EBS with Zero downtime during Server Vulnerability Patching

· Worked on Password rotation of EBS & ASCP environments as part of SOX Compliance.

· Worked on JAR Signing , TLS Setups with Renewal of Certs by working with Security team .

· Configured and Implemented Cold/Hot Backups using NetApp Flex clone for new Critical Environments

· Troubleshooting & fixing MSCA Login failure like Account Lock & Authentication failed

Developed Monitoring Scripts for MWA (Authentication ,Process ) and for Collecting & finding the difference between PROD and UAT systems

· Support and maintenance of Gilead-Kite Production EBS & ASCP Applications and third party tools like Flex deploy tool ,CCG & AACG in 24*7 Environment

· Regular Day-to-Day activities like Production Health Checks, Working on SNOW tickets, Issues raised by end users & DEV teams.

· Performed 2021 APR CPU Patching of Apps( 12.2.8 Tech Stack with AD Patches) & Databases (12.1.02 Proactive BP)

· Involved in DR Drill of EBS & ASCP systems

· Clones/Refreshes/Env Builds of 12.2.8 instances with SSL, DMZ, SSO & TLS Configurations.

· Performed High Availability of EBS with Zero downtime during Server Vulnerability Patching

· Worked on Password rotation of EBS & ASCP environments as part of SOX Compliance.

· Worked on JAR Signing , TLS Setups with Renewal of Certs by working with Security team .

· Configured and Implemented Cold/Hot Backups using NetApp Flex clone for new Critical Environments

· Troubleshooting & fixing MSCA Login failure like Account Lock & Authentication failed

Developed Monitoring Scripts for MWA (Authentication ,Process ) and for Collecting & finding the difference between PROD and UAT systems

· Support of Oracle LSH (EBS R12.1.3) with DP Server and third party tools like GPS,WDCS configuration for Novartis Pharma AG

• Oracle EBS R12.1.3 Maintenance and Support of 3 node RAC DB (12c and 11g) and Multi node (3 Node) Application Tier for IRONMOUNTAIN Inc

· Supporting Functional Team and Technical Team to execute their daily and scheduled activities like Month end financial close and other enhancements.

• Supporting Oracle System administration activities like SSO User sync, Responsibilities, Workflow issues etc.,

• Supporting SSO User access related issues, Performance of Database and Application like Concurrent jobs and DB sessions.

• Regular Day-to-Day activities like Cloning, Patching, and Performance related issues.

• Providing 24/7 On call DBA Support for 300 + Production Instances for Sev1/Sev2 issues

• Proactive Monitoring of issues related to Databases through Custom Dashboard (based on OEM)

• Solid exposure to OEM to get Performance data/Metrics/Agents.

• Monitoring the Critical Pages whenever thresholds are reached.

• Extensively worked with Oracle Support through SR on fixing highly critical & business impacting issues

• Good Experience on oracle Application 12.2 and WebLogic Administration

• Starting, stopping managed servers, admin servers as per the monitoring status.

• Strong knowledge on R12.2 online Patching

• Fixing failures for Weekend Cold & Hot backup issues and daily RMAN Backups

• Supporting Month-end, Quarter-end, Yearend and release activities for Cisco

• Data Guard Lag issue/Block corruptions/RMAN incremental backups & Database backups and recovery using RMAN.

• Full / Partial Table space Restoration

• Troubleshooting Performance issue – Such as Trace enabling, Detect and resolve Lock / Waiting Session, High Server Load issue on Linux Servers, Analyze and Compiling Objects

• Experience in preparing the technical documents related to the issues faced.

• Providing the regular updates to the managements if any technical issues.

· Create/Configure/Manage of Deplhix Enabled databases [VDB,Dsource] and Monitor the alerts via Engine + Worked with Deplhix support

· Cloning of Non-ERP/ERP Databases

· Incident management where we provide support to cross-functional teams

· Experience in troubleshooting Connectivity issues for RAC Database,FE,SSO Login issues

· Managing & Creating Users,Tablespaces,DB Links, Roles and assigning privileges & Done Export/Import of tables

· Performing System Administration activities for Oracle Applications.

· Troubleshooting Concurrent Programs and Concurrent Manager Issues & Bouncing of WebLogic & ERP Services like Apache, Concurrent manager, Database services.