Database Administrator

Responsible for maintaining, securing, and operating databases.

Ensures that data is correctly stored and retrieved.

Specialize in Database Management & Administration of various database (e.g.Oracle/MS SQL/MYSQL).

Database/System/Backup/Replication/Restore.

Database security & familiar with multiple operating system platform (MS OS /Linus); able to setup new environment and deploy application system into Development/Test/Production/Disaster Recovery Environment.

Administer and maintain all activities associate with database management such as install, configure, upgrade, maintain, test, monitor, optimize and fine tune database/application servers's performance.

Perform analysis, troubleshoot database related issues, monitor, allocate and plan database storage capacity requirements.

To handle & provide after office hours on urgent critical incident support request.

Create, maintain and monitor end-of day scheduler jobs, perform end of day and month end system closing.

Perform, monitor and ensure daily/weekly/monthly backup/replication or any restoration request is performed successfully.

Monitor database/systems logs to proactively identify, report exception or error to minimize disruption and impact to the database/systems downtime.

Setup, configure, implement & maintain Application/Database related Development/Test/Production environment.

Perform objects/programs migration, deploy bug-fix script/programs, deployed security patches; prepare and review monthly object migration change management report/logs.

Protect database against threats or unauthorized access.

Create and maintain users profiles and permissions.

Serve & being the in-house subject matter expert to participate in projects and evaluate database related solution/requirement, database requirement.

To provide related advice, design, implement, managing database security/integrity, capacity, backup, replication, restore requirement and recommend improvements wherever is necessary.

Degree in Computer Science, Information Technology or equivalent practical experience

Oracle Certified Professional (OCP) is additional advantage.

Minimum 5 years of strong technical hands-on experience in Database Management and Administration.

Able to perform Database Setup, Migration, Upgrade, Performance Tuning, Indexing, Capacity Planning & Archiving (e.g. Oracle (ver 12c above), MS SQL (ver19), MySQL).

Experience with database automation and scription (e.g. SQL, Shell, etc)

Familiar with Winter & Linus Operating Systems, Middleware & VMWare platform will be added advantage.

Ability to monitor, analyze, and optimize database performance, including indexing, query optimization, and resource management (CPU, memory, disk I/O).

Proactive in monitoring database performance, identifying potential risks, and taking steps to prevent problems before escalation.

Experience in identifying and resolving performance bottlenecks, tuning queries, and optimizing server configurations.

Ability to diagnose and resolve complex database issues quickly and accurately.

Good multitasking abilities.

Communicate effectively to various groups of people and portray a pleasant personality.

Willingness to stay updated with new technologies and adapt to changing database platforms and tools.