Sr. Consultant-Database HANA DB Job
Pune, IN Bangalore, KA, IN IN Hyderabad, TG, IN Indore, IN
Job Description:
HANA DBA | Experience – 7 to 10
Role Overview
Experienced personnel with in-depth expertise in Database administration and monitoring across platforms like SAP HANA, MS SQL Server, Oracle, IBM DB2, SAP MaxDB, PostgreSQL, MongoDB, Redis. This position looks to design, implement, and maintain databses, collaborate with SAP infrstructure teams, and ensure efficient system performance and compliance. This covers database management (project & sustain), DB health and monitoring activities to support enterprise-wide operations.
Key Responsibilities:
- Database design
- Design and implement databases
- Ensure databases are high quality, reliable, and available
- Database security
- Ensure data security and compliance
- Manage access to systems that store company information
- Ensure data is only available to authorized people
- Backup and recovery
- Create and maintain backup and recovery procedures
- Test and implement disaster recovery plans
- Performance optimization
- Tune and optimize performance
- Find and fix problems that slow down database performance
- Database usage
- Create backups, restore data, and speed up database performance
- Fluent on DB Technologies like, SAP HANA, MS SQL Server, Oracle
- Good to have exposure to IBM LUW Db2, SAP MaxDB, PostgreSQL, MongoDB, Redis in-memory DB
- Capacity Planning
- Forecasting future database storage needs and scaling accordingly
- Managing database storage allocation and usage
Skills Required (technical & nontechnical):
Database design:
- Understand normalization, indexing, and schema design
- Create efficient and maintainable databases
Data security:
- Implement access controls, user permissions, and encryption
- Protect data from unauthorized access.
Problem-solving:
- Identify, test, and eliminate potential problems
- Generate new solutions to new problems
- Troubleshoot and correct problems
Technical Proficiency:
- Familiarity with various DB technologies, tools, and Operating System platforms (like, Windows, Suse Linux)
- Proficiency with SAP HANA Database Administration
- Proficiency in handling HA/DR configs and solutioning
Data Analysis Skills:
- Ability to proactively analyze DB performance & consistency issues, identify trends, and support decision-making.
Communication Skills:
- Clearly communicating complex technical information to internal stakeholders, including IT teams and business users.
Additional Skills may include:
- Database Migration (Homogeneous/ Heterogeneous)
Cloud Computing Knowledge:
- Understanding of cloud platforms like, GCP and Azure
- Shell Scripting
Key Experiences and Knowledge Required (e.g. actual experiences foundational for this job, years of experience, jobs that must be mastered before doing this job, career pathing):
- A minimum of 7-8 years of experience in datebase administration with a strong focus on improved database efficiency and reduced downtime through quantifiable results, including experience with database performance tuning, data security measures and DB high-availability solutions.
Job Scope & Key KPOs :
- Job Scope is essentially focusing on minimizing DB infrastructure costs while ensuring efficient data access and maintaining database integrity and consistency.
- Candidate performance will be evaluated on below KPOs
Availability and reliability:
- Database uptime: Percentage of time the database is operational.
- MTTR (Mean Time To Resolve): Average time to fix a database issue.
- Upkeep of High-availability solution deployed in SLB SAP DB ecosystem
Optimization and efficiency:
- Number of optimized queries: Proportion of queries that have been reviewed and optimized for performance.
- Index usage: Percentage of queries utilizing appropriate indexes.
Performance metrics:
- Query response time: Average time taken to execute a query.
- Throughput: Number of queries processed per unit time.
Alerting and monitoring:
- Set up monitoring tools for alert notification on DB KPIs via SAP std or customized solutions
Resource Management:
- CPU utilization: Percentage of CPU capacity used by the database.
- Memory utilization: Percentage of available RAM used by the database.
- Storage utilization: Amount of storage space occupied by the database.
Customer/Stakeholder Base Impact:
This job interacts with internal stakeholders. This person would play a key role in maintaining relationships with the SAP Basis team, Infrastructure team, Development & Functional team.