Positive to Have Skills : Mainframe Enterprise Cobol, MS SQL Server, MySQL
Job Description
- 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 good 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