Senior Database Administrator MSSQL Job Toronto area,Ontario Canada,IT/Tech

Is this role right for you?

In this role you will:

Configuration planning & deploying MSSQL servers/components on public cloud and on-premises servers.

Performance tunning, capacity planning and monitoring.

Database maintenance/housekeeping including database rebuilds/re-indexing/expansion and archiving.

Trouble-shoot MSSQL server problems and assist in the resolution of application problems.

MSSQL Server Software currency resolution including Patching/Upgrades/Migrations.

Assist in database code promotions & 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 etc.

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.

Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:

Must have skills

At least 5+ years of progressive technical working experience as a MSSQL Database Administrator.

MSSQL Server 2022/2019/2017/2016 and prior versions DB Administration

Windows Servers 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.

You possess sound practical working experience with:

MSSQL Instance/Database Installation/Configuration/Hardening

Assist developers on Stored Procedures 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 Data at rest as well as in transit e.g. TDE, SQL Always encryption and TLS etc. configuration

Database Re-build/De-fragment techniques

Logical & Physical Backup/Recovery/Compression techniques

MSSQL Services (SSRS/SSAS/SSIS/Poly base, R Service, Power BI etc.)

Scripting and Automation with TSQL, SSIS, Power Shell, C#, VB Scripts etc.

You have good analytical, problem solving, trouble shooting and automation skills.

Education and certificationss:

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

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

What's in it for you?

Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.

Upskilling through online courses, cross-functional development opportunities, and tuition assistance.

Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.

Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.

Community Engagement - We offer opportunities for community engagement & belonging with our various programs!


Increase/decrease your Search Radius (miles)



Job Posting Language