Summary
Overview
Work History
Education
Skills
Languages
Disclaimer
Timeline
Generic
SUMAN SHEKAR RAO

SUMAN SHEKAR RAO

Bangalore

Summary

8+ years of experience as HANA DBA, worked in a 24*7 support project (Managed Cloud Delivery), offering 2L and 3L support for more than 200 SAP customers across the globe. Also worked in BFSI banking project (Nordea Bank AB – Finland) supporting the customer systems. Currently working in Cloud / Application Management Services project in Database Health Check team for NESTLE client.

Overview

8
8
years of professional experience

Work History

SAP HANA DBA / Consultant

Tech Mahindra
09.2022 - Current
  • Monitoring and Performance Optimization of systems across the customer landscape
  • Analyzing and forecasting system data - by creating reports based on historical data and then proving technical solutions to customer
  • Executing regular mini checks / health checks on the systems to identify and resolve the various issues in the systems
  • Performance Optimization - analyzing various reports - EWA / TPO etc - and provide appropriate recommendations so that customer stays in line with SAP Standards
  • Identifying database issues and performance bottlenecks in the systems and resolving the issues on priority basis
  • Analyzing the system with respect to various KPIs - MEMORY, CPU, DATA GROWTH, TABLE MAINTENANCE, SYSTEM REPLICATION etc - and provide necessary recommendations to customer
  • Identifying and analyzing expensive SQLs in the system and optimizing the queries to enhance the performance.

HANA database Administrator

NTT DATA
06.2021 - 09.2022
  • Installing, Configuring and Maintaining HANA database
  • Upgrading HANA database to latest patches with near Zero downtime
  • HADR setup and maintenance - System Replication
  • Handling distributed (scale-out) HANA systems
  • Maintaining Backup & Recovery
  • Performing system copies (recoveries) - specific backup, point-in-time, Enhanced Tenant Copy etc
  • Troubleshooting backup, memory, CPU utilization and performance issues
  • Troubleshooting HANA database issues by analyzing trace files
  • Handling log-full situations, encrypting data and log volumes
  • Analyzing EWA reports, recommended the HANA related parameter changes in HANA landscapes
  • Configuring and maintaining redo-log encryption, fast restart in HANA
  • Performing system copy from multinode to single node system
  • DB upgrade from 1.0 to 2.0 using backup and recovery method
  • Performing export/import of tables
  • Creating and maintaining remote connection to HANA using SDI and SDA
  • Handling Table related issues ( Table Partition, doing copy of table, table backup etc )
  • Handling errors related HANA hooks
  • Alert Handling as a proactive measure to avoid any DB down situation
  • OS: Unix, Redhat Linux ,Windows
  • SAP Tools: CAM, XIMO Studio, SPC, HANA Studio, HANA Hotspot
  • Decision making whether to proceed with DB Failover in case of primary down situation
  • Handling data and log mount full situation
  • Helping customer in migrating HANA from cloud to on-premise using replication method
  • Migrating HANA to different hardware - using Replication method or Backup-Recovery method
  • Migrating HANA from on-premise to Cloud and handling SHC (SAP HANA Cloud instance).

Database Administrator

TATA Consultancy Services
12.2015 - 06.2021
  • HANA] Installing, Configuring and Maintaining HANA database
  • Upgrading HANA database to latest patches with near Zero downtime
  • Maintaining distributed(scale-out) systems
  • Optimizing data load in multi-node systems using DWF DDO (Data Distribution Optimizer)
  • Performing DR tests in replicated systems
  • Replication configuration for high availability
  • Performing Backup and Recovery
  • Analysing EWA reports and implementing parameter changes
  • Troubleshooting backup, memory, CPU utilization and performance issues
  • Troubleshooting HANA database issues by analyzing trace files
  • Reclaiming logs in case of log full situations
  • Creating and maintaining remote connections for HANA SDA / SDI
  • Migrating HANA 1 to HANA 2 (conversion to MDC)
  • Handling Tenant databases in HANA 2 (creation/deletion, isolation level ,cross-database access, etc)
  • SYBASE ASE] Installation and Upgrading ASE to latest patch level
  • Device creation and database creation
  • User management like adding users, granting roles and privileges, password reset
  • Performing point in time recovery in case of incident in place
  • Analyzing stack trace and fixing out of locks and lock wait issues
  • Parameter configuration, Data segment and log segment management
  • Configuring the systems to solution manager and scheduling jobs for log backup in DBA planning calendar via DBACOCKPIT
  • Troubleshooting ASE performance issues by analyzing log files.

Education

Bachelor of Engineering - Information Science

Visvesvaraya Technological University
Chikkamagaluru
06.2015

Sri Vidhyabharathi College
Shivamoga
04.2011

Sahyadri School
04.2009

Skills

  • DBMS: SAP HANA,
    SyBase ASE ( Working Knowledge of MSSQL )
  • OS: Unix, REDHAT Linux ,Windows
  • SAP Tools: CAM, XIMO Studio, SPC, HANA Studio,
    HANA Hotspot

Languages

English
Kannada
Hindi

Disclaimer

I hereby confirm that that the information given above is true and correct to the best of my knowledge.

Timeline

SAP HANA DBA / Consultant

Tech Mahindra
09.2022 - Current

HANA database Administrator

NTT DATA
06.2021 - 09.2022

Database Administrator

TATA Consultancy Services
12.2015 - 06.2021

Bachelor of Engineering - Information Science

Visvesvaraya Technological University

Sri Vidhyabharathi College

Sahyadri School

Similar Profiles

CREATE PROFILE
SUMAN SHEKAR RAO