Application DBA Support Specialist, TD Securities

As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.

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 performancedevelopment teams on advanced database topics
• 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.

#LI-Tech

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. 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.

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.

Please be advised that this job opportunity is subject to provincial regulation for employment purposes. It is imperative to acknowledge that each province or territory within the jurisdiction of Canada may have its own set of regulations, requirements.

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 (Quebec only):
Sans Objet