Mssql database consultant

Overview

Requisition ID:

Employee Referral Program – Potential Reward: $0.00

We are committed to investing in our employees and helping you continue your career at Scotiabank.

Purpose of the Role

We are looking for a Senior DBA (Microsoft SQL Server) to join our global data platform team at Scotiabank. In this role, you will be responsible for providing end-to-end operational support for Microsoft data platform services, ensuring the availability, security, and performance of both cloud and on-premise environments.

Reporting to the DBA Manager, you will play a key role in maintaining, optimizing, and evolving our database infrastructure in a dynamic, high-impact environment.

Key Responsibilities

• Plan, configure, and deploy MS SQL servers in cloud and on-premise environments
• Monitor, optimize performance, and maintain overall database health
• Perform routine maintenance such as database rebuilds, reindexing, expansion, and archiving
• Troubleshoot SQL Server issues and support application-related incidents
• Execute server upgrades, migrations, and patching activities
• Support database code deployments and data fixes following change management processes
• Implement and support Disaster Recovery and High Availability (DR/HA) strategies
• Manage backup and recovery of local and replicated databases
• Provide DBA support to development and implementation projects (installations, migrations, testing, data loading)
• Participate in incident management and collaborate with cross-functional teams
• Provide support on a rotational on-call schedule (24x7), including after-hours and weekend support

Experience and Skills

• 5+ years of progressive experience as a Database Administrator
• At least 2 years of hands-on experience with Microsoft SQL Server administration and operations

Technical Knowledge

• SQL Server (versions 2025, 2022, 2019, 2017, and earlier)
• Windows Server (2022, 2019, 2016)
• Azure SQL Managed Instance and DBaaS solutions
• GCP Cloud SQL for MSSQL
• Always On Availability Groups and database replication
• Database security standards and data encryption
• Backup, recovery, reindexing, and database optimization techniques
• Installation and configuration of MSSQL services: Database Engine, SSRS, SSIS, SSAS, Power BI, PolyBase, and R Services
• SQL Server and application-level query tuning

Soft Skills

• Strong analytical thinking and problem-solving skills
• Advanced troubleshooting and automation capabilities
• Excellent verbal and written communication skills
• Fast learner with strong collaboration abilities

Nice To Have

• Knowledge of T-SQL and scripting languages

Education

• Degree in Computer Science, Mathematics, or a related field
• Microsoft Data Platform certifications are an asset

Recommendations For Your Application

• Make sure you have been in your current position for at least one year.
• Confirm that you meet the essential requirements.
• Talk to your current supervisor and let them know about your application.
• Remember that you can only apply for one position at a time.

To participate in Scotiabank’s internal job postings, you must ensure that your Talent Profile is 100% up to date.

Scotiabank is an inclusive company that respects diversity and does not engage in any form of discrimination.

Location(s): Mexico : Ciudad de México : Cuauhtémoc