• 6+ Years of IT Experience in MS SQL Server 2014 /2008 / 2008 R2, SQL, T-SQL.
• Have expertise of working on T-SQL/SQL.
• Experience of Store Procedures to User Defined Functions which formed part of a data warehouse, creating considerable number of User Defined Functions which were required for the data warehouse.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Created and maintained database, tables, views, indexes, and constraints to implement business rules by using Query Analyzer and SQL Server Management Studio.
• Expertise in query tuning using query hints and indexes.
• Have expertise of working on SSIS.
• Have 3.5 months of client site (AU Finance Small Bank, Jaipur) experience