SQL Server Developer (SSIS/SSAS)

TL;DR

SQL Server Developer (SSIS/SSAS): Developing and maintaining high-performance database solutions for large-scale OLTP systems with an accent on performance optimization, T-SQL debugging, and complex data modeling. Focus on managing large-scale databases, building SSAS cubes, and ensuring system reliability through advanced indexing and query plan analysis.

Location: Must be based in Redmond, WA

Company

A global staffing, consulting, and technology solutions company providing industry-specific services to Fortune 500 clients and worldwide corporations.

What you will do

• Optimize performance of SQL stored procedures, functions, and SQL agent jobs.
• Debug complex T-SQL objects including triggers, views, and SQL CLR.
• Manage SQL security, roles, and logins.
• Handle large-scale databases (terabytes) supporting active OLTP environments.
• Build and maintain SSAS cubes using MDX and DAX.
• Implement advanced database features like partitioning, change data capture, and indexing.

Requirements

• Master’s degree in Computer Science, Mathematics, Engineering, or related field.
• 8+ years of professional experience with SQL Server.
• Expertise in performance tuning, deadlocks, and query plan analysis.
• Proficiency in creating Star and Snowflake schemas.
• Strong knowledge of SQL security management.

Culture & Benefits

• Full-time employment opportunity.
• Work with Fortune 500 clients and global corporations.
• Confidential hiring process in accordance with EEO guidelines.