SQL SERVER SSIS/SSAS

SmartRecruiters, Inc.; Redmond (WA); Presencial; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

SmartRecruiters, Inc. in Redmond, WA seeks an experienced SQL Server Developer to lead performance optimization and OLTP data solutions. You will design and optimize T-SQL objects, implement MDX/DAX for OLAP cubes, and contribute to security and governance of databases.

Must have a Master's degree and 8+ years of experience in CS/Engineering related field; strong collaboration with cross-functional teams. The role requires handling terabyte-scale datasets, implementing complex partitioning, and

Formación

• Master’s degree in CS, Math, Engineering or related field with 8+ years of experience.
• Expert in SQL Server performance optimization and stored procedures.
• Experience with T-SQL debugging and SQL security management.
• Experience with MDX/DAX and star/snowflake schemas.
• Experience with large OLTP databases (TB scale).
• Familiarity with SSAS/SSIS for cubes and data analysis.

Responsabilidades

• Build and maintain SQL Server ETL/OLAP solutions for business needs.
• Perform deep query tuning, indexing, and plan analysis to optimize performance.
• Develop and maintain OLAP cubes using SSAS and related tooling.
• Collaborate with developers, BI teams, and DBAs to deliver scalable data platforms.

Conocimientos

SQL Server

Performance tuning

T-SQL debugging

SQL security

MDX & DAX

OLTP

Star/Snowflake schemas

Educación

Master's degree

Herramientas

SSIS

SSAS

SQL Profiler

DB Tuning Advisor

Descripción del empleo

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:

• 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
• Ability and expertise in debugging T-SQL Stored Procedures, Functions, Triggers, SQL CLR, Users, Tables, Views and other objects
• Very good knowledge on SQL Security management (Roles, Users, and Logins etc.)
• Extensive knowledge in Transactions, Deadlocks, Partitioning, Change Data Capture, Query Plans, Dynamic Management Views, Row and Column Store Indexing etc.
• Extensive experience handling large databases (Terabytes) supporting highly active online transaction processing (OLTP)
• Experience in MDX, DAX and creating Star and Snowflake schemas

Experience in SSAS and ability to build and maintain cubes

Qualifications

Any

Additional Information

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