JACK D. WILLHOITE

SENIOR SQL SERVER ADMINISTRATOR

ad3ufp@r.postjobfree.com 352-***-**** 1224 KELLOGG DR., TAVARES, FL 32778

Objective

I am a SQL Server Developer and Administrator with 30+ years of hands-on experience in developing Databases as well as administering and maintaining them and various .NET applications that talk to the databases.

Professional Experience

Medadept, LLC

Senior Software Architect, April 2004–Present

For almost 20 years I’ve been part of a team that has designed, built, and maintained several Healthcare Applications. I’ve worked with Physical, Occupational, Speech, Respiratory Therapists as well as Home Health and Hospice Professionals and Doctors.

All our Servers are in Azure, and I am an Administrator for all Window’s servers. I have set up and maintained all Security Groups in Azure and been involved with successful SOC2 Audits and staying abreast of all HIPPA regulations. I access the Window’s based Servers by use of Virtual Private Networks (VPN’s) creating a completely encrypted connection. I maintain every aspect of the SQL Server security, from row/table level access to accessing the Azure Server itself

I designed the initial templates for all the SQL Tables and Views used in the Healthcare Apps. From populating the Lookup list in Drop-Down boxes in the Apps, to writing end-user data to specific tables in the Applications. I tuned each query in the Applications to provide an optimum performance to the end user.

I built JOINS of every kind, Complex Queries using Aliases, Views, Cursors, Cross Apply Queries, CTE’s and Triggers. I set up daily Differential and weekly Full Backups for each Production database. I wrote a series of complex queries that uses Restore and Verify commands to ensure the integrity of each Full database backup.

As Medadept employed additional developers, working with a Source Code Repository became critical, we chose GitHub. Building on that experience, I learned to write APIs for communications between different Applications and wrote the Source Code as well. We maintained a separate Development Server, also in the Azure space, so we could Test what we wrote before placing the new components into Production. This coupled with other steps in the CI/CD Pipeline allowed us to rapidly develop, test and deploy the new code and components.

Besides building the Source Code in a .NET environment, I used the Entity Framework to communicate with User-Specific Databases authorized by using OAuth logins which I built for Single-Sign-On to the Apps and Database.

I also built all the Clinical Reporting Application that the users need every day to communicate their findings to various people in the Healthcare world. Every Report I built has several filters that allow the user to customize what data is seen. I built an average of 80 sub-reports for each major category of Reports. I used Crystal Reports, Tableau and most recently, Telerik to build and maintain these Reports.

Skills

Database Development:

MS Access Database

SQL Stored Procedure with Variables

SQL SSIS Packages

Backup and Restore Procedures

SQL Agent Jobs

Report Development:

SQL Server Data Tools

Crystal Reports (Earlier versions)

Tableau Reports (Earlier versions)

Telerik/Progress Report Server and Tools

Code Development

VB.NET

ASP.NET

Java Script

HTML

DevOps CI/CD Software Development Methodology

Worked with GitHub Source Code Repositories

Automated Testing before placing new versions of code into Production

Accelerate Code and Data Table Development

Strict Guidelines for placing new versions of code into Production

Professional References available upon request