Sql Server DBA

Leigh Houck

Livermore, CA 925-***-**** ******@*****.*** https://www.linkedin.com/in/leigh-houck-644748b/

Senior Database Administrator

Database Design & Developmentò Server Administrationò Issue Resolution

Adept Senior Database Administrator with 10+ years’ demonstrated expertise owning Database Management operations and Administration. A prolific problem solver and troubleshooter, proactively identifying, monitoring, and rapidly resolving issues with poise and diligence. Proven experience developing physical database designs and logical data models, leveraging prowess in DBA on large and small organizational scales, supporting SQL Server Installation, Administration, Maintenance, and Upgrades. Multifaceted technical skill-set bolstered by adaptability to new/emerging technologies, methodologies, and standards.

Core Competencies

SQL & MySQL Configuration

Capacity Planning

Performance Tuning

Disaster Recovery

Continuity Planning

Replication & Mirroring

Cluster Management

AlwaysOn High Availability Groups

AWS

SQL Server Monitoring

PowerShell

ETL

Reporting & Maintenance

Solar Winds

Idera

Professional Experience

Database AdministratoròBlackhawk Network Holdings, Inc.òPleasanton, CA 2015 – 2019

Administer SQL Server and MySQL databases, monitoring databases for availability and performance, backups and recoveries, Disaster Recovery, CPU and memory utilization, and complex issue analysis and resolution. Implement and configure numerous SQL Server failover clusters with SQL ServerServer 2014. Utilize SolarWinds DPA in monitoring and troubleshooting of various user and system database issues.

Notable Accomplishments

Own optimization and installation of SQL Server (2008 – 2016) and install SQL Server 2014 and 2016 Enterprise and Standard Edition on clusters, standalone servers, and VMWare.

Successfully implement, upgrade, and support new and emerging technology, including Attunity, AWS, and MariaDB, replicating large-scale corporate tables to data warehouse platforms.

Establish support databases and jobs for monitoring, reporting, and maintenance of databases.

Expediently analyze and resolve numerous job, backup, index, failover, logged errors, restarts, and reboots.

Troubleshoot and optimize slow database servers through performance analysis, index optimization, configuration changes, and statistics monitoring/maintenance.

Database AdministratoròMBSIòModesto, CA 2010 – 2015

Owned administration of SQL Server databases, monitoring performance and uptime while leading backups, recoveries, Disaster Recovery, disk space utilization, and issue resolution. Implemented numerous SQL Server failover clusters. Leveraged Idera SQL Diagnostics Manager for monitoring and troubleshooting performance and various issues. Conducted regular analysis of SQL Servers with Idera SQL Diagnostic Manager to improve performance on every level, including queries, configuration, and indexes. Provided post-installation support, reviewing SQL and indexes for subsequent performance tuning. Drove up-to-date statistics on automatic and nightly job basis relevant to performance, and tracked index fragmentation and space utilization on all drives with alerts while managing baseline SQL Server instances and server performance for tuning.

Notable Accomplishments

Optimized and installed SQL servers on clusters, standalone servers, and VMWare, installing key features including integration, analysis, and reporting services.

Utilized Powershell and T-SQL to automate re-indexing process for production clusters.

Developed maintenance jobs, targeting objects requiring expedient optimization.

Database AdministratoròIBMòSan Ramon, CA 2007 – 2009

Spearheaded SQL Administration in multiple datacenters nationally, monitoring database availability and performance, managing backups and recoveries, Disaster Recovery, disk utilization, and problem analysis and resolution. Implemented RAID arrays and HDD’s ranging from 400 GB to 4 TB’s.

Notable Accomplishments

Provided support for 2K users and Operator Services with 5K users in a team of six.

Championed all post-installation support, reviewing SQL indexes for performance tuning and ensuring timely reorganizations and statistical updates regularly in addition to tracking index fragmentation and space utilization.

Senior Database AdministratoròAT&TòSan Ramon, CA 2001 – 2007

Issued on-point operational database support for DB2 and IMS databases. Conducted database backup and recovery, Disaster Recovery, growth and disk space utilization, issue analysis and resolution, security, and authored documentation as necessary.

Notable Accomplishments

Optimized databases, creating DB2 support files, DB2 OS and system-level schemas, and special features for physical DBMS, including RACF, IBM tools, and AT&T DB tools.

Engaged in Project Management, leading 10+ DBA’s in professional development for IBM Rocket DBA tools to implement naming standards for DB files across several large-scale platforms; project encompassed ~12 months and resulted in release of many TB’s of disk storage and thousands of tapes for storage and backup of obsolete production and/or unusable data, saving an ~$100K with an additional savings in disk storage space.

Education

Bachelor of Science – Bowie State University

Certifications/Professional Development

Microsoft Certified Technology Specialist (MCTS), Microsoft Corporation

Microsoft Certified IT Professional – Database Administration, Microsoft Corporation

System Engineer Development Program, Electronic Data Systems

Technical Skills

Tools

SQL Server 2017, 2014, 2012 & 2008 R2, MySQL,AWS, Workbench, Netezza, Aqua Data Studio, Linux, Putty, WinSCP,PowerShell, Idera SQL Diagnostic Manager, Attunity Replicate, Solar Winds(Ignite), T-SQL, SQL, Activity Monitor, Performance Monitor, Database Engine Tuning Advisor, SQL Server Profiler, Dynamic Management Views (DMVs), Windows Server 2008 R2/2012, Change Control/Management, S3

Methods

SQL Server and MySQL configuration, Capacity Planning, Performance Tuning, Backup and Recovery Planning, Disaster Recovery Planning and Exercises, Replication, Mirroring, SQL Server Upgrades and Cluster Management, Attunity Replicate, SQL Server monitoring, reporting and maintenance jobs/objects

Contact this candidate