Senior Database Administrator MSSQL

Scotiabank; Toronto; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Bonus

Flexible vacation

Personal days

Sick days

Benefits

Tuition assistance

Job summary

Scotiabank is seeking a Senior Database Administrator (MSSQL) to support on-premises and cloud MSSQL environments. You will ensure high availability, security, and performance while working in a hybrid model and providing after-hours support as needed.

Reporting to the DBA Manager, you will deploy MSSQL servers, tune performance, manage backups, and assist in migrations. Collaboration with development teams to optimize procedures and data reliability is essential.

Qualifications

• Post-secondary education in Computer Science, Math, or related discipline.
• Microsoft Data Platform and Azure/Google Cloud certification is desired for this role.
• Strong experience as MSSQL Database Administrator with hands-on in enterprise environments.

Responsibilities

• 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.
• 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.

Skills

MSSQL

Windows Server

Cloud MSSQL

Performance tuning

Disaster Recovery

Automation

Backup/Recovery

PowerShell

Education

Post-secondary education in CS/Math

Tools

SSRS/SSAS/SSIS

Power BI

T-SQL

PolyBase

Job description

Select how often (in days) to receive an alert:

Select how often (in days) to receive an alert:

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

Title: Senior Database Administrator MSSQL

Requisition ID: 249794
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Team

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 would be supporting the 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 is required to work hybrid (on site and work from home) as well as to 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.

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:

• Assist developers on Stored Procedures performance optimization and troubleshooting.
• 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
• 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!

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. 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.

Job Segment: DBA, System Administrator, Cloud, Database, Housekeeping, Technology, Healthcare