David Kerslake

Georgetown, TX *****

admhks@r.postjobfree.com - 563-***-****

US Navy Veteran

EDUCATION

Computer Engineering/Computer Science (30 Credit Shy)

Iowa State University - Ames, IA

1994 to 1999

Nuclear Engineering

US Navy Nuclear Power School

1992 to 1994

Experience:

Data Engineer and Architect

Cloud Based Systems, Migration, and Management

Data Experience on SSMS, Postgres, DB2, Oracle, MySQL, H2, Mongo Databases

ETL/ELT using Talend, SSIS, DMS, Stitch, Fivetran, and Informatica

High Availability and Disaster Recovery

Information Technology, Software Development, and Network Security Industries

Lead and Mentor

Data Governance and Data Analytics

Development, Customer and Team Service Support

WORK HISTORY:

Lead Data Integration Engineer – (Start Up Lost Funding)

Paycertify – San Jose, CA – Sept 2020 to Present

Led Project to Migrate all onsite datasets to AWS

Reconfigured the ELT pipeline Third Party, DB, DW, and Reporting platforms

Created Automated Alerts for Databases and Data Warehouses

Optimized SQL queries and Stored Procedures

Worked with Development to Implement Standardized DML and DDL processes

Created New Redshift Data Warehouse

Sr Data Engineer and Architect – (Contract)

Duke Energy - Charlotte, NC – May 2020 to Sept 2020

Created New True Data Source for Seven Separate Divisions to Work Together and Communicate

Architectural Design and Support for Postgres and SQL Server

Data Migration from Legacy DB’s into Cloud Based Postgres and SSMS Instances

Reconfigured and Created new ELT Pipelines

Rewrote Hundreds of SQL Queries and SP’s for Performance Tuning and Optimization

Established New DR and HA Protocols

Designed New Snowflake DW

Sr Data Engineer and Architect – (Contract)

American Home Shield - Memphis, TN – Aug 2019 to Apr 2020

Migrate Data and DB’s from Onsite to Cloud Based Instances

Provided Solutions for Performance and Optimization Issues

Incorporated Three New Business Acquisitions into existing Data Environment

Reworked ETL Pipeline

Saved Time and Costs by Reconfiguring and Elimination of Redundant or Obsolete Processes and Instances

Mentor and Train Current Data Engineers and DBA’s

Designed New Snowflake DW

Sr Database Engineer and Architect – (Contract: Project Ended)

RoadVantage - Austin, TX – March 2018 to Aug 2019

Converted Third Party Software Data into Internal Database Structure

Created New Redshift DW Instance

Designed and Created New Proprietary Software

Established New ETL Pipeline and Process

Improved Data Access from Nightly Run Processes to Real Time Data Availability

Established Performance Monitoring

Improved Query, Database Efficiency, and System Performance

Created New Data Governance

Mentor and Train Current Data Engineers and DBA’s

Lead Database Engineer – (Contract)

Texas Higher Education Coordinating Board THECB - Austin, TX – January 2017 to February 2018

Optimize Queries and Database Efficiency

Advised Management on Long-Term Capacity Plans and Growth

Worked with Business Partners and Staff to Clarify Requirements and Solutions for Data Governance

Modified Databases to Specific User Requirements

Oversee and Plan Upgrade of Obsolete Database Versions to Current

Optimize and Rework Query Performance

Reconfigured ELT Pipeline

Mentor and Train Current Data Engineers and DBA’s

Sr Database Architect and Engineer – (Start Up Lost Funding)

Assured Enterprises - Austin, TX - June 2016 to January 2017

Designed New AWS Cloud Platform

Moved Application from Onsite to AWS

Established Disaster Recovery and High Availability

Created New Platform Migrating from SSMS to Aurora

Established New Reporting and Data Governance

Implemented Security Groups and IAM

Set Up New Snowflake DW

Redesigned ETL Pipeline

Lead Database Engineer – (Contract)

Texas Conference of Urban Counties CUC - Austin, TX - June 2015 to June 2016

Performed Data Conversion from Legacy System to New Software Platform

SSRS Report Setup and New Report Server Migration

Data Warehousing Migration to Snowflake

DML and DDL code check in Requirements

Upgrade ETL process

New Environment and Server Setup with Disaster Recovery and High Availability

Mentor and Train Current Data Engineers and DBA’s

Sr. Database Administrator – (Contract)

Allscripts - Raleigh, NC - August 2014 to June 2015

Analyze, Find, and Fix Database Corruption Issues

Provide Disaster Recovery Solutions for Database and System Failures

Write advanced T-SQL Queries to Find, Fix, Update or Remove Bad, Incorrect, or Inconsistent data

Developed Shell Scripts for Automation Purpose

Find and Update Inefficient Stored Procedures

Reconfigured the ELT pipeline using the Tools

Tier 5 Support Troubleshoot Clients Performance, Data, Connectivity, Permission, and Access Issues

Worked Directly with Data Admin and Developers to Implement DML and DDL Fixes

Run and Monitor Nightly ETL Jobs and Processes to Ensure Accuracy

Sr. Database Administrator

AMCAD - Herndon, VA - 2008 to 2014

Automated Release and Deployment Process to Increase Productivity

Maintained, Updated, Deployed and Supported all Development Sprints and Version Control

Handled and Created ETL and ELT Processes based on Each Customers Specifications

Production and Development DBA

Developed Shell Scripts for Automation Purposes

Investigated and Implemented all New Service and Customer Requests

Set and Maintained existing and New Databases, Users, Permissions, and Roles

Converted from Nightly Backups to a HA/DR Environment

Worked with Clients, PM’s, BA’s to Establish Change Request and Requirements

SKILLS

SQL (10+ years), Sql Server (10+ years), Oracle (10+ years), Microsoft (10+ years), Database Management (10+ years), Data Analysis (10+ years), Databases (10+ years), Database Objects (10+ years), ETL/ELT (10+ years), Data Mining (10+ years), T-Sql (10+ years), PL/SQL (10+ years), SQL Tuning (+10 years), SSIS (10+ years), SSRS (10+ years, )Large Datasets (10+ years), Java (10+ years), Office Suite (10+ years), Complex Problem Solving (10+ years), RDBMS (10+ years), OOP Implementations (10+ years), SAS (10+ years), Jira (10+ years), GIT (10+ years), Python(3 years)

Contact this candidate