SQL Database Administrator

Position Overview Opportunity to work for a Top 5 Canadian Bank Excellent opportunity for an experienced SQL Sever DBA to support large -scale enterprise database environment. Exposure to advanced database security , cloud technologies and highly regulated banking systems. Key Responsibilities • 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 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. Required Qualifications • 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 Preferred Qualifications • 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. • Time management skills • Take ownership of tasks and follow through to completion. Education and Certification • Post-secondary education in Computer Science, Math, or related discipline. • Microsoft Data Platform and Azure/Google Cloud certification is desired for this role.