Fachlicher Schwerpunkt dieses Freiberuflers

Data and Database Engineering; Data Warehouse; Business Intelligence; Database development; Database Administration and Performance Tuning.

verfügbar ab
04.11.2019
verfügbar zu
100 %
davon vor Ort
100 %
PLZ-Gebiet, Land

D0

D1

D2

D3

Kontaktwunsch

Ich möchte bevorzugt für Projekte in diesen Einsatzorten kontaktiert werden.

Position

Kommentar

Focusing on Data and Database Engineering, Data Warehouse and Business Intelligence projects.

Over 19 years of extensive experience in database administration, performance tuning and development. Strong proficiency and experience with data warehouse, database architecture/design and data modeling (3NF, Star, Data Vault). Significant knowledge and experience with Business Intelligence solutions and data visualizations. Experienced with ETL/ELT data processing, data pipelines and streams. Manage very large OLTP/OLAP databases in 24x7 production, QA and development mission-critical environments. Efficient in performance monitoring and diagnostic, tuning OLTP and batch application processes, complex SQL queries, PL/SQL code, and database optimizations. Experienced with backup and recovery, fail-over and disaster recovery, advanced replications and clones. Efficient in high availability, scalability and load balancing solutions. Advanced scripting in Perl, Unix shell and power shell, high skills writing complex SQL queries and PL/SQL. Experienced with IT infrastructure, cloud-based platforms and systems engineering.

Specialties:
• Oracle, MSSQL, MySQL/MariaDB, PostgreSQL, AWS Redshift Cluster
• Unix (HP, Solaris, AIX), Linux (RHEL, Debian, Ubuntu), Win Server
• Replication/Disaster Recovery: Log Miner, Oracle Streams, Data Guard
• High Availability/Scalability: Oracle RAC, ASM, Clustering, Hyper-V, VMware, AlwaysOn
• Backup/Recovery: RMAN, Veritas NetBackup, Legato, EMC-BCV, LVM Snapshots, XtraBackup
• Configuration/Monitoring: OEM, Grid Control, Quest, Precise, Nagios/Icinga, Zabbix
• ETL: Pentaho, Talend, MS SSIS
• BI: Tableau, MS SSRS, MS BI/Power BI
• Cloud: Amazon AWS (S3, Redshift, RDS, EMR, Athena, Spectrum)
• Scripting: Perl, Shell, PowerShell, PL/SQL and SQL/T-SQL
• Programming: Java, J2EE, ANTLR, Agile/Scrum
• Proficient with ITIL Fundamentals

Projekte

07/2019 - 11/2019

5 Monate

Database migration

Rolle
Databases Expert
Kunde
Sopra Steria GmbH
Einsatzort
Berlin
Projektinhalte

Lead Databases Expert in migration project from Oracle to PostgreSQL. Architect and designed the migration process, assisted development team and final client. Maintained previous database environment Oracle RAC and JBoss Applications.

  • Architect and implement the PostgreSQL Cluster by Patroni, implemented data and structure automatic migration process.
  • Converted and tuned SQL statements and PL/SQL from Oracle to PostgreSQL.
  • Implement PostgreSQL monitoring, identified metrics and defined alters.
  • Maintained Oracle RAC environments, applied application schema changes and data copies.
  • Supported development team on best practices and guided in migration to PostgreSQL.
Kenntnisse

PostgreSQL

Oracle

JBoss Application Server

04/2017 - 07/2019

2 Jahre 4 Monate

IoT System Development

Rolle
Lead Data Warehouse Architect and Database Engineer
Kunde
Siemens
Einsatzort
Berlin
Projektinhalte

