Sql Server Engineer

Samuel L. Sparks

**** ** ***** ******, **, Seattle, WA 98125

Email: **********@*******.***

Phone: 206-***-****

[pic]

SUMMARY

SQL Server Analyst with over 10 years experience managing and supporting

databases, servers and related processes

KNOWLEDGE AREAS & SKILLS

. Analysis, Organization & Visual Problem-Solving

. SQL Server/Azure, SSIS/SSAS/SSRS & SSDT/BIDS

. IIS, SharePoint, Windows Server & Linux

. IP Networks, Storage Systems, Backups, DR & HA

. Technical Writing (Word, Excel & Visio)

. Database, Query & Index optimization

. Scripting (T-SQL, VBScript, DOS Batch, etc.)

. BI, Data Integration & Data Warehousing

PROFESSIONAL EXPERIENCE

SQL Server DBA - WatchGuard Technologies, Seattle, WA (contract for AIM

Consulting) May 2013 - Sept 2013

. Enterprise-wide Database Maintenance & Server-Consolidation

< Tuning SQL Replication & Optimizing Indexes for OLTP, Reporting

Servers & Tableau Dashboards

< Analyzing Server and Query performance issues including memory, I/O

bottlenecks, contention and blocking

< Indentifying and removing unused databases, jobs and SSIS packages,

and performing database migrations

< Migrated Enterprise Data Warehouse including SSIS packages and SSAS

Cubes to SQL 2012 platform

. Documentation and Process Automation

< Deploying Database Maintenance plans, SSIS packages, SQL Agent jobs

via Central Management Server

< Provided system deployment diagrams, build instructions, operations

and troubleshooting guide

< Established SQL Security Policy, backup schedules and monitoring

metrics for SCCM

SQL Server Administrator - Holland America Lines, Seattle, WA (contract for

AltaSource Group) Feb 2013 - May 2013

. SQL Server Upgrade and SharePoint Database Migration

< Standardizing SQL Server deployments on all Shipboard Data-Centers for

upgrade to SQL 2012

< Automating database maintenance, file cleanup and index optimization

via Central Management Server

< Migrating databases and security settings from test systems to four-

node production SQL Server cluster

< T-SQL scripts and stored procedures for database maintenance, file

usage reports and capacity planning

Database Administrator - Community Health Plan of Washington, Seattle, WA

Mar 2012 - Jan 2013

. Database / Data-Warehouse Administration - SQL 2008R2, SSIS, SSRS &

Replication

< Responsible for ETL processes, database updates, SSIS packages and

SSRS report deployment

< Monitoring server performance, memory and disk space utilization and

file organization (~1TB database)

< Creating SQL Agents jobs and optimizing schedules for running SSIS

packages (~200 GB nightly load)

. Process Automation - SQL Agent, Opalis Integration Server & Scripting

< Automating FTP imports, file conversion, data migrations, SSIS and SQL

agent job execution via Opalis

< Migrating data via replication, and log-shipping for reporting and

test databases (200 - 300 GB databases)

< Writing T-SQL scripts for restoring and migrating databases, and re-

running failed SSIS packages

< VBScript, Jscript and DOS scripts for file processing, date-stamping,

archiving, etc.

. Documenting Systems and Processes - Excel, Word, Visio, SharePoint,

Subversion/Tortoise & Numara Track-It

< Creating system deployment and data-flow diagrams, operation notes and

troubleshooting guides

< Administering and maintaining security for SubVersion source-code

library

Visual Data Specialist I - Aerotek, Inc., Bellevue, WA

June 2010 - May 2011

Contract for Google Maps performing manual updating of content for street

maps. Responsible for reviewing map imagery and applying policies for road

creation, alignment, validation and classification within various country

databases. Utilizing internal CAD tools to apply map symbols for

representing road types, traffic rules, POIs, etc.

Database Administrator - Daptiv (formerly eProject) Inc., Seattle, WA

Nov 2006 - Aug 2008

Administering accounts, databases and backup systems for a SaaS internet

application. Providing tier-2 customer support and documenting deployment,

operating, backup and recovery procedures for multiple production

databases. Deploying and testing database changes on SQL 2000/2005 Servers,

creating T-SQL queries for table indexing, backups and custom reports.

Scheduling and monitoring tape backups (Symantec BackupExec 11d).

Installing and maintaining data-center equipment including (Windows 2003)

servers, storage arrays, KVM, power management and cabling.

Technical Support Engineer - Streambox, Inc., Seattle, WA

Aug 2006 - Nov 2006

First-line support for a Video-Over-IP product for television broadcast and

interactive performances. Interfacing with engineers to troubleshoot remote

installations and networks, optimizing audio and video settings for minimal

artifacts and latency issues, providing field updates to firmware, software

and Windows XP embedded OS. Creating assembly, installation and test

procedures, including a product guide in Adobe InDesign and Photoshop,

preparing equipment for pre-sales solutions, and providing root-cause

failure analysis to improve manufacturing and shipping methods.

Support Analyst/Engineer (contracts with various agencies) - Microsoft

Corp., Redmond, WA May 2002 - July 2006

Assigned to various business and product groups including BGIT, Tablet PC,

and Xbox Live. Deploying intranet applications on Windows 2003 Server with

NLB, IIS/ASP.NET and SQL Server 2000, including Content Management Server

2002 and SharePoint Portal Server 2003. Managing lab servers, test systems

and OS deployments via Altiris, for monitoring test scenarios and daily

build verification scripts. Installing, configuring and documenting

equipment and cabling for over 150 (Windows and Linux) servers with Avocent

KVM over IP, Sentry power & DLT tape library.

EDUCATION & TRAINING

North Seattle Community College: Nanotechnology Training Program

2010

Bellevue Community College: Graphics Design Certificate

2005

Volt Technical Education: SQL Server Database Design and Implementation

2003

University of Washington Extension: XML Standards and Technologies

Certificate 2002

Data

Communications Certificate 1997

C Programming

Certificate 1996

Washington State University: Bachelor of Science in Electrical Engineering

1983

AFFILIATIONS & CERTIFICATION

Microsoft Certified Technical Specialist (MCTS) for SQL Server 2005

2008

Microsoft Certified Database Administrator (MCDBA) for SQL Server 2000

2003

Microsoft Certified Application Developer (MCAD) for C#/ASP.NET

2003

Microsoft Certified Systems Engineer (MCSE) for Windows 2003 Server

2003

Membership - IEEE (ieee.org) and MCP since 1999

Contact this candidate