Application Support Analyst; Mainframe - Cobol

Location: Mississauga, ON - Hybrid Role (3 days a week)

Type: Full-Time

Start Date: ASAP

Mandatory Skills : AS400 - Cobol, Mainframe Admin, Mainframe DB2

Good to Have Skills : Mainframe Enterprise Cobol, MS SQL Server, MySQL

• 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 Mainframe AS
  400 Cobol

• Support the Unitrax unit holder or record keeping system
• Programming languages required are COBOL CLLE SQL
• The unit holder 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