04 Sep
|
Tekstaff IT Solutions
|
Toronto
04 Sep
Tekstaff IT Solutions
Toronto
TekStaff's Client has a current vacancy for a SQL Database Administrator .
Contract Duration: 12 months
Location: Toronto, ON - Hybrid (2 days in office)
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.
Candidate Requirements/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
- Solid 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.
- Time management skills
- Take ownership of tasks and follow through to completion.
TekStaff may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.
📌 SQL Database Administrator (Toronto)
🏢 Tekstaff IT Solutions
📍 Toronto