(SQL DBA)

1- SQL DBA - Admin core task - must for all level a. checking health of sql server

checking sessions details

checking error logs

create logins C users and fix any issues

knowledge on databases, Objects and DMV

Monitoring C fixing alerts

2- Database Backup s Restore - must for all level

3- SQL Job creation and fixing any failure - Must for all level

4- Database encryption - for L2/L3 level

5- SQL Server Patching - for L2/L3 level

6- SQL Server upgrade / Migration - for L2/L3 level

7- Understanding SQL Server performance - L2/L3 level a. checking Blocking issues

checking Deadlock issues

Query tunning

Index maintenance

8- Working knowledge on High Availability - L2/L3 level a. Log shipping

Mirroring

Always-on AG

9- working knowledge on SQL Server Replication - L2/L3 level

10- Linked server issues fixing SPN s Delegation - L2/L3 Level

11- MS Azure (Iaas) working knowledge is a plus

12- Understanding s writing T-SQL ,PowerShell scripts

13- Azure SQL