Responsibilities

• Assist in the system architectural design and solutions for the database systems and AIX related system software to meet business requirements and cost-effectiveness

• Undertake DBA role to manage and administer various RDBMS (e.g. DB2, Oracle, PostgreSQL, SQL Server)

• Install and configure database products (e.g. Oracle RAC, ASM, Oracle Active Data Guard, Oracle Golden Gate replication)

• Devise proper design and procedures for database backup and restore, snapshots, data recovery, disaster recovery, data mirroring, HA solution, security setup, 7x24 operation and other related features

• Perform software upgrade and apply security and software patches to the database and AIX related system software

• Conduct system monitoring, performance tuning and capacity planning

• Maintain high system availability and database integrity and ensure high database security

• Work closely with other technical teams and external vendors for database system set-up and configuration

• Monitor, time, and report systems performance in use of relevant monitoring tools

• Design, produce and conduct appropriate training sessions to colleagues for new developments in the database systems

• Provide advice and assistance, on the features of, and the use of the database software and utilities

• Provide 7x24 on-call for emergency production incidents and provide on-site support for fire-fighting

• Perform other duties as assigned by the superiors

Requirements

• University degree in electrical/electronic, computer engineering/science or related discipline

• Minimum 7 years’ experience in DBA role for database administration support

• Solid knowledge of at least one of DB2, Oracle or PostgreSQL with their associated software products

• Knowledge of SQL Server is preferred

• Good knowledge of AIX and/or other Unix systems, along with their associated system software

• Willing to perform evening and holiday shift duties for supporting operation

• Good command of spoken and written English and Chinese