Sfoglia categorie
Esplora
Fiverr Pro
Italiano
$
USD
I will audit and optimize your ssis etl performance
Senior Technical Architect , BI and ETL Performance Expert
I am a Senior Technical Architect and BI Lead with over 17 years of experience delivering enterprise-scale data solutions for global leaders like Shell, Centrica, and Lloyd's of London. I specialize i...
Informazioni su questo servizio
Stop wasting hours on slow, failing ETL processes.
If your SSIS data loads are timing out, hitting memory bottlenecks, or keeping your data warehouse offline until 9:00 AM, you don't need a junior developer. You need a Performance Architect.
With over 17 years of enterprise-level experience delivering high-velocity Microsoft BI solutions for global leaders like Shell, Centrica, and Lloyd's of London, I specialize in rescuing poorly performing data pipelines. I don't just put "band-aids" on errors; I fix the root cause.
What I analyze and fix in your architecture:
- Data Flow Tuning: Optimizing DefaultBufferMaxRows and DefaultBufferSize to prevent memory spooling.
- Execution Plan Review: Identifying and replacing asynchronous blocking transformations (Sorts, Aggregates) with optimized SQL source queries.
- Database Engine Tuning: Indexing strategies, partition alignment, and TempDB contention resolution.
- Enterprise Automation: Implementing BIML (Business Intelligence Markup Language) for scalable package generation.
Why hire me? As a Senior BI Lead with a track record of zero SLA breaches and migrating 100+ TB data environments, I build pipelines tha
_oi1r3f.jpg)
Warehouse Platform:
Azure Synapse
•
Altro
Tipo di progetto:
Ottimizzazione
Il mio portfolio
FAQ
Do I need to give you direct access to my Production server?
No. I strictly follow enterprise security best practices. I prefer to work via a secure VPN/RDP into your Development or QA environment, or we can work together via a live Teams/Zoom screen-share session to diagnose the issues.
What if the performance bottleneck isn't in SSIS, but in the SQL Database itself?
ETL performance is deeply tied to the database engine. My audit doesn't just look at the SSIS Control/Data Flow; I also review your SQL Execution Plans, missing indexes, and potential TempDB contention to find the true root cause.
Can you handle older legacy systems or just modern Azure stacks?
Both. With 17+ years in the industry both OnPrem and Cloud, I have successfully migrated legacy 175GB Sybase/DTS systems to modern SQL Server setups, and I am also fully certified as a Microsoft Azure Data Engineer for cloud-native architectures.
