Richard Cheatham

Experience

• 

  Georgia-Pacific LLC

  Aug 2002 - Jun 2003

  Senior SQL Server DBA

  Directly involved in initial implementation of Sever Clustering and subsequent migration to, installation, and configuration of SQL Server ClusteringInstallation and configuration of all production SQL Server environmentsProject lead on hardware upgrade and SQL migration from version 6.5 to 2000 at Chemical Division plant locationsDevelopment and implementation of security and compliance standards for Sarbanes-Oxley compliance and corporate auditDeveloped and implemented Disaster Recovery plans and hardware schemas to support them Developed and implemented standardized custom maintenance and optimization tasksWriting stored procedures, DTS packages using SQL, T-SQLWrite Custom dynamic scripting to automate administrative and maintenance tasksInstallation and configuration of all development and QA environmentsSupported development services for all business units at Georgia-Pacific. Heavily involved in moving corporate production database system from Atlanta data center to Green Bay data center. Show less

• 

  UPS Supply Chain Solutions

  Apr 2006 - Aug 2006

  Database Analyst / Technical Consultant

  Employed by UPS-SCS to assume management and administration of their SQL Server environment. Other responsibilities included SAN storage sizing, SAN LUN configuration for optimal database performance, maintaining application database backend for several application including the application that runs the UPS_SCS small package sort facility. Wrote and deployed a SQL Server metadata collection application in Visual Basic that collects operational, configuration, and security and stores that information is a SQL Server database. Wrote a reporting application in Access 2003 to offer a dashboard that gives one-click reporting about the information collected by the metadata collection application. This is for use internally by the staff DBAs. Show less

• 

  SunTrust Bank

  Aug 2006 - Apr 2009

  Database Admin 2

  Senior Database Admin to join a team of 8 – 10 SQL Server DBAs. Responsible for managing a very large database environment. The majority of the production database instances were on SQL clusters. Primary responsibility to manage the SunTrust Wealth and Investment Management line of business. The business was on a three node cluster of Itanium 64bit servers that housed more than 80 of the 150 total databases in this organization. Directly involved in an equipment upgrade project for these servers. Working hand in hand with Microsoft, HP, the application development group, and the internal server engineering group to ensure the databases were migrated successfully. Project lead for the proof of concept and implementation of IBMs Tivoli product at SunTrust. Set up disaster recovery solutions for key financial apps using log shipping from Atlanta to DR site in Durham, NC. Set up reporting solutions to move ad hoc querying from production OLTP systems to replicated databases.Supported Corporate Real Estate, Risk Management, and Regulatory Systems. Wrote and deployed a SQL Server metadata collection application in Visual Basic that collects operational, configuration, and security information and stores that information is a SQL Server database. Show less

• 

  UPS

  Apr 2010 - Sept 2010

  Database Administrator / Developer

  Managed, maintained, ran, and updated the processes used to gather data from the Corp Data Warehouse in NJ. ETL processes written in DTS or SSIS and integrated with secure FTP. Executed the proof of concept, testing, and installation of the secure FTP application. Re-engineered a process for gathering data about ocean shipments. Redesigned the process to run on a single process server in a single database instead of being distributed between multiple databases on multiple servers then pushing the data via secure FTP to the production server during non-peak production hours. This cut the processing time to a 3rd of what it was originally in system testing. Involved in troubleshooting and problem solving for process errors, data inconsistency errors and SSIS and DTS errors. Show less

