Consultant, Production Application Support

CIBC•Toronto, ON

1d•Hybrid

About The Position

As a Consultant, Production Application Support, you'll play a key role in supporting MS SQL databases across CIBC's technology landscape. You'll provide expertise in database builds, application deployments, migrations, performance tuning, and incident resolution. You'll collaborate with application owners, developers, and various CIBC Technology groups, including Solution Design, DB Engineering, Information Security, and external vendors. Your insights will help shape database standards and best practices, ensuring solutions are tailored to specific application needs. You'll work closely with project managers to develop implementation plans and oversee database upgrades and cross-platform migrations in both on-premises and cloud environments. Additionally, you'll develop automation scripts for code deployment and database migrations, embracing Agile methodologies to drive automation, project deliverables, and daily operations. Using tools like Dynatrace you'll quickly resolve performance issues for business-critical applications and manage day-to-day operational activities, including escalations and 24x7 production support.

Requirements

Hands-on experience with Azure Monitor, Log Analytics, Application Insights, and Dynatrace for integrated performance tracking, analysis, and proactive management.
Understand security and disaster recovery best practices.
Knowledgeable about advanced security features in Azure SQL, including auditing, threat detection, managed identities, user access management, and disaster recovery strategies such as geo-replication within Azure SQL PaaS environments.
Analytical Thinking
Application Production Support
Brokerage Services
Business Requirements
Identifying Opportunities
Impact Analysis
Implementation Planning
IT Operations Support
Technical Knowledge
Work Collaboratively

Nice To Haves

You can easily adapt to new tools and trends.
You know that details matter.
Your critical thinking skills help to inform your decision making.
You put our clients first.
You engage with purpose to find the right solutions.
You go the extra mile, because it's the right thing to do.
Values matter to you.
You bring your real self to work and you live our values - trust, teamwork, and accountability.

Responsibilities

Monitor and optimize performance of Azure SQL databases, including large databases (40TB+), and resolve issues related to query plan regressions, parameter sniffing, cardinality estimation changes, query timeouts, and blocking.
Utilize Query Store and analyze execution plans to identify and resolve bottlenecks, perform query performance tuning, and ensure efficient T-SQL code practices.
Collaborate with developers to analyze workload patterns and optimize database interactions.
Address and resolve high resource contention issues to ensure optimal database performance.
Assist in capacity planning, scaling, and resource allocation based on application demand and performance metrics.
Apply a thorough understanding of indexes, statistics, and recompilation to diagnose and resolve performance challenges.
Conduct root cause analysis for recurring or critical incidents impacting application operations.
Apply deep knowledge of Azure SQL Platform-as-a-Service (PaaS) limitations, capabilities, and best practices for performance management.
Troubleshoot and resolve issues related to DTU/vCore, Hyperscale resource allocation, throttling, and scaling.
Act as a liaison with business partners, technology teams, senior management, and internal and external clients.
Keep stakeholders informed of team mandates, policies, and relevant legislation changes, while promoting the products and services of the Channel Support area.
Serve as a subject matter expert in assessing impacts for planned system changes and projects, ensuring compliance with organizational standards (Business, Continuity, Security, Compliance, and Privacy).
Develop and maintain productive relationships with Technology, QA, and Project teams.
Research, analyze, and support the implementation of new or revised policies, procedures, and standards, and provide recommendations on system outages and issues.

Benefits

competitive salary
incentive pay
banking benefits
a benefits program
defined benefit pension plan
an employee share purchase plan
a vacation offering
wellbeing support
MomentMakers, our social, points-based recognition program
Purpose Day; a paid day off dedicated for you to use to invest in your growth and development