25.10.2026 aktualisiert

**** ******** ****
100 % verfügbar

Senior SQL Server Consultant | Stability, Performance, HA & Troubleshooting

Voula, Griechenland
Weltweit
State-certified Technical Engineer, specializing in Data Processing
Voula, Griechenland
Weltweit
State-certified Technical Engineer, specializing in Data Processing

Über mich

Senior SQL Server Consultant with 20+ years of experience in performance, troubleshooting, high availability, migrations and operational stability. I help companies resolve complex database issues and build reliable, maintainable SQL Server environments.

Skills

Business Continuity And Disaster RecoveryDisaster RecoveryFailover ClusteringMicrosoft Sql-ServerAzure SQLWindows-ServerSQL Server Management StudioPerformance-TuningWindows PowershellServer AdministrationSQLSql Server AgentTransact-SqlBackup And RestoreHochverfügbarkeits-ClusterUrsachenanalyseSQL OptimizationSql Server Database AdministrationZuverlässigkeit der SystemeDatenbankleistungDatenbank-MigrationSql TuningAdministration von Datenbanken
Senior SQL Server Consultant with more than 20 years of experience in SQL Server infrastructure, performance tuning, troubleshooting, high availability, database operations and migration projects.

My focus is on stabilizing critical SQL Server environments, identifying root causes of performance and availability issues, and implementing sustainable technical improvements.

Core skills include Microsoft SQL Server administration, performance analysis, query tuning, wait statistics, blocking and deadlock analysis, execution plans, indexing, SQL Server Agent, backup and restore, recovery readiness, patching, upgrades and migrations.

Extensive experience with SQL Server Failover Cluster Instances, Always On Availability Groups, Windows Server Failover Clustering, log shipping, replication, disaster recovery and high availability concepts.

Additional experience includes Azure SQL Database, Azure SQL Managed Instance, hybrid SQL environments, PowerShell, dbatools, T-SQL, Windows Server, virtualization, storage analysis, monitoring and production support.

I support customers with complex SQL Server incidents, infrastructure bottlenecks, database platform modernization, operational stabilization and technical assessments.

Erfahrung

Berufserfahrungmehr als 10 Jahre
Freelancer seit2022

Sprachen

GermanMutterspracheEnglishverhandlungssicherGreekGrundkenntnisseItalianGrundkenntnisseSpanishgut

Projekthistorie

Senior SQL Server Consultant – Upgrade and Platform Modernization

Confidential German business software customer

Industrie und Maschinenbau

Technical assessment and planning of a SQL Server upgrade and platform modernization for a business-critical production environment.

Key responsibilities:

- Review of SQL Server versions, editions and cumulative update levels
- Identification of outdated or unsupported SQL Server components
- Analysis of database, application and infrastructure dependencies
- Assessment of current CPU, memory, storage and database sizing
- Evaluation of high availability and failover requirements
- Development of upgrade and migration options
- Planning of implementation, testing and rollback procedures
- Preparation of recommendations for the future SQL Server platform
- Coordination with infrastructure, application support and external service providers

Technologies:

Microsoft SQL Server 2016–2022, Windows Server, SQL Server Failover Clustering, T-SQL, PowerShell, patching, upgrade planning, migration planning, capacity planning

Result:

Developed a structured modernization concept covering SQL Server version, patch level, infrastructure sizing, storage design and operational requirements for a more stable and maintainable future platform.

Senior SQL Server Consultant – Cluster Stabilization and Capacity Planning

German professional services company

Wirtschaftsprüfung, Steuern und Recht

Analysis and stabilization of a business-critical SQL Server failover cluster hosting multiple SQL Server instances on a virtualized infrastructure.

Key responsibilities:

- Analysis of SQL Server instance distribution across the cluster nodes
- Review of memory allocation and resource utilization
- Assessment of failover capacity and operational risks
- Analysis of backup storage consumption and retention requirements
- Troubleshooting of failed SQL Server maintenance and backup jobs
- Capacity planning for RAM and backup storage
- Development of recommendations for workload redistribution
- Technical coordination with infrastructure and application teams

Technologies:

Microsoft SQL Server, Windows Server Failover Clustering, SQL Server Failover Cluster Instances, PowerShell, dbatools, Ola Hallengren Maintenance Solution, Nutanix, Windows Server

Result:

Developed a structured optimization concept to improve cluster stability, resource allocation and backup capacity.

Senior SQL Server Consultant – Performance and Root Cause Analysis

