About the job Snr SAP HANA Database Administrator
- Please note: Under pandemic regulations all work is done remotely, although on-site work will be expected in future.
The HANA System DBA is expected to design, install, configure, administer, monitor and troubleshoot all components of the HANA Platform including the core database as well as the additional components and functionality. The DBA will also be responsible for integration authentication as well as administration tasks related to SDLC in HANA. The DBA will also be expected to consult with HANA developers, HANA modellers, third party Analytic and Reporting tool users as well as ingestion and ETL and security specialists.
DESCRIPTION OF THE POSITION:
General Administrative Responsibilities
Will be required to reference SAP documentation on the official site
Will be required to use the SAP support site, which include:
o Downloading software and patches
o Search for support notes
o Log and follow-up on support incidents
Day-to-day HANA Database Administration Responsibilities
Will be required to have an understanding of the SAP HANA system architecture, the memory model and memory usage
Will be required to use the SAP HANA Cockpit to monitor system health
Will be required to use SAP HANA Studio to monitor system health
Will be required to use SAP HANA Studio and Cockpit as first line memory usage, performance and issue troubleshooting
Will be required to administer virtual tables exposed via Smart Data Access
Will be required to monitor regular backups and perform ad-hoc back-ups
Will be required to monitor HANA High Availability/Disaster Recovery
Will be required to destroy data on request
Advanced HANA Database System Administration Responsibilities
Will be required to install, upgrade SAP HANA components using HANA Lifecycle Manager
Should be able to use advanced SQL Scripting for system administration, monitoring and troubleshooting
Should be able to use advanced Linux bash / HANA command line tools to monitor, administer and troubleshoot
Should be able to configure all necessary software infrastructure for HANA data provisioning
(SDA/SDI) including installation, setup and troubleshooting of third-party unixODBC drivers.
Should be able to design, configure, troubleshoot HANA Workload Management
Should be able to perform all tasks relating to HANA backups and restores including design, scheduling, testing and troubleshooting of backups.
Should be able to setup, troubleshoot HANA Authentication methods components including LDAP, SAML and Kerberos
Should be able to setup and troubleshoot HANA High Availability/Disaster Recovery HANA
Security Administration Responsibilities
Will be required to implement authentication for HANA database access
Will be required to configure and troubleshoot all aspects of HANA security including LDAP, SAML, Kerberos integration HANA Software Design Lifecycle
Will be required to setup and administer the SAP SDLC tools
Will be required to promote code and catalog objects between the different SDLC environments
Will be required to move data subsets between different SDLC environments Integration
Will be required, with external parties, to consult on HANA aspects of integration and testing of SAP and third-party consumption and analytic tools with HANA via ODBC, JDBC, ODBO and other SAP supported connectors.
Will be required, with external parties, to consult on HANA aspects of data ingestion via SAP or third-party replication or ETL tools.
Every second week you will be on Standby.
Working overtime might be required in busy periods.
College diploma or university degree in the field of computer science and/or 3-4 years' equivalent work experience.
Work experience in SQL scripting
Minimum 2 years as a SAP basis
Must have an understanding of SAP backend technology example: SSL, DMZ, API, Solution
Manager, HANA Cockpit, OSS support and SAP Maintenance planner
MUST have basic Linux system admin skills: proficient bash, ssh, file system layout and core file system locations, and core tools like grep and vi
MUST have basic SQL skills including data definition (e.g. CREATE), data manipulation (SELECT/INSERT/UPDATE/DELETE)
Strong understand of database structure/theories/principles and practices
Hands on tuning and troubleshooting experience
SAP Netweaver component will be an advantage
**Please note : If you have not heard from us within 2 weeks, please consider your application unsuccessful.