Aleksey Vitsko

Experience

• 

  Validio Ukraine

  Jun 2008 - Feb 2009

  Junior Tester
• 

  International Bridge, Inc.

  Jan 2010 - now

  Oleksii Vitsko - Aleksey VitskoDBA StackExchange: https://dba.stackexchange.com/users/133879/aleksey-vitsko?tab=profileGitHub: https://github.com/aleksey-vitsko/Database-Administrator-ToolsWorking with Microsoft SQL Server for several yearsHave experience with following:1. Production Database Administration (install/configure SQL Server, make sure its highly available, HA/DR, monitor and improve performance, updates/patching, backup/restore, integrity checks, security, maintenance, migrations, etc.)2. Development Database Administration (working with developers on SQL scripts, creating stored procedures, triggers and other database objects, optimizing SQL scripts for performance, ensuring best practices are followed, providing logins and permissions, etc.) 3. Business Intelligence (creating reports with SQL/Excel, good experience with Power BI in conjunction with SQL Server) Show less Have experience in following: - Windows Administration- Domain Admin- Active Directory Domain Controllers (AD DC)- Internal DNS / Public DNS- Failover Cluster Admin (WSFC)- Virtualization (vSphere, Proxmox, Azure)- Database Admin (SQL server)- Cloud Service Providers (Microsoft Azure)- Azure Subscription Admin (Production and Test)- Office 365 Portal Admin- Power BI Portal Admin- Webserver admin (IIS)- FTP Admin (Gene 6 FTP)- Source Control Admin (GIT, Visual Studio GIT) - Redmine Admin (Ticketing System)- Firewall admin (pfSense, SonicWall)- VPN (SoftEther, SonicWall, Azure)- Email Admin (Icewarp, Office 365 / Exchange) Show less Wrote numerous SQL reports for Business / Management / Operations / Finance teams. Core reports and reporting tables - are still used by this day. Used Excel for visualization, later Power BIDesigned data warehouse, ETL and refresh process, tables for reporting, stored procedures (DWH and ETL are constrained to SQL Server, agent/jobs, T-SQL). Reporting tables are used by Reporting TeamImproved and optimized SQL code of core Production applications Make company's APIs and systems go faster, allowing for increased volume / bandwidthWrote stored procedures that are widely used by Reporting, Billing, IT departments and by Production applications Maintained "Billing System" (application for generation invoices). Was responsible for correctness of “Billing System” Invoice charges, surcharges and total $ amount calculationCreated and maintained billing rules and Invoice charge calculation algorithms in T-SQL according to business logic and demands from the customers Refactored Rate tables structure and schema for the "Billing System", developed SQL procedures for managing rates. Performed yearly rate increases for all customers in the “Billing System”. Improved and simplified rate increase processDeveloped audit process for payments of the "no-invoice" customers, apple to apple comparison of ours vs customers data and highlight the differenceDeveloped stored procedures for database administration:BackupSP, IntegrityCheckSP, ScriptLoginPermissions, IndexDefragSP, AzureIndexDefragSP, ViewSessionsConnections, DatabaseSizeSP, SpaceUsedRating, IndexInfo, MemoryManagerInfo, BufferPoolInfo, ViewServerProperties, TempDBInfo, ShowTableUsage Show less

  • SQL Server Database Administrator

    May 2016 - now

  • System Administrator

    May 2016 - May 2020

  • SQL Developer

    May 2013 - May 2016

  • Accountant

    Jan 2010 - May 2016