Hong Kong [Change Country] Hong Kong JobsHong Kong Information Technology (IT) JobsHong Kong DBA Jobs Employers / Post Job
[ Log On ]

Database Administrator (AVP)

Job Gallery Consultancy Limited

  • Company Industries:Human Resources Management/Consultancy

Job Information

  • Post Date:2017-07-29
  • Career Level:Middle
  • Location:Not Specified
  • Salary:Salary provided
  • Employment Type:Full Time, Permanent
  • Job Function:DBA  Support  Security  

Job Description

KEY RESPONSIBILITIES

  • Provide on-going application database administration for securities trading and settlement systems as well as other business systems, mainly using SQL Server Enterprise 2014 and Oracle Enterprise 11g. 
  • Deploy production changes on schema, modules and data patches requested from application support team to testing, staging and production environments. Troubleshoot for any database related issues. 
  • Perform regular database maintenance, upgrade and patches. 
  • Monitor the stability of the database systems and maintain high availability. 
  • Perform performance monitoring and optimization. Fine tune the databases, indexes and SQL queries. Review and provide suggestion on underlying hardware specification, RAID and SAN. 
  • Design, implement and enforce database security policy included SQL hardening, user roles, permission, SQL auditing and transparent data encryption etc. Support database audit activities and review regulatory authority security requirements. 
  • Prepare and update database technical documents. Prepare database design specification by reverse engineering from current schemas and know-how with application team. Manage and execute the database backup, data recovery, DR, snapshots and other related features. 
  • Perform physical and logical database designs with application development and support team. 
  • Develop and maintain SQL queries, stored procedures, views and functions on request.
  • Generate ad-hoc reports and query data from database servers as requested by internal users. 
  • Provide technical support, best practices and guidelines for application development and support team. 
  • Research on latest database technologies and recommend improvement from time to time. 
  • Assist in application infrastructure operations e.g. application backup script, application healthiness monitoring, Splunk, VM Ware, Oceanstor SAN …etc.

 

REQUIREMENTS 

  • Bachelor degree in Computer Science or related disciplines. 
  • Minimum 3 years practical experience in MS SQL Server Enterprise 2014 and 1 year experience in Oracle 11G administration. 
  • Hands on development experience in database design, development and analysis.  Working experience in investment bank, brokerage or system vendor is an added advantage. 
  • Exposure to data warehouse, IB and big data technologies.
  • Proficient level of familiarity with application infrastructure operations e.g. Windows Server, Linux, Splunk, VMWare, Oceanstor SAN, application backup script, application healthiness monitoring etc. 
  • Experience in using bug or issue tracking systems is added advantage.
  • Experience in dealing with system vendors, application and infrastructure teams, external parties like P.2 of 2, 5/12/2017 10:45 AM auditor, problems solving and troubleshooting production issues for the database systems. 
  • Able to work overtime for non-office hour deployment or support. 
  • Team player, responsible, independent, self-starter, motivated, multitasking and able to take initiative to get projects completed. 
  • Good command of written and spoken English and Chinese with fluency in Mandarin; knowledge of Simplified Chinese a plus.

 

If you would like to be considered for these career opportunities, please send your updated resume in word format by click “Apply Now” application.

Personal data collected will be used for recruitment purpose only.

Company Info

Our client, a steadily growing Chinese Bank in Hong Kong, is looking for a talent to join them.

Our recruitment consultants will provide tailor-made advice for individual job seeker. 

Apply
Position Company Location Update
Subscribe job alert by email:
Email marketing by Spread