Sap Hana Dba 3

RedBeard Solutions•Newport News, VA

30d•$45 - $50•Remote

About The Position

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. Performance Management and Tuning: 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. Security and Authorization: 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. High Availability and Disaster Recovery (HA/DR): 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. Storage and Capacity Management: 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

Requirements

Bachelors Degree and 5 years of experience.
Masters Degree and 3 years of experience.
Ph.D. and 0 years of experience.
4 years of related exempt experience can be substituted for Bachelors degree.
8 years of non-related exempt experience can be substituted for Bachelors degree.
SAP Hana Administration
OS skills in Windows & Linux

Responsibilities

Installation, Configuration, and Patching: Performing initial setup, system copies, and applying necessary updates, patches, and service packs to maintain stability and access new features.
Monitoring: Proactive monitoring of database availability, performance metrics (CPU, memory, disk utilization), and resource consumption using tools like the SAP HANA Cockpit.
Backup and Recovery: Implementing, testing, and managing the complete backup strategy (full, incremental, differential) and ensuring rapid, reliable recovery in case of failure.
Optimization: Analyzing and tuning slow-running SQL statements, stored procedures, and data models to ensure optimal performance of analytical and transactional workloads.
Troubleshooting: Identifying and resolving performance bottlenecks, deadlocks, and system-level issues.
Workload Management: Configuring and monitoring workload settings to prioritize critical applications.
User and Role Management: Creating and managing users, roles, and privileges, ensuring the principle of least privilege is followed.
Auditing and Compliance: Implementing and maintaining database security policies, auditing activities, and ensuring compliance with regulatory requirements.
Encryption: Managing data and log encryption configurations.
System Replication: Setting up and managing HANA System Replication (HSR) for HA/DR purposes.
Failover Testing: Regularly testing failover scenarios to ensure business continuity.
Sizing: Working with architecture teams to ensure proper sizing of hardware and storage for growth.
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.