09.10.2025 aktualisiert
ES
teilweise verfügbar
info: Abends und am Wochenende verfügbar
Experienced SQL Server DBA & BI Developer
Hadamar, Deutschland
Hadamar +100 km
Bachelor of Computer SoftwareSkills
AbfrageleistungBankingBusiness IntelligenceBusiness Intelligence DevelopmentDatenbankenDatenarchivierungETLDatenmodellData WarehousingDatenbankserverDatenbank-SchemaDisaster RecoveryLog-VersandMicrosoft Sql-ServerSQL Server Management Studio
SQL Server Administration
Extensive experience in managing large-scale database environments, including 1000+ databases in banking systems. Expertise in High Availability solutions such as Always On and Log Shipping.
Business Intelligence Development
Proficiency in developing BI solutions using tools like Power BI, SSIS, and SSAS. Creation of interactive dashboards for real-time insights and design of multidimensional OLAP cubes.
Performance Optimization
Strong skills in query optimization and database performance tuning. Successfully optimized query performance by up to 50% on billion-record tables.
ETL Development
Experience in developing ETL pipelines integrating multiple data sources. Proficient in data modeling and data warehousing techniques.
Database Management
Expertise in configuring and maintaining database servers and processes. Implementation of efficient backup and restore strategies, and data archiving techniques.
T-SQL
Advanced knowledge of T-SQL for complex query writing, stored procedure development, and database schema design.
High Availability & Disaster Recovery
Implementation of High Availability solutions across multiple servers and design of disaster recovery strategies.
Extensive experience in managing large-scale database environments, including 1000+ databases in banking systems. Expertise in High Availability solutions such as Always On and Log Shipping.
Business Intelligence Development
Proficiency in developing BI solutions using tools like Power BI, SSIS, and SSAS. Creation of interactive dashboards for real-time insights and design of multidimensional OLAP cubes.
Performance Optimization
Strong skills in query optimization and database performance tuning. Successfully optimized query performance by up to 50% on billion-record tables.
ETL Development
Experience in developing ETL pipelines integrating multiple data sources. Proficient in data modeling and data warehousing techniques.
Database Management
Expertise in configuring and maintaining database servers and processes. Implementation of efficient backup and restore strategies, and data archiving techniques.
T-SQL
Advanced knowledge of T-SQL for complex query writing, stored procedure development, and database schema design.
High Availability & Disaster Recovery
Implementation of High Availability solutions across multiple servers and design of disaster recovery strategies.
Erfahrung
Berufserfahrungmehr als 10 Jahre
Freelancer seit2020
Sprachen
DeutschgutEnglischverhandlungssicher
Projekthistorie
Supported database administration and ensuring efficient storage, processing, and retrieval of data .
Designed, implemented, and optimized ETL pipelines for data integration from multiple sources, leveraging Azure Data Factory, Azure SQL Database, and other cloud tools.
Improved database and data warehouse performance through indexing, query optimization, and monitoring.
Ensured high availability, data integrity, and security for critical business applications in cloud and on-prem environments
Designed OLAP cubes with complex MDX calculations for banking analytics, created advanced Power BI dashboards, and optimized cube processing time by 50%.
Configured and maintained database servers, implemented high availability across three servers, designed efficient backup strategies, and reduced database size by 50% through data archiving.