Kyle Ratliff

Data Architect and BI Developer

SailPoint Technologies•  April 2020 - Present

• Migrated the Marketing and Data Science data warehousing solutions from Snowflake to Redshift by refactoring complex SQL queries and validating data sets between both environments in 4 months • Created and monitored ETL pipelines in SnapLogic that loads daily ingests into Redshift from sources such as Salesforce, Pendo, Intacct, Smartsheet, Eloqua, and Box • Automated integrity checks within the data by using Dynamic-SQL to identify important aspects of the data such as duplicates, counts, and changes of data sets between each day's ingest • Troubleshooted Production failures by identifying the cause, triaging the consequences by using admin privileges, such killing queries or managing the WLM within Redshift, and then documenting these issues for further analysis

Database Administrator

Revionics•  February 2019 - April 2020

• Resolved over 320 JIRA requests ranging from critical outages, database restores, and performance tuning for complex ETL processing • Responded to mission-critical incidents during on-call rotations with thorough investigation, documentation, and resolution for SQL Server, MongoDB, and Teradata • Automated maintenance tasks such as patching SQL Server across multiple domains using PowerShell and dbatools.io • Executed database migrations between old and new environments to satisfy new business requirements • Managed and improved inventory of metadata of all SQL Server environments using T-SQL enhancements

Database Administrator

General Motors•  June 2017 - February 2019

• Brought to production over 40 servers across 10 different applications, ensuring proper server and database monitoring and compliant with both industry policies and GM standards • Created and deployed over 180 changes into production environments using the internal GM change management system as well as communicating with all relevant stakeholders, including both the application team and the business • Architected and implemented multiple enterprise level database migrations from older to newer versions of SQL Server for highly critical applications • Collaborated with teams within the business to determine the optimal configuration of database servers, from drive size recommendations to the version of SQL Server • Implemented scripts to drastically improve performance by reducing data footprint by up to 30% using page compression • Ensured operational integrity by enforcing industry and Microsoft standards • Experienced in creating, and maintaining SQL Server AlwaysOn allowing for automatic failover as a vital disaster recovery solution • Managed daily maintenance jobs, such as full and log backups, index optimization, and integrity checks of SQL Server through SQL Server Agent • Installed multiple versions of SQL Server from 2005, 2008R2, 2012, 2014, and 2016 • Experience interfacing with SQL Server using Windows Core • Experience developing and using Powershell scripts to run database related tasks, such as ensuing jobs and logins are equal on both primary and secondary servers • Experience installing and implementing GoldenGate on critical production manufacturing databases for purposes of database migration and replication