Job Description
Job description
Role Description: Configuration planning & deploying MS SQL servers on cloud and on premise servers.Performance and general health / capacity monitoring.Tuning and load balancing of servers.Do routine maintenance including database rebuilds/re-indexing/expansion and archiving.Trouble-shoot MS SQL server problems, and assist in the resolution of application problems.Server upgrades/migrations.Assist in database code promotions & data fixes.Disaster Recovery/High Availability (DR/HA), backup & recovery of local and remote replicated databases.Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, etc.Practical working knowledge of:MS SQL Server 2019/2017/2016/2014/2012Windows Servers, versions 2012 and upWindows ClientAzure IaaS, MI and DBaaS database deployment and toolsFirewall IP/Port, domain trust/authenticationDatabase Device Configuration/InstallationStored ProceduresSetup SQL Always-On & Database ReplicationData Encryption & MaskingDatabase Re-build / De-fragment techniquesLogical & Physical Backup / Recovery techniquesMS SQL Services (SSRS/SSAS/SSIS/PolyBase, R Service)OLAPPower BIApplication side tuning vs. server side tuning
Competencies: Microsoft SQL Server 2019, Database Administration (DBMS)
Experience (Years): 6-8
Essential Skills: Configuration planning & deploying MS SQL servers on cloud and on premise servers.Performance and general health / capacity monitoring.Tuning and load balancing of servers.Do routine maintenance including database rebuilds/re-indexing/expansion and archiving.Trouble-shoot MS SQL server problems, and assist in the resolution of application problems.Server upgrades/migrations.Assist in database code promotions & data fixes.Disaster Recovery/High Availability (DR/HA), backup & recovery of local and remote replicated databases.Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, etc.Practical working knowledge of:MS SQL Server 2019/2017/2016/2014/2012Windows Servers, versions 2012 and upWindows ClientAzure IaaS, MI and DBaaS database deployment and toolsFirewall IP/Port, domain trust/authenticationDatabase Device Configuration/InstallationStored ProceduresSetup SQL Always-On & Database ReplicationData Encryption & MaskingDatabase Re-build / De-fragment techniquesLogical & Physical Backup / Recovery techniquesMS SQL Services (SSRS/SSAS/SSIS/PolyBase, R Service)OLAPPower BIApplication side tuning vs. server side tuning
Desirable Skills: Configuration planning & deploying MS SQL servers on cloud and on premise servers.Performance and general health / capacity monitoring.Tuning and load balancing of servers.Do routine maintenance including database rebuilds/re-indexing/expansion and archiving.Trouble-shoot MS SQL server problems, and assist in the resolution of application problems.Server upgrades/migrations.Assist in database code promotions & data fixes.Disaster Recovery/High Availability (DR/HA), backup & recovery of local and remote replicated databases.Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, etc.Practical working knowledge of:MS SQL Server 2019/2017/2016/2014/2012Windows Servers, versions 2012 and upWindows ClientAzure IaaS, MI and DBaaS database deployment and toolsFirewall IP/Port, domain trust/authenticationDatabase Device Configuration/InstallationStored ProceduresSetup SQL Always-On & Database ReplicationData Encryption & MaskingDatabase Re-build / De-fragment techniquesLogical & Physical Backup / Recovery techniquesMS SQL Services (SSRS/SSAS/SSIS/PolyBase, R Service)OLAPPower BIApplication side tuning vs. server side tuning
Role Description: Configuration planning & deploying MS SQL servers on cloud and on premise servers.Performance and general health / capacity monitoring.Tuning and load balancing of servers.Do routine maintenance including database rebuilds/re-indexing/expansion and archiving.Trouble-shoot MS SQL server problems, and assist in the resolution of application problems.Server upgrades/migrations.Assist in database code promotions & data fixes.Disaster Recovery/High Availability (DR/HA), backup & recovery of local and remote replicated databases.Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, etc.Practical working knowledge of:MS SQL Server 2019/2017/2016/2014/2012Windows Servers, versions 2012 and upWindows ClientAzure IaaS, MI and DBaaS database deployment and toolsFirewall IP/Port, domain trust/authenticationDatabase Device Configuration/InstallationStored ProceduresSetup SQL Always-On & Database ReplicationData Encryption & MaskingDatabase Re-build / De-fragment techniquesLogical & Physical Backup / Recovery techniquesMS SQL Services (SSRS/SSAS/SSIS/PolyBase, R Service)OLAPPower BIApplication side tuning vs. server side tuning
Competencies: Microsoft SQL Server 2019, Database Administration (DBMS)
Experience (Years): 6-8
Essential Skills: Configuration planning & deploying MS SQL servers on cloud and on premise servers.Performance and general health / capacity monitoring.Tuning and load balancing of servers.Do routine maintenance including database rebuilds/re-indexing/expansion and archiving.Trouble-shoot MS SQL server problems, and assist in the resolution of application problems.Server upgrades/migrations.Assist in database code promotions & data fixes.Disaster Recovery/High Availability (DR/HA), backup & recovery of local and remote replicated databases.Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, etc.Practical working knowledge of:MS SQL Server 2019/2017/2016/2014/2012Windows Servers, versions 2012 and upWindows ClientAzure IaaS, MI and DBaaS database deployment and toolsFirewall IP/Port, domain trust/authenticationDatabase Device Configuration/InstallationStored ProceduresSetup SQL Always-On & Database ReplicationData Encryption & MaskingDatabase Re-build / De-fragment techniquesLogical & Physical Backup / Recovery techniquesMS SQL Services (SSRS/SSAS/SSIS/PolyBase, R Service)OLAPPower BIApplication side tuning vs. server side tuning
Desirable Skills: Configuration planning & deploying MS SQL servers on cloud and on premise servers.Performance and general health / capacity monitoring.Tuning and load balancing of servers.Do routine maintenance including database rebuilds/re-indexing/expansion and archiving.Trouble-shoot MS SQL server problems, and assist in the resolution of application problems.Server upgrades/migrations.Assist in database code promotions & data fixes.Disaster Recovery/High Availability (DR/HA), backup & recovery of local and remote replicated databases.Provide DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, etc.Practical working knowledge of:MS SQL Server 2019/2017/2016/2014/2012Windows Servers, versions 2012 and upWindows ClientAzure IaaS, MI and DBaaS database deployment and toolsFirewall IP/Port, domain trust/authenticationDatabase Device Configuration/InstallationStored ProceduresSetup SQL Always-On & Database ReplicationData Encryption & MaskingDatabase Re-build / De-fragment techniquesLogical & Physical Backup / Recovery techniquesMS SQL Services (SSRS/SSAS/SSIS/PolyBase, R Service)OLAPPower BIApplication side tuning vs. server side tuning
💡 Quick Summary
Seeking a career-building opportunity? The Database Admin position is now open for candidates interested in the Database Administrator sector. This role in Toronto offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.