About the vacancy

Our team of engineers is responsible for supporting database servers in Yandex projects that use Microsoft SQL Server. We support databases for MS Axapta, MS SharePoint, 1C, a wide range of application software used for various project tasks and infrastructure services, OLTP and OLAP.

The team's responsibilities include supporting both small installations and multi-node, high-load MSSQL AO clusters. We provide our clients with a full cycle of services, from consulting on solution selection to their deployment and operation.

We are looking for an experienced engineer to help us improve service quality. This vacancy is for a fixed-term employment contract, for the duration of the primary employee's parental leave.

What tasks await you

Support and development of project services Our engineers help internal teams create and maintain various projects. In collaboration with them, you will define database requirements, develop and create fault-tolerant and highly available architecture, and ensure the operation of project services according to specified criteria.

Support of core processes An integral part of an engineer's work involves managing, configuring, and maintaining database servers and processes, monitoring system health and performance, performing backups, improving and automating routine database maintenance processes, documenting changes, and carrying out technical maintenance. Together with your colleagues, you will improve these processes.

Optimization and improvements Load analysis and modeling, identifying and resolving issues, proposing solutions to emerging problems, and interacting with developers on query optimization and index building are examples of tasks you will be involved in.

Security In today's world, ensuring the security of information systems is a critical task. You will participate in comprehensive information security improvement processes for services based on the Windows OS.

We expect you to have

• Solved problems and provided support for critical business projects, with in-depth knowledge of performance tuning and optimization
• Be an experienced engineer with excellent knowledge of MS SQL Server administration
• Be able to build fault-tolerant and highly available solutions based on MS SQL Server Always-On
• Be proficient in T-SQL
• Be able and willing to optimize code, processes, and service architecture
• Be inclined towards automating routine SQL server maintenance tasks
• Take a responsible approach to project support
• Be able to work in a team

It will be a plus if you have

• Worked with high-load MS SQL Enterprise databases
• Good understanding of Windows OS administration
• Experience using various software and technologies to improve service monitoring, performance, and stability