Optimizing the performance of the database infrastructure (queries, indexes, locks, CPU/RAM/disk resource usage, etc.)
Solving performance issues within short timeframes, supporting business-critical services
Analyzing and optimizing stored procedures, functions, and triggers
Diagnosing and resolving performance issues
Carrying out routine database administration tasks
Optimizing administration processes for multiple SQL Server instances
Creating and maintaining replications (transactional, snapshot, merge)
Collaborating with backend/devops/infrastructure teams on shared tasks
Updating production systems with patches
Assisting other departments with data retrieval
Participating in the design of data storage architecture

Deep knowledge of Microsoft SQL Server architecture and internals
Expert-level experience with SQL Server versions 2016–2019
Practical experience optimizing high-load systems and performance bottlenecks
Excellent knowledge of T-SQL, including writing and optimizing stored procedures, UDFs, and triggers
Understanding of indexes, locking, isolation levels, transaction management, waits analysis, deadlock analysis, tempdb optimization
Experience with built-in diagnostics tools (SQL Profiler, Extended Events, Query Store)
Experience with SQL Server setup, migrations and upgrades
Experience with HA/DR solutions (Always On Availability Groups, Log Shipping)
Experience troubleshooting production incidents
Basic knowledge of MongoDB and ClickHouse (nice to have)
Experience creating and supporting SQL Server replications (Transactional / Snapshot / Merge) (nice to have)
Knowledge of PowerShell (including dbatools module) (nice to have)
Experience with monitoring systems (Zabbix, Grafana) (nice to have)
Experience with partitioning, compression, archiving strategies (nice to have)
Ability to quickly understand and work with existing code (nice to have)

DBA Engineer

Key skills