Mssql database consultant

Ph3Overview /h3pbRequisition ID: /b /ppbEmployee Referral Program – Potential Reward: /b $0.00 /ppWe are committed to investing in our employees and helping you continue your career at Scotiabank. /ph3Purpose of the Role /h3pWe 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. /ppReporting to the DBA Manager, you will play a key role in maintaining, optimizing, and evolving our database infrastructure in a dynamic, high-impact environment. /ph3Key Responsibilities /h3ulliPlan, configure, and deploy MS SQL servers in cloud and on-premise environments /liliMonitor, optimize performance, and maintain overall database health /liliPerform routine maintenance such as database rebuilds, reindexing, expansion, and archiving /liliTroubleshoot SQL Server issues and support application-related incidents /liliExecute server upgrades, migrations, and patching activities /liliSupport database code deployments and data fixes following change management processes /liliImplement and support Disaster Recovery and High Availability (DR/HA) strategies /liliManage backup and recovery of local and replicated databases /liliProvide DBA support to development and implementation projects (installations, migrations, testing, data loading) /liliParticipate in incident management and collaborate with cross-functional teams /liliProvide support on a rotational on-call schedule (24x7), including after-hours and weekend support /li /ulh3Experience and Skills /h3ulli5+ years of progressive experience as a Database Administrator /liliAt least 2 years of hands-on experience with Microsoft SQL Server administration and operations /li /ulh3Technical Knowledge /h3ulliSQL Server (versions 2025, 2022, 2019, 2017, and earlier) /liliWindows Server (2022, 2019, 2016) /liliAzure SQL Managed Instance and DBaaS solutions /liliGCP Cloud SQL for MSSQL /liliAlways On Availability Groups and database replication /liliDatabase security standards and data encryption /liliBackup, recovery, reindexing, and database optimization techniques /liliInstallation and configuration of MSSQL services: Database Engine, SSRS, SSIS, SSAS, Power BI, PolyBase, and R Services /liliSQL Server and application-level query tuning /li /ulh3Soft Skills /h3ulliStrong analytical thinking and problem-solving skills /liliAdvanced troubleshooting and automation capabilities /liliExcellent verbal and written communication skills /liliFast learner with strong collaboration abilities /li /ulh3Nice To Have /h3ulliKnowledge of T-SQL and scripting languages /li /ulh3Education /h3ulliDegree in Computer Science, Mathematics, or a related field /liliMicrosoft Data Platform certifications are an asset /li /ulh3Recommendations For Your Application /h3ulliMake sure you have been in your current position for at least one year. /liliConfirm that you meet the essential requirements. /liliTalk to your current supervisor and let them know about your application. /liliRemember that you can only apply for one position at a time. /li /ulpTo participate in Scotiabank’s internal job postings, you must ensure that your Talent Profile is 100% up to date. /ppScotiabank is an inclusive company that respects diversity and does not engage in any form of discrimination. /ppbLocation(s): /b Mexico : Ciudad de México : Cuauhtémoc /p /p #J-18808-Ljbffr