SAP HANA BASIS DBA

Who We Are:-

Globant is 20 years old, NYSE listed public organization with more than 27000+ employees worldwide working out of 25 countries globally.

We are a Product Engineering Services organization which provides end to end product development solutions to our customers. Right from:- Conceptualizing the software product, Architecting, Developing, Testing and Sustaining of the software product. Find out more at www.globant.com

We are looking for transformative SAP Techs to join our Enterprise Apps Studio. We help businesses transform via augmented processes and the continual enhancement of their enterprise architecture. We provide the expertise to enable organizations to take advantage of the latest in machine learning and data science platforms and services. Come be a part of the team to transform, innovate and optimize.

Required Experience in years: 7 to 8 Years

Job Location : Pune/Hyderabad/Indore/Ahmedabad

Title: SAP HANA BASIS DBA

Key Responsibilities:

• Performance Analysis: Conduct comprehensive performance analysis of HANA database systems to identify performance bottlenecks, high resource consumption, and potential areas for improvement.

• SQL Query Optimization: Analyze and optimize SQL queries used in HANA database to minimize response times and resource utilization. Utilize query execution plans and other performance indicators to identify areas for improvement.

• Database Hints: Identify and implement relevant database hints to influence the query optimizer's execution plan and improve the performance of critical SQL queries.

• Indexing and Partitioning: Optimize database indexing and data partitioning strategies to improve data retrieval and processing efficiency.

• Memory Management: Configure and optimize memory settings in the HANA database to balance performance and resource consumption.

• NUMA Analysis: Perform NUMA analysis to understand memory access patterns and optimize database operations accordingly for multi-socket systems.

• Database Thread CPU and Memory: Monitor and analyze database thread CPU usage and memory consumption to identify performance bottlenecks and implement necessary optimizations.

• Data Modeling: Collaborate with developers and data modelers to design efficient database models for optimal data processing and storage.

• Compression and Archiving: Implement data compression and archiving strategies to reduce storage requirements and enhance database performance.

• HANA Database Parameters: Fine-tune HANA database parameters and configurations to achieve optimal performance levels.

• Query Performance Monitoring: Implement and maintain monitoring tools to track query performance metrics, proactively identify slow-running queries, and provide timely recommendations for optimization.

• Performance Testing: Plan and execute performance testing scenarios to assess HANA database performance under different workloads and stress conditions.

• Troubleshooting: Investigate and resolve database performance-related incidents and issues, providing expert-level technical support.

• Patching and Upgrades: Collaborate with the technical team to plan and execute database patches, upgrades, and migrations while ensuring minimal impact on performance.

• Documentation: Create and maintain detailed documentation of performance analysis, tuning techniques, best practices, and optimization strategies for future reference.

• Collaboration: Work closely with cross-functional teams, including application developers and infrastructure teams, to implement performance-related changes and align with business requirements.

• Continuous Improvement: Stay up-to-date with the latest HANA database advancements, performance optimization tools, and best practices to continuously improve database performance.