Database Administrator x 3

Nexus Systems Group Inc.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A technology solutions provider in Toronto is seeking a Database Administrator with over 8 years of experience in MSSQL and database management. The ideal candidate will monitor systems, perform diagnostics, and support database operations. Candidates must possess a Bachelor's degree in a technical field and demonstrate strong communication and time management skills. This role is critical for maintaining system performance and reliability.

Qualifications

• 8+ years Database Administration experience with MSSQL.
• 8+ years of technical support in database administration.
• 5+ years of experience with SQL Always-On and MSSQL components.
• 3+ years of application side tuning experience.
• 5+ years with Windows server 2012/2016/2019.

Responsibilities

• Monitor system and act upon automated alerts.
• Perform diagnostics and troubleshooting of software and database issues.
• Plan and perform software and database upgrades.
• Manage system and database backups.
• Provide on-site database and system support.

Skills

Database Administration

MSSQL

Technical Support

SQL Always-On

Tuning

Education

Bachelor's degree in a technical field

Tools

PowerShell

Azure Cloud

PostgreSQL

Linux

Job description

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

Qualifications (Must Have)

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