*Dear Jyothi*
*Please see the below job and let me know if you have any suitable consultants.* *Kindly share the matching resumes to **sun...@datsolinc.com <sun...@datsolinc.com> / dil...@datsolinc.com <dil...@datsolinc.com>* *Title: SQL Business Intelligence DBA (SSAS Tabular)* *Location: Grand Rapids, MI* *Job Description* 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 ErrorsSe *Technical Skills* Highly Skilled · SSAS Tabular (Vertipaq, xVelocity) Internal Engine · SSAS Tabular Configuration Settings and Properties (ie Memory Limits) · Metadata documentation and performance monitoring experience · DAX programming · ANSL SQL skills Adequate / Marginal · Active Directory, Role Security and Row Level Security Administration · Cloud and Hybrid Cloud Infrastructure experience · Dimensional Modeling and Business Intelligence Concepts · Power BI Experience including Enterprise Gateway and Office 365 Administration · SQL Server Reporting Services (SSRS) · Teradata experience · Upgrading SQL Server and SSAS · SharePoint *General Skills* · Communication – Excellent written and verbal communication skills · Teamwork – Ability to work in a team *Regards* *Suneel R * *Data Solutions Inc* *** Certified Minority-Owned Business Enterprise (MBE) *** Canton, Michigan 48187 Direct Line - (734)-399-4473 Fax - (734)-437-5524 Email:*sun...@datsolinc.com <sun...@datsolinc.com>* URL: http://www.datsolinc.com -- You received this message because you are subscribed to the Google Groups "International SAP Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to international-sap-projects+unsubscr...@googlegroups.com. To post to this group, send email to international-sap-projects@googlegroups.com. Visit this group at https://groups.google.com/group/international-sap-projects. For more options, visit https://groups.google.com/d/optout.
