6-8 years experience as Application Support Analyst with 4 years working in a 24x7 Ability to investigate high priority tickets and provide timely updates to Client.
Should have good written and Oral communication skills to interact with Onsite and Client.
Should have good knowledge in SQLs as the project will require scripts to be formed for any data fix or for any utility
Should have positive knowledge in AS400 Cobol
Open to work in shifts and provide On call support Willing to work weekends for Product Releases
Should be able to support month end or Year end batches as per the allotted schedule
Mandatory Skills Working knowledge of Oracle SQL Able to build ad hoc SQL queries Working knowledge of MainframeAS400 Cobol
Key Responsibilities
Support the Unitrax unit holder or record keeping system
Programming languages required are COBOL CLLE SQL
The unitholder or record keeping system runs on IBMi or POWER system
Provide support to internal and external technology and business groups
Communicate directly with end user clients regarding application and system issues Defect recreation
Analyze database logical and physical structures
Create Query SQL and SEQUEL database views
Fund SERV experience a strong asset
Ad hoc query SQL creation for data analysis which is used for troubleshooting and data correction
Debug embedded SQL COBOL ILE programs
Recommend modifications to the existing programs and to the AS400 applications
Document defect corrections On call support on a rotation schedule
Work with team to resolve tickets on priority through defined process and escalation matrix
Coordinate with various client stakeholders to provide technical solutions
Triage issues and provide short term and long term solutions
Speak through the solution with Client and provide insights into entire chain of events and plan for resolution
Perform root cause analysis and work hands on to guide through the problem and incident management process
Coordinate with offshore and other global teams
Provide creative solutions to customer problems to ensure customer satisfaction
Ability to exercise judgment using procedures and practices to determine the appropriate course of action
Excellent analytical and communication skills
Support application Releases and change management functions
Provide support for monitoring of applications logs feeds issue tickets
Should be able to articulate the problem and provide a step-by-step approach to problem and incident management