Database Administrator

We are hiring for the position of "Database Administrator with MS SQL DBA" and are looking for talented individuals who are passionate about this field. If you have experience, we would love to hear from you. 

Job Title: Database Administrator with MS SQL DBA 

Duration: Contract

Location: Hybrid in Toronto, ON 

Job 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/2012, Windows 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
Competencies: Microsoft SQL Server 2019, Database Administration (DBMS)
Key Words: MS SQL DBA 

Database administration