Microsoft SQL Server Administrator

Location: Vienna, Austria Salary: €300 - €400 per day
Sector: Consultancy Type: Contract
Reference #: CR/059529_1552387901

Microsoft SQL Server Administrator / 3 months / Vienna / Start ASAP


- Setup of DWH & BI environment on a SQL Cluster environment
- Microsoft SQL Server (aktuellste Version wenn möglich)
- inkl. SQL Server Integration Services
- inkl. SQL Server Analysis Services
- inkl. SQL Server Reporting Services
- inkl. SQL Server Data Tools
- inkl. SQL Server Data Quality Services
- inkl. SQL Server Management Studio
- Microsoft Power BI (aktuellste Version wenn möglich)
- inkl. Berichtsserver
- Installation, Configuration & Sizing of SQ Server Infrastructure
- AZURE IaaS environment for Development & Test with option container based setup
- Production deployment on kubernetes container management (could also be VM if container for SQL Server components are not performing well).
- Operate development & test environment for DWH&BI
- Give advice to use container based architecture for SQL Server to meet production environment requirements
- Decide and elaborate physical data architecture (storage, tablespaces)
- Design physical integration architecture with overall operational environment and help to decide best fit integration mechanisms (e.g. CDC, Kafka or classical ETL)
- Support IT provider to monitor SQL Server DWH & BI environment
- Support DWH & BI development team to administrate and tune SQL Server components (scalability, parallelization , availability, etc.)
- Other typical SQL Server administration tasks