Sql Server Systems Administrator

William C. Goetschius Jr

* ***** ***** *****, ** 03079

Cell 603-***-****

*****@*******.***

OBJECTIVE

SQL Server DBA

QUALIFICATIONS

. DBA technician working with SQL Server 2005, SQL Server 2008, SQL

Server 2012,

SSIS, and SSRS, SQL Server Agent jobs, DB2, DB2 UDB, Sybase, SQL

Anywhere, DB2 Systems Administrator

. Application Programmer writing C++, Visual Basic, Java Websphere

applications, REXX along with SQL Server 2005/2008/2012, DB2, Sybase,

and UDB stored procedures to access Relational Databases

EDUCATION

SetFocus Master's Program in SQL Server 2005

Executive MBA University of New Hampshire, Durham, NH

Bachelor of Science, Business Administration University of New Hampshire,

Durham, NH

CERTIFICATES

2008 - Microsoft Certified IT Professional: Database Administrator

2006 - IBM Certified Database Administrator - DB2 UDB V8.1 for Linux,

UNIX and Windows

2006 - DB2 (Version 8) Fundamentals Certification

EXPERIENCE

Riverstone Insurance 04/2010 - 12/2014

. SQL Server Operational DBA

. Upgraded @50 SQL Servers 2008 - 2012 to use industry standard,

backups, DBCC Checks, Index Optimization, System Database cleanup, SQL

Alerts, recommended space configuration, and company standard recovery

models

. Created an Automated Restore process whereby with a few parmameters we

can restore From Any Server - From Any DB, To Any Server - To Any DB.

. Created Performance Statistics collection process for @50 SQL Servers.

It captures CPU, Memory, Disk, I/O, Locking, Deadlocks, TempDB, User

Counts and Transaction Counts etc. We have IDERA but only for 5

Servers.

. Upgraded SQL 7.0 and SQL 2000 Databases to SQL 2008

. Converted SQL Server 2005 SSIS Packages to SQL Server 2008 SSIS

Packages.

. Create SQL Server 2008 SSIS Packages to meet business needs.

. Create SSRS Reports to meet business needs

. Create SQL Server Agent Jobs to meet business need

. Enjoy performance and tuning using Server Side traces and DMV's

Bill Dube Ford Toyota Scion 9/2009 - 04/2010

. Car Salesmen - I was unable to find a job in my field. This was much

better than sitting at home collecting unemployment. I am a worker bee

at heart.

Vestmark, Wakefield Ma 7/2008 - 3/2009

SQL Server DBA

. Installed SQL Server

. Created Backups

. Created Restores

. Setup Log Shipping

. Ran Index Defrag's

KANA Software 06/2007 - 05/2008

Senior Technician working with DB2 UDB, UNIX, JAVA, Websphere

software.

FIDELITY INVESTMENTS SOFTWARE ENGINEER CONSULTANT 04/2007 - 06/2007

Wrote AD-Hoc DB2 SQL reports using WINSQL and REXX DB2 batch

programs.

CITY OF BOSTON SR. DB2 DBA CONSULTANT 06/2006 - 12/2006

Led Online and Batch tuning efforts for their release of PeopleSoft

version 8.9 software

Came in and organized their process and worked with Application

Programmers to

improve Online and Batch performance issues

LIBERTY MUTUAL INSURANCE COMPANY, Portsmouth, NH 06/78 - 12/2005

DBA Technician Skills

Participated in all phases of an Application project's development

using Database Relational Technology.

. Database Design

. Database Creation

. Database Backup

. Database Recovery

. Database / Application Load Testing

. Database Performance and Tuning

. Database Production Implementation

. Database Performance Monitoring

. Lead DBA / Systems Architect on a Bi-Directional Data Replication

project from DB2 on the mainframe to Sybase on a mid-range box to SQL

Anywhere on a PC

Technology Skills

DB2 DBA, DB2 UDB, IBM Data Capture OS/390, Sybase DBA Skills RS6000,

Sybase Bi-Directional Replication Skills, SQL Anywhere DBA Skills on PC,

SQLAnywhere Bi-Directional Replication Skills, IMS DBA skills,

Understanding of Relational Database internals in order to perform Database

Design, Database Performance and Tuning, and Database Performance

Monitoring.

DB2 Systems Administrator Skills

I was the first DB2 Systems Administrator for the Company. I created first

Production DB2 Subsystems. Choose all options and then monitored the

overall DB2 Subsystems performance and made changes as necessary.

. Lead software purchaser for software purchased from Database vendors

to monitor DB2 on all Mainframe subsystems. Used leverage of working

for a large company with several vendors competing for our business to

procure the best price for the Company.

. Set up standards and guidelines for DB2 use throughout the company (At

the time I received calls from recruiters who told me, they heard I

was the "best DB2 DBA in New England.")

. Lead Database Designer / DB2 Application Architect for the Company's

first DB2 Mainframe systems.

. Lead DBA on all performance and tuning issues for the Company's first

DB2 Mainframe systems.

. Taught other DBA's and application programmers how to use DB2

efficiently and

effectively

Technology Skills

Since I was the 1st DB2 Systems Administrator for the company I learned how

to install DB2 on the Mainframe OS/390. I Learned about each DB2 System

Parameter. I learned all DBA skills (database, table, and index creation,

database backup and recovery options etc.). I learned DBA performance and

tuning skills as well as DB2 Database Design skills. I then demonstrated

the ability to pass on my knowledge to other DBA's and Application

programmers.

Programming Skills

. Experience with C++ Mainframe and Mid-range programs using DB2 on the

Mainframe

. Experience with Visual Basic. Wrote a C++ Code Generator program that

allowed us to perform purges on our mainframe 150+GB DB2 database

using Visual Basic.

. Experience with Java Websphere application programming. Wrote a time

management system using Java Websphere and DB2 on the Mainframe

. Experience with DB2 stored Procedures. Wrote first Personal Market DB2

Stored procedures. Working with our DBA team and Production

Implementation team, created documentation and standards for the

rest of Personal Markets to use

. Experience with UDB stored procedures. Created over 100 UDB Production

stored procedures.

. Experience with writing PLI Programs

. Experience writing Transaction SQL in several Database Management

Systems

Technology Skills

C++ OS/390, C++ Unix, Visual Basic, Java, Websphere, REXX, JCL OS/390, DB2,

UDB

Unix, PLI, JCL

References:

Andy Leonard - Nationally Known SSIS Expert - 904-***-****

Jack Corbett - SQL MVP - 978-***-*****

Jay Hoyt - Former Mgr at Riverstone - 603-***-****

Contact this candidate