Database Administrator

Requirements

Creates and maintains all databases required for development, testing, training, and production usage

Performs the capacity planning required to create and maintain the databases

Performs tuning of the database instances as when as required

Implement and maintain backup and recovery procedures for all databases

Perform database changes, housekeeping, and re-organizations to enhance performance and ensure maximum uptime

Planning is also performed by the DBA, along with the application developers and System Administrators, to ensure that any new product usage or release upgrade takes place with minimal impact

Provides technical support and consultancy to application development teams

Administers all database objects, including tables, indexes, views, sequences, packages, and procedures.

Troubleshoot and resolve database-related issues

Create and manage database users as when required

Design and maintain physical database structures

Perform ad-hoc backup and recovery as when required

Qualification

Bachelor’s Degree, Post Graduate Diploma or Professional Degree in Computer Science / Information Technology or equivalent

Required skill(s)

Strong knowledge in producing / writing technical and operational reports. Proficiency in database management systems (DBMS) such as Oracle, MySQL, MSSQL, and Postgres. SQL scripting and query optimization / tuning. Shell scripting for automation and database tasks. Experience with Oracle Data Pump for data import / export. Capability in enterprise database design is an added advantage

Key quality(s)

Good communication and interpersonal skills. Strong problem-solving abilities and attention to detail.

Required language(s)

English and Bahasa Malaysia

Desired experience / exposure

Minimum 3-5 years experiences in database administration across Oracle, MSSQL, Postgres, and MySQL

Willing to work long hours and on weekend or public holiday when required

#J-18808-Ljbffr