Talent.com
MSSQL Server DBA

MSSQL Server DBA

Astra North Infoteck Inc.Toronto, ON, ca
10 days ago
Job description

MSSQL Server DBA

Toronto

Experience (Years) :

6-8 MSSQL Server DBA and MSSQL Development

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