Server jobs in Canada

Work Location:
Toronto, Ontario, Canada

Hours:
37.5

Line of Business:
Technology Solutions

Pay Details:
$76,800 - $115,200 CAD

This role is eligible for a discretionary variable compensation award that considers business and individual performance.

TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs.

Job Description:

Department Overview

TD Securities offers a wide range of capital markets products and services to corporate, government, and institutional clients who choose us for our innovation, execution, and experience.

With more than 6,900 professionals operating out of 32 cities across the globe, we help clients meet their needs today and prepare for tomorrow. Our services include underwriting and distributing new issues, providing trusted advice and industry-leading insight, extending access to global markets, and delivering integrated transaction banking solutions. In 2023, we acquired Cowen Inc., offering our clients access to a premier U.S. equities business and highly-diverse equity research franchise, while growing our strong, diversified investment bank.

We are growth-oriented, people-focused, and community-minded. As a team, we work to deliver value for our clients every day.

Job Description:

We are seeking an experienced Application DBA with a strong background in Oracle and SQL Server databases to join our Platform OPS team. This individual will play a critical role in guiding application support teams during database incidents, reviewing database upgrades, and evaluating database migration changes. Additionally, the candidate will be responsible for reviewing and suggesting standards for database run books. Will have extensive knowledge of database architecture, including Backup, High Availability (HA), Disaster Recovery (DR), Performance tuning, and data archiving strategies. Will need periodic on-call support and shift work required.

Job Requirements:

• Proven experience in managing and administering Oracle and SQL Server databases.
• Experience with cloud environments, especially Azure and Oracle Exadata.
• Ability to lead and mentor application support teams during database incidents.
• Strong analytical and troubleshooting skills.

Required Skills:

• Oracle Database Administration: Experience with Oracle 12c, 19c, and higher versions.
• SQL Server Administration: Experience with MS SQL Server 2012, 2014, 2016, 2019, and higher versions.
• High Availability (HA): Experience with Oracle RAC, SQL Server Always On Availability Groups, and clustering.
• Disaster Recovery (DR): Knowledge of Oracle Data Guard, SQL Server Log Shipping, and Always On Availability Groups for DR setup.
• Backup and Recovery: Experience with RMAN for Oracle, SQL Server native backup, and third-party backup tools like Veritas NetBackup.
• Performance Tuning: Proficient in SQL query optimization, execution plans, indexing strategies, and database performance tuning for both Oracle and SQL Server.
• Database Migration: Experience with database upgrades, patching, and migrations between Oracle versions and SQL Server versions, as well as moving databases to the cloud (Azure, Exadata).
• Cloud Platforms: Hands-on experience with Oracle Exadata Cloud and Azure SQL Database.
• Monitoring Tools: Proficiency in Oracle Enterprise Manager (OEM), Foglight for SQL Server, and other monitoring tools like Splunk and Dynatrace.
• Partitioning: Advanced knowledge of partitioning strategies in Oracle (range, list, hash partitioning) and SQL Server (table partitioning).
• Automation and Scripting: Experience in writing SQL scripts, PL/SQL, and T-SQL for automation of DB tasks, maintenance, and monitoring.
• Security Management: Understanding of database security models, user management, roles, privileges, and access control for Oracle and SQL Server.
• Troubleshooting: Ability to troubleshoot complex database issues, including performance bottlenecks, replication issues, and resource contention.
• Tools for Health Checks: Familiarity with tools like AWR, ASH, SQL Profiler, and Extended Events for performance diagnostics in Oracle and SQL Server.
• Log Management and Analysis: Experience in log analysis using Splunk and Dynatrace for monitoring database health and application performance.
• Excellent communication skills to work with cross-functional teams.

Qualifications:

• 10+ years of experience in Oracle and SQL Server database administration.
• 2+ years of experience with monitoring tools like OEM, FogLight, Splunk, and Dynatrace is a plus.
• 2+ years of experience with cloud technologies such as Azure and Oracle Exadata.

Additional Information:

Join in on what others in TD Technology Solutions are doing:

• Inspire a positive work environment and help champion quality, innovation, teamwork, and service to the business.
• Learn voraciously, stretch your thinking, share your knowledge and educate others.
• Communicate and collaborate with both technical and non-technical professionals.
• Cultivate winning relationships by building trust with business and technology partners.
• Share our commitment to productivity, effectiveness, and operational efficiency.
• Embrace change and witness amazing things happen - from the inside.

Who We Are:

TD Securities offers a wide range of capital markets products and services to corporate, government, and institutional clients who choose us for our innovation, execution, and experience. With more than 6,500 professionals operating out of 40 cities across the globe, we help clients meet their needs today and prepare for tomorrow. Our services include underwriting and distributing new issues, providing trusted advice and industry-leading insight, extending access to global markets, and delivering integrated transaction banking solutions.

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.

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.

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!