Position Title : SSAS Platform engineer
Location: San Jose CA
• SQL Server Analysis Services installation and administration on MS SQL Server Environment
• Install, Configure, Optimize the SSAS environment on Windows Platform.
• Design Server backup and recovery plan from the production server.
• Experience in Building the Infrastructure around SQL Server BI (SSAS, SSIS, SSRS) with High Availability.
• Strong Understanding of Server Memory, Disk Configuration, and Utilization
• Strong Understanding for the Network Optimization for Faster Performance
• Have a prior experience in Building the Infrastructure around SSAS from Scratch.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement.
• Installed and administered Microsoft SQL Server Integration Services, SQL Server Reporting Services, and Team Foundation Server.
Environment: Windows Server, SQL Server SSAS, SSIS, SSRS, IIS, MS SQL Server, Office, Visual Studio, Database Engine Tuning Advisor, SQL Server Management Studio, SSIS, SSRS.