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

Mandatory Skills : Major incident management, Problem Management, Resource Management, Stakeholder Management Good to Have Skills : Knowledge Management, Schedule Management, Scope & Change Management, ServiceNow ITSM, ServiceNow(ITOM ITSM and other) Functional Testing