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

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.