LCS Support Analyst (Singaporean only)

APBA TG Human Resource Pte Ltd; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

A leading company is seeking a skilled support engineer for a critical role in application support. The ideal candidate will have extensive experience in troubleshooting and production support, particularly in banking environments, and must be ready to work shifts to provide 24/7 support. Strong troubleshooting skills and SQL proficiency are essential for this position.

Qualifications

• At least 5-7 years of experience in troubleshooting applications.
• Strong knowledge in SQL and production support in banking applications.
• Proficiency in Linux/Unix and scripting.

Responsibilities

• Provide 24/7 application support and monitor production systems.
• Troubleshoot performance issues and resolve bugs.
• Ensure SLA compliance and perform continuous system improvements.

Skills

Incident management

Problem management

SQL query optimization

Monitoring tools

Troubleshooting

Production support

Performance tuning

Linux/Unix scripting

GIT

Hadoop

Tools

Grafana

GIT

Bitbucket

Jenkins

Job description

.Job Responsibilities

• Willing to work in shifts to provide rotational 24/7 shift application support duties as mentioned below.

• Has experience or knowledge on Incident and Problem management.

• Health check and monitoring production system and job scheduling to ensure SLA is meet.

• Troubleshoot and solve production issues related to performance and reliability throughout the software stack.

• Proactively identify bottlenecks in the system and work to resolve these issues before they become a problem.

• Continuous improvement of the system, e.g. job automation, performance tuning.

• Should be able to identify and fix the bugs.

• At least 5-7 years of hands-on experience on troubleshooting the applications run on full stack preferably in Java, Spring-boot, Microservices.

• At least 5-7 years of working experience, preferably in Banking or Anti money laundering.

• At least 5-7 years of working experience in production support in banking applications running on Windows and Unix environments.

• L2 Production support experiences must be 5 years above and must be the current/last role.

• Should have strong hold on SQL server/Oracle databases and able to write/debug the SQL programs.

• Good knowledge in Linux/Unix/Windows environment and scripting.

• Hands on experience on monitoring tools like Grafana has added advantage.

• Should be open to learn and adapt to new technologies.

• Knowledge on GIT Bitbucket and Jenkins has added advantage.

• Knowledge on Actimize/Hadoop/AML support experiences has added advantage.

• Investment banking background has added advantage.

Required Technical Skills

• SQL query optimization, including how to check if a query needs optimization, understanding SQL database locking DB locks (splocks), and interpreting query plans.

• The importance of analyzing show plans, logical IO, table scans, and the use of indexes, how the optimizer selects query plans and the impact of removing cache and recalculating indexes.

• Role of indexes in query performance, including the need to ensure index columns are used correctly in queries.

• Use of Unix commands (iostat) and coordination with the storage team.

• Network latency troubleshooting was mentioned, with ping tests used to identify round-trip delays and timeouts (e.g., 100 ms latency).

Shift Timing

• Morning shift: 6am to 3pm

• General shift: 9am to 6pm

• Afternoon shift: 2pm to 11pm

• Night shift: 10pm to 7am

• Need to support including night shift, weekends and public holidays

If you are keen, please email your updated resume to [e-mail]

EA License no. 14C7275/Registration no. R1434860

Please take note that only shortlisted candidate will be contacted. Thank you.