Senior Analyst - Technical Services
- Hong Kong
- Permanent, Full time
- Linedata Services (H.K.) Ltd
- 13 Apr 19
The Technical Services Consultant role requires a blend of technical ability and client facing skills. The responsibilities are split into three main areas, DR, ASP and DBA with a particular focus on the Linedata Global Hedge suite of software but also other Linedata products. Pre-emptive monitoring and problem solving are encouraged as much as reactive and proactive troubleshooting.
DBA – Database Administration:
· Maintain a good knowledge of Oracle databases including 11g, 12c and 18c
· Troubleshoot issues that arise with the Oracle database both internally on development and testing platforms and at client sites.
· Performance tune Linedata solutions running on Oracle on internal platforms and at client sites. Mainly, but not exclusively, PL/SQL and SQL tuning.
· Maintain a good knowledge of Oracle tuning tools and techniques.
· Research new technologies released by Oracle and see how they can be leveraged by Linedata products
· Maintenance and programming of installation disks for Linedata products, including Oracle installation.
· Maintenance of housekeep and healthcheck packages.
· Ad hoc project work for clients, including but not restricted to, upgrade work and platform migrations.
· Documentation of DBA procedures.
ASP – Application service provider:
· Maintain a good knowledge of Windows and Citrix administration
· Daily monitoring checks on various ASP servers
· Troubleshoot issues on the ASP servers, including database servers (Oracle), application servers (windows services) and Citrix servers.
· Implementation of new ASP clients.
· Upkeep of monitoring tools and documentation.
· Documentation of ASP procedures.
DR – Disaster Recovery:
· Maintain a good knowledge of Oracle disaster recovery and high availability tools and techniques including RMAN and Dataguard.
· Maintain a good knowledge of disaster recovery solutions implemented using CA Arcserve/Xosoft and Doubletake.
· Troubleshoot issues with any of the Linedata disaster recovery solutions.
· Daily monitoring checks on the Linedata disaster recovery solutions
· Installation of Linedata disaster recovery solutions.
· Development of new disaster recovery solutions.
· Documentation of disaster recovery procdures.