Senior DBA / DBA Lead

Your role:
• Lead a database team to look after all MS SQL database servers for the company : including of proactive monitoring, vendor management, software currency, capacity planning and proactive collaboration with application team and package solution vendors.
• Administrate the production MS SQL servers of online platforms
• Configure SQL Cluster, Database Mirroring and Log Shipping
• Configure SQL monitoring, identify performance bottleneck, and database performance tuning
• Analyze query execution plan and performance statistics to help developers on performance tuning
• Create SQL Server Audit to trace activities on production database servers
• Maintain database table index and column statistics, identify and create missing indexes
• Design and create automated script for database backup and restore
• Develop ETL process for data warehouse by SQL Server Integration Services (SSIS)
• Perform database integrity check, apply services pack (SP) and security cumulative updates (CU)
• Manage SQL Server login, database user, and permissions
• Generate analytical reports for business team using SQL Server Reporting Services (SSRS)
• Make maintenance tasks plan and execute maintenance tasks
• Knowledge of Oracle Database is an advantage.

To succeed in this role:
• Minimum of 7 years' experience in SQL Server Administrator and Maintenance
• Minimum of 10 years' IT related experience
• Knowledge of Oracle Database is an advantage.

Required Techinical Skills:
• Programming language – Transact-SQL
• Development tools – SQL Server Management Studio, SQL Sentry Plan Explorer, TSQLLint
• Load Testing tools – SQL Server Profiler, SQL QueryStress
• SQL Tracing tools – SQL Server server-side SQL Trace, client-side SQL Profiler
• Server Operating System – Windows Server 2012, Windows Server 2016, Windows Server 2019 and others
• Relational Database – SQL Server 2012, SQL Server 2016, SQL Server 2017, SQL Server 2019 and others
• Database High Availability solution – MSSQL Failover Cluster, Availability Group, Log Shipping
• Database Replication solution – SQL Server Transactional Replication
• Database Monitoring tools – Idera SQL Check, SentryOne Power Suite for SQL Server
• Database Performance Tuning tools – Database Engine Tuning Advisor
• Database Auditing tools – SQL Server Audit
• Data Transformation tools – SQL Server Integration Services
• Data Reporting tools – SQL Server Reporting Services, Visual Studio Report Designer
• Database Backup & Maintenance solution – Netbackup

HKT is an equal opportunity employer and welcomes applications from all qualified candidates. Information provided will be treated in strict confidence and will only be used for recruitment-related purposes. Personal data provided by job applicants will be used strictly in accordance with the employer's personal data policies (www.hkt/privacy-statement), a copy of which will be provided immediately upon request.

All personal data provided by candidates will be used for recruitment purposes only by HKT Services Limited in accordance with HKT's Privacy Statement, which is available on our website. Unless otherwise instructed in writing, candidates may be considered for other suitable positions within the Group (being, HKT Limited, PCCW Limited and their respective subsidiaries, affiliates and associated companies). Personal data of unsuccessful candidates will normally be destroyed 24 months after rejection of the candidate's application. If you have any questions regarding your personal data held by HKT Services Limited HKT's Privacy Statement, please feel free to contact our Privacy Compliance Officer by writing to privacy@pccw.com or GPO Box 9896, Hong Kong.