MS SQL server Database Administrator @ Toronto, ON - Hybrid - Long Term

Role - MS SQL server Database Administrator

Location - Toronto, ON - Hybrid

Duration - Long Term

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 up Windows Client Azure IaaS, MI and DBaaS database deployment and tools Firewall IP / Port, domain trust / authentication Database Device Configuration / Installation Stored Procedures Setup SQL Always-On & Database Replication Data Encryption & Masking Database Re-build / De-fragment techniques Logical & Physical Backup / Recovery techniques MS SQL Services (SSRS / SSAS / SSIS / Poly Base, R Service)OLAP Power BI Application side tuning vs. server side tuning

Thanks & Regards,

Harshaja

Apptoza Inc.

Email : [email protected]

Phone# : 647-953-1625