SSAS Cube MDX Cube

7 - 9 years

4 - 8 Lacs

Posted:12 hours ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Educational Requirements

Bachelor of Engineering,Bachelor Of Technology,Master Of Technology,Master Of Engineering,Master Of Science,Master Of Comp. Applications

Service Line

Data & Analytics Unit

Responsibilities

Job DescriptionWe are seeking a skilled and experienced SQL Server & BI Platform Administrator to manage and maintain our Microsoft SQL Server environment, including SSIS (Integration Services), SSAS (Analysis Services), and MDX cube development and administration. The ideal candidate will ensure high availability, performance, and security of databases and BI solutions, while supporting data integration and analytical reporting needs across the organization.Key Responsibilities:SQL Server Administration:
  • Install, configure, and maintain SQL Server instances (2016 and above).
  • Monitor database performance, implement tuning and optimization strategies.
  • Manage backups, restores, disaster recovery, and high availability (AlwaysOn, clustering, replication).
  • Implement and maintain security best practices (roles, permissions, encryption).
  • Perform regular health checks and capacity planning.SSIS Administration:
  • Develop, deploy, and manage SSIS packages for ETL processes.
  • Monitor and troubleshoot SSIS jobs and data pipelines.
  • Optimize data flows and ensure data quality and consistency.
  • Schedule and automate data integration tasks using SQL Server Agent or other tools.SSAS & MDX Cubes Administration:
  • Design, deploy, and maintain SSAS OLAP and Tabular models.
  • Write and optimize MDX queries for reporting and analysis.
  • Manage cube processing, partitioning, and performance tuning.
  • Collaborate with BI developers and analysts to support reporting tools (e.g., Power BI, Excel).Required Skills:
  • Strong experience with Microsoft SQL Server (2016/2019/2022).
  • Hands-on expertise in SSIS and SSAS (Multidimensional and Tabular).
  • Proficiency in MDX and DAX query languages.
  • Solid understanding of data warehousing concepts and dimensional modeling.
  • Experience with monitoring tools and performance tuning techniques.
  • Familiarity with Power BI, Azure Data Services, or other cloud platforms is a plus.
  • Excellent problem-solving, communication, and documentation skills.Preferred Skills:
  • Microsoft Certified: Azure Data Engineer Associate
  • Microsoft Certified: Data Analyst Associate
  • MCSA: SQL Server or equivalent (legacy)
  • Preferred Skills:

    Technology->Business Intelligence - Analytics->MSBI (SSAS)

    Mock Interview

    Practice Video Interview with JobPe AI

    Start Data Engineer Interview
    cta

    Start Your Job Search Today

    Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

    Job Application AI Bot

    Job Application AI Bot

    Apply to 20+ Portals in one click

    Download Now

    Download the Mobile App

    Instantly access job listings, apply easily, and track applications.

    coding practice

    Enhance Your Skills

    Practice coding challenges to boost your skills

    Start Practicing Now
    Infosys logo
    Infosys

    IT Services and IT Consulting

    Bangalore Karnataka

    RecommendedJobs for You

    bengaluru, karnataka, india

    bengaluru, karnataka, india