KENT KRUG

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

Jacksonville FL ***50

E-Mail: acpi0e@r.postjobfree.com

Phone: 904-***-****

OBJECTIVE

To secure a Database Administration position where I can incorporate my 10+

years of experience.

SOFTWARE

ERWIN, System Architect, VMware, SQL Server 6.5 - 2014, DTS, SSIS, Oracle

6, 7, 8, 9i, 10g, 11g,, Oracle Forms, Oracle Reports, TOAD, SQL

Navigator, SQL*Loader, DB2, ASP.NET, ASP, VB.NET, Visual Basic 4.5 -6,

VBScript, VBA,, WMI, ADO.NET, DAO, MAPI, CDO, ActiveX,, HTML,

Infragistics Ultra Web Suite, Crystal Reports 4.5 - 10, Active Reports,

Microsoft Access 2.0 - 2013, PowerPoint, Visio, SourceSafe, LiteSpeed,

Ignite Monitoring Tool

EDUCATION

. Indiana University of Pennsylvania, Indiana, Pennsylvania

. B.A. Economics

. Harrisburg Area Community College, Harrisburg, PA

. Database, Systems Analysis

. Wake Technical Community College, Raleigh, NC

. Networking

. FCCJ, Jacksonville, FL

. Oracle SQL, PL/SQL & Database Administration

CERTIFICATIONS

. MCDBA, MCSE, MCITP: DBA and Developer 2005 and 2008, MCSA, MCSD,

Microsoft Small Business Specialist, OCP DBA 10g

PROFESSIONAL EXPERIENCE

Database Professional Consultants, Inc.

NOV 2013 - Present

Database Consultant\Owner

. Migrated and upgraded multiple databases

. Installed 32 and 64 bit drivers and created Linked Server to AS400

Database

. Create Backup and Maintenance Plans and perform general DBA functions.

Cypress Property and Casualty Insurance

OCT 2011 - January 2015

DBA

. Installed SQL Server 2008 R2 and upgraded SQL Server 2005 Databases to

SQL Server 2008 R2 and SQL Server 2012 and 2014 in a test environment

. Create Tables, Views, Function, etc. for new 2.2 TB Data Warehouse

. Created ETL Packages that loaded Data from AS400, Oracle into SQL

Server Data Warehouse

. Configured Reporting Server, BI Application Server, Great Plains and

various other Database Servers

. Develop SSIS and Reporting Services Solutions and managed the

deployment, subscriptions, etc.

. Implemented Backup and Recovery Procedures, Maintenance Plans,

performed other common DBA duties

. Monitored SQL Server Jobs.

. Mentored and assisted Developers and BA's on an ongoing

basis.

First Coast Service Options

OCT 2009 - NOV 2009

DBA

. Converted DTS Packages to SSIS.

. Created scripts for deployments to Production.

Safariland - BAE Systems Subsidiary (Contract)

JUL 2009 - AUG 2009

Database Developer

. Consolidated data from several Oracle Databases and SQL Server

Databases into an Oracle 10g Operational Data Store Database for

Reporting purposes

PSS World Medical

SEP 2006 -MAY 2009

Database Administrator

. Created and maintained ERD Diagrams and implemented physical design

. Created SQL Server Traces, queried System Tables, stepped through C#

and VB.NET code to identify deficiencies in the SQL Server Procedures,

User defined Functions.

. Installed 3rd party SQL Server 2005 Databases, decommissioned Database

Servers and moved Database to different Servers to consolidate and

optimize performance

. Monitored Database growth and identified space requirements for

Database files and Backups

. Performed Database Backups and restored Databases to a Point in Time

. Created ETL Packages (DTS and SSIS) to transfer to between SQL and

Oracle Databases and import and export data to and from various file

formats

. Provided ongoing support to various departments with developing ad-hoc

queries, performance and connection issues to include SQL Server,

Oracle and Microsoft Access

Fidelity Information Services

AUG 2005 - SEP 2006

Web & Client Services C# Team Database Analyst/DBA

. Performed Data Modeling and implemented physical Database

. Create Tables, Indexes, Constraints, Stored Procedures, UDF's

Triggers, DTS Packages

. Created scripts to Promote to create and modify objects from

Development to QA & Production

. Tuned Stored Procedures and Monitored Production SQL Servers

Allstate (Contract)

JAN 2005 - JUN 2005

SQL Server Developer/DBA

. Converted Postgre SQL Database to SQL Server, wrote DTS Packages to

load Database

. Modified existing DTS Packages and created deployment scripts

. Created SQL Scripts on a daily basis to perform updates of data

Merrill Lynch (Contract)

APR 2004 - DEC 2004

SQL Server Development DBA

. Performed data modeling, database design and implementation

. Converted Access Tables, Access Queries, VBA Code into SQL Server

Objects

. Created DTS Package to load SQL and refresh Several Tables from Sybase

