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.