Lead Data Warehouse Architect and Database Engineer for IoT System development project. Design, develop and maintain highly scalable and high-volume Big Data Platform in Amazon Could (AWS). Develop new data lake based on S3/EMR, Redshift, Spectrum, RDS PostgreSQL, Aurora and Java/SQL API. Migrate 40TB of data from on-premise legacy data platform based on Hadoop HDFS/Hive and Teradata to AWS, include data re-modeling and conversion. Develop data pipelines / ETL processes for daily and real-time data ingestions. Design and develop scalable and high-volume Data Warehouse on Redshift Cluster for advanced analytics and customer facing business intelligence.

  • Develop data ingestion processes by Spark and Lambda to convert data files to ORC format.
  • Designed and develop SQL/Java API and implement Redshift Spectrum to read data from Data Lake.
  • Design and develop data warehouse on Redshift and Aurora Clusters, include data model (Data Vault/3NF) and logical/physical modelling for best performance, flexibility and high availability.
  • Assist developers/product owners to identify backend processes and their KPI’s/data requirements.
  • Develop ETL processes to feed facts data including filling data gaps in point of time for times series data, units of measure conversion, advanced analytical calculation, data quality/consistency check.
  • Review and approve SQL statements of developers and assist in improving the efficiency of the code and SQL Framework/ORMs for best performance, guide developers on best practices using DB.
  • Tune Redshift Cluster and Aurora/RDS PostgreSQL, configured Work Load Manager for performance improvement, implement the high availability and disaster recovery solutions.
  • Support various development teams, stockholders and product owners with data requirements.
  • Collaborated with teams in US and India, to learn business models and data requirements.
Kenntnisse

Data Warehouse

BI

Big Data Analytics

Produkte

AWS

amazon Redshift

Talend

Apache Spark

PostgreSQL

Amazon Aurora

S3

EMR

Lambda

12/2016 - 04/2017

5 Monate

Data Warehouse and BI Implementation

Rolle
Senior Data Warehouse Architect
Kunde
DaWanda GmbH
Einsatzort
Berlin
Projektinhalte

Conception and implementation Data Warehouse system on PostgreSQL including ETL processes by Talend and reports/data visualization by Tableau. Analyzing and evaluating the requirements and business processes, identifying KPI and business data measures, designing dimensional model in continues integration environment.
• Analyzed and defined the business processes (events) and their data-driven decisions.
• Designed the dimensional model according to required reports and business processes.
• Developed Talend ETL processes to load dimension data and calculate measures/facts.
• Designed the physical model by choosing appropriated hardware, servers and tools.
• Implement tabular and visual reports, defined workflow and deployment process to Tableau Server.

09/2015 - 12/2016

1 Jahr 4 Monate

Data Warehouse and BI Platform

Rolle
DBA Team Manager, Project Manager
Kunde
Nexon Europe GmbH
Einsatzort
Berlin
Projektinhalte

Managed DBA Team and related project, lead the successful delivery of complex IT infrastructure and business solution project from planning, design to implementation. Defined work processes, technologies, policies and standards to provide efficient support and projects delivery.
Major projects:
• Implementation of Data Warehouse and BI environment, defined reports and data monitoring requirements, performed logical/physical design and data modeling, defined and developed ETL processes with data normalization and cleanup, developed dashboards, data visualization and tabular reports. Used technologies: SQL Server 2016, SSIS, SSAS, and Tableau
• Develop and implement new databases backups to Cloud Storage (Amazon S3/Glacier), defined backup strategy to provide high availability and disaster recovery, developed backup procedures to backup databases and upload to cloud storage with history retention and validation.
• IT infrastructure consolidation: Merge DB servers and instances, clean database sand improve data flow processes (ETL, SSIS), capacity planning in order to minimize infrastructure resources usage (Storage, Network Traffic, Servers and Licenses).
• Implement monitoring system by Zabbix to monitor infrastructure, availability and business data metrics.
• Data migration projects: supported data migration projects to partners Data Center, with data conversion, defined and developed procedures for business data migration and security.

10/2013 - 09/2015

2 Jahre

Data Warehouse and Infrastructure Support

Rolle
Lead DBA, Senior System Engineer
Kunde
Aeria Games GmbH (Berlin, Germany)
Projektinhalte

