Specialist - System Management

LTM; Mississauga; On-site; CAD 90,000 - 110,000; Full time

Benefits offered by this job

Medical plan

Health Spending Account

Disability insurance

Life insurance

Vacation and leaves

Maternity leave top-up

Job summary

LTIMindtree Canada seeks a Sr. Application Support Analyst in Mississauga, ON to investigate high-priority tickets, provide timely client updates, and support 24x7 operations.

You will work with Oracle SQL, COBOL on AS/400 (IBMi), and CLLE, participate in month-end/year-end cycles, and occasionally weekend releases while coordinating with offshore and client teams.

Qualifications

• 6+ years experience as Application Support Analyst with 2 years in 24x7 support.
• Strong written and spoken communication with onsite and client teams.
• Proficient in SQL and scripting for data fixes and utilities.

Responsibilities

• Support Unitrax unitholder or record keeping system.
• Programming languages required are COBOL CLLE SQL.
• Runs on IBMi or POWER systems.
• Provide support to internal and external technology and business groups.
• Communicate with end users regarding issues; perform defect recreation.
• Analyze database structures; test stored procedures, views.

Skills

Oracle SQL

SQL

COBOL

AS400

Job description

Role Description

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.

Other Details

Vacancy Type: New Vacancy

Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree Canada ("LTIMC"):

Benefits And Perks

• Comprehensive Medical Plan Covering Medical, Dental, Vision
• Health Care Spending Account
• Short Term and Long-Term Disability Coverage
• Life Insurance
• Annual vacation and other Paid Leaves
• Maternity Leave Top Up Pay

The range displayed on each job posting reflects the total compensation range for the position across all Canada locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.

Disclaimer: The compensation and benefits information provided herein is accurate as of the date of this posting.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family-care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.

Accessibility and Reasonable Accommodation: LTIMindtree has an accommodation process in place and provides accommodations for applicants with disabilities. If you require a specific accommodation because of a disability or a medical need, please write to us at [e-mail] so that arrangements can be made for the appropriate accommodations to be in place.