Greetings of the day..!

Momento USA is a global technology consulting, talent acquisition and creative development firm that addresses clients’ most pressing needs and challenges. We are currently looking for SQL Server & SSAS Solution Architect. Please see the Job description for the reference.

Role: SQL Server & SSAS Solution Architect

Location: Remote

Contract Length : 18 Months

Job Description:

We are seeking a skilled and experienced SQL Server & SSAS Solution Architect with expertise in SQL Server, Data Warehousing, and Analysis Services. For SQL Server, there should be a strong focus on Performance, High Availability, and Failover Clustering. For SSAS, the ideal candidate will play a key role in designing, developing, and optimizing SSAS solutions to support business intelligence and analytics initiatives.

Qualifications :

• Proven experience as an SSAS Development/ administration with a focus on Data Warehousing.
• Experience with multidimensional and Tabular cubes.
• In-depth knowledge of SQL Server, T-SQL, MDX, and DAX.
• Strong understanding of performance tuning methodologies.
• Experience in configuring and maintaining SQL Server high availability and failover clustering.
• Excellent problem-solving and troubleshooting skills.
• Ability to work collaboratively in a team environment.
• Strong communication skills to effectively interact with stakeholders.
• Advanced Microsoft certifications preferred.
• Previous Consulting and/or customer-facing role.

Required Skill Set:

SQL Server

•                Enterprise-level support and administration focused specifically on:

• SQL performance and tuning optimization, Clustering, Always On Availability groups, High Availability, Core SQL migration, on-premise and cloud.

•                All versions of SQL Server (2012 and onwards)

•                Solving performance problems, query tuning, and optimization

•                Architectural experience for Data Platform

•                Architecting for High Availability and Disaster recovery solutions using FCI, Always on Availability groups 

•                Delivering and/or authoring technical training

•                SQL Server Integration Services, Reporting Services, Analysis Services

•                SQL Server on IaaS experience on Azure/ Other public cloud.

•                Azure data factory, Azure SQLDB, Azure SQLDB Managed Instance, Azure Synapse knowledge is a plus.

SSAS/ Data Warehouse/ Reporting 

• Design, develop, and maintain SSAS cubes, dimensions, and data models.
• Multidimensional and tabular cubes
• MDX query writing, SSAS Performance, health checks/ best practices. 
• Implement and optimize MDX and DAX queries for efficient data retrieval and analysis.
• Work closely with business analysts to understand reporting requirements and translate them into SSAS solutions.
• Scalability of SSAS and high availability of SSAS.
• Power BI development and administration skills

Technical Skills:

Mandatory

• Data modeling and database design. 
• Indexing strategy   
• Performance Optimization and Tuning Capabilities 
• Partitioning data implementations 
• Metadata management and repository usage.   
• Database schema creation and management.   
• Backup and recovery.   
• Ensuring data integrity.   
• Ensuring High availability and Disaster recovery.   
• SQL code reviews with ability to dissect query plan, T-SQL code 
• Procedural skills.  
• Data security. 
• Data Encryption 
• Auditing 
• Replication of data  
• SQL Edition and version differences with discontinued and deprecated features 
• Upgrade process 
• Storage management techniques. 
• Data Engine Capacity planning.  
• General database management and policy-based management.    
• Windows Failover Clustering
• SQL Server Reporting service
• SQL Server Integration Service
• SQL Server Analysis Service
• MDX Query writing and tuning
• SSAS administration, best practices, and health checks
• Power Shell

Best Regards,

Sunitha Thapa

Desk – 856 372 4625, 856-456-1805 Ext 1025

Email: sunitha@momentousa.com 

linkedin.com/in/sunitha-thapa-sanu-649b46229