The Team Leader, Production Support DBA, is responsible for leading a high‑performing DBA production support team delivering 24x7 mission‑critical database services across on‑premise and cloud platforms . This role requires very strong hands‑on technical expertise , deep production troubleshooting skills , and proven people leadership to ensure high availability, performance, observability, and resilience of enterprise databases.

The Team Leader acts as the technical escalation point , leads major production incidents , participates in all MIRT bridges , and drives proactive monitoring, prevention, and automation across the database estate.

Key Responsibilities Production Database Support & Operations

• Lead and oversee production database support for on‑premise and cloud platforms, ensuring stability, availability, and performance.
• Serve as the highest technical escalation for complex production issues, including Sev‑1 / Sev‑2 incidents.
• Lead major production incidents and actively participate in every MIRT bridge, driving fast restoration and clear communication.
• Perform deep‑dive root cause analysis (RCA) and ensure permanent fixes are implemented.
• Own incident, problem, and change management processes related to databases.

Database Platforms Supported Provide expert‑level support and leadership for:

• Microsoft SQL Server (on‑prem, Azure SQL Database, Azure SQL Managed Instance)
• PostgreSQL (on‑prem and cloud)
• Oracle
• IBM Db2
• Netezza
• AWS RDS
• Amazon Redshift

Performance Tuning & Troubleshooting

• Lead advanced production troubleshooting across all supported database platforms.
• Drive performance tuning initiatives including SQL tuning, indexing strategies, memory/IO optimization, and workload analysis.
• Review and optimize database configurations for high throughput, low latency, and scalability.
• Guide the team in resolving complex locking, deadlock, replication, backup, recovery, and corruption issues.

High Availability, Resiliency & Observability

• Work with engineering, application, and infrastructure teams to design and maintain high availability (HA) and disaster recovery (DR) architectures.
• Ensure databases meet RTO/RPO objectives and resilience standards.
• Lead the implementation and continuous improvement of monitoring, alerting, and observability across the database ecosystem.
• Proactively identify risks and implement preventative controls to reduce production incidents.

Automation & Engineering Excellence

• Drive automation‑first mindset for database operations.

• Lead development and maintenance of Ansible playbooks for database monitor

• Promote scripting and automation using:

• Linux shell scripting

• Windows PowerShell

• Reduce manual effort and operational risk through standardized, repeatable automation.

Team Leadership & People Management

• Lead, mentor, and develop a production DBA team, fostering strong technical depth and operational excellence.
• Assign work, set priorities, and ensure on‑call coverage and operational readiness.
• Coach team members during major incidents and post‑incident reviews.
• Promote collaboration across DBA, application, cloud, infrastructure, and SRE teams.
• Build a culture of accountability, continuous improvement, and knowledge sharing.

Required Technical Skills (Very Strong / Expert Level) Database Technologies

• Microsoft SQL Server
• PostgreSQL
• Oracle
• IBM Db2
• Netezza
• AWS RDS
• Amazon Redshift
• Azure SQL Database
• Azure SQL Managed Instance

Operating Systems & Scripting

• Linux (expert level) – troubleshooting, performance analysis, OS‑level tuning
• Shell scripting (bash/ksh)
• Windows PowerShell

Automation & Configuration Management

• Ansible playbook development
• Infrastructure and database automation for production environments

Production Support Expertise

• Very strong production troubleshooting
• Performance tuning and optimization
• Backup, recovery, HA/DR
• Monitoring, alerting, observability
• Incident, problem, and change management

Leadership & Soft Skills

• Proven team leadership in a production support environment
• Ability to lead under pressure during major production incidents
• Strong collaboration and stakeholder management skills
• Clear communication on MIRT bridges and executive updates
• Strong ownership mindset with focus on reliability and prevention

Preferred Qualifications

• Experience supporting large‑scale enterprise databases
• Strong understanding of hybrid cloud architectures
• Experience implementing enterprise monitoring and observability tools
• Experience in financial services or highly regulated environments

Success Measures

• Reduction in incidents
• Improved database availability and performance
• Strong RCA quality and prevention effectiveness
• High automation coverage and reduced manual work
• Strong team engagement and technical capability growth

NOTE: This role requires 2/3 days a week in the office. Salary: $75,900.00 - $141,900.00

Pay Type: Salaried

The above represents BMO Financial Group’s pay range and type.

Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part-time roles will be pro-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.

BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total-Rewards

About Us At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in-depth training and coaching, to manager support and network-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://jobs.bmo.com/ca/en

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.