Database Administrator Responsibilities:
Skills:-Normalisation, Diff between Delete/Trunkit, Union/Union All, Knows to write SQL Query, SQL Tuning, SQL version - 2017/18 SQL Server Upgrade, Migration, Re-host, Patching, New installation (standalone & clustered), High Availability features (Replication, Always-On, Log Shipping, Mirroring)
- Installation and configuration of SQL Server Database Engine, Integration Service. Creating SQL cluster with 2/3 nodes. Clustered Roles setup, flip, quorum disk witness, file share witness, instance flip and node reboot.