Sr. IT Support Analyst

Posted:
9/25/2024, 12:36:25 AM

Location(s):
Ontario, Canada ⋅ Toronto, Ontario, Canada

Experience Level(s):
Senior

Field(s):
IT & Security

Work Location:

Canada

Hours:

37.5

Line of Business:

Technology Solutions

Pay Details:

We’re committed to providing fair and equitable compensation to all our colleagues. As a candidate, we encourage you to have an open dialogue with a member of our HR Team and ask compensation related questions, including pay details for this role.

Job Description:

About This Role

We are looking for someone with diverse skills and background with Microsoft SQL database administration to carry out broad range of operational database activities ranging from database administration, performance tuning, high availability, monitoring and capacity management.

Meaningful work is fueled by meaningful performance and career development conversations with your manager. Here's some of what you may be asked to perform:

  • Support applications and database infrastructure by meeting or exceeding standards and service levels while minimizing operational risk.

  • Partner closely with stakeholders to improve production environment stability.

  • Actively involved on all aspects of support and application issue resolution: identify, assess, recommend, escalate, resolve, report, document and communicate.

  • Strong focus on problem determination including data gathering and analysis.

  • May develop scripts using appropriate tools to automate, address gaps, simplify or enhance the application/system or environment.

  • Provide quality service and solutions consistent with objectives and client requirements.

  • Dive into design, review, and integration of all application requirements like functional, security, integration, performance, quality and operations.

  • Identify, address application/ data issues, cross-capability and cross-release issues that affect application and database integrity.

  • Provide expertise to other functional areas (technology, trends and processes).

  • Follow change management procedures. ensure proper testing, sign-off, monitoring.

  • Participate in disaster recovery planning (Define, Review, Test).

  • Strive to improve production environment stability by working with others to set up, maintain and monitor databases/applications, while meeting availability targets.

  • Follow established processes/standards, business technology architecture, risk and production capacity guidelines; plan, monitor and escalate issues as required.

  • Actively work with business users to provide guidance on best practices for writing SQL queries.

  • Review database reports and provide solutions to improve database performance.

Job Requirements :

What can you bring to TD? Share your credentials, but your relevant experience and knowledge can be just as likely to get our attention. It helps if you have:

  • Undergraduate Degree or Technical Certificate.

  • 5-7 years application support experience

  • Azure certification preferred.

  • Good understanding of cloud infrastructure and microservices.

  • Microsoft SQL server experience and skills with T-SQL and SQL scripting.

  • Knowledge of API, Json and XML.

  • Understanding of Azure database design concepts and best practices

  • Knowledge of Data Studio, Data Bricks, Data Lake and Data Factory

  • Scripting and automation experience with PowerShell, Python, JavaScript or other scripting languages.

  • Experience with Windows Server and Windows Clustering

  • Solid understanding of database backup and recovery

  • Ability to work independently in a senior/lead role on a diverse range of tasks and may be relied upon to coach/ educate others.

  • Strong subject matter expertise, as you prepare to provide clients, team, and/or project team with technical guidance and assist with highly complex troubleshooting/problem resolution.

  • Strength in identifying root causes and implementing targeted and controlled remediation plans.

  • Readiness to review, participate in and implement procedures.

  • Strength in consulting with other functional areas to provide technical expertise on area of specialization by acting as a reference on technology, trends and processes related to your own area.

  • Strong interpersonal communication skills and can work effectively with vendors to fulfill support requirements.

  • Possession of effective change management discipline.

  • Willingness to work effectively as a team, helping others to resolve critical service issues.

  • Interest and drive to enhance knowledge/expertise by staying abreast of industry and business trends, research industry standards, best practices and new innovations, make recommendations.

  • Confidence acting as a reference for team members or clients.

  • Inspire a positive work environment and help champion quality, innovation, teamwork and service to the business.

Who We Are:

TD is one of the world's leading global financial institutions and is the fifth largest bank in North America by branches/stores. Every day, we deliver legendary customer experiences to over 27 million households and businesses in Canada, the United States and around the world. More than 95,000 TD colleagues bring their skills, talent, and creativity to the Bank, those we serve, and the economies we support. We are guided by our vision to Be the Better Bank and our purpose to enrich the lives of our customers, communities and colleagues.

TD is deeply committed to being a leader in customer experience, that is why we believe that all colleagues, no matter where they work, are customer facing. As we build our business and deliver on our strategy, we are innovating to enhance the customer experience and build capabilities to shape the future of banking. Whether you’ve got years of banking experience or are just starting your career in financial services, we can help you realize your potential. Through regular leadership and development conversations to mentorship and training programs, we’re here to support you towards your goals. As an organization, we keep growing – and so will you.

Our Total Rewards Package
Our Total Rewards package reflects the investments we make in our colleagues to help them and their families achieve their financial, physical, and mental well-being goals. Total Rewards at TD includes a base salary, variable compensation, and several other key plans such as health and well-being benefits, savings and retirement programs, paid time off, banking benefits and discounts, career development, and reward and recognition programs. Learn more

Additional Information:
We’re delighted that you’re considering building a career with TD. Through regular development conversations, training programs, and a competitive benefits plan, we’re committed to providing the support our colleagues need to thrive both at work and at home.

Colleague Development
If you’re interested in a specific career path or are looking to build certain skills, we want to help you succeed. You’ll have regular career, development, and performance conversations with your manager, as well as access to an online learning platform and a variety of mentoring programs to help you unlock future opportunities. Whether you have a passion for helping customers and want to expand your experience, or you want to coach and inspire your colleagues, there are many different career paths within our organization at TD – and we’re committed to helping you identify opportunities that support your goals.
 

Training & Onboarding
We will provide training and onboarding sessions to ensure that you’ve got everything you need to succeed in your new role.

Interview Process 
We’ll reach out to candidates of interest to schedule an interview. We do our best to communicate outcomes to all applicants by email or phone call.


Accommodation
Your accessibility is important to us. Please let us know if you’d like accommodations (including accessible meeting rooms, captioning for virtual interviews, etc.) to help us remove barriers so that you can participate throughout the interview process.

We look forward to hearing from you!

Language Requirement:

N/A.