SQL Server Administration, SSIS/SSAS Administration, MDX Cubes

QL Server database administration

Install, upgrade, patch, and configure SQL Server instances and databases.

Monitor the health and performance of SQL Server instances and databases to ensure uptime and availability.

Optimize SQL queries, stored procedures, and indexes to improve performance.

Manage user access and permissions and secure data from unauthorized access.

Implement and manage backup and recovery strategies.

Deploy, schedule, and monitor SSIS packages, using SQL Server Agent for scheduling.

Manage security roles for SSIS packages to control access to packages and their execution.

Configure and manage the SSIS service and understand its security implications.

Troubleshoot SSIS package execution failures and performance issues.

Manage server-level and database-level objects, including creating and processing cubes, dimensions, and other objects.

Create and modify database roles, assign permissions (e.g., Administrator, Read, Process), and manage role membership.

Monitor and tune SSAS performance, including processing and query execution.

Deploy OLAP or tabular models and manage security at the server and database levels.

Automate administrative tasks using tools like SSIS or other scripting utilities.

Platform monitoring, Infra Support, Patching and observability for MDX Cubes

Create and manage roles that grant specific permissions to users and user groups.

Assign different levels of access, such as read, read-contingent, and read/write, at the database, cube, dimension, and even cell level.

Total Experience

5-8 YEARS

Relevant Experience

Mandatory skills

SQL Server Administration, SSIS/SSAS Administration, MDX Cubes