Desktop Support Sql Server
Resume:
Mike Hornfeck
Akron, OH ****3
*********@****.***
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