Completed design on two manufacturing databases by defining and implementing unique natural keys/migration keys, removing orphaned, duplicate and conflicting records, configuring referential integrity and database partitioning to improve performance on 20+ billion row tables (NSGDW). Supported and enhanced SSIS 2012 ETL packages importing hundreds of thousands of files daily, MSSQL 2008R2 / 2012.