Source description
About the role
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 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 significant 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 easy coding for day-to-day activities .
More at RECEX