Job Description

• 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
• Manage and maintain database monitoring tools, backup software, and management agents to ensure system performance, data integrity, and availability. Proactively monitor, schedule backups, perform recovery tests, and update tools to support seamless and secure database operations.
• Manage database consolidations and migrations from Oracle, MariaDB, and PostgreSQL. Configure and optimize monitoring setups using third-party tools to ensure performance, reliability, and smooth transition during projects.
• 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
• Knowledge of python scripting is a plus.

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

Skills Required