Kowloon City, Kowloon Peninsula Kowloon City Kowloon Peninsula, Hong Kong Hong Kong
职位描述
岗位职责
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, MySQL, Mongo, Clickhouse, Postgres / 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