. Integrated Data from various external data sources into single

databases

. Created Staging Tables, DTS Packages and Stored Procedures to populate

Operational Data Store

Medical Services Company

SEP 2001 - JAN 2004

Web Development and Database Administration Team Leader

. Lead Development effort to transfer Legacy Application Data to SQL

Server Database.

. Created the logical and physical design and implemented and promoted

from the Development, QA and Production Environments.

. Created queries from the legacy system to generate text files, created

DTS Packages to load Tables from text files and created Stored

Procedures and UDF's for an ASP.NET/VB.NET SQL Server Application that

interacted with Insurance Adjusters, TPA's & Pharmacy Benefit

Management System (PBMS) and customer service

. Translated conversations and quickly created functional Relational

Databases

. Created Database Objects, Constraints, UDF's, Stored Procedures, Views

and Triggers

. Gathered requirements and created a Prototype using VB.NET for an

application that provided the functionality to search and drill down

on Insurance Companies and TPA Regions Adjusters, Patients, Claims and

generate Pharmacy utilization Reports

. Gathered requirements and led the development effort for a ASP.NET

/SQL Server component that processed Pharmacy Orders, rejects and

overrides, generated e-mails to the adjusters for authorizations of

medication outside the formulary, displayed and printed unpaid,

overpaid or partially paid invoices and interfaced with a PBMS

. Created tables to store & report medical billing (HCFA 1500) data to

include HCPCS, CPT & ICD 9 Codes.

. Created queries from Accounting Legacy Systems and imported into Great

Plains.

. Provided Technical Support for ADP and migration to Ceridian.

BellSouth (Contract)

MAR 2001 - SEP 2001

SQL Server DBA/Developer

. Worked in a SQL Server Environment with data feeds into SQL Server

from Oracle, Teradata, DB2, and Informix Data Sources

. Developer for Bellsouth and Singular Small Business Marketing Rebates

Applications

. Created Stored Procedures and wrote VB Modules to extract service

orders to determine the number of activations and disconnects and

generate excel objects that are e-mailed to the customer and posted to

the STARS Web Site

. Developed project specifications Developed scripts to initiate FTP

Sessions

. Developed Stored Procedures and Visual Basic Programs that dynamically

created Excel Worksheets

TeleHealth Inc.

FEB 1999 - MAR 2001

Systems Engineer

. Responsible for the development of logical data models and the

creation of physical database designs

. Created tables, Indexes, Constraints, Stored Procedure, Views and

Triggers

. I created a program that captures Health Level 7 (HL7), Admission,

Discharge and Transfer (ADT) messages and store into SQL Server to

enable patients to rent their telephone/television and provide billing

information feeds to the vendor

. Developed an automated Simulcast (Phone and TV) Hospital Customer

Satisfaction Survey Component for Baptist Health Jacksonville

. Developed Application that captures payroll and sales information

extracts data from a locked down Excel Workbook and creates a text

file, e-mails text file attachment using MAPI to a Server to import

into SQL Server, validate and process the data and load into J.D.

Edwards.

. Developed Crystal Reports for Digital Video on Demand System and

Customer Satisfaction Reporting.

. Created VB/SQL Server Credit Scoring Program for Dunn & Bradstreet

Application.

. Provided Technical Support for ADP Payroll and Human Resource System.

EDS (Contract)

AUG 1998 - MAR 1999

Systems Engineer

. Developed a VB 4.5/SQL 6.5 Server application by creating COM Objects

and writing ADO

. Wrote code to Push Data to General Motors FTP Site

Pennsylvania Department of Commerce and Community & Economic Development

JUL 1987 - AUG 1998

Computer Systems Management Trainee/Systems Analyst I - IV (Design

Parenthetical)/DBA/Developer

. Lead DBA/Developer/Architect responsible for the analysis, design and

development of all database applications

. Responsible for all phases of the System Development Life Cycle

. Designed and developed conceptual, logical and physical data models

and implemented physical design

. Integrated disparate databases into single databases and from various

file formats

. Imported and Exported Data to and from Oracle

. Created Tables, Views, Procedures, and Triggers

. Created Several Databases for Economic Development and Community

Affairs

. Developed reports for various revolving loan programs using Crystal

Reports

US Army Reserve (Activation)

NOV 1990 - NOV 1991

1LT Finance & Accounting Officer

. Responsible for all sections of Military and Civilian Pay, Control,

Finance Services, Reconciliation, In-Out Processing, Travel,

Commercial Accounts and the Finance Crisis Coordination Center

. Operations Team Leader for Mobilization and Demobilization of Soldiers

for Finance Processing

. Performed the duties of a vacant GS-12 Information Technology

Civilian Position

. Wrote various Finance and payroll programs to calculate Variable

Housing Allowance and Separation payments during demobilization when

the IBM Mainframe crashed during demobilization operations

Contact this candidate