Job Description :
1. 8 Plus years of experience working with SQL Server and expert in Performance optimization of SQL Stored Procedures, Functions, SQL Agent Jobs using SQL Profiler, DB Tuning Advisor
2. Ability and expertise in debugging T SQL Stored Procedures, Functions, Triggers, SQL CLR, Users, Tables, Views and other objects
3. Very good knowledge on SQL Security management (Roles, Users, and Logins etc
4. Extensive knowledge in Transactions, Deadlocks, Partitioning, Change Data Capture, Query Plans, Dynamic Management Views, Row and Column Store Indexing etc.
5. Extensive experience handling large databases (Terabytes) supporting highly active online transaction processing (OLTP)
6. Experience in MDX, DAX and creating Star and Snowflake schemas
7. Experience in SSAS and ability to build and maintain cubes