Establishes configuration standard and design guideline for database software, covering availability, performance, resilience, monitoring, backup and recovery functional areas.
Provides technical assistance to development team and operation teams for database systems.
Troubleshoot and drive system recovery. Escalate problems with actual or potential major impact to problem management and IMS management. Performs root cause analysis and ensure planned actions are carried out to prevent recurrence.
Ensures the supportability of database software systems. Plans and leads upgrade projects.
Reviews and approves change requests. Supervise execution for major change
Conducts performance analysis and tuning
Automates system operation
Tracks and drives patch management for all database software. Track, plan and drive software upgrades to ensure continuous supportability.
Establish backup and recovery procedures
Perform regular access review and validation.
Establishes adequate monitoring to ensure efficient and reliable service delivery
Apply new technology and process to improve system supportability, recoverability, availability and performance.
Provides operational excellence and skills on databases to support various project phases (requirement gathering, design, procurement, implementation and hand-over to operations).
Provides technical guidance and mentoring to help develop less experienced engineers.
Supports audit and compliance activities.
Requirements
Operating Systems (AIX/Solaris/Linux/Windows)
Databases (Oracle/MariaDB/SingleStore/OceanBase)
Scripting (Shell/Perl/Puppet)
2-6 years of production support experience as Oracle DBA or MariaDB
Demonstrable experience of managing high-performance, high-capacity databases in a critical production environment.
Distributed Databases
Experience on, Linux including strong shell scripting skills.