Microsoft SQL-Server – DBA Admin
Company: Börse Stuttgart
Technology: SSIS, SSAS, MS SQL-server.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Aug 2021 – Mar 2023
Cost: no details
Supporting a team in a data center as a SQL server administrator with the main task of performing more complex migrations into a cluster for customer-side databases and for internal databases. Additional support in processing the 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 SSRS.
- Install and configure SQL Server.
- Configure SQL Server databases and storage.
- Plan and implement a backup strategy.
- Restoring databases from backups.
- Import and export data.
- Monitoring the SQL Server.
- Tracking SQL Server activities.
- Managing SQL Server Security.
- Knowledge of data access and data encryption.
- Carrying out ongoing database maintenance and database optimizations.
- 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 servers internally.
- Cluster to stand alone.
- Migration of a virtual SQL server cluster.
- Installing SQL Server Virtual Cluster.
- Migration of all SQL servers for customers ARZ.
- Ticket processing.
- Training SSIS, SSAS and SSRS installations.
- Advisory function, does not affect 100% workload.