Application Support Analyst (Mainframe - Cobol)

Cloudious LLC; Mississauga; Hybrid; CAD 80,000 - 95,000; Full time

Job summary

Cloudious LLC is seeking an experienced Application Support Analyst for a hybrid role in Mississauga. Candidates must have 6-8 years in application support, strong AS400 Cobol skills, and the ability to provide on-call support. Responsibilities include supporting a unit holder system, communicating with clients about application issues, and performing SQL analysis. This position offers the opportunity for growth and collaboration within a dynamic team environment.

Qualifications

• 6-8 years experience as Application Support Analyst with 4 years in a 24x7 environment.
• Good written and oral communication skills to interact with clients.
• Knowledge in SQL for data fixes and utility scripts.
• Open to work in shifts, including weekends for product releases.

Responsibilities

• Support the Unitrax unit holder or record keeping system.
• Provide support to internal and external technology and business groups.
• Analyze database logical and physical structures.
• Communicate directly with end users regarding application and systems issues.
• Perform root cause analysis and coordinate with various client stakeholders.

Skills

AS400 - Cobol

Mainframe Admin

Mainframe DB2

Mainframe Enterprise Cobol

MS SQL Server

MySQL

Job description

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

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