Database Administrator for Bangalore

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 security configuration: Users and logins management, Audit, Certificates management, TDE
SQL Server Configuration Management: existing options and their meaning
Familiarity with Prometheus/Grafana stack to monitor MSSQL

Less important skills (Basic knowledge is sufficient): * OpenShift/Kubernetes, Helm

Git, CI/CD
SaltStack (knowledge in this is a big plus), or other Desired State Configuration Management software.
Python Development with focus on data or automation
Experience with testing frameworks
Windows OS internals understanding
PowerShell simple coding for day-to-day activities