Christopher Tompkins Email & Phone Number

Osceola, Ar, Us

Osceola, Ar, Us

Osceola, Ar, Us

Greer, South Carolina, Us

Managed database administration, always-on availability groups, and performance monitoring supporting 350 locations.• Orchestrated successful migration of production AG cluster encompassing 20TB database with two synchronous nodes and one asynchronous node, transitioning from SQL 2012/2014 to SQL 2019.• Heightened system responsiveness and reliability through SSIS ETL / ELT development for business process data flow while improving critical data warehouse workflow. - Maintained Data Warehouse SSIS pipelines, ensuring optimal performance and reliability.• Streamlined lower environments dedicated to development and QA testing, leveraging Red Gate Clone tool and SQL management tools. • Single-handedly drove DBA teams’ collaboration with InfoSec Vulnerability Advisor Board, effectively addressing security vulnerability for SQL servers. • Leveraged Microsoft SQL Server Activity Monitor, Performance Dashboard, and SolarWinds DPA to monitor SQL and PostgreSQL servers across multiple environments, ensuring robust performance and preemptive issue resolution.

Memphis, Tennessee, Us

Single-handedly led comprehensive oversight of server infrastructure, monitoring backups, server performance, data growth, and server efficiency. • Architected data model and optimized stored procedures to automate comprehensive audit logging system for largest US retailer.• Implemented error-free deployment processes by developing SQL and PowerShell scripts for manual server deployments.• Guaranteed operational readiness by monitoring vendor backup processes for SQL servers, ensuring continuity and integrity of essential data backups.• Engineered SSIS micro-batch streaming process for importing files and processing data.• Generated new clients by creating T-SQL stored procedures and data model summarizing information for dynamic data visualization in application.

Mclean, Va, Us

Maintained and supported data systems driving reservation information utilized companywide.• Increased system efficiency and streamlined operations by collaborating with DBA team to maintain BI systems, handle security requests, fine-tune queries / indexes, and optimize data pipeline ETL processes.• Improved stakeholder visibility and streamlined teams’ efforts to resolve data issues by pioneering column-by-column SSIS comparison.• Recognized for conducting business process reviews and recreating critical annual business hotel process.

Memphis, Tennessee, Us

Improved performance of stored procedures, views, and functions.• Refactored T-SQL to replace cursor with set base logic, resulting in 50%+ improvement in performance.

Memphis, Tn, Us

Developed, maintained, and generated code supporting organizations’ DMS, reporting systems, and Kimball data warehouse.• Drove discovery of $1M+ in missing revenue by utilizing SSRS dashboard to give visibility of financial data across 4 channels including Salesforce and Oracle.• Streamlined operations and improved efficiency. - Maintained and enhanced data pipelines crucial for SQL data warehouse operations, ensuring optimal data flow and accuracy. - Updated star schema data marts for donor-driven Unica campaigns.- Collaborated on conversion of Oracle data warehouse ETL processes to SQL data warehouse.• Modernized Event Planning Department’s Microsoft Access solution leveraging SSRS, significantly enhancing data accessibility and reporting capabilities.• Orchestrated and led project upgrade transitioning Event Planning’s Microsoft Access solution to cutting-edge .NET web application.

Tupelo, Mississippi, Us

Maintained, upgraded, and supported SQL databases and GP Dynamics application for 80 utilities.• Solely accountable for fortifying application security across diverse portfolio, ensuring robust data protection and compliance with industry standards.• Orchestrated maintenance and database optimization, enhancing web applicationprocess for utility customers viewing online bills. • Engineered database and scripts, enabling remote retrieval of GP Dynamics SmartList data from 80 utilities, providing actionable insights for analysis and tracking purposes.

Mclean, Va, Us

Düsseldorf, North Rhine-Westphalia, De