The Bühler company operates 2000 SQL servers worldwide. The main task in this project was to administer this SQL server in a ticket-oriented manner. This in a team of three employees who were responsible for the administration of this 2000 Microsoft SQL server. Among other things, the following activities were carried out:

• Install and configure SQL Server.
• Configuring SQL Server databases and storage.
• Plan and implement a backup strategy.
• Restoring databases from backups.
• Importing and exporting data.
• Monitoring the SQL Server.
• Tracking of SQL Server activities.
• Manage SQL Server Security.
• Carrying out ongoing database maintenance and database
• Automating SQL Server Maintenance with SQL Server Agent Jobs.
• Configure database mails, alerts and notifications.
• Install SQL Server Virtual Cluster.
• SSIS, SSAS and SSRS installations.
• Creation of various concepts in the area of ​​Microsoft SQL Server.
• Requirement Engineering.
• Loading and cleaning data using T-SQL.
• Creation of the ETL processes using SSIS packages or T-SQL.
• Data refinement and data mapping using T-SQL.
• Loading the data into the peripheral systems.