Overview
Work History
Education
Skills
Timeline
Generic

Bhanu R

Bangalore

Overview

6
6
years of professional experience

Work History

DB2 DBA

Wipro Limited
Bangalore
06.2021 - Current
  • Daily sharing health check reports to the customer as per request.
  • Closing tickets raised to us with in time.
  • Worked on Weekly activities and monthly activities.
  • Checking space utilization as per the requirement.
  • Moving the data by using EXPORT, IMPORT, LOAD, db2move utilities.
  • Updated the DBM and DB configuration parameter as per requirement.
  • Using RUNSTATS, REORGCHK and REORG to enhance application performance.
  • Operating Systems: Linux/Unix, AIX and Windows
  • Client: Shared Flex

SAP BASIS CONSULTANT

Wipro Limited
Mysore
02.2020 - Current
  • Installing, Configuration, Upgrading, Uninstallation and Maintenance of HANA. Includes installation of new database, Appling database patches
  • Analyzing EWA Reports (Early Watch Analysis Report) and implementing the parameter changes as per the analysis or as per customer requirement on the database for improving performance of the database HANA databases.
  • Performing Database and application HANA client & plugin installation and upgrades, installation delivery units on database level as per customer requirement
  • Creating Users, roles, granting roles and privileges to users, Resetting user passwords
  • Performing setup of replication of database from Primary to HA and DR databases, Changing the replication modes and replication operation modes and disabling Replication
  • Performing Table partitioning such as HASH, RANGE and ROUND ROBIN table partitions, Table redistribution & Landscape Redistribution activity, Database and table consistency checks and fixing issues as per consistency check.
  • Performing Fail-over such as HA or DR failover tests
  • Performing Database both online and offline Database backups & Recovery for HANA Database.
  • Performing Database and Data volume Encryption for both HANA & ASE database.
  • Creating and Extending Database volumes and log volumes for data storage
  • Performing Hyper Care checks (database health check)
  • Working in P1 & P2 incident for Troubleshooting Database related issues
  • Overall system monitoring (Work process, Users, System logs, Short dump, Locks, System traces, Disk space
  • Performed daily System Monitoring and prepared Health Checks
  • Responsible for day-to-day administration like monitoring work process overview, analyzing of ABAP.
  • Dumps, enqueue locks and system logs, etc
  • Experience in configuring and maintaining the operation modes based on time intervals.
  • Analysis ABAP dump and system log error message and provide solution
  • Importing the transport request throughout landscapes
  • Performing Kernel update.
  • Performing parameter change Static and Dynamic as per customer request.
  • Performed client copies like local, remote, and export/import.
  • Performing System Refresh and System Copy activities as per request.
  • Performed SAP note implementation.
  • Performing Update & Upgrade application software using (SUM, SPAM, SAINT) tool.
  • Operating Systems: Linux/Unix
  • Client: SAP LABS
  • Organization: NTT DATA BUSINESS SOLUTIONS

DB2 DBA

IBM India Pvt Ltd
Bangalore
03.2019 - 01.2020
  • Create and modify databases and database objects as per application requests.
  • Installing DB2 Fix-pack as and when required
  • Ad-hoc Database backup & recovery as part of application maintenance.
  • Database monitoring (free space in tablespaces, event monitor outputs etc.)
  • Monitoring scheduled jobs for any failures and taking necessary action.
  • Object and tablespace refresh from PROD to QA/DEV databases.
  • Moving the data by using EXPORT, IMPORT, LOAD, db2move utilities.
  • Updated the DBM and DB configuration parameter as per requirement.
  • Using RUNSTATS, REORGCHK and REORG to enhance application performance.
  • Operating Systems: Linux/Unix
  • Client: GHD (Global Hardware Database)

Education

B.E. -

SCSVMV UNIVERSITY
01.2011

Skills

  • SAP HANA administration
  • Database performance tuning
  • System monitoring
  • Data encryption techniques
  • Replication setup
  • Client relationship management

Timeline

DB2 DBA

Wipro Limited
06.2021 - Current

SAP BASIS CONSULTANT

Wipro Limited
02.2020 - Current

DB2 DBA

IBM India Pvt Ltd
03.2019 - 01.2020

B.E. -

SCSVMV UNIVERSITY

Similar Profiles

CREATE PROFILE
Bhanu R