Tymur Sokolov Email & Phone Number

Kyiv, Ukraine

Kyiv, Ukraine

- Development and support information systems for Treasury and Liquidity department with SQL Server 2008/2012.- Development database schema, stored procedures and static data scripts to implement ETL processes.- Development derived attributes calculation and extract procedures.- Optimizing existing transformation and loading processes.- Create and support build scenario for database projects.- Preparing release scripts, working with source control and continuous integration systems.- Working closely with business representatives and DevOps teams.- Company interviewer for SQL Server candidates.- Committee member of company experts in SQL Server discipline.- Successfully mentored middle developer to achieve senior level.- Passed assessment process to reach lead level.

Kyiv, Ukraine

- Development and support ETL solutions for feeds aggregations with SQL Server 2008.- Working with complex SSIS transformations to process large data volumes.- Creating database patches to promote changes (schema, data, sql code).- Implemented script-based approach to promote mass data changes to other environment.- Documented “Golden Source” generation and “Health Check Report” processes.- Works closely with international support team.- Participated in interview process for candidates.- Had 4 weeks business trip to Stamford, USA.

Kyiv, Ukraine

Responsible for Production database environment. Create, review, fix, approve, install or rollback all database changes. Setup replication, backup, maintenance jobs. Create and support ETL processes. Install new database instances. Resolve performance and compatibility issues.- Migrated SQL Server 2000 active-passive 4-node cluster from Windows Server 2000 32-bit to SQL Server 2008 Windows Server 2008 64-bit active/active - 2-node cluster (Tel-Aviv, Israel).- Replaced three database servers with new hardware.- Installed 5 additional database instances in Rackspace Cloud.- Migrated 4 physical database servers to Hyper-V campus, decommissioned unused boxes.- Upgraded SQL 2005 express to SQL 2008 R2 Express for Project and SharePoint services.- Participated in BI & Reporting project.

Kyiv, Ukraine

Responsible for development, review and approve database changes. Checking for update and rollback code correspondence. Working on optimization of existing database codes and processes.- Documented existing database infrastructure. Updated wiki library.- Placed all database change scripts under source control.- Developed and implemented standards for making database changes.- Created database training for QA team, published presentation and video materials.- Published set of templates for typical database changes.- Trains newcomers in regards on database infrastructure.

Kyiv, Ukraine

Administrating and support company database servers. Responsible for external data transforming and loading. Working with Very Large Databases (150GB+), Address Windowing Extensions (AWE), SQL Replication, Data Partitioning.- Participating with future infrastructure planning as DBA.- Preparing analysis and monthly report for database servers loading. Proposing desirable hardware upgrades and requesting system changes if required.- Prepared and realized plan for movement database servers to new office.- Documented existing database infrastructure.- Tested, fixed and optimized current backup-restore scenarios for flexible usage.- Creating loading procedures for new incoming data, expanded database structure if required.- Administrating and support SQL transactional replication.- Continuous servers monitoring, tuning and optimization.- Checked existing databases and applications for SQL Server 2005 upgrade readiness.

Kyiv, Ukraine

Administration and support regional infrastructure for Europe, including Database, Web, Application servers for development, test and production purposes with total count of 50 units.Responsible for environment availability, continuous servers and applications monitoring, maintenance, patches installation, hardware and software upgrades, license ordering. Cooperate with developers team and application owners as database architect and business relationship manager.- Leaded Distributors Data Collection project for Russia. Created architecture and developed database part for project. Launched the system and passed to support team. Consulted key customers and businesspersons.- Leaded 5+ webMethods projects for system integrations and data ETL processes.- Developed database and webMethods parts for EDI Russia project.- Developed and support many interfaces for webMethods middleware platform.- Member of international support team for regional projects.

Kyiv, Ukraine

Providing servers and applications support. Responsible for any related processes like maintenance, upgrades, installation or decommissioning. Working closely with third party developers as customer representative.- Leaded Intranet development project with 3rd party company.- Prepared and controlled project plan, managed project from start to finish.- Leaded business part of project Phone Bulling System Expansion, consulted developers for existing company standards.- Developed and tested disaster recovery documentation for critical application servers.- Planned and realized main application server upgrade to new hardware.- Done two servers upgrade from SQL Server 7 to SQL Server 2000.- Implemented updateable SQL data partitioning approach for ISA Server Internet statistic reporting using SQL Server 2000.- Developed 200+ business reports from Excel to Crystal Reports.- Administration Crystal Enterprise reporting environment.

Kyiv, Ukraine

Architect, development, testing, implementation and support custom software. Supporting company hardware and software.- Leaded the project SciLube (www.scilube.com) – automated solution for USA lube services.- Architect and developed system from scratch (Delphi 3 + SQL Server 7).- Manage developers team with 3+ members.- Successfully remotely implemented for 10+ customers.