Application Support-SQL

Support Engineer

The Support Engineer will be responsible for providing technical support for the Risk Management System (RMS) product, ensuring that both internal and external users can resolve issues quickly and efficiently. This role involves troubleshooting technical problems, providing solutions, and collaborating with engineering and QA teams to enhance the product. Additionally, the Support Engineer will assist with user training, monitor system performance, and contribute to continuous product improvement. 

Roles and Responsibilities

• Act as the first point of contact for users experiencing issues with the RMS platform, both internally and externally. 
• Troubleshoot and resolve product-related issues, ensuring minimal disruption to users. 
• Collaborate with product and engineering teams to identify and resolve recurring technical problems and escalate more complex issues. 
• Document support tickets, ensuring detailed tracking of issues, resolutions, and feedback. 
• Provide training and guidance to users on how to effectively use the RMS system.
• Ensure customer satisfaction by providing timely and effective solutions to any issues faced by users. 
• Assist in the preparation of knowledge base articles, user documentation, and FAQs to empower users to resolve minor issues independently.
• Respond to user queries in a friendly and professional manner, ensuring clear communication. 
• Proactively follow up with customers to ensure issues are resolved to their satisfaction.

Required Skills

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field. 
• Prior experience in software support preferably in a fintech or financial services environment. 
• Experience with troubleshooting software and hardware issues in a production environment.
• Hands-on experience with common support/ticketing tools (e.g., JIRA, Bugzilla, Selenium, Postman, etc.).
• Ability to manage multiple priorities and deliverables in a fast-paced environment.
• Familiarity with databases like SQL.

ROLE:  

Address technical issues relating to software implementation, function, and upgrades. Resolve customer complaints or problems and create product problem reports and troubleshoot documents for each issue. Work closely with application support and development teams to identify and resolve any technical problems that might arise during the development of software. Work with Implementation teams and Account managers to recommend solutions to new customer implementations and workflows.  

ESSENTIAL DUTIES and RESPONSIBILITIES: 

• Understanding the PeopleScout architecture and framework  
• Provide L2 support for tickets passed on by L1 support team using advanced knowledge of Java, SQL, Stored Procedures, Functions, and database development.  
• Analyze and understand Java code to debug, trace, and communicate technical issues effectively with the Development team.  
• Review application logs, perform exception analysis, monitor system performance, and identify root causes to ensure timely issue resolution and optimal application performance.
• Provide technical support to application support team
• Develop solutions to complex customer and software problems
• Assist with software design and development  
• Work within an agile environment  
• Deliver sprint commitments on time
• Be responsible for your own code, and work with others to improve the quality and deliver of theirs  
• Document troubleshooting guides and outcomes of problems, analysis and solutions for future re-use  

MUST HAVE SKILLS: 

• 5 to 8 years of experience in L2 Application Support, preferably supporting SaaS products.
• Strong troubleshooting skills with Java applications, SQL, and REST APIs.  
• Strong hands-on experience with Core Java (Java 8 or above).  
• Good understanding of Spring Boot and Java-based enterprise applications.
• Experience troubleshooting production issues, performing root cause analysis (RCA), and resolving incidents within SLA  
• Strong SQL skills with databases such as Oracle, MySQL, PostgreSQL, or SQL Server.  
• Experience working with REST APIs, JSON, and API testing tools like Postman.
• Ability to analyze application logs using tools such as Splunk, Kibana, ELK, or Grafana.
• Excellent customer communication skills with experience managing client interactions and providing timely updates.
• Familiarity with ServiceNow/Jira, Linux basics, and log analysis for application support