Igor Butakov Email & Phone Number

Saint Petersburg, Ru

Санкт-Петербург, Россия

Database design and development; maintenance and support of code of Microsoft SQL Enterprise Server Management Studio 2022 technology stack; writing scripts, stored procedures, functions, triggers in T-SQL; creation of advanced SQL queries and refactoring (optimization); working with Extended events; solving database performance problems; code analysis, execution plans, index configuration; searching for performance bottlenecks and giving recommendations to software developers interacting with the database; code review; change/source control using Microsoft TFS; review of technical documentation; working with project and task management systems (Jira bug tracker); user training; user support.

Санкт-Петербург, Россия

Development and maintenance of information systems (satellite security and monitoring) based on MS SQL. Work with highly loaded MS SQL databases (hundreds of queries per minute). Maintenance and support of current code of Microsoft SQL Enterprise Server Management Studio 2014 technology stack. Creating complex SQL queries and refactoring them. Writing scripts, stored procedures, functions, triggers in T-SQL. Working with Profiler. Designing database architecture and structure. Performance analysis and optimization. Experience in solving database performance problems (e.g., optimizing complex SQL queries, code analysis, execution plans, index tuning, refactoring the database, queries and indexes). Finding performance bottlenecks, making recommendations to software developers interacting with the database. Preparing recommendations on MS SQL server database capacity planning for applications and services under development. Database Administration (backup/restore, mirroring setup). Experience with geodata (geography, geometry, spatial sql). Experience with project and task management systems (Redmine bug tracker).

Санкт-Петербург, Россия

Programming VBScript, JavaScript scripts. Development and optimization of SQL queries using Transact SQL (MS SQL Server 2008, 2012), stored procedures, functions and triggers. Working with web API (JSON). Using MS SQL CLR (embedding C# assemblies into MS SQL). Experience with Crystal Reports, Fast Reports.

Санкт-Петербург, Россия

Development and optimization of SQL queries using Transact SQL (MS SQL Server 2008), development of stored procedures, functions and triggers. Development and support of WinForms applications in C# (Visual Studio). Independent design of user interface of applications. Improvement and support of the functionality of existing applications (working with other people's code). Development of technical documentation. Working with version control system (SVN). Experience with Crystal Reports.

Санкт-Петербург, Россия

Gathering, analyzing, describing and agreeing requirements with the customer. Decomposition of requirements, evaluation and setting tasks for developers. Detailed specification of tasks including description of algorithms, principles of data storage and exchange. Setting tasks for development. Interaction with stakeholders (customer representatives) during project development, testing and implementation. Interaction with the project manager, designer, development and testing departments at all stages of the project. Conducting product training, demonstrations of functionality to the customer. Writing technical requirements (TR), user manual (UM), technical specifications (TS) for the software. Acceptance of TS, implementation of software, user training, control of work performance. Experience with Microsoft SQL Server 2005-2008

Санкт-Петербург, Россия

Testing of software products developed by the company (Foxpro, C#). Writing checklists, test plans, bug reports, test documentation, test cases