HANA BASIS Administrator roles and responsibilities

Home


1)  Setup roles for admin, consumers, HANA modelers.
2)  Initial configuration of HANA Server - Parameters such max number of rows.
3)  Create Schemas on HANA Server
4)  Create and schedule regular backup
5)  Install stand-alone SLT Replication Server
6)  Install add on in ECC for SLT
7)  Create and configure connection SLT to HANA
8)  Create and configure connection SLT to ECC
9)  Initial configuration of SLT Replication Server
10) Setup roles, users, jobs in SLT
11) Configure alerts in DS,ST to monitor load failures
12) Configure alerts in HANA for memory consumption
13) Replicate metadata to HANA from ECC using DS/HANA Studio
14) Migration of BW 7.3 on Oracle to BW 7.3 on HANA database
15) Experienced in SAP HANA Database installations, BW on HANA installation and implementations.
16) Monitoring SAP HANA system landscape
17) Starting and stopping of SAP HANA systems
18) Creating database users and roles in HANA studio
19) HANA database security.
20) Experienced in using various HANA database tools like HANA studio, HLM, HDMLCM
21) Scheudling regular backups of HANA system
22) Expertise in HANA STUDIO
23) Integration of ECC with HANA Database using the SLT Replication Servers or services.
24) HLM (Hana lifecycle manager) expertise

HANA Administration Tasks:

This document lists HANA system administration tasks. HANA administration tasks are not limited to following activities. Activity scope varies with organization's ITIL requirements.

DAILY TASKS:

Monitor overall system/services status.          
Monitor system alerts and resolve.
Monitor resource utilization.

MONTHLY TASKS:
   
Cleanup of  old DIAGNOSIS/Log FILES.
Archive or cleanup of backup files system.

ON-DEMAND TASKS:

Security and Authorization
Create a User.
Create a Role and Privileges.
Assign Roles and Privileges
Delete a User.  
Deactivate/Activate Users
User password reset
Defining password policy.
Logging and Tracing
Activate and analyze database/JDBC logging and tracing.
Performance/Kernel tracing (Only for SAP developers)
SQL tracing.
Activate and analyze expensive SQL trace.
Define Audit policy.
Backup and Recovery
Execute manual on-demand backup.
Schedule automatic regular backup.
Perform on-demand DB recovery.
Distributed landscape maintenance.
Adding or removing additional hosts.
Host failover.
Table partitioning.
Table redistribution.
Alert Configuration.
Configure alert threshold.
Configure email notification.
License Administration.
Checking current license.
Request and install license.
HANA system upgrade/update.
Apply HANA support packs/revisions.
Update HANA content/libraries.
Data provisioning and configuration.
Install and configure SLT server and connections.
Install and configure ECC add-on for SLT server.
Manual data upload from flat files.
Change transport.
Migrate HANA Delivery Unit (Export-Import).
Migrate HANA packages.
Migrate HANA Development artifacts(Attribute view , Calculation view etc).
Routine Operation tasks
Start/stop system.
Restart database services.
Parameter configuration.
Manual Delta merge
Avoid Log full situation.

• System administration and monitoring
• Secure administration and configuration
• Landscape management and network administration
• Administration of the SAP HANA XS runtime environment
• High availability (including backup and recovery) and scalability
• Data access and integration with SAP HANA data provisioning tools and technologies