Experience on SQL Server Enterprise Database.
Should have good hands on experience in creating Stored Procedures, Functions, Tables, Cursors, Hash tables and handling large data types.
Should have prior work experience and knowledge in Query Tuning, Database Tuning, Performance tuning and different indexing methods.
Should have knowledge on working of Joins.
Should be aware about all types of indexes and their advantages and disadvantages.
Should have experience in writing complicated queries involving sub queries and co-related queries.
Should have knowledge on using query plan and explain plan to tune queries.
Should have worked on Triggers, Views and table valued functions.
Should have experience in Microsoft office tools.
Experience in Database migration is big plus.
Able to run multiple daily manual processes gathering and processing large volumes of data accurately.