Connecting...

Database Administrator (MS SQL)

Job Title: Database Administrator (MS SQL)
Contract Type: Contract
Location: Hong Kong, Hong Kong
Industry:
Salary: neg
Start Date: ASAP
Reference: 178673_1559638291
Contact Name: Alice Tong
Contact Email: alice.tong@peoplebank.asia
Job Published: June 04, 2019 16:51

Job Description

Our Insurance Client is seeking for MS SQL and SSIS talents for the role as below:

Responsibilities:

  • Advise on the design of the Integration layer to allow for scalability and flexibility
  • Incorporate error handling and audit trail activities into the design
  • Design codes which are reusable and subjected to minimal modification when reuse
  • Advise on the database design and creation of reference table
  • Automate the data feed between source system and destination (and vice versa)
  • Design and writing script on the SSIS platform
  • Perform SQL programming based on the business rules defined
  • Writing stored procedure to automate the script
  • Prepare technical specification and design document
  • Design batch program and execute job on the Window Scheduler
  • Embedded encryption into the data file

Candidate Specifications:

  • University degree in Computer Science, Information Technology or related subjects
  • 5+ years working experience, of which more than 3 years in-depth SQL programming & SSIS exposure
  • Advanced problem determination and resolution skills
  • Effective written and oral communication in English

Technical Skills:

  • MS-SQL administration including SSIS and SSRS
  • Advanced SQL skill & design script on SSIS platform
  • Exposure of cloud technology
  • Good understanding of PGP 6 encryption program
  • Knowledge in Sun GL 4.x/6.x is added advantage
  • Knowledge in Workday is added advantage
  • Experience in supporting SFTP data transfer is an advantage
  • Experience in Azure Data Factory and Azure SSIS would be an added advantage

Interested parties please send your resume by Apply Now.