Database Administrator - 4 - 38022

Hiring Manager: Database Administration Manager

Location Address: Toronto - Hybrid - onsite 2-4 times/week based on business needs

Contract Duration: 6 months

Possibility of extension & conversion to FTE

Number of Positions: 3

Schedule Hours: 8:30am-5pm Monday-Friday; standard 37.5 hrs/week (Possible OT)

Reason: additional workload

Story Behind the Need

Business group: GTS - Technology Operations & Engineering

Project: Database Administration Support

Typical Day in Role:

• Monitor the system, and act upon system and application automated alerts

• Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues

(ex. correcting installation, configuration, or data problems)

• Plan and perform software installation, configuration, upgrade and patching

• Plan and perform database configuration, maintenance, upgrade and patching

• Perform and manage system and database backups

• Perform manual switch to redundant system / database components, in case of system failure

•Provide on-site database and system support

•Monitor, collect statistical information, and provide reporting on capacity and system performance

•Based on statistics, make recommendations to maintain and improve capacity and system performance

•Monitor the system, and act upon system and application automated alerts

•Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)

•Plan and perform software installation, configuration, upgrade and patching

•Plan and perform database configuration, maintenance, upgrade and patching

•Perform and manage system and database backups

•Perform manual switch to redundant system / database components, in case of system failure

Candidate Requirements/Must Have Skills:

1. 8+ years Database Administration experience with MSSQL (combined experience with the following 2022/2019/2017/2016/2014/2012)

2. 8+ years experience in providing technical support, covering database administration and

operations to include monitoring maintenance capacity, performance

monitoring/planning and incident/problem troubleshooting and resolution

3. 5+ years of Experience with SQL Always-On, mirroring, clustering and data replication, and experience with MSSQL components (SSRS/SSAS/SSIS/Fulltext/Polybase/R).

4. 3+ years of Experience with application side tuning versus server-side tuning

5. 5+ years of Experience with Windows server 2012/2016/2019

Nice-To-Have Skills:

• Experience with Windows 10/8/7 client operating systems.

• Experience with VB, C#, Power shell, Azure Cloud

• Experience with use of PostgreSQL and Linux, ksh

- Experience providing DBA support for Public Cloud MSSQL offerings such as Azure MI, Azure SQL Databases, and GCP Cloud SQL MSSQL.

Soft Skills Required:

• Strong Communication skills

• team player

• Time management skills

Education: Bachelor's degree in a technical field such as computer science, computer engineering or related field required

Best VS. Average Candidate:

The ideal candidate would have experience providing DBA support for Public Cloud MSSQL offerings such as Azure MI, Azure SQL Databases, and GCP Cloud SQL MSSQL.

-Need someone who takes care of the entire process:

-Database Sub-tier deployment - SQL integration - installing components

-Data Platform/Application Support - DBA should know which technical services need to be provided to get the application running on the database created

-Ongoing support - after goLive, ensuring everything runs smoothly

-not looking for candidate who can only do part of function, can't just be familiar with sub-function of requirements

- need to provide end to support on databases

- need experience with SQL installation and deployment, supporting project before GoLive, working with application teams to get the database customized for the application, managing afterlife after GoLive - manage any issues that arise - need to be able to answer questions such as (need experience with at least 75% of the requirements - Manager will consider candidates who show interest and potential to learn any missing experience)

Candidate Review & Selection

1 round - HM + peer - 1 hr - MS Teams Video (technical interview)

Hiring Manager’s availability to interview: ASAP