MSSQL DBA

An Initial AI Screening will be conducted for this role. Contract Duration: 6 months 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 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 FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The compensation range for this role is C$50-69/hr. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.

The role involves monitoring, troubleshooting, and maintaining MSSQL databases and Windows servers to ensure system stability. Key tasks include performing upgrades, patching, backups, and providing on-site technical support and performance reporting.

Candidates must have over 8 years of MSSQL DBA experience and 5+ years of experience with SQL Always-On and Windows Server. A bachelor's degree in a technical field is required.

Identified from the job description. Confirm important requirements above.

• MSSQL Database Administration
• SQL Always-On
• Mirroring
• Clustering
• Data Replication
• SSRS
• SSAS
• SSIS
• Windows Server
• Application Tuning
• Server-side Tuning
• Performance Monitoring
• Troubleshooting
• Database Backups
• Capacity Planning
• Patching

• Technology
• Data & Analytics
• Software
• Engineering
• Consulting

Minimum education

Bachelor’s degree

Minimum experience

10+ years

Apply by

Sep 3, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level