Last Contract Technologies

This  was a cloud-computing project that utilized multiple technologies, including  AWS (Amazon Web Services), including RDS and EC2, Hadoop, Hive, Pig, Redshift,  SQL Server, MySQL, MySQL Workbench, and SSIS.   SQL Server and MySQL databases and SSIS were hosted in the AWS cloud and  the following tasks were completed:

  • Upgraded SQL Server 2008 to SQL Server 2008 R2 then applied SP3.
  • Created SQL Server and MySQL logical and physical models.
  • Created SQL Server and MySQL databases on both local and cloud servers.
  • Created SSIS packages to load SQL Server databases on both local and cloud servers.
  • Created and compiled SQL Server digital, educational library.
  • Created and compiled MySQL digital, educational library.
  • Designed SQL Server to SSIS to MySQL architecture.
  • Installed SQL Server 2008 and 2008 R2 on both local and cloud servers.
  • Installed MySQL and MySQL Workbench on both local and cloud servers.
  • Installed SSIS, SSAS, and SSRS.
  • Developed  accelerated, table generation tools.
  • Performed troubleshooting of numerous system components, including SSIS packages.
  • Used Embarcadero to translate diverse RDBMS DDL database generation SQL scripts.
  • Used Visual Studio 2008 to create SSIS packages.