06/15/2016
Direct Client - Business Intelligence DBA - SSAS
Location: Grand Rapids, MI
Duration: Long Term
Start Date: ASAP.
Active Directory, Role Security and Row Level Security Administration: Adequate
ANSL SQL skills: Highly Skilled
Cloud and Hybrid Cloud Infrastructure experience: Adequate
DAX programming: Highly Skilled
Dimensional Modeling and Business Intelligence Concepts: Adequate
Summary:
The business intelligence DBA (BI-DBA) will be responsible for the availability, scalability and monitoring of mission critical business intelligence assets and solutions. The BI-DBA will implement and support scheduled processing procedures of OLAP data sources, analyze system resource usage, perform required backup and restore tasks across DEV\QA\PROD environments, and contribute to performance tuning and usage analyses across client applications.
Description:
The top responsibility of the BI-DBA will be to ensure that corporate SSAS Tabular databases are refreshed/updated within required processing windows and are available to support required query workloads. The BI-DBA will be deeply familiar with SSAS Tabular processing modes, partitions, and design patterns as well as skills in methods for implementing required processing logic including Powershell scripts, XMLA, SSIS and SQL Agent. The BI-DBA must also be deeply familiar with restore/backup and synchronization processes as well as Load Balancer scale out configurations. Expert knowledge in troubleshooting errors via tools such as SQL Server Profiler, Extended Events and Performance Monitor is required.
The second responsibility of the BI-DBA will be to monitor and support performance tuning and design efforts to maximize report rendering speeds and minimize resource usage (CPU, RAM). The BI-DBA will partner with development teams on analyzing user access frequency, slow and/or common queries, performance bottlenecks, and options for adjusting infrastructure, databases and queries (DAX, MDX) to drive greater performance and scalability.
Required Skills:
SSAS Tabular Database Administration Experience including the following:
• Designing and Managing Scheduled Processing/Refresh, Partitions, Defragmentation, PowerShell Scripting, SSAS XMLA Commands and SSIS Tasks
• Migrating and synchronizing databases across environments
• Synchronization, Backup/Restore
• Monitoring and Analyzing System Resource Usage
• SQL Server Profiler, Extended Events, Performance Monitor Counters
• Troubleshooting and Error Handling experience
• Alerts and Notifications for Errors
Thanks & Regards,
Vasanth Dolai, Lead Recruitment Specialist
Email: [email protected]
DataFactZ Inc., 22260 Haggerty Rd, MI, 48167
Phone: (248) 221-1438 Fax : (248) 715 – 6434
Toll free: 1 866 739 0820
https://www.linkedin.com/in/vasanthdolai
https://twitter.com/DolaiVasanth
http://vasanthdolai.blogspot.in/
https://www.facebook.com/GetJob4u/
Unlock your career potential. Find the key to career satisfaction. For more jobs position visit the blog http://vasanthdolai.blogspot.in/