Role: SQL Server & SSAS Solution Architect
Location: Remote
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
Minimum 10 years of experience.
Must be a US citizen or Green Card Holder.
Proven experience as an SSAS Development/ administration with a focus on Data Warehousing.
Experience with multidimensional and Tabular cubes
Indepth knowledge of SQL Server TSQL MDX and DAX.
Strong understanding of performance tuning methodologies.
Experience in configuring and maintaining SQL Server high availability and failover clustering.
Excellent problemsolving 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 customerfacing role.
Required Skill Set
SQL Server
Enterpriselevel support and administration focused specifically on:
SQL performance and tuning optimization Clustering Always On Availability groups High Availability Core SQL migration onpremise 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 TSQL 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 policybased 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