Job Responsibilities

• Perform impact analysis for upstream and downstream changes that affect the systems.
• Utilize programming methodologies and adhere to coding standards, procedures and technologies while contributing to the technical code documentations.
• Design, develop and deploy the programs, shell batch scripts, complex MSSQL and T-SQL scripts (packages, stored procures, functions, and triggers).
• Follow the organizational SDLC processes to deliver the project or enhancement requests, create/update the SDLC documents including functional and non-functional specifications, technical design documents, test plan, test cases, release procedures, system operational documents, user manuals etc.
• 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.
• Manage, maintain, and support applications and the corresponding operating environments, focusing on stability, quality, and functionality against service level expectation.
• Evaluate the current system state, identify aspects which could be improved and recommend changes to achieve the improvement.
• Coordinate production release preparation, provide on-call support and afterhours/weekend support as needed to cover change deployment.
• Highlight or escalate risk and issues to relevant parties in a timely manner.

Job 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).
• 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.
• In-depth understanding of database management systems.