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.

Get similar jobs like these by email

By submitting your details you agree to our T&C's