Microsoft SQL Server Consultant - DBA Admin - Consultant
Company: Oerlikon
Technology: MS SQL-server.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Aug 2021 – Now
Cost: no details
Supporting a team as SQL server administrator with the main task of carrying out more complex admins. Additional support in processing tickets in 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.
- 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.
- Undertaking 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.