Database Administrator for Bangalore

Job Description: JD SQL Server architecture (memory management, IO, Backup-Restore mechanisms, High Availability options) DB physical design structures: Table design, data types, Index design, Columnstore Index internals (mandatory!), functions, procedures, table partitioning and partition management Locking mechanisms Query Performance Tuning: familiarity with Extended Events, Query Execution Plans, Query Store and ability to use those to check and improve query performance. SQL Server securit…