Develop Tables, Views, Stored Procedures and Triggers using SQL Server Management Studio 2019. Create databases and schema objects including tables, indexes, and applied constraints, and written functions, stored procedures, and triggers. Write stored procedures for the Application development using T-SQL. Develop SSIS packages using Derived Column, Conditional split, Script Task, Merge, FTP task and Multicast. Work on migration of SQL objects, SSIS packages and SQL Agent Jobs from SQL Server 2012 to SQL Server 2019 version. Optimization and performance tuning of long running SQL queries by using execution plans report, indexes, statistics for optimal maintenance of daily jobs cycle.
Requirements:
- Master degree in Computer Science or Electrical and Computer Engineering with 6 months experience as Software/System Engineer or Intern or Consultant.
Ref: #7168.
Location: Farmington Hills, MI. (Relocation is possible).