Company: Zolotoye Yabloko
Location: Yekaterinburg
Employment: Full-time
We are looking for a Lead Database Administrator for Zolotoye Yabloko, a dynamically developing company where growth and ambition shape interesting work tasks and provide opportunities for everyone to influence the business and develop professionally.
You will be working in the IT Operations Department, where the team is responsible for the development and operation of the IT infrastructure, procurement and accounting of IT assets, opening stores, distribution centers, offices, and technical user support.
Responsibilities:
- Perform initial installation and configuration of database servers.
- Administer and provide operational support for MS SQL Server DBMS.
- Administer clusters, Always On, replication, and high availability/disaster recovery (HA/DR) mechanisms.
- Configure database performance monitoring: metric collection, dashboard creation, notification system setup.
- Configure and maintain data replication mechanisms.
- Implement table and index partitioning.
- Ensure correct transaction operation, manage locks, control isolation levels.
- Optimize SQL queries and indexes.
- Analyze query execution plans, identify bottlenecks.
- Identify and resolve locks as they occur.
- Configure and support backup and recovery processes.
- Perform scheduled maintenance and database servicing, including automation of regular procedures and processes.
- Differentiate access levels to databases according to the adopted role model and security policies accepted in the company, and automate these tasks.
- Regularly audit databases for compliance with information security policies.
- Interact with developers on query optimization (perform analysis of performance, statistics, indexes, logs, lock resolution, and other database incidents). Provide optimization recommendations for developers.
- Develop operational standards and technical documentation.
Candidate Profile:
- 5+ years of experience in administering and supporting MSSQL databases (2012-2025), with 20+ installations and 100+ databases.
- Knowledge of SQL Server internal architecture and DBMS principles.
- Practical experience with Always On.
- Understanding of Failover Clustering, Replication, and Log Shipping principles.
- Skills in performance analysis, bottleneck identification, and DBMS fine-tuning.
- Proficient in SQL, T-SQL, PowerShell.
- Experience with PostgreSQL or other OLTP database vendors is a plus.
- Deep understanding of the SQL language and query optimization principles, including: index optimization, reading and analyzing query execution plans, profiling current database load, identifying and resolving locks, performance analysis, bottleneck identification, and DBMS fine-tuning.
- Experience with enterprise databases such as ERP AXAPTA or other high-load MSSQL-based systems will be an advantage.
Why Join Us:
- Accredited IT company that creates and develops one of the TOP-10 largest online stores in the country*
- Personal salary offer and official employment; we value transparency and honesty.
- Career consultant assistance for choosing an individual development path.
- Comprehensive social package including dentistry, office meal compensation, and discounts/bonuses from partners – everything to make life and work comfortable.
- Modern work equipment.
- Stylish and cozy office in the center of Yekaterinburg.
- A corporate culture and special energy that resonates with you – you'll feel like you belong here.
- English language learning at GA English Club, compensation for training, and development in our own online university to grow with the company.
- No restrictions on dress code or appearance. We respect your individuality.
Join an international and stable business – secure your future with us!
*According to the Data Insight rating in 2025.
