Freelancer profile translated to English.
Back to original languageAbout Andreas
I have been working in the IT world for over 20 years, primarily developing database solutions for small and large companies across various industries, including consulting, healthcare, online, banking, and logistics.
My practical work experience includes designing and building new environments from scratch, overhauling & consolidating existing systems, implementing high availability and disaster recovery technologies, performance tuning, development and support, as well as in-house training.
I have been a member, leader, and mentor for on- and offshore teams, working with developers, IT and support staff, and management alike, both as a technical resource and a liaison between technology and the business.
I am passionate about technology, learning new skills, and implementing solutions to problems I didn't even know existed yesterday - if you ask me, there's nothing better than a real challenge!
☑ Microsoft SQL Server - 2000 | 2005 | 2008 | 2008 R2 | 2012 | 2014 | 2016 | 2019 | 2022 - MCITP
☑ Oracle - 8i | 9i | 10 g - OCP
☑ System Architecture - Physical | Virtual (VMware / Hyper-V)
☑ Storage Architecture – Local | SAN | SSD | NVME
☑ High Availability - AlwaysOn AG | Failover Clustering | Mirroring | Replication | LogShipping
☑ Database Design – OLTP | OLAP
☑ Performance Tuning - Index Strategy | Query Plans | Query Optimization
☑ Cloud – Microsoft Azure | Google GCP | Amazon-AWS
☑ Data Migration – Consolidation | Upgrade
☑ Scripting – TSQL | PowerShell
☑ 3rd Party Tools – Monitoring (SentryOne | Idera SQL Diagnostic Manager | Dell Spotlight | Confio Ignite), Backup (Red Gate Backup | Dell Litespeed), Ticketing (ServiceNow | Matrix42)
☑ Community Tools – sp_WhoIsActive | Ola Hallengren Maintenance Solution | Brent Ozar Tools | DBATools | DBADash
German
Native or bilingual
English
Native or bilingual
Remote only
Primarily works remotely
Experience
- TEDi GmbH & Co. KGSr SQL Server DBA / Architect ConsultantRETAIL (LARGE RETAILERS)December 2023 - Today (2 years and 8 months)Hannover, GermanyPlanning & Execution of a Migration to Google CloudStrategic migration of the SQL Server infrastructure to Google Cloud (GCP) with a focus on high availability and cost-efficiency.This includes:
- Responsibility:Management of 30 instances (2012–2022 EE/SE) in Hyper-V/VMWare environments.
- Preparation:Setup of a monitoring system for baseline data acquisition and server sizing, including performance testing of GCP VMs for quality assurance.
- Automation:Development of a PowerShell script for standardized cloud installation following best practices.
- Migration:Implementation of hybrid AlwaysOn AGs (On-Prem to GCP) for "Near Zero Downtime" migrations and execution of all transfers.
- Optimization:Performing edition downgrades to significantly reduce licensing costs in the cloud.
- Support:Full responsibility for production support throughout all migration phases.
- Huf Haus GmbHSr. SQL Server DBA ConsultantCIVIL ENGINEERINGJuly 2023 - Today (3 years and 1 month)Hannover, GermanyIndependent Senior ConsultantFocus on overhauling the server setup according to best practices and production support.This includes:
- Architecture:Design of a high availability solution for critical internal systems, considering existing frameworks.
- Implementation:Support in the introduction of AlwaysOn Availability Groups, including best practice configuration for SQL Server.
- Simon HegeleSr. SQL Server DBA ConsultantLOGISTICS AND SUPPLY CHAINMay 2021 - Today (5 years and 2 months)Hannover, GermanyIndependent Senior ConsultantFocus on overhauling the server setup according to best practices and production support as needed.This includes:
- Responsibility:Management of approximately 12 SQL Server 2017 instances in a virtualized environment (VMware).
- High Availability & DR:Support of AlwaysOn Availability Groups (AG) to ensure HA and Disaster Recovery.
- Support & Optimization:Support for internal teams in development and T-SQL performance tuning (Stored Procedures, Functions, Queries).
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Computer Assistant, Specialization Software Technologyb.i.b. Hannover2001Die Ausbildung zum staatlich geprüften Informatikassistenten mit Fachrichtung Softwaretechnologie am Bildungszentrum für informationsverarbeitende Berufe ( b.i.b. ) verlief über eine Dauer von zwei Jahren. Während dieser Zeit wurde durchgehend theoretischer Unterricht mit entsprechender praktischer Umsetzung der Lehrinhalte erteilt. Zusätzlich wurde eine Projektarbeit in einem Unternehmen für die Dauer von 8 Wochen durchgeführt. Inhalte: - Deutsch / Kommunikation (160 Stunden) - Politik (80 Stunden) - Englisch (80 Stunden) - BWL (240 Stunden) - C / C++ (160 Stunden) - Programmierung: Visual Basic / Java (320 Stunden) - Datenbanken (240 Stunden) - Betriebssysteme / Rechnerkonzepte (240 Stunden) - Netzwerke (360 Stunden) - Informatik (240 Stunden) - Mikroprozessor - Systeme (280 Stunden) - Informatik - Multimedia (240 Stunden) - Wahlpflichtkurs Informatik l: Standardsoftware (80 Stunden) - Wahlpflichtkurs Informatik 2: Programmierung C / C++ (80 Stunden) - Software-Projekt Realisierung einer DV-Aufgabe in einem achtwöchigen Block vor Ort, Teamarbeit für zwei Personen -> Erstellung einer Webseite mit Datenbankanbindung unter Verwendung von HTML, ASP & MS Access für List+Lohr in Hannover (320 Stunden)
Certifications
- Microsoft Certified ProfessionalMicrosoft (F218-4138)2012
- Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and MaintenanceMicrosoft (D512-8574)2011