Overview

Responsibilities:
  • 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 (deployment and support of SQL Server infrastructure, including instances and databases, backup and recovery, security, monitoring, maintenance, data integrity checks, index and statistics maintenance, etc.).
  • Optimizing administration processes for multiple SQL Server instances.
  • Creating and maintaining replications (transactional, snapshot, merge), working with Always On and Log Shipping.
  • Collaborating with backend/devops/infrastructure teams on shared tasks.
  • Updating production systems with patches in automatic and, less frequently, manual mode.
  • Assisting other departments with data retrieval.
  • Participating in the design of data storage architecture and scaling approaches.
Required Qualifications:
  • 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 identifying 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, ability to read and analyze execution plans.
  • Knowledge and ability to apply SQL query, stored procedure, and function optimization techniques.
  • Experience with built-in diagnostic tools such as SQL Profiler, Extended Events or Query Store, usage of DMV/DMF.
  • Experience with SQL Server setup, migrations and upgrades.
  • Experience with HA/DR solutions (Always On Availability Groups, Log Shipping).
  • Ability to identify architectural and logical issues in database structure and code.
  • Experience troubleshooting production incidents.
  • Fluent Russian and intermediate (B1) or higher English level
Benefits:
  • Vacation 28 calendar days per year
  • 7 wellness days per year (time off) that can be used to deal with household issues, to lie down and recover without taking sick leave
  • Bonuses up to $5000 for recommending successful applicants for positions in the company
  • 50% payment for professional training, international conferences, and meetings
  • Corporate discount for English lessons
  • Health benefits. According to the paychecks, if you are not eligible for corporate medical insurance, the company will compensate you with up to $ 1,000 gross per year per employee. This can be spent on self-purchase of health insurance or on doctor’s fees for yourself and close relatives (spouse, children)
  • Workplace organization. The company provides all employees with an equipped workplace and all the necessary equipment (table, armchair, wifi, etc.) in our offices or co-working locations. In the other locations, the company provides reimbursement of workplace costs up to $ 1000 gross once every 3 years, according to the paychecks. This money can be spent on the rent of the co-working room, on equipping the working place at home (desk, chair, Internet, etc.) during those 3 years
  • Internal gamified gratitude system: receive bonuses from colleagues and exchange them for our merchandise, team building activities, massage certificates, etc.
Nice To Have:
  • Basic knowledge of and experience with MongoDB and ClickHouse.
  • Experience with SQL Server 2008+, 2022, 2025.
  • Experience creating and supporting SQL Server replications (Transactional / Snapshot / Merge).
  • Knowledge of PowerShell (including the dbatools module).
  • Experience with monitoring and observability systems (Zabbix, Grafana).
  • Experience with version control systems.
  • Knowledge of Windows Server administration.
  • Experience with partitioning, compression, and archiving strategies.
  • Experience with 24/7 mission-critical systems.
  • Ability to quickly understand and work with existing code.
Note:

✨ Our intelligent job search engine discovered this job and republished it for your convenience.
Please be aware that the job information may be incorrect or incomplete. The job announcement remains the property of its original publisher. To view the original job and its full details, please visit the job's URL on the owner’s page.

Please clearly mention that you have heard of this job opportunity on https://ijob.am.