Sql Server Manager

MIKHAIL ILINE

**** ********** *****,

Alpharetta GA 30004

E-mail: **********@*****.***

Cell: (404) 729 - 4499

Linkedin profile: https://www.linkedin.com/in/mike-iline-7397119?trk=nav_responsive_tab_profile

Summary of Experience:

Over 16 years of experience in Information Technology including over 9 years of experience in Healthcare Industry (Medical software: EPIC, Nextgen, McKesson, GEMMS, HL7 Interfaces, AllScripts & etc)

Over 13 years of experience as Sr. Database Administrator in SQL Server & Oracle environments

Professional experience in 24x7x365 High Availability environments for many years

Over 4+ years of experience with EPIC Clarity ETL and Database installation, maintenance, troubleshooting and performance optimization (Console, Compass, Hyperspace, SQL Server databases, OLAP Cubes and ETL processes) with solid knowledge of EPIC Clarity & Caboodle data models, Healthy Planet and reporting.

Excellent analytical, management, self-managing, logical and troubleshooting skills

Proven ability to communicate and work well with co-workers, end-users and clients on all levels

CERTIFICATION:

• 2016 EPIC Radar Dashboard Administration 2015

• 2016 EPIC Caboodle Administration 2016

• 2016 EPIC Clarity 2016: Extract, Transform and Load Administration

• 2016 EPIC Cogito 2015: Star Data Warehouse Administration

• 2016 EPIC Clarity 2015: Extract, Transform and Load Administration

• 2014 Microsoft Certified Solutions Expert: SQL Server 2012 Data Platform

• 2014 EPIC Clarity 2014: Extract, Transform and Load Administration

• 2013 EPIC Clarity 2012: Extract, Transform and Load Administration

• 2012 Microsoft Certified IT Professional: SQL Server 2008 Database Administration

• 2008 Microsoft Certified IT Professional: SQL Server 2005 Database Administration

• 2003 Oracle 9i OCP DBA

EDUCATION:

2017 EPIC: RPT650 Reporting Workbench Self-Study 2015

2016 EPIC, Madison, WI: EPIC RDR100 Radar Dashboard 2015

2015 EPIC, Madison, WI: EPIC Cogito Star Data Warehouse 2015 Administration

2012-2013 EPIC, Madison, WI: EPIC 2012 CLR150 & CLR250: Clarity Extract, Transform & Load Administration

2012 Global knowledge Technical Education Center, Atlanta GA:

VMWare vSphere (VCP 5.0): Install, Configure, Manage (40 hours)

2011 Oracle University, Atlanta GA: Oracle 11G Database Administration RAC & Grid Course (40 hours)

2006 Technical Education Center, Norcross GA: Oracle 10G Database Administration Course (40 hours)

2005 Technical Education Center, Norcross GA: PMI Project Management Professional Prep (35 hours)

2005 Microsoft, Atlanta GA: SQL Server 2000 Performance Tuning Workshop (24 hours)

2003 Technical Education Center, Norcross GA: Oracle 9i OCP DBA Course (140 hours)

1998-1999 CSC Institute, Philadelphia PA: Implementing a SQL Server & Oracle Database Design (840 hours)

1982-1987 Moscow Metallurgical Institute, Moscow, Russia: BS in Engineering, Minor in Computer Science

Databases:

MS SQL Server 2014/2012/2008R2/2005 & Oracle 11g/10g/9i, MS Access 7.0/2000/2003

Languages:

SQL, PL/SQL, Transact-SQL, MS Visual Basic 6.0, VB.NET, C#, HTML, ASP, XML, VBScript and JavaScript, Web Services, VMWare vSphere

Operating Systems:

Windows NT/2000/XP/2003/2008/2012, UNIX HP, MS DOS, Linux

Tools:

Talend, Qlickview, Tableau, Idera (SQL Diagnostic Manager), Quest tools (Foglight, Spotlight & Performance Manager), Veritas, Tivoli, MOM, Visual Studio .NET, Component Services Manager, Erwin, SSIS, BizTalk Server, TOAD, Erwin, Crystal Reports, Visual SourceSafe, Legato Disk Extender, Veeam 8.0, SSIS, SSRS & SSAS.

