A professional with engineering background having 12 years of experience in IT industry.
I have professional knowledge of working on SQL, T-SQL, Server migration, SSIS, QA scripting, Manual testing.
T-SQL for developing Stored Procedures, Triggers and Tables, Views, Indexes, Query, SQL Server Profiler for trace analysis.
SSIS Package to transform the data using different Stored Procedures, Tables and controls. Worked with many flat file source related ETL processes by importing the data, cleansing the data then loading it into tables.
Worked on database management activities such as analyzing query execution plans, backing up and restoring databases on development and staging environments and performing various database maintenance tasks.
JOBs in Job Agent and Monitoring and Scheduling for Backup.
Mail using database mail systems. In addition, worked with procedures where need to call, retrieve and store data using web services.