JOB DESCRIPTION:

Provide broad range of research, installation, maintenance, configuration, administration and/or provisioning of systems/applications. May also be involved in deployment and release management activities.

EXPERIENCE & EDUCATION

• Lead and optimize Azure SQL Managed Instance and SQL Server databases to ensure high performance and availability.
• Lead database migration projects and upgrades to minimize downtime and disruption.
• Experience in trouble shooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Ability to detect and trouble shoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Provide technical support and trouble shooting for database-related issues.
• Implement and maintain database monitoring tools to proactively determine and resolve performance issues.
• Collaborate with development teams to design and implement database solutions that meet business requirements.
• Conduct regular database maintenance tasks, including indexing, statistics updates, and performance tuning.
• Develop and maintain documentation for database configurations, processes, and procedures to ensure compliance with industry standards for database management.

WHAT YOU’LL NEED TO SUCCEED (REQUIRED SKILLS)

• Experience in Database Administration in SQL Server. (2008R2, 2014, 2016, 2017, 2019 and 2022)
• Proficiency in maintaining database scalability by planning and forecasting.
• Solid understanding of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Always ON.
• Expertise in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and trouble shooting tools on Azure SQL VM.

WHAT WILL HELP YOU STAND OUT (PREFERRED SKILLS)

• Hands on experience on PostgreSQL, Oracle and DB2 LUW Databases would be added as advantage.
• Hands on Monitoring tool such as SCOM, Splunk, Dynatrace
• Hands on Backup tool such Commvault, DDBoost 5-7 years relevant experience

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.

Please refer the Job description for details