Data Developer

Jeremy A. Lafoon

*** ******* ***** ***

Wake Forest, NC 27587

**************@*******.***

919-***-****

Objective

Database professional with over ten years of experiences looking to secure a position in but not limited to Database Administration and Database Architecture involving Systems/Data Analysis and design that will enable me to utilize my analytical, problem solving and communication skills combined with practical hardware components and software experience.

Skills

Environment: Linux, OSX, Windows Server 2008/12, Amazon AWS Database: MySQL 5.5x/5.6x, MariaDB 5.5/10, Postgres 3, Oracle 9i/10g/11g, SQL Server 2005/08, AWS Aurora 1.x (MySQL Compatible)

Languages: SQL, PL/SQL, T-SQL, Bash scripting, Java Tools: M ySQL Workbench, SQLPro, Navicat, Percona Toolkit, SSMS, Toad, Liquibase, GitHub Methodologies: S crum, Kanban, SDLC, CI/CD

Experience

Netsertive Morrisville, NC

Database Administrator II February 2016 – Present

● Implemented database version control / code repository solution using Liquibase/GIT with DevOps and Developer Architects

● Routine system audits identifying poor performing queries and refactored for optimal performance

● Developed data integrity system to monitor for inconsistencies in enterprise data sets

● Implemented database unit testing using MyTap framework to reduce bugs in database code and automate qa process

● Provide code reviews for developers ensuring proper database standard practices and defined company conventions are followed

● Provide support in hiring initiatives

Database Administrator I April 2013 – February 2017

● Migrated production web, application and database servers from internal data center into AWS Cloud platform

● Architected new database to support external client facing web-based service

● Author and maintain stored procedures to manipulate data in a big-data Data Warehouse environment with tens of millions of records

● Automated refresh process of qa and developer database environments

● Designed, implemented and maintained ETLs that process third-party data incorporating internal data which is used by proprietary applications

● Developed and maintained internal alerting system Cerberus used to broadcast process statuses

● Performed routine MySQL upgrades on all database servers for enhancements and security purposes

● Setup and maintain data replication from Production level system to standby system Farragut Systems Durham, NC

Database Administrator November 2005 – March 2012

● Database Management of NCPTS property tax system using Oracle and Microsoft SQL Server Databases

● Migrate data from legacy systems into SQL using Oracle DataPump

● Author and maintain DB code to translate data from raw tables into NCPTS compliant data structures

● Maintain database archives using crash dumps

● Design Oracle triggers to audit data changes in the system

● First level customer support and response of product for Pitt, Wake, Guilford, Henderson, and Catawba Counties

IBM Corporation RTP, NC

Software Intern May 2001 – August 2002

● Microsoft Windows XP Certification

● Translation Verification Test Support

● SWG Hardware Support

● Java Development of UI components

Education

North Carolina State University Raleigh, NC

Bachelor of Science Computer Science M ay 2005

NCSU Scholars Program

References are available upon request

Contact this candidate