Position: MS SQL/Azure Developer
Category: SQL
English level: upper
Years of experience: 7

In OLTP solution changed type of wide spread column (near 20 tables) that were also used as composite primary key of few project tables. Done without downtime using triggers, migrations,  backward compatibility code in stored procedures.

Designed, tested and implemented high loaded message queue for Kafka.

Without downtime were moved DB objects of high loaded Micro Service to dedicated DB.
Started to work with Azure Data Factory / Databricks (using Delta tables).Preparing to DP-203 exam.

Experience in refactoring / writing high performance T-SQL scripts / stored procedures for OLTP systems (available 24/7 without downtime for release deployment) including next approaches:
- design and development Micro Service DB part of architecture in new and existing projects;
- NHibernate code refactoring (good .Net code reading skills);
- readable, commented SQL code;
- dynamic SQL code with parameterization (resistant to SQL-injections);
- index covering for certain cases;
- checking IO statistics and tuning;
- checking execution plans and tuning;
- profiler trace use;
- XEvents monitoring;
- creating fast working SSRS reports; 
- altering SSIS packages / creating migration scripts.

Education:
University. Department of electronic and information technologies. Specialty: "Computer systems and networks". Master degree.
Interesting tasks, dynamic work, Scrum approach, effective work in team, getting new knowledge and experience.