Responsibilities:

Design, develop and deploy the programs, shell batch scripts, complex MSSQL and T-SQL scripts (packages, stored procures, functions, and triggers).

Perform impact analysis for upstream and downstream changes that affect the systems.

Utilize programming methodologies and languages and adhere to coding standards, procedures and technologies while contributing to the technical code documentations.

Participate in design reviews and provide input to the design recommendations; incorporate security requirements into design; and provide input to information/data flow; participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications.

Investigate and troubleshoot the production issues and system problems escalated by IT operation team, identify the root cause, provide workaround to rectify the issue/problem, and work out the long-term solution to fix issues/problems permanently.

Involve in regularly maintenance activities, e.g., yearly DR drill, quarterly support for server or platform software patching, etc.

Provide ad-hoc support for other IT service requests, e.g., data extraction, data alteration, extract system logic, answer to users’ inquiry about the data/logic in the system, etc.

Highlight or escalate risk and issues to relevant parties in a timely manner.

Coordinate production release preparation, provide on-call support and afterhours/weekend support as needed to cover change deployment.

Requirements:

Masters or Bachelor’s Degree in Information Technology, Computer Science, Manage Information Science, Banking and Finance or equivalent.

Min. 2 years’ experience on MS SQL Server development (SSIS packages, stored procedures, functions, triggers).

In-depth understanding of database management systems.

Familiar with Software Development Life Cycle (SDLC) process.

Possess problem-solving ability and work well in a challenging technical environment, with capability to multi-task whilst delivering high quality solutions.

Strong communication and influencing skills.

To apply, please visit www.gmprecruit.com and search for Job Reference: 25009

To learn more about this opportunity, please contact Yingying at yingying.lai@gmprecruit.com

We regret that only shortlisted candidates will be notified.