This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

previous arrow
next arrow
Slider

Ward Technology Talent: Sql Server Database Administrator (Dba) – Toronto Montreal Ottawa, Calgary Vancouver

Ward Technology Talent

This is a Full-time position in Scarborough, ON posted March 31, 2021.

SQL Server Database Administrator (DBA)This job can be based out of any of the following citiesTorontoMontreal Ottawa,CalgaryVancouverPurpose of the RoleWe are seeking a highly skilled SQL Database Administrator to support the company’s SQL environment (manage Microsoft SQL Server database servers, including routine maintenance, security auditing, backup and recovery, index tuning, and optimization).This position will work with the DevOps team to ensure proper database design and optimal performance of products, and to enforce data governance standards.Key ResponsibilitiesThe key responsibilities of this role are:Core responsibilities You will be asked to support the day-to-day SQL operations and to work with the rest of the team to define the company’s technology roadmap.

The responsibilities include:Support and maintain an effective database environment to support all business systemsDaily production support of the database application serversEnsure proper security measures are enforcedInstalling, managing and optimizing MS SQL Server (In a SQL 2008 R2, SQL 2012, 2016, 2019 and Azure environment)Performance troubleshooting and optimizing MS SQL ServersUpgrading and enhancing MS SQL Server environment to latest versions and patchesParticipate in change control activitiesDevelopment of SSIS scriptsFirm projects as assigned, this role will act as the technical lead on many strategic firm initiativesSupport firm data warehouse, SSRS and SSAS environmentMaintenance Part of the responsibilities includes the maintenance of existing applications.You will receive some requests to:Perform integrity tests and data spot-checksPerform performance tests on applications and analyze the results to prevent or correct potential problemsSupport You will be asked to provide a second level support to the users of internally developed application.The responsibilities include:Troubleshoot problems found in existing applications with the collaboration of the operation team.Identify the necessary fixes needed to resolve those problemsProvide the fixes to be implemented in productionTechnical skills (Essential): Minimum 6 10 years of practical experience working as a database administrator.Experience with SQL Server installations and configurations for stand-alone and clustered instances (In a SQL Server 2008 R2, 2012 and 2016, 2019 and Azure environment).Experience with highly available architectures such as clustering, replication, Always-on of MS SQL Server.Experience in capacity and growth planning.Experience in defining migration plans, risk mitigation and execution of defined strategy.Strong understanding of SQL Server backup and restore concepts and implementations.Strong performance tuning and optimization skills.Strong understanding of index design and management.Strong understanding of SQL Server security concepts and implementations.Understanding of filegroups and data file layouts.Understanding of concurrency and locking concepts.Experience with SQL Server tools, including SSMS, Profiler, Tuning advisor, Business Intelligence Studio, and Configuration Manager.Experience creating and managing SQL Server Maintenance Plans and Jobs.Strong analytical skills for troubleshooting incidents and performing root cause analysis.Strong working knowledge of SSIS, SSRS and SSAS.Strong knowledge of T-SQL including enhancements introduced in SQL Server 2008, 2012 and 2016, 2019 Azure.

Ability to create and maintain scripts, jobs, views, stored procedures, user-defined functions and triggers.Experience with TFS/DevOps.Key CompetenciesAbility to communicate in a professional mannerStrong organizational and time management skillsExcellent multi-tasking skills with the ability to manage multiple assignments, both immediate and strategic, at the same timeStrong attention to detailAbility to work independently, follow instructions with minimal supervision and take initiativeAbility to work in a multi-office dynamic team environmentA team player with excellent interpersonal skillsAvailability to work overtime, when necessaryFlexible and dependable, able to take the initiativeAble to remain calm under pressure and work to tight deadlinesConscientious, approachable and enthusiasticAble to quickly build confidence, respect and trust with othersHave a positive approach to daily tasks and have a solutions focused working method