12+ years of experience as MS SQL DBA(SQL Server DBA). SQL Server internals and architecture. Backup and Restore. Troubleshooting orphaned users. Checking index fragmentation and rebuilding or reorganizing indexes. Updating statistics. ACID properties, shrink operations, recovery models, DBCC commands, DMV, blocking, permissions.High Availability Technologies like Database Mirroring, Log Shipping, Transactional Replication, Availability Groups. Ticketing tools.