Nallam Devi Prasanna

• Ensuring system availability, performance tuning, troubleshooting and RCA, P1 outage handling
• System Refresh for both Hana and Maxdb using backup restore method
• Sound knowledge in Hana High availability and DR Setup in both scale-up and Scale-out systems
• EWA Report Analysis – performance tuning parameter management and red alert analysis
• Hands on experience on multiple database platforms like Hana DB, Oracle, MaxDB, SYBase Database
• Hana DB installation and patching (Hana Revision Upgrade) with addon installation
• DR Exercise to ensure high system availability
• Database Administration – Backup monitoring, performance monitoring, Backup scheduling and configuration, space management – table partition and index creation
• Sound knowledge in DB tools like Hana studio, Hana cockpit and DB studio for maxdb
• Adding /removing systems in Cockpit
• Hands on experience in monitoring systems using Datadog
• Worked on SAP deployments on AWS Hyperscaler
• Transport Management, STMS Configurations and TR imports using Active Control
• Performed kernel upgrades and support pack component upgrades

• Provide L1/L2 support on daily performing checklist activities like Monitoring, Troubleshooting, Support, and configured work processes basing on number of users for all landscapes
• Performing Kernel upgrades and applying Support Packs using SUM, SAINT/SPAM on quarterly basis as per SAP standards
• Addon Installation
• Performed ERP EHP upgrade from ERP 6.0 EHP 7 to EHP 8
• Involved in all the basis daily activities which includes STMS, Operation Modes, scheduling the Database backups, archive logs and much more
• Starting and stopping SAP instances
• Parameter changes
• SSL Certificate Renewal
• SNC and CSR generation and import
• System monitoring and performance tuning- Background Jobs, logs, locks, update, traces, analysis of short ABAP dumps, workload analysis
• Knowledge of Change requests using STMS, Exporting & Importing of Change Request by Configuring Transport Management System and Resolved the issues while moving change request at operating system level
• Monitoring on the following Transaction for ensuring smooth performance of SAP: (SM04, SM50, SM51, SMLG SM21, SM13, SM37, SM12, SP01, ST02, ST03, ST22, OS06/ST06, SP01, SU01)
• Host Agent upgrade
• User creation and authorization
• Table spaces management through BR TOOLS
• DB Refresh from production to Sandbox system
• Generating Developer and Object keys from SAP service marketplace
• Daily working on end user tickets and resolving them with in SLA
• Oracle DB Monitoring related to Space management, Archive directory/Backups and DB alerts
• Database Administration using BRTOOLs and SQL query for changing the archive log modes, Table space administration etc
• Applying SAP Notes and generating OSS Messages, Open Connections, Install License
• System recommendation notes as per SAP standards
• Performed SPS upgrade to latest stack for entire landscape

• Daily Activities (System Logs, ABAP Dump Analysis / Short Dump, Lock Entry, Update Records, Background jobs, Database Backup, work process overview)
• Transport Management: Import transport requests into the QA and PROD using ChaRM tool
• Experience in database (Oracle, HANA) and OS (Linux, Unix, Windows server) administration
• File System Monitoring through SAP and OS level
• Performed Support package upgrade using SPAM
• Starting and stopping the SAP systems
• Applying SAP License for an SAP Systems
• Resolving the incident & service requests raised by users and interacting with the users on regular basis to resolve the issues upon laid SLA
• Performance Monitoring and Backup of HANA systems using SAP HANA Studio 2.0
• Kernel upgrades, Applying SNOTES
• Weekly/monthly system maintenance and restarts

● Working in ticket tool, service now ITIL framework

● Working on service request incident query via call,chat,mail,ticket request

● Working as team member of L1

● Resolving issue of URA, Outlook, Office 365, Circuit

● Company portal related issues

● Software issue installation, troubleshooting, ETC..