SAP HANA DBA Database Architect 3

Job Description

Job Description

DATABASE ARCHITECT 3

Designs, models, documents, and guides the logical and conceptual relationship of data and database changes for complex applications. Analyzes needs and requirements of existing and proposed systems, and develops technical, structural, and organizational specifications. May create standards and / or do modeling to monitor and enhance capacity and performance.

Core Responsibilities for SAP HANA DBA

• Database Operations and Maintenance :

o             Installation, Configuration, and Patching : Performing initial setup, system copies, and applying necessary updates, patches, and service packs to maintain stability and access new features.

o             Monitoring : Proactive monitoring of database availability, performance metrics (CPU, memory, disk utilization), and resource consumption using tools like the SAP HANA Cockpit.

o             Backup and Recovery : Implementing, testing, and managing the complete backup strategy (full, incremental, differential) and ensuring rapid, reliable recovery in case of failure.

o             Optimization : Analyzing and tuning slow-running SQL statements, stored procedures, and data models to ensure optimal performance of analytical and transactional workloads.

o             Troubleshooting : Identifying and resolving performance bottlenecks, deadlocks, and system-level issues.

o             Workload Management : Configuring and monitoring workload settings to prioritize critical applications.

o             User and Role Management : Creating and managing users, roles, and privileges, ensuring the principle of least privilege is followed.

o             Auditing and Compliance : Implementing and maintaining database security policies, auditing activities, and ensuring compliance with regulatory requirements.

o             Encryption : Managing data and log encryption configurations.

o             System Replication : Setting up and managing HANA System Replication (HSR) for HA / DR purposes.

o             Failover Testing : Regularly testing failover scenarios to ensure business continuity.

o             Sizing : Working with architecture teams to ensure proper sizing of hardware and storage for growth.

o             Data Tiering : Managing data temperature and implementing strategies like SAP HANA Native Storage Extension (NSE) or SAP HANA Dynamic Tiering to optimize memory usage and cost.

10)         What are the top 3 skill sets you are looking for in an ideal candidate?  SAP Hana Administration, OS skills in Windows & Linux

Basic Qualifications

Bachelor’s Degree and 5 years of experience.  Master’s Degree and 3 years of experience.  Ph.D. and 0 years of experience.  4 years of related exempt experience can be substituted for Bachelor’s degree.  8 years of non-related exempt experience can be substituted for Bachelor’s degree.