Specialist - System Management

Job Title: Sr. Application Support Analyst

Work Location:

Mississauga, ON

Job ID:

1476786

Job Description:

·       6 years experience as Application Support Analyst with 2 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 AS400 Cobol.

Key Responsibilities:

·       Support the Unitrax unitholder 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.

·       Test stored procedures database functions database triggers.

·       Create Query SQL and SEQUEL database views.

·       FundSERV 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 step by step approach to problem and incident management.