Major 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
• Perform trouble-shooting, problem solving and incident management
• Develop and keep up-to-date documentation of database systems
• 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
• Provide technical assistance to the application development teams on database design for project development
• 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
• Under direction from the Management, investigate developments in the database software packages and utilities areas. Make appropriate proposals for the improvement of services delivered to the users of the computer 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

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
• Pick up new skills through self-learning and on the job training
• Willing to perform evening and holiday shift duties for supporting operation
• Good command of spoken and written English and Chinese
• Excellent problem-solving skills including root-cause analysis
• Good communication and interpersonal skills and able to work under pressure