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 Scotiabank is an inclusive company that respects diversity and does not engage in any form of discrimination. #J-18808-Ljbffr
Mssql Database Consultant
SCOTIABANK
distrito federal, distrito federal
Publicado hace 7 días
Denunciar empleo