|
Major Duties: |
|
(a) |
To oversee the team responsible for database administration, including web servers, application servers, and RAC Oracle / MSSQL / MySQL databases; |
|
(b) |
To supervise the team in providing continuous database support and technical solutions aligned with requirements; |
|
(c) |
To plan and execute database design, performance tuning, maintenance, configuration, and upgrades; |
|
(d) |
To manage the collection, analysis, and interpretation of data from various applications; |
|
(e) |
To establish and implement standards and best practices for database administration; |
|
(f) |
To lead and oversee the design and implementation of data warehouse / data lake solution; |
|
(g) |
To provide comprehensive technical support and management for container platforms (e.g., OpenShift and Kubernetes) across on-premise and on-cloud environments; |
|
(h) |
To lead the migration of proprietary databases to open-source databases such as PostgreSQL, including schema conversion, data validation, and performance optimisation; and |
|
(i) |
To prepare data driven analysis reports strategic planning and decision making for management. |
|
|
|
|
Requirements: |
|
(a) |
A recognised degree in information technology (IT), or equivalent professional qualifications; |
|
(b) |
at least 7 years’ relevant experience at supervisory level in the IT field, preferably including 5 years in database administration; |
|
(c) |
Applicants with knowledge and experience in any of the following aspects will be an advantage: |
|
|
(i) |
SQL for database querying and management; |
|
|
(ii) |
Database schema design, normalisation, and indexing; capable of creating and managing data models; |
|
|
(iii) |
Optimising database performance, including query optimisation and indexing strategies, with expertise in diagnosing and troubleshooting using tools, e.g., Oracle Enterprise Manager (OEM); |
|
|
(iv) |
Database security best practices, such as user account management, data encryption and access control; |
|
|
(v) |
Oracle Real Application Clusters implementation; |
|
|
(vi) |
Migrating proprietary databases to open-source platforms such as PostgreSQL using tools like Ora2Pg or native PostgreSQL utilities; |
|
|
(vii) |
Data Warehouse and / or Data Lake design, implementation, and integration; |
|
|
(viii) |
Oracle database related certificates such as OCM or OCP; and |
|
|
(ix) |
Architecture, implementation, and operation of container environment (e.g., OpenShift, Kubernetes, Docker); |
|
(d) |
Good administrative, interpersonal, communication, and team-building skills; |
|
(e) |
Proactive attitude, strong initiative, and the ability to work independently and effectively; and |
|
(f) |
High proficiency in both Chinese and English. |
|
|
|
|
Notes: |
|
(1) |
The post is at the rank of “Manager”. |
|
(2) |
Applicants with substantial experience and achievements in the relevant field but without the required academic / professional qualifications OR those with exceptional academic / professional qualifications but with less experience may also apply. |
|
(3) |
Applicants are required to provide detailed information by outlining their specific technical expertise and previous development projects managed in their curriculum vitae. |
|
(4) |
Appointee(s) may be required to work irregular hours / outside normal office hours and / or at different work locations on a need basis. |
|
(5) |
Appointee(s) may be posted to any operational units of the VTC, for example a campus / centre, to carry out similar duties, and have different post titles which are subject to change at the Council’s discretion. |
