SAP HANA DBA ( Senior Consultant)

Experience - 6yrs- 8yrs

Location - Bangalore

Job title - Senior Consultant

Job Summary

Experienced SAP HANA DBA with expertise in SAP HANA installation administration upgrades migrations backup and recovery performance tuning and system replication. Hands-on experience with Single DB and MDC environments HANA 1.0/2.0 upgrades security administration tenant management monitoring troubleshooting and high-availability configurations. Skilled in supporting production systems resolving critical incidents and ensuring database reliability and optimal performance.

Responsibilities

• Strong expertise in SAP HANA Architecture administration and support across enterprise landscapes.
• Hands-on experience managing Single Database and Multi-Tenant Database Container (MDC) environments.
• Performed SAP HANA database installation configuration post-installation activities and system provisioning.
• Managed HANA database reinstallation tenant database creation/deletion and lifecycle management activities.
• Installed and maintained SAP HANA Studio HANA Client HANA Client for Excel and HANA add-ons including AFL RTL and LCApps.
• Executed HANA SPS upgrades maintenance revisions and HANA 1.0 to 2.0 migrations for single-node scale-out and replication-enabled systems.
• Optimized database performance through monitoring trace analysis transaction management memory optimization table partitioning row-store reorganization and SQL performance tuning.
• Troubleshot critical issues involving CPU utilization OOM events blocked transactions long-running threads XS Engine and database alerts.
• Conducted SAP HANA DBCC health checks Mini Checks and EWA report analysis to ensure system stability and compliance.
• Implemented and administered HANA security through user management role assignments privilege administration and HDB user store configuration.
• Managed static and dynamic parameter configurations to improve system performance and operational efficiency.
• Performed backup recovery PIT/LPT restores and disaster recovery activities across on-premises Azure and AWS environments.
• Executed HANA database refreshes system copy activities DB SID changes virtual hostname renaming and password reset procedures.
• Utilized SAP HANA Studio and SAP HANA Cockpit 2.0 for administration monitoring and troubleshooting activities.
• Configured and managed HANA System Replication in 2-tier and 3-tier landscapes ensuring high availability and business continuity.
• Worked with HANA Hooks Pacemaker Clusters and scale-out environments including node addition and removal activities.
• Implemented SAP Notes and supported end-to-end SAP HANA deployment upgrade and maintenance projects.
• Planned and executed database restart activities during approved downtime windows and maintenance schedules.
• Resolved high-priority production incidents and ensured timely resolution of critical system alerts.
• Integrated SAP HANA with Smart Data Integration (SDI) for enterprise data connectivity and data provisioning requirements.
• Collaborated with cross-functional stakeholders to deliver reliable secure and scalable SAP HANA platforms supporting business-critical applications.
• SAP HANA Certification is an added advantage demonstrating expertise in HANA database administration and best practices.