Specialist for Microsoft SQL Server migrations as well as DBA Admin
Company: ARZ Innsbruck
Technology: SQL Server, SSIS, SSAS, SSRS.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Jan 2020 – Dec 2020
Cost: no details
Support of a team in a data centre as SQL Server administrator with the main task of carrying out more complex migrations into a cluster for customer-side databases and for internal databases. Additional support in the processing of tickets in the general operation of the databases and the installation of special applications as well as the migration of complex data warehouse environments and the required tools such as SSIS, SSAS and the SSRS.
- Install and configure SQL Server.
- Configure SQL Server databases and storage.
- Plan and implement a backup strategy.
- Restore databases from backups.
- Importing and exporting data.
- Monitoring SQL Server.
- Tracking SQL Server activities.
- Manage SQL Server security.
- Knowing data access and data encryption.
- Perform ongoing database maintenance and optimisation.
- Automate SQL Server maintenance with SQL Server Agent jobs.
- Configure database mails, alerts and notifications.
- Migration of all SQL Servers internally.
- Migration of all SQL Servers for customers ARZ.
- Migration from SQL Server cluster to cluster.
- Migration of all SQL Server intern.
- Cluster to single.
- Migration of SQL Server Virtual Cluster.
- Installation of SQL Server Virtual Cluster.
- Migration of all SQL Servers for customers ARZ.
- Ticket handling.
- Training SSIS, SSAS and SSRS installations.
Consulting function, does not affect 100% workload.