Manage more than 100 high transactional mission-critical production database environments
(Oracle, SQL Server, MySQL), DWH/ETL processes and DB environments, BI/reporting tools/scripts:
• Implemented backups for high transactional MSSQL 2008R2 Servers with storage in Amazon S3, developed automatic procedures for transaction log maintenance.
• Implemented new ETL and BI procedures by Pentaho and automatic ETL processes in Perl
• Developed BI environment based on Amazon Redshift with PostgreSQL/NoSQL and Tableau, implemented automatic data uploads to AWS by using S3 API in Perl.
• Tuned MSSQL servers for performance improvement and efficiency, optimized databases to meet high availability requirements
• Participated as a lead DBA for MSSQL servers virtualization and databases merge, provided capacity planning, database scalability for performance impact of data volume growth.
• Implemented Oracle backups by RMAN, and replication to standby environment by Data Guard
• Managed Amazon AWS environments, S3 storage, RDS instances, EC2 Servers and Redshift
• Administrated Hadoop Cluster, designed data models and Map Reduce data aggregations, data loads
• Managed MySQL master to master cluster with MySQL MMM Control and Load Balancer
• Managed problems, incidents and change tickets, and implemented/monitored database changes.

04/2012 - 10/2013

1 Jahr 7 Monate

OLAP/DWH/ETL Expert

Rolle
Senior DBA, Application Engineer
Kunde
William Hill Plc.
Einsatzort
Tel Aviv
Projektinhalte

Managed large-scale mission-critical OLTP/OLAP database environments and business applications, provided daily operations for front/backend application and overall infrastructure environment:
• Managed Oracle RAC 10.2 with Oracle ASM on Solaris 10 and EMC storage
• Administrated MS SQL Server 2000 with merge replication on Windows Server 2003
• Lead MS SQL Server migration to version 2008, include DTS rewriting and SSIS development
• Provided incidents, defects and change requests management, development and implementation
• Performed database clones by RMAN images, developed automatic data sync by Data Pump
• Administrated Oracle ASM storage disks, provided capacity planning, managed large database partitions, administrated regular data cleanup.
• Maintained mission-critical ETL processes, tuned for performance improvement, efficiency enhancements and high availability.
• Managed large data conversions and migrations, developed automatic data feed extracts and loads.
• Provided performance monitoring and tuning for applications processes, complex queries and reports
• Managed front/backend applications and automatic reports, developed complex SQL queries
• Administrated Glassfish application server; provided troubleshooting and debugging by SOAP.
• Assisted and maintained implementation and migration process for a new BI and backend system.
• Provided system exercises for a new project, assisted management on infrastructure and application issues, provided architecture design and data modeling.
• Assisted R&D team on best technical practices, supported developers and QA teams.

03/2011 - 04/2012

1 Jahr 2 Monate

SaaS Software Development

Rolle
Technical Project Lead, Senior Database Expert
Kunde
Zimory GmbH
Einsatzort
Berlin
Projektinhalte

Technical Lead and Senior Database Expert in R&D project of IaaS Cloud Management Software:
• Managed projects implementations and development activities, prepared and implemented a planned set of activities to achieve the projects scope to timescale and quality specification.
• Assisted sales team with the project’s technical concept and provided the products demonstrations.
• Designed and facilitated the expansion and improvement of the applications architecture and its components, build and maintain methodologies and technical procedures.
• Provided expertise to identify and translate system requirements into software design and functionality, modeling the transactional workloads and consistency architecture.
• Developed and implemented advanced database replications (mostly Oracle to non-Oracle) based on Log Miner, Oracle Streams/XStreams and Redo reading/parsing.
• Designed and developed the Oracle SQL statements parsing by ANTLR/Java, include data conversions.

04/2006 - 03/2011

5 Jahre

Amdocs Billing Implementation and Support

Rolle
Lead Oracle DBA, IT Infrastructure Expert
Kunde
Vodafone / Hewlett-Packard
Einsatzort
Budapest
Projektinhalte

