Snr Engineer, Entrprs D/B Svcs

RHB Banking Group; Selangor; On-site; MYR 80,000 - 120,000; Full time

Job summary

A leading banking institution in Malaysia is seeking a Database Administrator to oversee database performance, implement updates, and ensure data recovery processes. The ideal candidate will have strong expertise in Oracle and MS SQL databases, along with experience in ITIL compliance and disaster recovery planning. This role offers an opportunity for continuous improvement and 24/7 support responsibilities.

Qualifications

• Proven experience with Oracle and MS SQL RDBMS.
• Strong analytical skills related to database performance.
• Experience in ITIL process compliance.

Responsibilities

• Manage database troubleshooting and vendor communication.
• Implement database patches and performance improvements.
• Prepare documentation for database operations.
• Provide 24/7 DBA support for database systems.

Skills

Database troubleshooting

RDBMS patch management

Data analysis

Performance tuning

Scripting for automation

Disaster recovery planning

Capacity planning

ITIL compliance

Oracle Engineered Systems management

24/7 DBA support

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle RDBMS

MS SQL Server

Job description

Responsibilities

• Perform troubleshooting on all errors and warning message seen in database logs and OEM alerts daily by raising service request with respective database vendors where necessary to keep the database online without interruption
• Review and perform all required RDBMS patches and ensure fixes are applied according to release from respective service providers to keep the database secure, safe, stable and available at all times
• Review, analyze and manage all RDBMS errors with proper logging to service providers and follow up until conclusion including resolution deployment where necessary.
• Collect and perform analysis of all production database storage data, chart growth pattern, and provide monthly capacity report on database growth
• Review and diagnose database slow performance with root cause analysis and propose steps for improvement that leads to overall improve application system performance
• Develop, update and enhance scripts used for daily repetitive and mundane task to ease and automate service operations
• Perform all application software installation and upgrade request that has been approved by change committee/authorized party to ensure an updated application software version is maintained in Group and deployment being done on a timely basis to meet business requirements
• Implement a robust and trustworthy disaster recovery model to meet defined RPO and RTO
• Perform database backup to ensure recovery of data up to the point required by the business in the event of a disaster.
• Perform periodic analysis of database statistics and performance metrics to prevent any potential database performance degradation and other resource contention
• Monitor and add physical storage to databases when threshold is reached to prevent system outages
• Perform and review periodically on capacity planning management and configuration management for DB assets in accordance to ISO/IEC 20000 (ITSM) compliance and standard
• Perform all activities and processes complies to ITIL, Internal Audit requirements and internal system evaluation criteria to avoid audit finding
• Build and maintain Oracle Engineered Systems covering Exadata Storage Cell, InfiniBand Switch, ZDLRA catalog and HyperConverged Infrastructure for MS SQL databases to achieve consistent performance
• Prepare RDBMS all documentations, procedures and operational manual for effective planning reference, control and operational standard
• Provide 24×7 on call DBA support for Group RDBMS on rotation and need basis to fix any system anomalies