SQL Server DBA - Database Security, HA/DR, Cloud

FP Inc.; Toronto; On-site; CAD 69,000 - 96,000; Full time

Job summary

FP Inc. is seeking an experienced Microsoft SQL Server Database Administrator to design, deploy, and secure SQL Server environments across on-premises and cloud platforms in line with CIS and regulatory standards.

The role emphasizes encryption at rest and in transit, strong access controls, and automated scripting with T-SQL, PowerShell, SSIS, C#, and VBScript to improve reliability, security, and efficiency. A 12‑month contract with a focus on HA/DR and regulatory compliance.

Qualifications

• Minimum 8+ years of experience as a Microsoft SQL Server Database Administrator.
• Experience with encryption at rest and in transit (TDE, TLS, column-level).
• Scripting and automation using T-SQL, SSIS, PowerShell, C#, and VBScript.

Responsibilities

• Plan, configure, and deploy SQL Server instances across on-premises and cloud environments.
• Maintain encryption, access controls, and password policies per security standards.
• Maintain HA/DR, backups, patching, and migrations to protect data.

Skills

SQL Server

Database security

Automation scripting

PowerShell

T-SQL

Analytical thinking

Education

Post-secondary education in Computer Science or related discipline

Microsoft Data Platform / Azure or Google Cloud certification

Tools

Azure

Google Cloud

SQL Server on-premises

Job description

An intial AI interview will be conducted

Contract Duration: 12 months

Role Responsibilities / Typical Day in Role:

• Plan, configure, and deploy Microsoft SQL Server instances and components across on-premises and public cloud environments in alignment with CIS and Bank security standards.
• Adhere to database best practices, security standards, and vulnerability remediation requirements for SQL Server environments based on the regulatory standards of OSFI, SOX etc.
• Implement and maintain SQL Server access standards and login with password policies, complexities and maintain passwords secured in password management systems
• Implement and maintain Database encryption at rest and transit using certificates based on the Crypto standards.
• Maintain SQL Server software currency, including patching, upgrades, and migrations.
• Support High Availability and Disaster Recovery (HA/DR) solutions, including backup, recovery, and failover/failback of both local and distributed databases to secure the data

Must Have Skills:

• Minimum of 8+ years of progressive experience as a Microsoft SQL Server Database Administrator specially involving database security features and standards.
• Database and access encryption of TDE, TLS and column level encryptions.
• Scripting and automation using T-SQL, SSIS, PowerShell, C#, and VBScript
• Strong analytical, problem-solving, troubleshooting, and automation skills

Nice-To-Have Skills:

• Active Directory, firewall configurations (IP/port), and domain authentication/trust mechanisms related to SQL Server and Windows connectivity
• Database administration in cloud environments, including GCP (Cloud SQL for SQL Server, GCVE, GCE) and Azure (Managed Instance, DBaaS, IaaS)
• SQL Server installation, configuration, and system hardening

Soft Skills:

• Quick learner with excellent interpersonal and communication skills, both written and verbal.
• Take ownership of tasks and follow through to completion.

Educational Requirements:

• Post-secondary education in Computer Science, Math, or related discipline.
• Microsoft Data Platform and Azure/Google Cloud certification is desired for this role.

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 hourly compensation range for this role is $50/hr -$70/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.