SQL DBA
Resume:
Timothy Hosack
*********@*****.***
SQL DBA Experience Summary
Total SQL Server DBA experience - 12 years
Total SQL Server T-SQL development experience - 12 years
SQL Server DBA and development comprehensive experience - 12 years
Windows 2000, 2003 and 2008 Enterprise Server Administration - 12 years
SQL Server 2012 database administration - 2 years
SQL Server 2014 database administration - 1 year
SQL Server 2008 (R2) database administration - 5 years
SQL Server 2005 and 2008 SSIS development and administration - 8 years
SQL Server 2005 and 2008 Reporting services development and administration
- 8 years
Windows Cluster (active-passive and active-active) administration - 10
years
VMware (vSphere 5.0 with hardware versions 7 and 8) supported for SQL
Server - 5 years
Windows 2008 (R2) Server and Hyper-V (virtual machine) supported for SQL
Server - 5 years
SAN architectures and mounted storage - 10 years
RAID disk array support for SQL Server - 12 years
Professional Experience by Project
Trailstone LLC.
2801 Via Fortuna Drive
Austin, Texas
Sr. SQL DBA
October 2014 to Feb 2015 (short term contract)
Performed migrations to SQL Server 2014 for existing SQL 2012 databases
Performance Tuning of all SQL 2012 and 2014 databases including indexing
Oversaw over-all health checking and general maintenance of all SQL 2012
and 2014 instances, servers, and databases
Created plan for future database scalability
Created H.A. ALWAYS ON Clustering for SQL Server 2012 and 2014 platforms
Management of indexes and databases for SQL 2012 and 2014
Redeployment of SSIS packages on SQL 2012 and 2014 in development, test,
and production environments
Mentoring junior developers on both SQL 2012 and 2014 platforms
Implementing new features of SQL 2012 and 2014 such as in memory objects
(tables and indexes)
Interacted with development teams to determine best practices and standards
for new and existing SQL 2012 and 2014 databases
Kinetic D
Austin, Texas (Dallas and Toronto Data Centers - Remote Support)
Sr. SQL DBA and Architect
February 2013 to October 2014
Responsible for the installations and configurations of new SQL Server 2012
and servers and SQL instances in two data centers in Dallas as the sole Sr.
SQL DBA
Configured SQL 2012 Enterprise ALWAYS ON clusters and availability groups
Responsible for the authoring and implementation of SQL Server 2012 Build
Documentation and the chief editor of all SQL documentation thereof.
Supporting two remote data centers in Toronto, Canada and Dallas, Texas
Implement new features of SQL 2012 such as page level compression and
backup compression as well as development of new T-SQL objects
Optimization of current production SQL 2012 Server database servers and
instances, of which there are 3 SQL 2012 clustered instances
Optimization includes the separation and arrangement of new files on
separate disks thereby dividing and load balancing the I/O pressures that
may impact SQL Server production loads and avoiding I/O bottle-necks
including on RAID 5 and RAID 10 SAS and SAN LUN disks as well as some solid
state storage for improved IOP's
Making recommendations for enhancement of coded objects such as parallel
processing and adjusting isolation levels (ie. read committed snapshot)
within stored procedures for better optimization and utilization of both
upper memory 64 GB+ as well as CPU cores
Making recommendations for future optimization with features of SQL Server
2012 Enterprise such as database compression to further minimize I/O impact
during production by as much as 1000% (100 GB tables vs.1TB plus) and
advanced database file partitioning
IBM
Lead Senior SQL DBA and Architect
Account Focal for Baker Hughes International
Houston, Texas
June 2011 to January 2013
Involved heavily in daily builds of SQL Server 2008 R2 instance
installations and configurations including performance tuning, fail-over
planning and best practices
Installed and administered Windows 2008 R2 and SQL 2008 R2 clusters for
high availability and increased performance of SQL databases through
performance tuning
Heavy capacity planning for memory, CPU, and I/O utilization for SQL Server
2008 R2 shared clustered instances and highly transactional databases over
1 Terabyte
Designing and physically installing both active passive and active active
clusters
Designing layouts for SAN LUN disk space allocations based on calculated
and estimated database growth patterns during weekly and monthly averages
Management of physical disks for optimization and performance for SQL
Server 2008 R2 including creating new SQL data and log files over a range
of SAN LUN's
Includes capacity and performance planning for two Share Point 2010
projects for designed for improved monitoring and reporting to the
management chain
Includes performing of large scale migrations of SQL Server 2005 databases
to SQL Server 2008 R2 clustered instances
Supported VMware hardware versions 7 and 8 for SQL Server installations
Troubleshooting of SQL stored procedures and other code for performance
enhancements and in some cases making recommendations for rewrites in code
Managed and monitored SQL Server 2008 R2 processing and I/O with advanced
SQL tools including resource governor and cluster resource load balancing
Attend daily conference calls with both IBM and the customer to discuss
current and new projects that are in scope for the current and upcoming
quarter
Met with management on a weekly basis to update with information on
projects
Supported remote customers to manage SQL transactional (OLTP) processing
Created and managed SQL Server performance tuning enhancements to database
objects including tables, indexes, stored procedures, and views.
Created documentation and specifications to outline SQL Server 2008 R2 and
SQL Server 2012 instance configurations such as upper memory allocations,
CPU, disk I/O affinities and advanced settings for instance specific loads
and database sizes
Southwest Airlines
Feb 2011 - June 2011
SQL Server 2008 R2 upgrade and physical clustering migration project
Supported production instances of SQL Server 2005 and SQL Server 2008
Enterprise
Met daily with project managers and teams to discuss and determine project
scope
Monitored all SQL Serves and SQL instances and made necessary configuration
changes
Supported all customer and user base line requests and requirements for SQL
migrations
Performed upgrade analysis and made recommendations for configuring SQL
2008 R2
Performed analysis and make recommendations for legacy systems to be
upgraded
Performed monitoring and analysis of physical disk I/O for performance
resolution
Created new documentation to serve as the background and recommendation for
the SQL Server 2008 R2 upgrades and migrations
Worked with SAN storage engineer to determine best overall builds and
performance
Implemented SQL Server 2008 R2 installations in testing environments to be
in place for several months before fully migrating to SQL Server 2008 R2
production environment
Developed T-SQL code and stored procedures to perform ETL and DML
functionality within SQL Server 2005 and 2008 R2 OLTP databases
Developed SSIS packages to perform ETL functionality within SQL Server 2008
R2 OLTP databases and data warehouses
Created automation for nightly updates for SQL Server 2005 and 2008 R2
databases
Supported SQL Server 2005 and 2008 R2 servers and databases on a 24x7 on
call basis both on site and remote
City of Fort Worth
August 2010 - December 2010
Supported SQL 2000, 2005, and 2008 databases
Imported and converted DTS packages to SQL 2005 and 2008 SSIS
Assessed databases for possible upgrade and migration to SQL Server 2008 R2
Debugged, reconfigured objects, and rewrote SSIS packages for SQL 2008 SSIS
64 bit
Rewrote and optimized SQL Server 2008 objects including stored procedures
Installed and configured SQL 2008 Reporting Services (SSRS)
Managed SQL Server Reporting Services using Report Manager
Worked with Vendors to install and/or upgrade applications and databases
Made recommendations for SQL migrations to SQL Server 2008 R2
Microsoft
Senior SQL Server DBA
Jan 2010 - Aug 2010
SQL Server 2008 R2 Implementation and Support Project
Provided direction and guidance on large Enterprise environments to install
and configure SQL Server 2008 R2 servers, clusters, instances, databases,
reporting services (SSRS) and integration services (SSIS), and other
applications.
Providing knowledge and direction on new features of SQL Server 2008 R2
including database compression, database mirroring, multiple instance
management, and master data services.
Performing and assisting in SQL upgrades, migrations, and server
consolidations from SQL 2000, 2005, and 2008 to SQL Server 2008 R2.
Supported VMware and Hyper-V virtual machines
Supported remote customers to build and scale out SQL clusters and assist
in server specifications and storage sizing and make recommendations based
on experience and Microsoft best practices with SQL Server including
multiple database file distribution on RAID disk arrays, solid state
drives, or SAN LUN
Provide support for performance issues and walk through steps to identify
performance bottle-necks and performance enhancement and boosting
techniques
Engage in redeployment of SQL Server 2008 R2 after performance issues are
identified and resolved
Provided information recommendations on Oracle to SQL Server 2008 R2
migrations
Sr. SQL DBA Consultant
First Bank of Puerto Rico
Contract - October 2009 to Feb 2010
SQL Server 2008 Cluster Database Consolidation/Migration
Performed analysis and assessment of production environment and wrote
recommendations
Created and maintained all documentation regarding SQL Server 2008
consolidation migration
Met with business groups and technical teams to introduce and discuss SQL
consolidation and Server 2008 cluster database migration strategy and the
long term benefits
Installed and configured SQL Server 2008 Enterprise Cluster on Windows 2008
Enterprise Server
Installed and managed Windows 2008 Server services and for SQL Server 2008
cluster
Performed analysis recommendations for allocating, and configuring SAN
LUN's for SQL 2008
Performed memory and CPU allocation for SQL Server 2008 instances on the
cluster
Installed and configured SQL 2008 Integration Services (SSIS)
Imported and converted DTS packages from SQL 2000 to SQL 2008 SSIS
Debugged, reconfigured objects, and re-wrote SSIS packages for SQL 2008
SSIS 64 bit
Created SSIS package migrations from SQL Server 2005 to SQL Server 2008
Installed and configured SQL 2008 Reporting Services (SSRS)
Recreated SQL objects including stored procedures using T-SQL scripting for
SQL 2008
Performed table re-indexing and updating statistics for SQL 2008
Currently working intermittently off-site for remaining project length
Professional Experience
Sr. SQL 2005/2008 DBA Consultant
Benefit Mall - Dallas, Texas
Contract May 2009 - October 2009
SQL Server 2008 Cluster Database Consolidation/Migration/Upgrade
Installed and configured SQL Server 2008 Enterprise Cluster on Windows 2008
Server
Installed and managed Windows 2008 Server services and for SQL Server 2008
cluster
Performed analysis and made recommendations for configuring SAN LUN for SQL
2008
Monitored and made recommendations for memory and CPU allocation for SQL
Server 2008 instances on SQL clusters and stand alone servers
Installed and configured SQL 2008 Integration Services (SSIS)
Imported and converted DTS packages from SQL 2000 to SQL 2008 SSIS
Debugged, reconfigured objects, and re-wrote SSIS packages for SQL 2008
SSIS 64 bit
Created new SSIS packages in SQL 2005 and in SQL 2008 for new ETL processes
Installed and configured SQL 2008 Reporting Services (SSRS)
Imported and converted SQL 2000/2005 reports to for SQL 2008 SSRS
Recreated SQL objects including stored procedures using T-SQL scripting for
SQL 2008
Performed table re-indexing and updating statistics for SQL 2008
Implemented SQL 2008 and signed-off to production support team
Sr. SQL Server 2005/2008 DBA + SAP
Commercial Metals Company - Irving, Texas
SQL DBA + SAP Consulting project - October 2008 to May 2009
Performed administration on 50+ SQL Server 2005 and SQL Server 2008
clustered servers
Supported 20 TB of production SAP databases, including ECC 5 and Net Weaver
BW modules
Monitored growth for multiple SAP databases on SQL Server 2005/2008
Created and implemented SQL Server 2005 maintenance and backup jobs for
Litespeed
Supported high availability SQL Server 2005/2008 20 TB clusters and SAN LUN
mounts
Configured advanced SQL Server memory management and connection settings
Installed and managed the SQL clustering and server nodes including the
windows 2008 services
Supported VMware virtual machines for SQL Server
Installed new instances of SQL Server 2008 on development and test servers
Upgraded and migrated 15 SQL Server 2005 databases to SQL Server 2008
Managed SAN space for SQL Lite Speed to perform SQL backups
Created complex custom T-SQL queries and stored procedures in SQL Server
2005
Used SQL Server 2005/2008 management tools to monitor instance and database
activity
Created new SSIS packages in SQL 2005 and SQL 2008 to extract data from
multiple servers and databases into SQL Server 2008 reporting databases
Developed reports for monitoring SQL Server instances on SQL Server 2008
SSRS
Monitored SQL Server 2005/2008 databases with SQL Profiler + Windows 2003
Server Performance Monitoring tools as well as SCOM alerts
Sr. SQL Server 2005/2008 DBA/Architect
CALPERS - California Public Employee Retirement Services
Sacramento, California
Consulting Project Started May 2008 to October 2008
Implemented and managed SQL Server 2005 Analysis Services financial
databases
Used Erwin Data Modeling and pushed changes through to test and production
databases
Created SQL 2005 Tables, Triggers, Views, Procedures for financial analysis
databases
Installed SQL Server 2008 on development and test servers including SSIS
and SSRS
Worked with advanced 3 TB SAN and 64 bit SQL Server technologies
Created complex custom T-SQL queries and stored procedures in SQL Server
2005
Designed and developed advanced SSIS packages to migrate Oracle databases
to SQL 2005
Supported a large development team for a full life cycle development and
testing of a real estate analysis application using an Oracle 10G data
warehouse
Wrote SQL DDL, DML, and ETL for converting Oracle data within Integration
(SSIS) packages
Installed SQL Server 2005 Reporting, Integration, and Analysis Services
Administered, configured, and designed SQL Server 2005 Reporting Services
Reviewed and assisted in rewriting SQL stored procedures for developers
Designed and implemented SQL security with SQL administrative, developer,
and user roles
Created SQL 2005 Maintenance Plans and jobs for full and transaction log
backups
Maintained SQL 2005 databases with enhanced performance tuning and query
optimization
Supported Windows 2003 Enterprise and SQL Server 2005 Clusters
Supported VMware version 4
Sr. SQL Server 2005 DBA/Architect
CCP Games - "EVE On-line" Reykjavik, Iceland
Consulting Project Started December 2nd 2007 to April 15th 2008
Designed and developed SQL Server 2005 financial databases
Created SQL Server 2005 Database objects
Created and administered MySQL databases and tables for development and
testing purposes
Wrote logic for database objects in MySQL databases
Designed and developed SSIS packages for data archiving to SQL Server 2005
data warehouse
Created new reporting database schema for finance and accounting data
analysis
Designed and developed SQL Server 2005 stored procedures for reports in
financial databases
Created SQL Server 2005 Reporting Services instance, databases, views, and
stored procedures
Created SQL Server 2005 Maintenance Plans and jobs for performance tuning
and re-indexing
Supported 1.5 TB databases on a 24 hour weekly tier three rotation
Supported Windows 2003 Enterprise Server Cluster and SQL Server 2005
Clusters
Supported VMware virtual machines for SQL Server instances
Supported Enterprise Applications Development Teams with code
implementations
Supported SQL Server 2005 database mirroring and fail-over procedures
Created and Supported SQL Server 2005 instance and database security and
roles
Sr. SQL Server 2005 DBA/Architect SQL 2005 Migration
Scalability Experts at Anadarko Petroleum Company
Contract - Migration 07/2007 to 12/2007
Performed database upgrade for both SQL 2000 and SQL 2005 Databases
Performed SQL Server 2005 database migrations and server/instance
consolidations
Performed SQL 2000 DTS to SQL 2005 SSIS package migrations
Project Manager for SQL 2005 migrations and consolidations
Created all documentation to provide strategy and methods for all SQL 2005
migrations
Designed and implemented SQL 2005 migrations for over 70 databases
1Terabyte of data
Provided SQL Server 2005 expertise to SQL database team and presented
technical facts
Performed SQL 2005 login migrations for SQL 2000 and SQL 2005 servers
Recommended and/or implementing hot failover capabilities for SQL Server
2005 databases
Supported SQL Server 2005 database mirroring and clustering
Sr. SQL Server 2005 DBA
XO Communications
Contract 1/2007 - 07/2007
Focus - designing SQL 2005 databases and database migrations
Created all documentation to provide strategy and methods for SQL 2005
migrations
Acted as the assistant project manager for SQL 2005 migrations and
consolidations
Provided SQL Server 2005 expertise to SQL database team and voice opinions
in meetings
Wrote and posted standardization documentation for SQL Server 2005 in
SharePoint 2007
Performed testing of Quest Spotlight and Capacity Manager for monitoring
SQL 2005 databases
Provided assessment of SQL 2005 with and without Quest tools
Provided support for over 20 SQL 2000 database servers including clustered
servers
Administer 60 SQL 2000 production databases and 2 data warehouses (500 GB)
Designed and developed new database schemas for SQL 2005
Created all documentation to provide strategy and methods for SQL 2005
migrations
Implemented SQL 2005 on test servers and performed test migrations from
production databases
Posted documentation to team VSS and SQL 2005 site
Migrated DTS packages to SSIS
Migrated SQL 2000 logins with scripts to SQL 2005
Designed, developed, configured, and tested new SSIS packages to improve
ETL feeds to data warehouses and transactional SQL 2000 and SQL 2005
production servers
Supported and maintained Great Plains 10 Enterprise Production Databases
Wrote advanced SQL 2005 stored procedures for reports and data warehouse
archive ETL
Configured linked servers to manage processes from SQL 2000 to SQL 2005 and
from Oracle 10G to SQL 2005
SQL 2005 Developer/DBA
Dell Computers Contract 2/2006 - 1/2007
Met weekly with business customers and management to gain understanding of
the business requirements and changes needed for complex call metrics
reporting and new data loads.
Worked with developers, database administrators, and managers from all of
Dells direct to customer lines of business, including all sales departments
and technical support departments for business and technical requirements
gathering.
Collected and compiled analysis and proposals to consolidate data in
various applications to include vendor software data to be imported to SQL
Server 2005 reporting database
Wrote SQL stored procedures for eliminating and preventing record
duplicates
Created thorough documentation, including snapshot screens to demonstrate
step-by-step solutions for implementing changes or performing routine
procedures and tasks
Created DTS packages to integrate data between Siebel 6 on an Oracle9i to
SQL 2005
Created SQL Server 2000 DTS packages to migrate databases from MS Access to
SQL 2005
Created and managed 100+ DTS packages to merge all of this data into SQL
2005
Designed and developed SQL Server 2000 production database schemas, indexes
(clustered and non-clustered), T-SQL stored procedures, aggregations,
functions
Created SQL aggregated roll-up and cubed data used for reporting
Created SQL Server 2005 maintenance plans with full backups of databases
and transaction logs
Performed all SQL Server 2005 tasks including database backup/recovery,
database roles, users and groups, SQL performance tuning and re-indexing,
managed DTS packages
Used SQL Profiler to view and manage SQL transactions along with SQL query
analyzer to fine tune code and increase performance.
Created SQL Server 2005 tables and stored procedures to import Oracle data
warehouse
Designed and developed SQL Server 2000 production reporting table schemas,
indexes (clustered and non-clustered), stored procedures, functions, and
views.
SQL Server 2000 Development/Production DBA
Bearing Point Inc. Austin, TX
Contracted 8/2005 to 2/2006
Supported and maintained SQL 2000 and SQL 2005 databases and servers
Managed and monitored SQL 2000/2005 database activity and performance
tuning
Designed and performed SQL database migrations to SQL 2005 servers
Performance tuned databases, tables, indexes, stored procedures, DTS
packages and SQL jobs.
Created new databases and schema for financial reporting databases and data
warehouses
Created complex DTS packages to load Oracle and Access data into SQL 2000
and 2005
Supported over 8 different production and test databases and applications
from 2GB to 850GB
Managed and monitored database activity on SQL 2000 clustered server
instances, Snapshot Replication, and Transactional Replication for SQL
Server 2000 databases.
Performed weekly database maintenance tasks (backup, indexing, and
performance tuning)
Designed and developed advance T-SQL stored procedures.
Created advanced DTS packages for data migrations and loads.
Installed SQL Server 2000 and 2005 instances both in test and production
Attended weekly meetings with development and infrastructure management
SQL 2000 DBA/Developer
Xerox Corporation Lewisville, TX
Contract 3/2005 - 8/2005
Performed SQL Server 2000 database migrations to SQL Server 2005
Created and configuring SQL Server instances on multiple servers
Worked with development teams to push applications and databases from
development and test servers to Windows 2003 Enterprise production servers
Created log-shipping scripts for database transaction logs to be replicated
to remote servers
Created SQL scripts to perform updates, inserts, and database modifications
Created SQL jobs to perform database maintenance, indexing, and
backup/recovery plans on production database
Created SQL DTS packages for importing, exporting, and transformation of
data to and from
Debugged and performance-tuned T-SQL stored procedures and other SQL
scripts to maintain business functional needs in fast-paced environment
Oracle databases as well as other SQL databases and MS Access and flat
files
SQL Server 2000 DBA/Developer
Capstone Inc. 711 Inc Contract 5/2004 - 3/2005
Performed database migration for 711 Inc. Legal from SQL Server 7 to SQL
Server 2000
Designed now database schema for SQL 2000 legal reporting database
New database implementation and migration involved writing de-duplication T-
SQL scripts for having different column names, data types keys, constraints
and indexes
Verified all data imports and consistencies were visible at the application
layer
Created stored procedures to query the legacy database and in the new
database
Created stored procedures and views for reporting and data analysis for
users\ Worked with developers, database administrators, and managers from
all of Dells direct to customer lines of business, including all sales
departments and technical requirements
SQL Server 2000 Developer/DBA
J.P. Morgan Chase, Monroe, LA 8/2003 - 4/2004
Designed databases for the work-flow of the department of Government
Insured Loans based on requirements from senior management and super-users
Used SQL Server 2000 Query Analyzer to build coded objects and used
execution plans to increase performance by tuning queries to run
efficiently
Created DTS packages to import data and create new tables from Oracle8i to
SQL Server 2000.
Designed and developed SQL Server 2000 production database and data
warehouse schemas, table schema, indexes (clustered and non-clustered),
stored procedures with aggregates, functions, temp tables, triggers, and
jobs, all written in T-SQL
Migrated tables from Oracle 8i Enterprise to SQL Server 2000 with DTS
packages and SQL Navigator for Oracle
SQL Server 2000 DBA/Developer and Crystal Reports 8.5 Writer
HGP LLC, Marshal, TX Contract 2/2003 - 8/2003
Created SQL Server 2000 tables, indexes (clustered and non-clustered),
queries, views, aggregate and scalar functions, stored procedures, and
triggers.
Created and managed SQL 2000 DTS packages for importing data objects into
SQL Server 2000
Created SQL scheduled jobs, linked servers (production and data
mart/archived servers) and databases, and performed all aspects of SQL
Server 2000 administration (logins, permissions, roles, locks, performance
tuning with Query Analyzer Execution Plan).
Analyzed and recreated stored procedures to carry out the archiving of
older data in the production database server to the data warehouse database
server, as well as to purge data
Created reports in SQL Server 2000 (w/ T-SQL stored procedures) and in
Crystal Reports 8.5.
Tyler Technical College Spring and Fall 2002 (28 HRS C.S.)
Application Support - Database Analyst
Texas Medicaid - Austin Texas - Nation Health Insurance Company 2000-2002
Oversaw the implementation of Texas Medicaid software installations and
upgrades
Interfaced with customers daily regarding problematic issues, specifically
errors of a vague nature and performed analysis and debugging to correct
these errors. Maintained good relationships with all customers by showing
superior performance and caring of their needs
Interacted with Software vendors to expedite the progress of fixes and
maintain good relationships with these vendors.
Interacted with Medicaid, Medicare, BC/BS and all elements of the Access
claims databases
Education and Military experience
Stephen F. Austin State University 1992-1999 (172 HRS C.I.S and B.A.)
US Army, Wurzburg Germany 1994-1996
D.O.D. Armored Division Parts, Maintenance and Logistics Databases
Tyler Technical College 2002 (28 HRS C.S.)
Contact this candidate