← Back to list
senior
Registration: 05.04.2022

Vadim Solnyshko

Specialization: SQL Server databases

Portfolio

ElephantDrive (storing, protecting and accessing user data)

Designing, administering, developing and optimizing SQL Server 2016 / 2017 / 2019 databases. - Developing and implementing solutions for installing, configuring and administering Microsoft SQL Server - Optimizing Microsoft SQL Server, databases and server-side code - Supporting an existing information systems in the part of data architecture - Designing data architecture when improving information systems - Modifying data architecture to optimize information systems - Designing databases - Optimizing performance - Developing, supporting and optimizing the server-side code: T-SQL scripts, stored procedures, user-defined functions, triggers etc. - Configuring and administering transactional replication - Administering servers and databases - Creating SSIS packages for ETL - Configuring and administering log shipping - Configuring and administering Always On Availability Groups (HADR) - Partitioning tables and indexes - Developing a data warehouse - Implementing row-level security - SQL Server Integration Services

Crexi (Commercial Real Estate Exchange)

Designing, administering, developing and optimizing SQL Server 2016 / 2017 / 2019 databases. - Developing and implementing solutions for installing, configuring and administering Microsoft SQL Server - Optimizing Microsoft SQL Server, databases and server-side code - Supporting an existing information systems in the part of data architecture - Designing data architecture when improving information systems - Modifying data architecture to optimize information systems - Designing databases - Optimizing performance - Developing, supporting and optimizing the server-side code: T-SQL scripts, stored procedures, user-defined functions, triggers etc. - Configuring and administering transactional replication - Administering servers and databases - Creating SSIS packages for ETL - Configuring and administering log shipping - Configuring and administering Always On Availability Groups (HADR) - Partitioning tables and indexes - Developing a data warehouse - Implementing row-level security - SQL Server Integration Services

Gracenote Los Angeles (Entertainment data and technology)

Designing, administering, developing and optimizing SQL Server 2012/2014/2016/2017 databases including ETL processes. Developing and implementing solutions for installing, configuring and administering Microsoft SQL Server - Optimizing Microsoft SQL Server, databases and server-side code - Modifying data architecture to optimize information systems - Designing databases - Optimizing performance - Developing, supporting and optimizing the server-side code: T-SQL scripts, stored procedures, user-defined functions, triggers etc. - Administering servers and databases - Creating SSIS packages for ETL - SQL Server Integration Services

Skills

Database Administrator
Database Developer
Data Management and Analytics
Data warehouse architect and developer
ETL architect, designer and developer

Work experience

Database engineer/architect/developer/administrator
since 05.2008 - Till the present day |TulaCo Ltd
.
SQL Server database engineer/architect/developer/administrator
Senior system architect
10.2005 - 05.2008 |OTR-2000 Ltd, Moscow, Russia
.
Providing consulting services for the customers in the server part of the package embedded in Microsoft SQL Server 2000.
Senior IT-specialist
10.2004 - 08.2005 |Moscow River Steamship Line Holding Company
.
- Maintenance, support and administering of the financial system. - Information security control at the holding company level. - Microsoft SQL Server 2000 Administering.
Senior Software Engineer
06.2003 - 09.2004 |Moscow Cinema Center Ltd
.
- Microsoft SQL Server 2000 databases design and development. - Developing and optimizing queries, stored procedures, user-defined functions, triggers. - Client part (Microsoft Visual FoxPro 8.0) development. - Microsoft SQL Server 2000 administering (server hardware selection, physical optimization, backups, log shipping etc).
Senior Software Engineer
03.1999 - 06.2003 |Firma AIK Ltd, Moscow, Russia
.
- Microsoft SQL Server 2000 databases design and development. - Developing and optimizing queries, stored procedures, user-defined functions, triggers. - Client part (Microsoft Visual FoxPro 6.0/8.0) development. - Microsoft SQL Server 2000 Administering (server hardware selection, physical optimization, backups, log shipping, transactional replication etc).
Senior Software Engineer
05.1998 - 02.1999 |Shakhtstroyoptorg Ltd, Rostov-On-Don, Russia
.
- Application development (Microsoft Visual FoxPro 5.0). - Application development (Microsoft Visual FoxPro 3.0).
Software Engineer / Senior Software Engineer
05.1986 - 05.1998 |Rostovshakhtostroy JSC, Rostov-On-Don, Russia
.
- Application development (Microsoft Visual FoxPro 3.0). - Application development (FoxPro for DOS).

Educational background

IT, automation and telemechanics
1981 - 1986
Technical University in the city of Novocherkassk

Languages

EnglishProficient