JAY WITHERSPOON

acxdf6@r.postjobfree.com

acxdf6@r.postjobfree.com

(954) 593 – 5105

(425) 285 - 8415

I am a SQL Server Database Administrator with 14 plus years of experience. My expertise in the installation, configuration, implementation, developing, designing, analyzing, reporting and maintenance of SQL Server versions 2000, 2005, 2008 (R2), 2012, 2014, 2016 and ETL

Career Experience:

SQL Server DBA April 2016 – Present

TriWest Healthcare Inc.

Federal Government, Phoenix, Arizona

Tracking and resolving performance related issues on Production, QA and Development Healthcare VA Government Databases

Installation and configuration of new SQL Server instances (2012, 2014 and 2016) based on best practices.

Create & Managing Database Structure, Storage Allocation.

Implementing process improvements for ETL data loads into the data warehouse.

Build out New Table Schema and Performance related Indexing rebuild

Performance Tuned Databases with fragmented or orphaned

Optimized ETL Data Loads for daily, weekly, and monthly processing

Created Support plans for QA, DEV, and Prod environments

Member of the Data Governance Committee

Support Backups with Actifo Backups Support Program

SQL Server DBA October 2015 – Mar 2016

UHG, Phoenix, Arizona

Worked within our team to support DOD Tricare Dental Program with was under the UHG/Optum Technology Support Contract

Managed and administrate the SQL Database Servers of the Disaster Recovery Team

Tracking and resolving all database issues related to Production, QA and Development Healthcare Government environments

Create and maintain backup strategies and capacity planning.

Writing PowerShell scripts for monitoring and reporting on the health of all the databases and systems in within the Gov’t UHG Organization;

Used CyberArk to access Work Bench Servers

HPSA/HPSM for Server diagnostic and Support with SQL 2014

Data Warehousing Design and Support

Unemployed August 2015 – September 2015

SQL Server DBA Mar 2015 – Jun 2015

AutoNation / TekPartners

Tracking and resolving all database issues related to Production, QA and Development environments

Installed and upgraded the database server(s) and application tools

Maintenance, retrieval, and scheduling of archived data

Generating reports through direct querying of all active databases, as needed.

Creating, maintaining, and updating database documentation

SQL Server DBA Jun 2014 - Jan 2015

State of Arizona MCCCD, Phoenix, Arizona

DUP Mon Server Installation and Upgrades Script (SQL Server 2012)

RDS_Web Migration to SCATDB01 Script (From SQL 2000 to SQL 2008)

Mesa BBAnalytic Script (SQL Server 2012)

Canvas ILM_Logons Script (SQL Server 2012)

MetaSys Server Installation and Upgrades (SQL Server 2012)

HelpDeskWorldWide DB Server Upgrades (SQL Server 2012)

BIADB Server Upgrades (SQL Server 2008-2012)

RDS_FTSE Created Database Migration from (SQL 2005) to (SQL Server 2012)

STCATDB1 Database created and maintained (SQL Server 2012)

ILM_Login Creation and Schema Creation (SQL Server 2012)

Prepared, and participated in quarterly DR tests with our IT and application support teams.

SQL Server DBA

State of Arizona - CGI Group Nov 2013 - Mar 2014

Installed and maintained SQL Server databases, including: ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.

Updated database by reviewing, planning, testing, installing database security patches and service packs.

Designed, documented, and promoted security "best practices", policies, standards and protocols.

Worked in Active/Active, Active / Passive Cluster environment as a High availability solution

Data Warehousing Design and Support

SQL Server DBA

CGI Group Gallop Technologies Aug 2013 - Oct 2013

Updated database by reviewing, planning, testing, installing database security patches and service packs.

Designed, documented, and promoted security "best practices", policies, standards and protocols.

Migrated application code and objects from development/test environments to Production.

Worked on Development, Network, SAN, and Systems teams to perform application and database warehousing and Production tuning

Checked Database Health by using DBCC Commands and DMVS

Data Warehousing Design and Support

