Application Support Analyst -.NET & SQL Specialist

TEEMA Solutions Group; Toronto; Hybrid; CAD 75,000 - 95,000; Full time

Job summary

A leading company seeks an Application Support Analyst to provide level 2 support for their Wealth Management systems. The role involves troubleshooting, incident management, and collaborating with technical teams. Candidates should have strong SQL skills and experience in financial services. This hybrid position allows for remote work three days a week.

Qualifications

• 6+ years of technical support experience, preferably in Banking/financial systems.
• Proficient in writing SQL queries and using ticketing tools like JIRA.
• Comfortable troubleshooting complex application and database issues.

Responsibilities

• Provide technical support for Wealth systems and manage incident tickets.
• Monitor system performance and implement preventative solutions.
• Assist in deploying system patches and create support documentation.

Skills

SQL

Technical Support

Troubleshooting

Powershell

JIRA

Python

C#

Education

Bachelor’s degree in Information Technology

Tools

SQL Server

ServiceNow

Job description

Application Support Analyst- Level 2 support (SQL,.NET, Powershell scripts, JIRA)

We are seeking a skilled Technical Support Analyst with solid SQL queries experience within Banking/ Financial sector to join our team and support our core Wealth Management systems, including the Book of Record and Trading Systems applications. In this role, you'll troubleshoot technical issues, manage support tickets, collaborate with cross-functional teams, and help maintain the stability and performance of critical financial platforms.

Screening Questions:

1) What is your experience working with Jira or Confluence (for team documentation) including usage at an Administration level?

(e.g. creating automation like auto closing tickets under a certain status after a specific period of time, giving access to sites to specific users, setting up sites for use by a team)

2) What is your experience with SQL Server and have you reviewed an execution plan? explain what you would use the execution plan for.

3)Describe your experience with Powershell scripts, Windows Batch scripting or Python experience? Provide an example.

4) Provide your experience working with ticketing systems such as Service Now or JIRA? Are you familiar with creating dashboards from those tools?

5) Do you have any C#.net Development experience?

6) Have you been involved in deploying back end code patches to test and/or production? If yes, what steps do you typically follow for a code deployment to ensure it was successful?

7) Do you do any stock trading? or mutual fund trading? If yes, what do you look for when purchasing these investments?

Key Responsibilities

Provide day-to-day level 2 technical support for Wealth systems

Troubleshoot application, integration, and database-related issues

Manage and resolve incident tickets using ServiceNow, JIRA, or similar tools

Monitor system performance and implement preventative solutions

Assist in deploying system patches and data fixes

Create and maintain user documentation and support materials

Collaborate with business, development, and infrastructure teams

Deliver regular reports on system health and ticket metrics

Required Qualifications

Bachelor’s degree in Information Technology, Computer Science, or equivalent experience

6+ years of technical support experience, preferably in Banking/financial or wealth management systems

C# or Python development (Nice to have)

Proficient in writing SQL queries, upgrade stored procedures :

Support ticketing tools (ServiceNow, JIRA)

Microsoft SQL Server or similar query tools a must

Troubleshooting complex application, server, and database issues

Strong communication skills (verbal and written)

Experience with incident management and root cause analysis

Comfortable working collaboratively across teams

Maintain and update technical documentation including troubleshooting guides, knowledge base articles and best practices in MS OneNote and/or Confluence.

What You’ll Do

Provide day-to-day level 2 support for trading systems applications

Write SQL Queries, upgrade stored procedures, deploy systems patches, create reports

Troubleshoot application, integration, and database issues to minimize downtime

Manage and resolve support tickets using ServiceNow, JIRA, or similar platforms

Work closely with technical and business teams to deploy system patches and fix bugs

Maintain support documentation, including user guides and troubleshooting resources

Preferred Qualifications

Background in Banking , financial services or wealth management

Familiarity with Python, C#.net development , Agile or other project management frameworks

Knowledge of financial regulations and compliance standards

This is a rewarding hybrid role- 3 days to work from downtown Toronto office.Connect with us on LinkedIn to explore more opportunities!

https://www.linkedin.com/company/talenttohire