Title:  MSSQL Database Consultant

Requisition ID: 263043
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

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

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.  

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our  Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.