Senior Database Administrator MSSQL

Senior Database Administrator MSSQL

Requisition

Join a purpose driven winning team, committed to results, in an inclusive and high‑performing culture.

Scotiabank’s Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end‑to‑end support for Microsoft data platform products across the globe where Scotiabank is present.

Physical & logical database services, from deployment, project support and after go‑live steady state support is the essence of what we do.

Reporting to the DBA Manager, the Database Administrator will support MS SQL Server on‑premises as well as on public cloud.

As a member of the database administration group, you will assist in the team effort to maximize the availability, security, and performance of the databases.

The Database Administrator must work hybrid (on site and work from home) and be on‑call for rotational after‑hours support of the bank’s databases.

The Database Administrator must be prepared to provide remote dial‑in support, in response to routine monitoring alerts and scheduled & unscheduled maintenance tasks occurring after hours and on weekends.

• Configuration planning & deploying MSSQL servers/components on public cloud and on‑premises servers.
• Performance tuning, capacity planning and monitoring.
• Database maintenance/housekeeping including database rebuilds, re‑indexing, expansion and archiving.
• Troubleshoot MSSQL server problems and assist in the resolution of application problems.
• MSSQL server software currency resolution including patching, upgrades and migrations.
• Assist in database code promotions and data fixes following internal change‑control process.
• Disaster Recovery / High Availability (DR/HA) support with backup, recovery and failover/failback of local and remote replicated databases.
• Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing and go‑live support.
• Follow database best practices, security standards and vulnerability remediations of MSSQL servers and components.
• Involve in database related incident management, alerts and business‑as‑usual tasks.

• At least 5+ years of progressive technical working experience as an MSSQL Database Administrator.
• MSSQL Server 2022/2019/2017/2016 and prior versions administration.
• Windows Server 2022/2019/2016 and prior versions.
• GCP Cloud SQL (MSSQL), GCVE, GCE and Azure MI/DBaaS/IaaS database administration.
• AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity.
• MSSQL Instance/Database installation, configuration, hardening.
• Assist developers on stored procedure performance optimization and troubleshooting.
• Application side tuning vs. server‑side tuning.
• Setup HA/DR with MSSQL Always‑On, Availability groups & database replication.
• Data encryption & masking (TDE, Always encryption, TLS configuration).
• Database re‑build/de‑fragmentation techniques.
• Logical & physical backup/recovery/compression techniques.
• MSSQL services (SSRS, SSAS, SSIS, Polybase, R Service, Power BI, etc.).
• Scripting and automation with TSQL, SSIS, Power Shell, C#, VB scripts.
• Good analytical, problem‑solving, troubleshooting and automation skills.

Post‑secondary education in Computer Science, Math, or related discipline.

Microsoft Data Platform and Azure/Google Cloud certification is desired.

• Diversity, Equity, Inclusion & Allyship.
• Upskilling through online courses, cross‑functional development opportunities and tuition assistance.
• Competitive rewards program including bonus, adaptable vacation, personal, sick days and benefits starting day one.
• Dynamic ecosystem: free tea & coffee, universal washrooms and collaborative space.
• Community engagement opportunities.

Location:

Toronto, Ontario, Canada.

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.