The incumbent is responsible to design, develop and implement AR and FRDMP programs, scripts, batch jobs for AR/ FRDMP systems. He/she will work with stakeholders across various functions to deliver technology solutions to address their business needs.
Job Responsibilities
- 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.
- 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.
- Strong communication and influencing skills.
