Yaroslav Alpízar Zhuravlev
Angestellt, Senior SQL Server DBA, VerizonConnect
Dublin, Irland
Werdegang
Berufserfahrung von Yaroslav Alpízar Zhuravlev
Bis heute 5 Jahre und 8 Monate, seit Nov. 2018
Senior SQL Server DBA
VerizonConnect
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
4 Monate, Sep. 2013 - Dez. 2013
Software analyst, SQL developer
Logitravel
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.
4 Monate, März 2013 - Juni 2013
Systems support officer (BI analyst and sql developer)
Club La Costa
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.
1 Jahr und 6 Monate, Okt. 2011 - März 2013
Analyst & developer, DBA junior
DigitalToyShop.com
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.
3 Jahre und 10 Monate, Nov. 2007 - Aug. 2011
Software anaylst and developer
SkyOps Informatica
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).
7 Monate, März 2007 - Sep. 2007
Software anaylst and developer
Dome Consulting & Solutions SL
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.
5 Monate, Okt. 2006 - Feb. 2007
Software anaylst and developer
ProSystem, consultoria de proyectos y aplicaciones
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
1 Jahr und 6 Monate, Feb. 2005 - Juli 2006
Anaylst and developer, IT admin
Universidad de las Islas Baleares (UIB)
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.
2 Jahre und 5 Monate, Sep. 2002 - Jan. 2005
IT manager
The Havana Company
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
1 Jahr und 7 Monate, Feb. 2001 - Aug. 2002
Database developer
Center for Cross-Cultural Study (CCCS)
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.
Ausbildung von Yaroslav Alpízar Zhuravlev
9 Monate, Feb. 2012 - Okt. 2012
Information technology
Intergrupo.net
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
1 Jahr und 1 Monat, Sep. 2009 - Sep. 2010
Information technology
Universidad de las Islas Baleares, España
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
4 Jahre und 10 Monate, Sep. 1997 - Juni 2002
Information technology
Universidad Politécnica Jose Antonio Echeverría
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.
Sprachen
Spanisch
Muttersprache
Englisch
Fließend
Russisch
Gut
Französisch
Gut