Rafał Dobrzyński
Vice President, Data & BI, Team Leader
Szwajcaria,
zagranica
Języki
polski
ojczysty
angielski
biegły
niemiecki
dobry
Doświadczenie zawodowe
SQL Server DBA
7digital
• General DBA tasks (security, disaster recovery, installation and configuration)
• Manage production, development and testing environments
• Performance tuning and query optimization
• Setup and manage replications
• Database development in Transact SQL (stored procedures, views, functions, triggers)
• Database design
• Create reports with Reporting Services
• Create upload processes with SSIS
• Designed and developed OLAP cubes (SSAS)
• Monitor production environment to ensure proactive maintenance and avoid unplanned downtime
• Ongoing capacity planning
• Manage production, development and testing environments
• Performance tuning and query optimization
• Setup and manage replications
• Database development in Transact SQL (stored procedures, views, functions, triggers)
• Database design
• Create reports with Reporting Services
• Create upload processes with SSIS
• Designed and developed OLAP cubes (SSAS)
• Monitor production environment to ensure proactive maintenance and avoid unplanned downtime
• Ongoing capacity planning
Senior SQL Server Administrator/Developer
APT (currently Sungard)
• Database logical and physical design
• Performance tuning
• High availability and disaster recovery (database mirroring, replication)
• Experience with very large databases
• Implement and monitor production loading processes with DTS and SSIS
• Experience with migration from Sql Server 2000 to 2005
• Day to day operational support
• Create reports with Reporting Services
• Database development experience using Transact SQL, c#, asp.net, vb, vbscript
• Performance tuning
• High availability and disaster recovery (database mirroring, replication)
• Experience with very large databases
• Implement and monitor production loading processes with DTS and SSIS
• Experience with migration from Sql Server 2000 to 2005
• Day to day operational support
• Create reports with Reporting Services
• Database development experience using Transact SQL, c#, asp.net, vb, vbscript
Sql Server Administrator/Developer
• Administration and maintenance of marketing databases
• Seven servers administration experience (MS SQL Server 7.0/2000) broken down into two departments
• Ensuring data base security
• Analyze customers needs and adapt solutions
• Developed applications and design databases for the company necessities (Visual Basic, T-SQL, MS Access)
• Created reports for the Management (Seagate Crystal Report)
• Seven servers administration experience (MS SQL Server 7.0/2000) broken down into two departments
• Ensuring data base security
• Analyze customers needs and adapt solutions
• Developed applications and design databases for the company necessities (Visual Basic, T-SQL, MS Access)
• Created reports for the Management (Seagate Crystal Report)
Database Developer
• Updated CRM system interface - Microsoft Visual Basic and Sql Server 7.0
• Made module to make out warranty - Microsoft Visual Basic
• Modernized CRM system - migration from Visual Basic and MS Access to stored procedures in T-SQL
• Changed services application into client-server model - C# .Net
• Made module to make out warranty - Microsoft Visual Basic
• Modernized CRM system - migration from Visual Basic and MS Access to stored procedures in T-SQL
• Changed services application into client-server model - C# .Net
Szkolenia i kursy
- VMware vSphere: Install, Configure, Manage [V4] - July, 2010
- DELL: Workshop Dell-EMC SAN (Clariion series CX and CX3) - November, 2009
- Microsoft Approved Course: Implementing and Managing Windows Server 2008 Clustering - July, 2009
- Solid Quality Learning University: SQL Server 2005 End-to-End Business Intelligence Workshop, April, 2007
- Microsoft Approved Course: Updating Your Database Administration Skills to Microsoft SQL Server 2005 (MS 2733) - September, 2006
- Microsoft Approved Course: Administering a Microsoft SQL Server 2000 Database (MS 2072) – May, 2005
- Kerberos Course: Information Security Policies – Feb, 2005
- Kerberos Course: The Protection of Personal Data – Feb, 2005
- DELL: Workshop Dell-EMC SAN (Clariion series CX and CX3) - November, 2009
- Microsoft Approved Course: Implementing and Managing Windows Server 2008 Clustering - July, 2009
- Solid Quality Learning University: SQL Server 2005 End-to-End Business Intelligence Workshop, April, 2007
- Microsoft Approved Course: Updating Your Database Administration Skills to Microsoft SQL Server 2005 (MS 2733) - September, 2006
- Microsoft Approved Course: Administering a Microsoft SQL Server 2000 Database (MS 2072) – May, 2005
- Kerberos Course: Information Security Policies – Feb, 2005
- Kerberos Course: The Protection of Personal Data – Feb, 2005
Specjalizacje
IT - Administracja
Administrowanie bazami danych i storage
Zainteresowania
sport, travelling, reading, photography
Organizacje
http://www.linkedin.com/in/rafald
Inne
good analytic and design skills
Grupy
Politechnika Warszawska
Politechnika Warszawska jest najstarszą polską uczelnią techniczną. Od ponad 180 lat kształci kolejne pokolenia inżynierów, wnosząc istotny wkład w rozwój nauk technicznych.
Bazy Danych
Zagadnienia bazodanowe: SQL99 i jego implementacje w popularnych systemach RDBMS: Oracle, MySQL, PostgreSQL, MSSQL, IBM DB2 i inne.
Business IT
Grupa firm branży IT / INTERNET. Liderzy i Eksperci. Wydarzenia branżowe rynku IT (B2B). Zarządzanie IT, badanie IT, startupy IT, technologia IT, internet IT, ebiznes IT.
CFA Society of Poland
Polskie stowarzyszenie CFA Institute, międzynarodowej organizacji doradców inwestycyjnych
Garaż IT
Masz pomysł na biznes. Szukasz kapitału i ludzi żeby go zrealizować? Dobrze trafiłeś, zacznij go robić z innymi!
Gdy na świat przychodzi niemowlę
Kompendium wiedzy, które przyda się Wam, gdy na świecie pojawi się dzidziuś. Stwórzmy je wspólnie ze sklepem www.BabyStyle.pl !
Gdzie na weekend?
Dysponując jedynie piątkowym wieczorem, sobotą i połową niedzieli - jak można ciekawie spędzić czas?