Business solutions for you portfolio

About

Company: Firma Bühler, Uzwil (40% - 60%)

Technology: MS SQLServer, T-SQL, Admin.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Jan 2017 – Nov 2017

Cost: no details


The company Bühler operates 2000 SQL servers worldwide. The main task in this project was to administer this SQL server in a ticket-oriented manner. This was done 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.
  • 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.
  • Perform ongoing database maintenance and optimisation.
  • Automate SQL Server maintenance with SQL Server Agent jobs.
  • Configure database mails, alerts and notifications.
  • Install SQL Server Virtual Cluster.
  • Ticket handling.
  • SSIS, SSAS and SSRS installations.
  • Creation of various concepts in the area of Microsoft SQL Server.
  • Requirement engineering.
  • Loading and cleaning of data using T-SQL.
  • Creation of ETL processes using SSIS packages or T-SQL.
  • Data refinement and data mapping using T-SQL.
  • Loading of data into the surrounding systems.
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52

 

info@bs4y.ch

Order a project
Tell us what kind of project you want to do.
Name
E-mail
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.