SSAS Platform Engineer / Admin

Adobe Systems   •  

San Jose, CA

Industry: Software

  •  

5 - 7 years

Posted 377 days ago

  by    Omkar Bhagwat

Position Title :      SSAS Platform engineer

Location:              San Jose CA

Job Duties:

•                    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.

$90K - $100K