Felix Tarnovsky

About Felix Tarnovsky

Highly experienced Database and Data Warehouse Team Lead with a deep knowledge of IT enterprise ecosystems.Results-oriented database specialist designing and implementing advanced database solutions.

Experience

1. Lead Database Administrator

   UChicago Medicine

   Mar 2011 — Present · Chicago, IL, US

   Supporting configuration, implementation, maintenance, and integration of critical SQL Server systems.Configuring and maintaining database servers and applications, including monitoring of system health and performance.Designed and built AlwaysOn Availability Group databases for SQL Server on premise, as well as Azure SQL VM. Designing, building and supporting Azure Databases. Developing monitoring routines for SQL Server environments.Providing database solutions for Healthcare enterprise applications like Epic and Unified Data Platform for Healthcare Analytics. Advised the proper database schemas which increased both inpatient and outpatient data analytics capabilities by about 30%.Assisting developers with complex query tuning and schema refinement; recommending code adjustment for application users. Designed and implemented SQL Server migrations from on-premises to cloud environments.Performing database capacity planning, providing storage projections and storage layouts to infrastructure teams. Saved 60 TB of PowerStore storage disk space by configuring SQL Servers according to most effective RTO/RPO policies.Configured SQL Server Azure Databases and Elastic Pools, performed Azure databases restores on demand.Implemented database indexing strategy and Backup and Recovery standards which improved applications performances by ~20%.Designed enterprise wide standards for SQL Servers and business continuity policies for Epic Cogito systems.

Education

• Lviv Polytechnic National University

  Bachelor's degree, Electrical, Electronics and Communications Engineering

Skills

• Troubleshooting
• Business Analysis
• Windows
• Ibm Datastage
• Analysis
• Sql Server
• Operating Systems
• Sdlc
• Pl/Sql
• Sybase Products
• Extract, Transform, Load (Etl)
• Netezza
• Intersystems Cache
• Database Design
• T-Sql
• Postgresql
• Database Administration
• Microsoft Sql Server
• Red Hat Linux
• Unix Shell Scripting
• Etl
• Administration
• Documentation
• Performance Tuning
• Unix
• Data Modeling
• Sql
• Visio
• Shell Scripting
• Sybase
• Project Management
• Oracle
• Databases