Skills Profile
SQL Server 2012-2017 Platform Development, Architecture, Administration
AWS Data Platform (EC2, SQL Server RDS, Postgres RDS, Aurora, Redshift)
Azure Data Platform (Azure SQL, Azure Data Warehouse, Azure Data Lake)
Powershell Automation
Python Development, ETL, Data Science
Docker
Tableau
PowerBI
Snowflake
Windows and Linux System Administration
C# Application Development
Employment History
Best Buy Health December 2018 – Current
San Diego, CA
Database Operations Team Lead and Senior Database Administrator
Database Operations Team Lead
Effectively manage a team of three DBAs under the Systems Engineering group.
Responsible for planning and executing all database related projects.
Build tools and dashboards to help keep track of time and projects.
Operations Database Platform Management
Build tools and deploy monitoring to automate data gathering and issue alerting for database platform from MongoDB, SQL Server, SQLAnywhere, and MySQL.
Institute and ensure best practices are followed for new database instance deployments. Using automated installs scripts, setup scripts, and Terraform.
Rebuild SQL Server reporting environment
Identified large IO issues related to SAN connectivity and overprovisioning.
Migrated from SAN to local SSD storage for a 100x performance improvement in IO throughput and eliminating many performance issues.
Build HA using Availability Groups in SQL Server 2016 across six servers.
Database Administration
Performed exhaustive environment review finding numerous issues across every environment.
Built and deployed standard backup plan across entire database platform ensuring recovery and availability.
Built and deployed standard database integrity checks and index defragmentation process across entire database platform. Numerous performance improvements resulted enterprise wide.
Took over the management of MySQL and SQLAnywhere platforms from acquired companies. Converted our standard backup and maintenance jobs to work across those platforms.
Renovate America March 2014 – Current
San Diego, CA
Senior Database Administrator and Support Contractor
Database Platform Management
Set direction, technology, methods, and standards for data storage, access, design, development, and administration company wide.
Advise software engineering and architecture teams across the company.
Implement data security practices in compliance with and exceeding mandatory regulations.
Mentor and train members of the Database and Business Intelligence teams on tools, methods, and best practices for working with data.
Database Administration
Built HA/DR across AWS and colocation facilities for production databases using Availability Groups and Log Shipping.
Full database environment upgrade from SQL Server 2012 to SQL Server 2016 with just minutes of total downtime across all systems.
Automated backup testing, obfuscated pre-prod data restores, and all database backups and maintenance with Powershell.
Azure SQL Database platform architecture, administration, high availability, maintenance, and security.
Business Intelligence
Lead project to migrate existing SQL Server based data warehouse to Amazon Redshift saving $300k+ per year over existing systems.
AWS Infrastructure Automation using cron and Python to save $100k+ per year in server costs.
Develop reports and dashboards from data warehouse and transactional systems including real time dashboards for large public displays using SSRS, PowerBI, and Tableau.
Develop ETL processes for the data warehouse and other internal and external systems including SFTP and PGP support. Technologies used include SSIS, Powershell, C#, and Python.
Implement traditional dimensional database model as well as supporting data lake semi-structured data access with Redshift Spectrum.
Walz Group February 2013 – March 2014
Temecula, CA
SQL Server Database Administrator
Developed and implemented backup strategy using Red Gate SQL Backup.
Implemented HA/DR procedures using database mirroring, log shipping, and NetApp SnapMirror.
Created automation scripts in Powershell to speed up deployment process between development, testing, and production environments.
Designed database and assisted database development efforts including T-SQL, SSIS, and implementing messaging with Service Broker.
Genoptix Medical Laboratory February 2012 – February 2013
Carlsbad, CA
Data Warehouse Developer
Data Warehouse Architect
Support Kimball based Star Schema data warehouse design efforts.
Gather requirements, prepare documentation, draft design documents and design and implement solutions to fit requirements.
Data Warehouse Development
Implement new data marts for tracking order issues with patient tests and screenings.
ETL design and implementation in SSIS
Data Warehouse design and implementation in SQL Server and SSAS
Includes implementing row level security to protect sensitive information.
Develop automation for process notification.
Create jobs and SSIS packages for monitoring status of ETL jobs.
Send email, text, and update SharePoint lists of job status.
Jack Henry and Associates June 2011 – February 2012
Overland Park, KS
Database Administrator
Designed and implemented an advertising targeting and display system.
Performance tune stored procedures and data structures to best practices and company standards.
Valorem Consulting February 2011 – June 2011
Kansas City, MO
Business Intelligence Solutions Architect
Deliver requirements documentation and project management documentation to client.
Build data warehouse and business intelligence system to client requirements using Microsoft BI Stack
Responsible for delivering presentations for Microsoft to area businesses on the current Microsoft Business Intelligence platform
Create PowerPoint and functional demonstrations to show new features or highlight specific areas of interest
Children International November 2008 – February 2011
Kansas City, MO
Database Administrator / Data Warehouse Engineer
Administrate All Business Intelligence and Data Warehouse related servers
Designed reporting database for external agencies in use world wide.
Developed Integration Services 2008 ETL process to move data to and from external agencies around the world
Datastage Data Warehouse ETL Development and Troubleshooting
Converted existing Datastage ETL processes to Integration Services 2008
The Sunflower Group July 2007 – November 2008
Overland Park, KS
Database Administrator / Microsoft Business Intelligence Developer
SQL Server 2005-2008 Database Administration
Develop SQL and MDX Reports against Online Data Store and Analysis Services 2005 using Reporting Services and ProClarity
Develop ETL Processes using Integration Services 2005 to load Data Warehouse from multiple source systems
Awards and Achievements
Sunflower Group Peak Performer 1st Quarter 2008 for Data Warehousing project
Nations Holding Company November 2006 – July 2007
Prairie Village, KS
Database Development Manager
Assigned tasks to database development team
SQL Server 2000-2005 Development
CarterEnergy Corporation July 2004 – November 2006
Overland Park, KS
IT Specialist
Helpdesk and End User support
SQL Server 2000 Database Administration
C# Development
Systems Administration
Awards and Achievements
CarterEnergy Base Camp Initiative All Star
Education
Bachelor’s of Science in Business Administration December 2004
Computer Information Systems
Central Missouri State University (University of Central Missouri)
Warrensburg, MO