LEAD SQL Server DBA Mar 2013 - Jun 2013

American Express, Phoenix, Arizona

Led a team of offshore DBAs in installing and maintaining Boardwalk approved application software and systems that integrate with Boardwalk's database systems.

Designed, documented, and promoted security "best practices", policies, standards and protocols.

Worked with development and systems teams to perform application and database tuning

In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.

Migrated Databases from SQL Server 2008 to SQL Server 2012

Data Warehousing Design and Support

SQL Server DBA Mar 2011 - Nov 2012

IBM Corp / Ameriprise - (CDI Contractor), Phoenix, Arizona

Automate the rebaselining of DBs in the non-Production environments

Tested applications for performance, data integrity and validation issues

Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures

Testing and implemented procedures.

Worked daily with executive level staff I.E. Business Analyst, Vendors, Directors, and Project Managers for drive out Software Life Cycles

Optimize DB logical and physical schema

Data Warehousing Design and Support

SQL Server DBA September 2010 - Jan 2011

Matrix Resources, Phoenix, Arizona

SQL Server DBA Production Support – Health Care Domain 24*7*365

Designed and Implemented Database Backup Restore Strategy

Planned Database Maintenance & Administrative Tasks

Configuring Replication / Data Synchronization

Tuning SQL Server Performance

Optimize DB logical and physical schema

Data Warehousing Design and Life Cycle Support

SQL Server DBA Feb 2010 - Aug 2010

Acxiom Corporation, Little Rock,

SQL Server DBA Production Support - E-Commerce Domain

Designed and Implemented Database Backup Restore Strategy

Auditing for SQL Server Security

Configuring Replication / Data Synchronization

Implementing and Maintaining Log Shipping Database Clustering

Monitoring with DDL Triggers SQL Server Profiler PowerShell Event Notifications

Data Warehousing Design and Life Cycle Support

SQL Server DBA Jun 2008 - Jan 2010

Microsoft Corp, Redmond, Washington)

Designed, documented, and promoted security "best practices", policies, standards and protocols.

Create processes and procedures for application code and database object migrations to support an efficient and reliable system development Life-Cycle.

Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in

Optimize DB interaction with OS, file system, storage, and network

Data Warehousing Design and Life Cycle Support

SQL Server DBA Apr-2007 - May 2008

Dell Contractor, Phoenix, AZ/Dallas, TX

Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.

Migrating Databases from SQL Server 2005 to SQL Server 2008

Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level

Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

SQL Server DBA Jun 2003 - Mar 2007

Global Skeptic Technologies, Dallas/Fort Worth Area

Installed and configured more than 2GB RAM in SQL Server 2005

Performed the migration of SQL Server 2000 to SQL Server 2005

Configured the servers on 32 bit and 64 bit clustered and standalone server environments

Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.

Data Warehousing Design and Life Cycle Support

SQL Server Software Engineer III September 1999 – March 2003 (3 years 7 months)

Sprint.com, Kansas City, Missouri Area

Installed and configured more than 2 GB RAM in SQL Server 2005

Performed the migration of SQL Server 2000 to SQL Server 2005

Configured the servers on 32 bit and 64 bit environments

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of DTS Packages to load the Data from various Databases and Files.

Implemented and maintained Database as a Disaster Recovery Solution.

Setting up Databases for Call Centers, and Monitored Databases.

EDUCATION:

2000 Sprint - University of Excellence Certified .NET Programming and SQL

2000 - 2012 SQL Server Training / Education

2001 - 2013 Specialized Technical Certifications

2001 Intervoice-Brite - Certified Software Engineer I

2002 Intervoice-Brite - Certified Software Engineer Database Connectivity

2003 Intervoice-Brite - Certified Software Engineer II Administration

2004 Sprint-Certified Advanced Visual Basic Programming

2005 IBM Certified Specialist for AIX Systems Support

2008 DCSE Enterprise Server Certified

2008 SQL Enterprise Edition

2008 MCP Certified SQL (Implementation, Design, and Maintenance)

Contact this candidate