Eric Korth Email & Phone Number

Saint Petersburg, Fl, Us

Tampa, Fl, Us

Upgraded data warehouse servers from MS SQL Server 2012 to MS SQL Server 2017Work closely with CISO to ensure security policies and procedures are metInstall and configure SQL Server Use PowerShell to maximize administration of all servers and environmentsResponsible for administration of SQL Server Reporting Services environmentsMaintain SQL Server patch levels to ensure compliance with security and audit requirementsConfigured Transparent Data Encryption to secure backups and data at restInstalled and configured SpotLight for SQL Server for monitoring and alertingImplemented table compression resulting in reduced disk space io and overall space savings of 60% on averageManage SQL Server running on Azure VMs and VMware Designed and implemented HA solution using AlwaysOn

Columbia, South Carolina, Us

Worked on over 200+ Production databases supporting SQL Server 2008R2, SQL Server 2012, and SQL server 2014Migrated databases from MS SQL 2008R2 to MS SQL 2014Created compressed native SQL Server backups to local drives or to network shares Restored backups to different SQL Servers and newer SQL versions. Utilized SentryOne to actively monitor and troubleshoot issues Setup and maintained Log Shipping for reportingConfigured and managed Always On Groups for SQL 2012 and SQL 2014Installed, configured, and managed SSRS Administrated and resolved all issues with SSIS packages for SQL Server 2012 and SQL Server 2014

Toronto, Ontario, Ca

Lead Database Developer for Retail Internet Banking and Small Business Internet Banking. Reviewed and optimized scripts from vendors and developers. Scripted backups and rollbacks for DML changes without using database backups and restores. Created and optimized Indexs to enhance query performance. Backing up and restoring databases to different SQL Instances.

Managed over 400 production databases that were housed on MS SQL 2000, MS SQL 2005, and MS SQL 2008. Decommissioned over 100 databases from production environments freeing up SAN space, reducing server resources, and saving backup tape space. Installed and configured SQL Server utilizing documented standards. Monitor SQL Servers for errors and resolve any issues quickly and consistently. Built a repository of all SQL Server information and database configurations.Designed and implemented a robust Disaster Recovery Architecture with minimal hardware resources. Provided on call database support to application teams and command center for quick and effective issue resolution. Created and optimized SQL Indexes on large tables with hundreds of millions of rows. Designed and optimized a Data Warehouse ETL Architecture utilizing MS SQL 2008 and MS Integration Services 2008. Created standards for all in house ETL development and deployment utilizing a central ETL environment. Created a backup strategy for large data warehouse SQL Server environment. Coordinated with vendors on data feeds for ETL processes.