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 datab