PROFESSIONAL EXPERIENCE:

9/2016 – 12/2016

EPIC Database Administrator (Contractor) Bayhealth Medical Center, Dover DE

Perform Day-to-day ETL and Database Administrator functions on EPIC Clarity & Cogito environments and Healthy Planet Epic software module: monitor and resolve Clarity & Caboodle ETL & DB’s performance issues, troubleshoot extract error messages, load failures, SU upgrades, BI SSIS development, tuning of SQL query, analyze & support reporting needs, evaluate Population Health goals and translate clinical requirements into necessary IT specifications for reports, dashboards, and workflows, Troubleshoot and modify EPIC Reporting Workbench & Crystal reports performance and distribution.

6/2016 – 9/2016

Database Administrator (Contractor) Longmont United Hospital, Longmont CO

Performed Day-to-day DBA functions on McKesson SQL Server environments: monitoring, troubleshooting, business needs support, BI SSIS development, tuning of SQL query, analyze and support reporting needs.

11/2015 – 4/2016

Database Administrator (Contractor) UC San Diego Health, San Diego CA

BI ETL development and production support Pharmacy, HealthPlans, Outside Billers, SOM, Collections and ZNB files and transfer data into Cognos DW DB, using different SSIS packages.

Developed ETL migration process from Cognos DW into EPIC Cogito Star DW pre-stage environment.

Provided activities related to the EPIC 2014 Clarity & Cogito Star ETL & Database Administration

Provided activities related to the Cognos 8.4.1 migration from old to new environments.

Translate Healthy Planet clinical requirements into necessary IT specifications for reports & dashboards.

Troubleshoot and modify EPIC Reporting Workbench & Crystal reports performance and distribution.

06/2015 – 11/2015

Architect/Sr. Database Administrator (Contractor) AdvancED, Atlanta GA

Architect the data warehouse technology and solutions serving internal and external customers, developed Data model for various reporting based Data marts, enhancement of OLTP data model using Erwin and Talend.

Created, published and processed an eProve Data Cube for SQL Server Analysis Server.

Created various dimensions, fact tables by understanding business requirement, managed SSIS.

Extensively worked on tuning of SQL query, optimizing batch process as well tuning various ETL jobs,

Day-to-day DBA monitoring and business needs analysis, analyze and support Tableau porting needs.

04/2015 – 05/2015

EPIC Clarity DBA/ETL Administrator (Contractor) Cleveland Clinic, Cleveland OH

EPIC 2014 Clarity ETL migration project

Provided activities related to the EPIC 2014 Clarity ETL Target Platform migration: worked with EPIC Nova case’s related to the 2014 upgrade, support the systems performance for multiple EPIC 2010 & 2014 Clarity non-production and production environments (Console, Compass, Hyperspace, Oracle 11.g)

Created and scheduled Clarity ETL extracts, resolve Clarity ETL performance issues, troubleshoot extract error messages, load failures, data and table issues, maintain custom KB-SQL code and etc.

08/2014 – 02/2015

Database Administrator (Contractor) OSF HealthCare, Peoria IL

•Provided activities related to the EPIC 2014 Target Database Platform migration: Installed Microsoft SQL Server 2012 Enterprise, upgrade existing Clarity ETL & SQL Server 2008R2 DB environments, restore DB’s & migrate SSIS packages, supported Clarity OLAP Cube's using SSIS and SSAS.

•Involved to planning and designing SSAS 2012 Cubes

•Performed Day-to-day DBA functions: monitoring, troubleshooting, business needs analysis and security.

09/2009 – 07/2014

Sr. ETL & Database Administrator WellStar Health Systems, Atlanta GA

I have been part of the team responsible for implementation and ongoing support for the new Epic electronic medical record (EMR) being deployed across the corporation with primary responsibility for implementing, testing and maintaining for multiple EPIC Clarity non-production and production environments (i.e., console, Compass, hyperspace, Clarity SQL Server DB’s, Cogito Data Warehouse & configuration of Epic tools) with following essential functions:

