Mike Hornfeck

**** ******** *****

Akron, OH ****3

330-***-****

ac68jq@r.postjobfree.com

Professional Profile

20+ years’ experience in Database Administration, Development, Reporting and support of SQL Server 2014/2008/2005/2001 and Sybase 16. Highly knowledgeable and experienced SQL DBA/Developer who is business-savvy and driven. Proactive and resourceful professional with track record of success in designing, developing and managing SQL Servers and Enterprise applications.

Education

The University of Akron, Akron, OH

Bachelor of Science – Accounting - 1994

Core Qualifications

SQL Server 2014

T-SQL

Sybase 16

SSIS, SSRS

Query writing and optimization

Performance improvements

Application upgrades

Power Shell

ASP.NET

Crystal Reports

HL7

Hardware upgrades

Patch management

Professional Experience

Cleveland Clinic/Akron General Health System (& Visiting Nurse Service & Affiliates) 1996 - 2018

Sr Programmer Analyst (2013 - 9/2018)

Database Administrator (2000 – 2013)

Financial System Analyst (1998 – 2000)

PC Tech Support (1996 – 1998)

Maintained 10 SQL Servers; over 100 databases.

Maintained 4 Sybase servers; 20 databases and 150 offline clinical databases.

Maintained 30 application servers.

Maintained and supported Enterprise Healthcare applications.

Experience in installation, configuration and administration of SQL Server 2014 version.

Experience in extracting, transforming and loading data (ETL) using SSIS packages.

Experience in in T-SQL.

Experience in Creating Tables, Views, Stored Procedures, User Defined Functions.

Experience in building Adhoc Reports, Parameterized Reports, Linked Reports, Toggle Reports, and Reports with Sub Reports using SSRS.

Experience in, backup/recovery, disaster recovery and planning.

Experience in using DMV/Perfmon/SQL Profiler/Scripts and other third party tools to resolve bottlenecks, dead locks and slow running queries.

Experience in automating process by creating jobs, and error reporting using alerts, SQL Mail Agent.

Rebuilding / monitoring the indexes at regular intervals for better performance.

Experience working with HL7 interfaces.

Provided desktop support.

Provided technical support and guidance to staff.

Certification

ITIL

Contact this candidate