Job Openings Snr SAP HANA Database Administrator

About the job Snr SAP HANA Database Administrator

EMPLOYMENT TYPE: 

Permanent

 

LOCATION: 

Cape Town 

  • Please note:  Under pandemic regulations all work is done remotely, although on-site work will be expected in future. 

JOB OVERVIEW: 

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  

Administration Responsibilities  

  • 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. 

 

QUALIFICATIONS REQUIRED: 

  • College diploma or university degree in the field of computer science and/or 3-4 years' equivalent work experience. 

  • Work experience in SQL scripting 

EXPERIENCE REQUIRED: 

  • 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 

 

ADVANTAGEOUS SKILLS: 

  • SAP Netweaver component will be an advantage 

 

**Please note : If you have not heard from us within 2 weeks, please consider your application unsuccessful.