Installed and maintained complete Clarity & Cogito DW non-production and production environments (Clarity & Data Warehouse Consoles; Hyperspace; Clarity, CogitoDW & CMS SQL databases; BO & OLAP Cubes).

•Created and scheduled Clarity ETL extracts, resolved ETL issues, such as error messages (Warnings & Errors), KB-SQL problems, load failures, data & table issues, maintain custom KB-SQL code to deliver accurate data.

•Performed advanced DBA functions: Physical DB design, linked server definition and security, Day-to-day DBA monitoring and business needs analysis, Participated in a 24x7 on-call DBA rotation

•Extensively worked on BI SSRS,SSIS & SSAS development, tuning SQL query, ETL and batch jobs.

•Troubleshoot and modify EPIC Crystal reports performance and distribution.

8/2007 – 7/2009 Independent Consulting

During my work at CDC Software my responsibilities included, but were not limited to, Sr. DBA work:

Architect & Developed from Business requirements Budgeting tool, including Budgeting database and ETL SSIS packages, where Budget related values was submitted and calculated using Excel templates and SQL Server 2005 Integration & Reporting services (SSIS & SSRS).

7x24 Database administration, BI development, performance tuning, assisting development team in China.

During my assignment in AIG, one of the insurance providers, I have held Sr. SQL Server / Oracle DBA responsibilities: server administration, backup and maintenance implementation for 24x7 SQL Servers & Oracle, ETL work with DTS & SSIS, database schema design, performance tuning, server configuration such as failover server cluster, log shipping and replication, assisting development team in India.

Worked on data warehouse / business intelligence / data archiving solutions.

Setup & troubleshoot different SQL Server High Availability technology’s (Cluster, Log Shipping, Replication)

03/2006 – 08/2007

Sr. SQL Server & Oracle DBA McKesson, Marietta GA

Performed Day-to-day the Database Administration in 24x7 SQL Server & Oracle environments:

(Nextgen, Kronos, HPF, API, Portal, HCR, HCI & other…) for more than 75 SQL Servers & 23 Oracle

Instances running in UNIX and Windows 2003 OS using SQL Server & Oracle Tools (backups, system

performance, user access, activity levels, system events, error logs, performance tuning, connectivity issues).

02/2004 – 03/2006

SQL Server & Oracle DBA Cox Enterprises, Atlanta, GA

Provided the 7x24 Database Administration, backup and maintenance implementation for 64-bit Active-Active-Passive SQL Server Cluster & nearly 40 SQL Servers used Microsoft Operations Manager 2005, ETL work with DTS, SSIS, performance tuning, reporting with SQL Server Reporting Services, .Disaster Recovery tests.

09/2002 - 12/2003 Independent Consulting

During my work at ADP my responsibilities included, but were not limited to, DBA work: redesigned the MS SQL Server 7.0/2000 database schema into a more normalized architecture, maintained and modified database objects (Stored Procedures, Tables, Views, Triggers, Indexes and DTS packages).

My assignment at Edgeware Computers included DBA responsibilities such as all aspects of SQL Server 2000 Database administration and architect, including data modeling, replication and recovery system.

07/2000 - 06/2002

Senior Systems Engineer / Development DBA Z-Tel Telecommunications, Atlanta, GA

Supported, administrated, developed and resolved WEB application and database problems related to company WEB Trouble Ticket & IVR applications.

Designed, developed, implemented in production different SQL objects, such as stored procedures, tables, views, triggers, indexes & DTS packages based on Specifications in MS SQL Server 7.0/2000.

07/1999-07/2000

Senior Systems Analyst/Oracle DBA CIBA Vision, Duluth, GA

Maintained original Marketing and Sales information system (MASS) using MS Visual Basic 6.0, Oracle PL/SQL and Oracle 8.1.5 at a lower Database Abstraction level.

Designed, Developed, Assisted in Implementation of Stored Procedures, Tables, Stored Packages, Triggers and Sequences in PL/SQL based on Specifications in Oracle 8.5, Created Unix shell scripts.

Contact this candidate