• 

  Multiple

  Mar 2011 - Oct 2012

  Independent Database Consultant

  Gryphex, LLC 1035 Windward Ridge Pkwy, Alpharetta, GA Sept. 2012 – Oct. 2012 SQL Server DBA / DeveloperEmployed by Gryphex as the sole SQL DBA / Developer to manage existing database platforms and databases. Duties include the development of new SSIS packages to enhance functionality of applications, management and maintenance of existing SSIS packages, writing stored procedures, triggers, views, and functions. Comverge, Inc. 5390 Triangle Pkwy, Norcross, GA April 2012 – May 2012 SQL Server DBA/Developer I was brought on to Comverge to Administer and do light development of their SQL Server Environment. Development included SSIS package creation and light VB scripting. Bridge2Solutions, 5900 Windward Pkwy, Alpharetta, Georgia Oct. 2011 – Jan. 2012 SQL Server DBA / DeveloperFull responsibility for health of all SQL Server database instances. Also created and scheduled SSIS packages for delivery of scheduled reports and created ETL processes to extract data from various platforms as required by the business.GoodCents Solutions. 400 Perimeter Center, Atlanta, Georgia March 2011 – May 2011 SQL Server Developer / DBAThe position was heavily weighted toward database development vs. administration (about 75/25). Developed of new SSIS packages as well as the maintained, modified, and resolved issues with existing packages. Developed processes used for both business processes and database administration. Involvement in system testing and database migration from SQL Server 2005 to SQL Server 2008R2. SCRUM based SDLC environment. Show less

• 

  FIS

  Jun 2013 - Oct 2014

  Sr SQL Server Database Administrator

  Database ConsultantUpdated all SQL Servers to current service pack and cumulative update levels. Assist in managing multiple complex database environments that FIS manages for Ceridian, Inc. Senior Database Analyst – Technical DBA TeamConverted to full time employee in September 2013. Participated in multiple ongoing projects with various business units. Managed and maintained the various clustered database environments daily, installed and configured new database servers and clusters, configured database mirrors. Trouble shoot and resolve issues as they arose and then take proactive measures to prevent reoccurrence. Managed and maintained very complex replication environment. Created process automation solutions tasks to offload DBA work load. Designed, tested, and deployed disaster recovery solutions for high visibility applications. Implementation of SQL Server 20012 for AlwaysOn availability. SME in the on-call group for problem resolution of mission critical applications Show less

• 

  VisionSoft International Inc

  Sept 2018 - Jun 2019

  Sr SQL Server DBA / Developer

  State of Georgia – Department of Natural Resources – Senior Database Developer / Architect Sole database resource on a DNR project charged with re-writing and deploying their Agricultural Permitting application based in Tifton, GA. The original application was developed in Microsoft Access 2010 and was distributed across 19 separate Access databases where different processes and reports were executed parallel to the main Access database and then merged into the main database. The application was re-written in an Angular JS front end with a SQL Server 2017 database backend. Database tasks included conversion of Access tables, queries, macros and business processes from all Access databases into a single SQL Server 2017 instance. Tasks also included the creation of a SQL Integration Services package used to merge and migrate the existing Access data into the SQL database. A MicroStrategy reporting solution was also implemented to serve the reporting needs of the business unit. Served as the Implementor, Architect, Administrator, and developer of the reporting solution. Also integrated SQL Server with GIS functionality required by the department. The integration was with ArcGIS Pro. Show less

• 

  Medical Asset Management, Inc.

  Aug 2019 - Jan 2020

  SQL Server Architect / Developer

  Medical Asset Management is a SAAS company with a product directed for use in hospitals and doctor’s offices/clinics that provides automated medical procedure coding in real time for procedures used for investigational radiology and cardiac catheterization. As the sole database resource at company I brought the existing SQL Server environment up to near current release, upgraded the hardware and network infrastructure, provided a non-intrusive reporting solution for the production data, and set up a high availability solution for the production system.This was a cloud-based server architecture originally on Windows Server 2008R2 and SQL Server 2012 Standard Edition that had restrictive configurations on server processing power, total memory configuration, as well as inadequate storage configuration. There was no high availability solution in place.The final solution was a new primary database server with Windows Server 2012R2 and SQL Server 2016 Standard with C, E, F drives of 256GB each, 64GB RAM, and 8 cores on 2 sockets. This server clustered with a similarly configured (OS and database versions) for reporting. The reporting server has 4 cores with 16GB RAM. High availability achieved using SQL Always-On with the secondary replica on the reporting server. The reporting solution was achieved by using readable database snapshots of the secondary replica refreshed every 6 hours.Other duties included troubleshooting production issues, exploring software solutions for future requirements, and optimizing current SQL code, indexes, and processes. Show less