Lead Oracle DBA/Infrastructure Expert in On-Going Support Team for Telecom Billing and CRM Systems. Responsible for delivery of consulting/technical services throughout all phases of the project life-cycle from conception, planning, implementation, post-implementation and through to production:
• Monitored and administrated Oracle VLDB in 24/7 complex mission-critical environments
• Administrated Oracle RAC with ASM on EMC storage and databases on VERITAS cluster
• Maintained Data Guard environment, re-configured replications for efficiency enhancements
• Managed DWH database, tuned ETL processes for data availability and performance improvement
• Administrated production DB weekly clones by EMC-BCV, implemented cloned data encryption
• Performed backups and recovery by RMAN and VERITAS, adjusted backup plans for high availability
• Provided database optimizations/adjustments according to business and apps requirements
• Reorganized database storage's and resources, provided regular capacity planning and clean
• Responsible for revision and deploying database changes, SW patches and releases
• Provided database logical/physical structure troubleshooting, supervised on structure/data changes
• Developed and maintained automatic data conversion from MSSQL to Oracle
• Implemented various infrastructure tools for automate database processing and better utilization
• Assisted with application design and data modeling, provided technical consulting expertise.
• Performed tuning and revision to developers on their SQL and PL/SQL codes
• Analyzed complex issues, improved and adapted new methods and techniques
• Administrated application versions releases, deliveries and production deployment
• Provided incidents, change requests and problems management for internals and clients platforms
• Performed performance analyzing and tuning for OLTP apps and batch processes
• Supervised on naming conventions and documentations of all the topics related to overall team activities

05/2003 - 04/2006

3 Jahre

Amdocs Billing Production Support

Rolle
Senior Oracle DBA, Senior Subject Matter Expert
Kunde
Amdocs Inc.
Einsatzort
Tel Aviv
Projektinhalte

Application and Infrastructure technical support for various Telecom Billing customer delivery projects:
• Provided full application life-cycle support in production and R&D projects for various European and Asian Large Telecom customers
• Ensured successful delivery of solutions to technical expectations, including high availability, efficient code usage, application releases
• Prepared logical/physical models for new projects include capacity calculations and growth planning.
• Tuned OLTP/Batch applications processes/databases for performance and efficiency enhancements
• Prepared and deployed database backups/recovery and fail-over strategies.
• Managed application versions, performed revision and deployment of data and structure changes
• Developed scripts for production upgrade and patching, managed data conversions by Data Stage.
• Installed new Oracle software on various platforms; Build and configure databases and network.
• Configured databases and UNIX servers according application requirements
• Managed database clones for PET systems by EMC-BCV.
• Managed internal and external data feeds, responsible for Data Integrity and Quality.
• Developed, maintained and tuned infrastructure tools for QA and R&D teams.
• Mentored and provided oversight and backup for the production environments.
• Produced and maintained documented operational procedures and diagrams (ERD).
• Assisted with the design, development and maintenance of the application support tools.

06/2000 - 05/2003

3 Jahre

DBA Expert

Rolle
Oracle DBA
Kunde
ACS Ltd
Einsatzort
Tel Aviv
Projektinhalte

Served as Oracle specialist for various IT Infrastructure projects:
• Provided architecture, consulting, and implementation for database availability and tuning projects.
• Designed and implemented database backup and recovery by RMAN and Off/Online methods.
• Maintained RMAN repository and implemented high availability architecture.
• Participated as a lead DBA in Oracle migration projects
• Evaluated applications for a new Oracle version, analyzed risks and impacts
• Tuned databases and application processes for performance improvement as post migration phase
• Reorganize database storage’s, maintained table spaces and database resources.
• Designed and setting up standby databases for high availability improvement.
• Administrated Oracle products, installations, patches and upgrades
• Managed UNIX Solaris OS, partitioned and mounted disks, configured network and SAMBA
• Developed scripts for automated data processing and control in Perl and UNIX Shell scripts

Projekthistorie

Focusing on Data and Database Engineering, Data Warehouse and Business Intelligence projects.

