Project description MICROSOFT PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Microsoft SQL Server - DBA Admin

Börse Stuttgart

MS SQL Server

Börse Stuttgart

PROJECT LINK: Not available
Persons in the PROJECT: Stefan Troehler
PROJECT Duration: Aug 2021 – Mar 2023
PROJECT value: SFR. 00,000.00

SQL

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT
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 the SSRS.

  • Installing and configuring SQL Server.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restoring databases from backups.
  • Importing and exporting data.
  • Monitoring the SQL Server.
  • Track SQL Server activity.
  • Managing SQL Server Security.
  • Knowledge of data access and data encryption.
  • Perform ongoing database maintenance and optimizations.
  • Automate SQL Server maintenance with SQL Server Agent jobs.
  • Configure database mails, alerts and notifications.
  • Migrate all SQL servers internally.
  • Migration of all SQL servers for customers ARZ.
  • Migrate from SQL Server cluster to cluster.
  • Migrate all SQL servers internally.
  • Cluster to standalone.
  • Migrate 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 role, does not affect 100% workload.