• 

  Waystar

  Apr 2020 - Aug 2020

  Senior Technical Specialist Database

  Waystar, Inc is a company dedicated to managing the revenue cycle of medical practices and corporations.Waystar’s SQL Server environment is a very high availability environment consisting of server stacks of 3 pairs of Always-On servers representing Development, QA, and Production. These server stacks also had replicated databases that used an Always-On distribution database that was also a 6 servers stack of 3 pairs. I was responsible for the migration of all server stacks to SQL Server 2019. I was also heavily involved a project to move some recently acquired environments from the cloud (Azure) into a physical data center in Louisville, Ky and to begin setting up duplicate server stacks in a data center in Cincinnati, Oh for disaster recovery using geo-clustering and multi-subnet clusters. Show less

• 

  Rollins, Inc.

  May 2021 - May 2022

  Senior Database Administrator

  I worked for Rollins, Inc as a contract Senior SQL Server DBA with the primary responsibility of maintaining and improving the main corporate databases behind the public facing and internal Rolling applications.The databases(5) behind the main applications were in excess of 16 terabytes with the largest being 13 terabytes in size. The production databases were all duplicated in separate Test, Dev, and QA environments as well as Hotfix and some other specialized environments, so the data footprint was in the petabytes.The lower environments(Dev, Test, and QA) were based on a reduced and scrubbed version of the production systems. My primary project outside of my DBA responsibilities was to rebuild the Reduction server and rewrite the application that reduced and scrubbed the production data. When I initially started this project, the time it took to create the reduced data set was 10 days. This was primarily due to the old process excluding any parallel processing and multi-threading. I rewrote the process using SQL Server Data Tools(SSIS) to be able to force parallel processing and muti-threading. I also rewrote the code to use a much more efficient way of eliminating the unwanted data.The net result of my efforts was a process that reduced a 13 TB to a 2.6 TB replica of production than ran in less than 5 days. This allowed developers to develop against fresh data instead of stale data that might not meet the needs of the business. Show less

• 

  Taylor Morrison

  Nov 2022 - Jan 2024

  Database Administrator I

  Worked with Taylor-Morrison, Inc. as a contract SQL Server DBA with the primary responsibility of maintaining and improving the corporate database and reporting systems with strong emphasis on moving all old data warehouses and application server databases into a new data lake and adjoining data warehouses. All application servers to feed data into the data lake while all data warehouses were either direct views into relevant parts of the data lake or encrypted tables of sensitive data in the data lake. All reporting servers were populated with views into the different data warehouses. No direct user access to the data lake.Streamlined the task of maintaining the Dev, QA, and Test environments through automation using a combination of PowerShell scripting and SSIS packages called through the SQL Server Agent scheduler.Automated numerous redundant processes that were previously done manually and made them a 1-click process for end users or a fully automated process that ran without user intervention. This was also a combination of PowerShell, .NET, SSIS, and a third-party scheduler called VisualCron.Set up process monitoring and alerting through either third-party tools such as OpsGenie or through SQL Agent jobs and T-SQL scripts.Very familiar with C# and VB.NET. However, because these are not daily used languages, I often use Open AI (Ghat GPT4) to write my baseline code for any given coding task and then adapt it to my real time environment to test, debug, and implement as a solution. This is a huge time saver. Most recently I created C# solutions for API calls to integrate data from Zendesk and Jira into our data lake to allow more robust reporting on the workflow and usage from each platform. Show less

• 

  Geisinger

  Jul 2024 - Oct 2024

  Created SQL Server API integration to ServiceNow.

  • SQL Server Developer

    Sept 2024 - Oct 2024

  • Database Developer

    Jul 2024 - Sept 2024