Database Administrator

Scotiabank Global Site; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading financial institution is seeking a Database Administrator in Toronto to manage MSSQL databases both on-premises and in the cloud. The role involves troubleshooting, maintenance, and support, requiring 5+ years of experience in database administration. Applicants should possess strong analytical skills, communication abilities, and a relevant educational background. Competitive benefits and an inclusive culture are offered.

Benefits

Competitive Rewards program

Flexible vacation

Personal sick days

Tuition assistance

Community engagement opportunities

Qualifications

• At least 5 years of experience as a Database Administrator.
• Experience with MSSQL Server 2022, 2019, 2017.
• Knowledge of database maintenance and performance tuning.

Responsibilities

• Support MS SQL Server on-premises and on public cloud.
• Manage database change management and incident management.
• Assist in database code promotions and data fixes.

Skills

MSSQL Server Administration

Disaster Recovery

Problem Solving

Performance Tuning

Database Design

SQL

High Availability

SSIS

Education

Post-secondary education in Computer Science or related field

Tools

Microsoft SQL Server

GCP Cloud SQL

Azure MI / DBaaS

Job description

Requisition ID : 234271

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

Scotiabanks 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 / Lead 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 on shifts as well as to be on-call for rotational after-hours support of the banks databases. The Database Administrator must be prepared to provide remote dial-in support or occasionally on-site support in response to routine monitoring alerts and scheduled & unscheduled maintenance tasks occurring after hours and on weekends.

Is this role right for you

Database related change management incident management business as usual tasks and project related database tasks.

Configuration planning & deploying MSSQL servers on public cloud and on-premise 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 and change control process of the bank.

Do you have the skills that will enable you to succeed in this role

You have at least 5 years of progressive technical working experience as a Database Administrator.

You possess sound practical working knowledge of :

• MSSQL Server 2022 / 2019 / 2017 and prior versions DB Administration
• Windows Servers 2022 / 2019 / 2016 and prior versions
• GCP Cloud SQL(MSSQL) 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 Procedures performance optimization and troubleshooting.
• Application side tuning vs. server-side tuning.
• Setup 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 1.2 etc. configuration
• Database Re-build / De-fragment techniques
• Logical & Physical Backup / Recovery / Compression techniques
• MSSQL Services (SSRS / SSAS / SSIS / PolyBase R Service Power BI etc.)
• Scripting and Automation with Power Shell C# VB Scripts SSIS TSQL etc.

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

You are a quick learner with good interpersonal and communication (verbal / written) skills.

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

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

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

Accessibility and Workplace Accommodations - 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. Scotiabank continues to locate remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.

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.

Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons contests cooking with friends Humans of Digital and much more!

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. If you require technical assistance please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however only those candidates who are selected for an interview will be contacted.

Required Experience

Unclear Seniority

Key Skills

• Databases
• Disaster Recovery
• SQL
• High Availability
• Microsoft SQL Server
• ssrs
• Database Design
• Performance Tuning
• SSIS
• Database Administration
• Sybase
• Oracle

Employment Type

Full Time

Experience

years

Vacancy

1