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
Database Administrator • Sepang, Selangor, Malaysia