Resume

Sign in

Project Manager Sql

Location:
Smithville, Missouri, 64089, United States
Salary:
90000
Posted:
October 17, 2016

Contact this candidate

Resume:

**** ****** *****, **********, ** 640**-***-*** **64 acw3ne@r.postjobfree.com

Dan Schlobohm

Objective

Looking for an opportunity to work with a team and allow my SQL knowledge help solve problems.

Experience

Aug 2015 – Jul 2016

Sherman Consulting Inc.

Kansas City, MO

Senior Database Administrator

Manage over 200 servers for the USDA

Created Scripts to automatically update CMS servers for the USDA

Recovered missing SSRS reports

Discovered a Deadlock for the USDA that was causing data loss

Rewrote linked server reports to capture CPU, IO, Deadlock, disk space management, VM or physical, core count and server property

Fixed issue with customers job install and issue with server install

Fixed all the data with the recovered SSRS Report

Created an uptime job using link servers to verify SQL server off or SQL server Agent

April 2014 – Aug 2015

DSC Consulting Services

Kansas City, MO

Senior Database Administrator, 2014-2015

Setup Always on Clustering SQL2014 for a Grantham University

Installed SSIS 2014 and SSRS 2014 for a Grantham University

Discovered and rewrote several views and store procedures.

Recommended the setup of the DR environments for several local internet companies

Recommended structure changes to improve performance

Use Toad to update MYSQL

Use Toad to update Oracle

Recommended the redesign of the databases to allow for archiving

Dec 2001 - April 2014

Nations Holding Company

Prairie Village, KS

Senior Database Administrator, 2010-2014

Administers 20+ SQL servers in development and production using SQL2012, SQL2008R2

Database DR setting up and maintaining Replicated Mirrored and Clustering SQL2012

Created Jobs to monitor database growth catching several runaway applications

Created Jobs to keep track of CPU and Read, Writes allowing for the addition of Indexes or I would rewrite the query

Integrated Microsoft Dynamics and SQL servers automating the export to the IRS

Integrated SQL with all the banking vendors including UMB, Chase and BOA

Used ERWIN 8.5 to redesign Nations MYSQL database to SQL

Designed all of Nations New Databases with ERWIN 8.5

Project Manager during the acquisition of NVS

Experienced T-SQL Developer with over 14 years T-SQL programming

Connected to Oracle

Monitored and repaired all performance issues on all Servers with RedGate and Performance Monitor

SQL Team Lead and Database Administrator, 2005-2009

SQL team lead (Managed a team of 4) during the rewrite of the legacy app

The group and I created and maintained over 2000 views an stored procedures

lead a team of 3 while redesigning the database for the legacy rewrite of the title and appraisal program with over 1000 tables

The group and I created all the tables, foreign keys and indexes

Setup the schema and file groups needed to assist in performance

In order to keep the new application and the legacy app in sync, I created triggers and stored procedures to write the data in both systems

I setup merge replication so all 5 of the production servers could communicate with the legacy app

Database Administrator, 2003-2004

Set-up Transactional Replication between Pittsburg and Prairie Village, KS

Added the BPO company to legacy layout

Data Designer/SQL Developer, 2002-2002

Redesigned Legacy App using Erwin

Recommended Structure changes to improve performance

Nov 1999 – Dec 2001

Datacore Marketing

Kansas City, MO

Director of IT & DBA, 1999-2001

Director of IT and SQL 2000 DBA during the creation of a multi-tier data warehousing system

Managed a Team of 5 (VB developers) that created applications that collected marketing information

Created a program to collect marketing information for Swatch Watches improving the sale of watches

Created a program to collect marketing information for Hill's Science Diet improving the sale of Dog food to the veterinaries

1991 - 1999

Creative Meetings

Kansas City, MO

Director of IT, 1995-1999

Managed a team of four (Basic, Foxpro developers)

Created and sold a registration program to TWA and American Airlines

Installed and administered MSExchange

Network administrator 40 station network

Programmer/Analyst, 1990-1994

Created a group meeting system used to run marketing meetings for Marion Merrill Dow improving the sale of pharmaceuticals

Created a program that would scan the airline flights for lowest fare fewest connections

Tools

Clustering, AlwaysOn, SQL2014, Virtual Machines, SQL 2000, SQL 2005, SQL 2008 R2, SQL 2012 SSMS 2012, Microsoft Dynamics Nav, ERWIN, T-SQL, SSIS, SSRS, SSAS, RedGate,Google Hangout, Gmail, Power Shell, CMS

Education

Computer Science

1979-1981 Longview College

Kansas City, MO

References

References are available on request.



Contact this candidate