PDF Here

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





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


Bachelor’s of Science in Business Administration                     December 2004

Computer Information Systems

Central Missouri State University (University  of Central Missouri)

Warrensburg, MO