- Planning & deploying MS SQL servers on cloud and on premise servers.
- and general health / capacity monitoring.
- and load balancing of servers.
- routine maintenance including database rebuilds/re-indexing/expansion and archiving.
- MS SQL server problems, and assist in the resolution of application problems.
- upgrades/migrations.
- in database code promotions & data fixes.
- Recovery/High Availability (DR/HA), backup & recovery of local and remote replicated databases.
- DBA support to development/implementation projects as assigned, doing installations, database loading, migrations, testing, etc.
- working knowledge of:MS SQL Server 2019/2017/2016/2014/2012
- Servers, versions 2012 and upWindows Client
- IaaS, MI and DBaaS database deployment and toolsFirewall IP/Port, domain trust/authentication