Over 18 years of extensive experience in database administration, performance tuning and development. Strong proficiency and experience with data warehouse, database architecture/design and data modeling (3NF, Star, Data Vault). Significant knowledge and experience with Business Intelligence solutions and data visualizations. Experienced with ETL/ELT data processing, data pipelines and streams. Manage very large OLTP/OLAP databases in 24x7 production, QA and development mission-critical environments. Efficient in performance monitoring and diagnostic, tuning OLTP and batch application processes, complex SQL queries, PL/SQL code, and database optimizations. Experienced with backup and recovery, fail-over and disaster recovery, advanced replications and clones. Efficient in high availability, scalability and load balancing solutions. Advanced scripting in Perl, Unix shell and power shell, high skills writing complex SQL queries and PL/SQL. Experienced with IT infrastructure, cloud-based platforms and systems engineering.

Specialties:
• Oracle, MSSQL, MySQL/MariaDB, PostgreSQL, AWS Redshift Cluster
• Unix (HP, Solaris, AIX), Linux (RHEL, Debian, Ubuntu), Win Server
• Replication/Disaster Recovery: Log Miner, Oracle Streams, Data Guard
• High Availability/Scalability: Oracle RAC, ASM, Clustering, Hyper-V, VMware, AlwaysOn
• Backup/Recovery: RMAN, Veritas NetBackup, Legato, EMC-BCV, LVM Snapshots, XtraBackup
• Configuration/Monitoring: OEM, Grid Control, Quest, Precise, Nagios/Icinga, Zabbix
• ETL: Pentaho, Talend, MS SSIS
• BI: Tableau, MS SSRS, MS BI/Power BI
• Cloud: Amazon AWS (S3, Redshift, RDS, EMR, Athena, Spectrum)
• Scripting: Perl, Shell, PowerShell, PL/SQL and SQL/T-SQL
• Programming: Java, J2EE, ANTLR, Agile/Scrum
• Proficient with ITIL Fundamentals

Branchen

Software development company
IT Services
Telecommunications
Financial industry

Kompetenzen

Sprachkenntnisse
Deutsch
B1/B2
Englisch
fließend

Datenbanken
Amazon Aurora
amazon Redshift
Athena
Data Warehouse
MariaDB
MS SQL Server
MySQL
MySQLCluster
Oracle
PostgreSQL
Redshift

Betriebssysteme
EMR
Lambda
Linux
RHEL, Debian
S3
Unix
HP, Solaris, AIX
Windows Server

Programmiersprachen
Bash Shell
C Shell
Java
Perl
PowerShell
Python

Berechnung / Simulation / Versuch / Validierung
IT Architecture
ITIL Fundamentals

Produkte / Standards / Erfahrungen
Amazon AWS
Apache Spark
AWS
BI
Big Data Analytics
JBoss Application Server
Pentaho
Tableau
Talend

Bemerkungen

Specialties:
• Oracle, MSSQL, MySQL/MariaDB, PostgreSQL, AWS Redshift Cluster
• Unix (HP, Solaris, AIX), Linux (RHEL, Debian, Ubuntu), Win Server
• Replication/Disaster Recovery: Log Miner, Oracle Streams, Data Guard
• High Availability/Scalability: Oracle RAC, ASM, Clustering, Hyper-V, VMware, AlwaysOn
• Backup/Recovery: RMAN, Veritas NetBackup, Legato, EMC-BCV, LVM Snapshots, XtraBackup
• Configuration/Monitoring: OEM, Grid Control, Quest, Precise, Nagios/Icinga, Zabbix
• ETL: Pentaho, Talend, MS SSIS
• BI: Tableau, MS SSRS, MS BI/Power BI
• Cloud: Amazon AWS (S3, Redshift, RDS, EMR, Athena, Spectrum)
• Scripting: Perl, Shell, PowerShell, PL/SQL and SQL/T-SQL
• Programming: Java, J2EE, ANTLR, Agile/Scrum
• Proficient with ITIL Fundamentals


Aus- und Weiterbildung

09/2006 - 09/2010

4 Jahre 1 Monat

Bachelor of Science

Abschluss
Bachelor of Science in Computer Science
Institution, Ort
University of Hertfordshire

09/1997 - 09/2000

3 Jahre 1 Monat

College Diploma

Abschluss
Software Engineering
Institution, Ort
Technological College of Beer-Sheva
×
×