Yaroslav Alpízar Zhuravlev

Designed and executed a plan to move +20 WSFC with VLDBs (4-6TB x instance) to new hardware with minimum downtime. Design and execute a plan to migrate critical production systems from tens of WSFC to AlwaysOn Availability Groups on AWS EC2 instances with minimal downtime. Responsible for data availability, consistency, and performance of +50 SQL Server 2012/2016 instances with critical production VLDBs (4-6TB). Architect systems for HA/DR including replication, log shipping, WSFC and AlwaysOn technologies.

- Manage and monitor health of SQL Servers 2008 & 2008R2, 2014, including backups, restores, replication, mirroring. - Configuration, maintenance and troubleshooting of AlwaysOn AvailabilityGroups on SQL Server 2014 - Review and tune SQL queries, stored procedures, views, triggers and other database objects. - SQL Server 2008 & 2008R2, 2014 performance tuning. - Design and implement database changes. - Reliably improve database performance by examining hardware, software, and storage configuration

Deeply involved with hospitality and tourism my current duties range from daily user requests related with hotel booking platform to weeks long projects developing XML integrations with new providers. Daily tasks include tsql and vb.net coding, performance optimization and code cleaning. Intranet maintenance, include new requests and in general improve all processes whenever is possible.

Reporting to the Club Operations Director, responsible for the maintenance and development of operational systems to support business processes, general reporting and product billing across the business. Additional responsibilities include ensuring the accuracy and integrity of all Club and Member information and processes within the software systems, reviewing current system functionality, procedures and reporting capabilities. Regular contact on a daily basis with directors and managers.

VisualBasic.Net development and maintenance on VisualStudio 2010 framework of a backoffice ecommerce application. Analysis, design and development of CRM and Shipping module to update the existing one. Query tuning and optimization, development and tuning of stored procedures, maintenance and administration of SQL Server 2008R2 databases. Administration and development of a new Magento + OpenERP CMS platform for eCommerce, together with MySQL and PostegreSQL.

Analysis, development and monitoring of a platform for aeronautical operations, including customers as Pullmantur, ClickAir, SkyWork Airlines, VipAir, ElitAvia and others. Main tasks included database development, administration and optimization and also integrations with external systems through SOAP architecture to obtain real-life data for aeronautical operations (Jeppesen flight plans, NOTAM's, PPS, cosmic radiation data, external booking systems).

Development and maintenance of DOMETour (ERP/CRM for travels and reservation operations) on Delphi 2005 integrated development platform. Using Toad and PL/SQL for daily tasks, query tuning and creation of detailed reports for end users. Remote connections to end users to solve in-site issues and training on newly added options. Provide users help by creating reports of new developments as well as answering emails on a daily basis.

Development and optimization of a ERP/CRM platform for retail sales. SQL Server 2000 and 2005 where used together with Delphi 2005 integrated development platform. Database development, tuning and administration for several clients. Migration from other platforms and databases. Query and stored procedure tuning and optimization. Remote connections as well as insite visit to customers for training and new developments analysis

Analysis, development and maintenance of a desktop application based on Delphi integrated development enviroment. The application is in charge of recovering data via serial and USB ports from a wide range of interfaces on a chemical I+D laboratory. Data recovered is then analized and processed to give inmediate feedback to the user in form of reports and tabulated spreed sheets. IT manager and administrator. Server configuration and management.

Installation, configuration and maintenance of company intranet. Supervision of daily IT related tasks. Server tasks included configuration, administration and management. Other IT related tasks as adding, configuring and managing user permissions. Company web site configuration and update together with a web designer. Advice and recommendation on new hardaware to buy on a basic budget. Provide assistance to all users on their daily tasks. Teaching a small introductory course to all users on basic internet

Helped to design and improve clients database to get new reports, better usability and performance. Suggested new improvements to gather information usefull for management decision making. Improved database performance by query and index tuning. Installing and configuration of several user desktops. Windows Server 2000 configuration and management for a small quantity of users. Network maintenance, managing users.

MOC 2778: Writing queries using MS SQL Server 2008 tSQL MOC 6232: Implementing a MS SQL Server 2008 database MOC 6231: Maintaining a MS SQL Server 2008 database

Principal subjects and occupational skills covered: Distributed applications (multitier architecture, cloud computing), Free software (Linux, phyton, Django platform), Internet protocols, Security Web architecture, Mobile communications, Data mining, Embedded systems

My work on my undergraduate thesis on "Software for creation and simulation of n-bar systems" was selected on the industrial design subject on the Design School of Havana as main software for students to learn how to design n-bar systems and simulate how they interact between them.