SharePoint SQL Server Datacenter infrastructure Software development (i.e. Powershell, C#)

• Automate the re-organization of employees together with their departments and business units into new organizational structures regarding their file server resources
• writing specification booklets, application architecture
• programming in C# and MSSQL Server
• short engagement because WIPRO was not able to provide the contract-agreed conditions

• configuration of application deployments with Octopus Deploy
• consultant for all MSSQL Server topics
• short engagement because the management ideas did not fit to the employee’s moods

• Performing a hard- and software-refresh on the complete IT-infrastructure
• Implementation of high availability in all areas of the infrastructure and for the applications

• conception and implementation of the SQL Server landscape for the big data project
• SQL Server 2017 AlwaysON, Windows Server 2019 Clustering
• Configuration of the sub-systems (VMWare, vSAN, Active Directory…)
• Performing performance tests vSAN and optimization due to the special performance requirements together with the team
• implementation of additional SQL server services (SSRS, SSIS, SSAS, Power BI)
• documentation in confluence
• short engagement: The project had been stopped by the Federal Ministry of Transport after a negative judgement of the European Court of Justice

• supervision of the customer’s major enterprise project in software development as DBA.
• operation of the SQL Server AlwaysOn landscape, various stages, MSSQL Server 2014, 2017
• developer support for all SQL Server topics
• capacity management
• investigations into performance at the complete SQL Server infrastructure environment and assistance on removing bottlenecks wherever they are
• advising the company on SQL Server architecture topics and migration strategies

• conception of a production database, information needs analysis, design, implementation and programming of DB, access with views and stored procedures
• Programming a Business-Class Wrapper (C#-DLL) for accessing programs from data structures
• Programming a GUI for configuring the production database with C#
• Optimization of processes surrounding the operation of SQL Server (maintenance plans, query optimization, database access, etc.)
• database design

• operation of SQL Servers, especially in the DWH – Environments
• operation of a banking application at AS/400 iSeries 7.2
• automation of DWH interfaces with Powershell, SSIS and TSQL
• implementation of an additional DWH Test Environment
• programming of functions and views for reporting purposes
• service provider management

• Cure a serious illness after a failed medical procedure
• Everything is fine again

• Examination of the status quo and concept development for the consolidation of the SQL Server landscape
• Perform the operation of the current SQL environments
• Division of the environment as part of a staging concept
• Implementation of AlwaysOn SQL Server 2016 environments
• Teaching of a DBA
• Introduction of a SharePoint – environment as a SharePoint specialist

• Deployment of a SharePoint lab environment using SharePoint 2016, including Office Online Server and SQL Server Analysis Services / PowerPivot
• Developing use cases and test the functionality in a hosted On-Premise environment

• Bridging personnel shortages at the database administration
• Responsible for the operation of the enterprise’s SQL Server landscape consisting of many SQL Server 2008-2014 instances (OLTP, DWH, Reporting Services, Integration Services)
• Preparation and implementation of the migration of all company databases (several hundreds) into a SQL Server 2016 AlwaysOn environment
• Designing and implementation of that high-performance, high-availability platforms
• Performance-tuning of business-critical database-applications
• Automation of operation tasks with the focus on that AlwaysOn playground

• The project has been terminated after two weeks
• Deloitte had substantially changed the conditions and arranged the work in three shifts a few days after I joined the project
• This was contrary to the previously agreed working hours

• Bridging personnel shortages (all DBA had terminated). Since I knew the implemenations, I was asked to bridge the situation and introduce a new internal DBA
• Operation of all SQL services
• Discovering the root cause of performance degradation in the company’s DWH environment
• Re-organization of permission constructions
• Designing an destination SQL architecture that solves different tasks with the use of SQL 2014 AlwaysOn
• Introduction of SCOM into the SQL Server landscape

SQL Server:

• designing of the SQL Server architecture with the following key features: SQL Server 2014 AlwaysOn high availability with the use of geo clusters providing high performance environments migration from SQL 2012 to SQL Server 2014
• creating architectural documentation for the international team

SharePoint:

• evaluation of the existing setup and development of necessary changes in the stretched datacenter scenario
• collaboration on the preparation of the operational readiness of the farms

• Conceptual work for fully automated SharePoint installations at a German cloud provider
• Construction of an architecture for that environment, definition of the product
• Implementation of high performing SQL Server AlwaysOn Clusters with SQL Server 2014
• Supervision and assistance during the script creations by the team
• Construction of methods that ensure long – term standards for SharePoint farms that are already in use, balance the configuration with contracts

Enterprise SharePoint operation and creation of a migration architecture

• Operation of multiple SharePoint Farms for about 6.000 Users worldwide for a globally playing customer
• Finalizing the introduction of advanced operation standards for more failure resistance and stability based on audits
• Creation of highly detailed architectures and migration procedures for migrating existing farms into new environments, consolidation, standardization
• Customer management support in organizational fields like governance, permissions and roles, staging, performance