Senior DWH Platform Engineer- SQL Server DBA

CoolPeople Technology; Österreich; Remote; EUR 80,000 - 110,000; Full time

Job summary

CoolPeople Technology is seeking two Senior DWH Platform Engineers / Database Administrators to support an on-premise Data Warehouse for an Austrian furniture retail client. The consultants will ensure stability, availability, and performance of the DWH environment, including SQL Server and SSAS administration, ETL monitoring, deployments, and tuning, with 2nd/3rd level support.

The engagement is fully remote and starts ASAP. German language proficiency (B2-C1) is required.

Qualifications

• Several years of experience as Senior Database Administrator, DWH Platform Engineer or in a similar role.
• SQL Server performance optimization and tuning.
• Hands-on experience with SSAS; cube processing.

Responsibilities

• Stability, availability and performance of the DWH environment.
• SQL Server and SSAS administration, ETL monitoring and troubleshooting.
• Database deployments and performance tuning; 2nd/3rd level support.
• Coordinate operational processes with stakeholders; independent ownership.

Skills

Senior DBA

DWH Engineer

SQL Server Tuning

SSAS

ETL Monitoring

PowerShell

SQL Scripting

Performance Tools

HA SQL

L2/L3 Support

German Proficiency

Tools

Redgate SQL Compare

MDX

Power BI

SQL Server Profiler

Extended Events

DMVs

Automation Scripts

Job description

We are looking for two experienced Senior DWH Platform Engineers / Database Administrators to support the operation and further development of an existing on-premise Data Warehouse platform for an Austrian furniture retail client.

The consultants will take responsibility for the stability, availability, performance and ongoing operation of the DWH environment. The role includes SQL Server and SSAS administration, ETL process monitoring and troubleshooting, database deployments, performance tuning, 2nd/3rd level support and coordination of operational processes with relevant stakeholders.

The engagement is fully remote and should start as soon as possible. Structured onboarding at the beginning of the assignment is available and preferred.

Must have skills

• Several years of experience as Senior Database Administrator, DWH Platform Engineer or in a similar role
• SQL Server performance optimization and tuning
• Hands-on experience with SSAS
• SSAS troubleshooting and cube processing
• Experience with operation and management of ETL processes
• PowerShell
• SQL scripting
• Experience with performance analysis tools: SQL Server Profiler, Extended Events, Performance Monitor, Dynamic Management Views
• Backup and recovery processes
• Permission / access management
• High Availability solutions, ideally SQL Server Always On
• Experience with 2nd and 3rd level support
• Ability to independently take operational responsibility
• Structured and solution-oriented working approach
• Communicative German (B2-C1)

Nice to have skills

• Redgate SQL Compare
• SSIS
• MDX
• Power BI
• Automation of database deployment processes
• Automation of maintenance and operational processes
• Previous experience working together with the second proposed consultant is an advantage