German ERP and business applications provider

Internet und Informationstechnologie

Analysis of recurring performance issues and application outages in a historically grown SQL Server environment hosting several business-critical components on a shared virtual machine.

Key responsibilities:

- Analysis of SQL Server error logs and Windows event logs
- Identification of database, storage and infrastructure bottlenecks
- Review of CPU, memory and storage configuration
- Analysis of database growth, large tables and abnormal space consumption
- Assessment of SQL Server version, edition and patch level
- Evaluation of workload distribution and resource contention
- Development of immediate stabilization measures
- Preparation of recommendations for a future SQL Server platform redesign
- Coordination with infrastructure and application support teams

Technologies:

Microsoft SQL Server 2016, T-SQL, SQL Server Error Log, Windows Server, VMware, performance analysis, storage analysis, capacity planning

Result:

Identified structural risks and resource bottlenecks in the existing environment and developed recommendations for short-term stabilization and a properly sized future SQL Server platform.

Senior SQL Server Consultant – Connectivity, Protocol and Security Troubleshooting

Confidential German IT services company

Internet und Informationstechnologie

Analysis of intermittent SQL Server connectivity problems, login failures and protocol-related errors in business-critical production environments.

Key responsibilities:

- Analysis of SQL Server error log messages and Windows event logs
- Investigation of connection errors, invalid login packets and interrupted client sessions
- Differentiation between SQL Server engine, network, client and security-related causes
- Review of TDS protocol, TLS configuration and certificate requirements
- Assessment of SQL Server client drivers and application connection behavior
- Analysis of errors including SQL Server messages 4014, 17821, 17832 and severity 20 incidents
- Validation of SQL Server service availability and network connectivity
- Coordination with network, security, infrastructure and application teams
- Documentation of findings, responsibilities and recommended follow-up actions

Technologies:

Microsoft SQL Server, SQL Server Error Log, Windows Event Logs, TDS, TLS, certificates, network troubleshooting, SQL Server client connectivity, Active Directory

Result:

Isolated SQL Server engine issues from network, client and security-related causes and provided targeted recommendations to the responsible technical teams.

Senior SQL Server Consultant – Backup, Restore and Recovery Readiness

Confidential German enterprise customer

Pharma und Medizintechnik

Review and improvement of backup, restore and recovery processes for business-critical SQL Server environments.

Key responsibilities:

- Analysis of failed full, differential and transaction log backup jobs
- Review of SQL Server Agent jobs and Ola Hallengren maintenance configurations
- Assessment of backup retention periods and storage capacity
- Analysis of backup volume consumption and future capacity requirements
- Validation of backup files and backup chains
- Planning and execution of restore tests
- Review of recovery models and transaction log backup strategies
- Identification of operational risks in existing backup processes
- Development of recommendations for sustainable backup and restore procedures
- Coordination with infrastructure, storage and application teams

Technologies:

Microsoft SQL Server, SQL Server Agent, Ola Hallengren Maintenance Solution, T-SQL, PowerShell, dbatools, Backup and Restore, Transaction Log Management, Disaster Recovery

Result:

Improved transparency around backup reliability, storage requirements and recovery readiness. Developed practical recommendations for retention, capacity planning and regular restore testing.

Senior SQL Server Consultant – Transaction Log and Storage Troubleshooting

Confidential pharmaceutical company

Pharma und Medizintechnik

Troubleshooting of transaction log growth, storage pressure and failed maintenance processes in business-critical SQL Server environments.

Key responsibilities:

- Analysis of transaction log utilization and file growth
- Review of database recovery models and transaction log backup chains
- Identification of failed, missing or delayed transaction log backups
- Analysis of virtual log file allocation and shrink limitations
- Evaluation of current file sizes, autogrowth settings and maximum file sizes
- Controlled resizing and reduction of oversized transaction log files
- Optimization of autogrowth settings
- Review of SQL Server Agent and maintenance jobs
- Assessment of available storage capacity and operational risks
- Development of recommendations for sustainable log management and monitoring

Technologies:

Microsoft SQL Server, T-SQL, DBCC SHRINKFILE, DBCC SQLPERF, SQL Server Agent, transaction log management, backup and restore, storage analysis

Result:

Resolved acute storage pressure and established more sustainable transaction log sizing, growth settings and backup procedures.

Kontaktanfrage

Einloggen & anfragen.

Das Kontaktformular ist nur für eingeloggte Nutzer verfügbar.

RegistrierenAnmelden