IDC SYSTEM PVT. LTD.Software Engineer
May. 2012 - Jun. 2015Ahmedabad Area, India• Working with all kind of MS SQL (2005 to 2008 R2).
• Developed all the required Tables, Stored Procedures, user defined Functions, Triggers, Views, Indexes, Cursors etc using T-SQL.
• Responsible to setup Jobs and update data related Tables as per defined structure. Besides setup E-Mail configuration to send details on Job failure. • Working along with Replications, Query Performance tuning, Troubleshooting and Log Shipping.
• Creating .mdb files and .bkp files of Database and restore it as per requirement.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary table space, eliminated redundant and inconsistent data ,normalized tables, established joins and Re-indexing whenever necessary.
• Creating windows Task to run .bat file or .VBS files to generate appropriate file from Database to .xml, .csv, .txt etc. and send them on FTP or SFTP locations as per requirement.
• Working knowledge in SSIS.