SQL SERVER SSIS/SSAS

SQL SERVER SSIS/SSAS

Location: Redmond, WA

Job Description:

Looking for developers with Master’s degree from an accredited college/university in Computer Science, Mathematics, Engineering, or related fields with 8 plus years of experience.

Mandatory Skills:

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

Experience in SSAS and ability to build and maintain cubes

Any

All your information will be kept confidential according to EEO guidelines.