Livermore, CA 925-***-**** firstname.lastname@example.org 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.
SQL & MySQL Configuration
Replication & Mirroring
AlwaysOn High Availability Groups
SQL Server Monitoring
Reporting & Maintenance
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.
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.
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.
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.
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.
Bachelor of Science – Bowie State University
Microsoft Certified Technology Specialist (MCTS), Microsoft Corporation
Microsoft Certified IT Professional – Database Administration, Microsoft Corporation
System Engineer Development Program, Electronic Data Systems
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
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