We are looking for transformative SAP Techs to join our Enterprise Apps Studio.
Required Experience in years: 7 to 8 Years
Job Location : Ahmedabad
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.
