Requisition id:
employee referral program - potential reward: $0.00
purpose of the role
we are looking for a senior dba (microsoft sql server) to join our general 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
* mexico: ciudad de méxico: cuauhtémoc
scotiabank is an inclusive company that respects diversity and does not engage in any form of discrimination.
#j-18808-ljbffr