Architect and implement new data warehouse platform and real-time data streaming in AWS Cloud using Redshift for DWH, S3/EMR/Spectrum for Data Lake, DMS/Kinesis/Kafka and Lambda for real-time data streaming, AWS Glue/Spark/Python for ETL, Tableau and Redash for data visualization and reporting. Implement data quality and security (GDPR) processes, data dictionary and glossary.
Assit technical team with the migration of data warehouse from Oracle to PostgreSQL in AWS Cloud. Trained team with best practice working with PostgreSQL. PoC for PostgreSQL in AWS. Developed ETL process for data migration. Developed optimal logical data model in PostgreSQL. Designed and implemented the high availability architecture for PostgreSQL.
Architect and development of data warehouse in AWS Redshift. Assist technical teams with the best practice, migration process and performance improvement. Developed logical data model for data warehouse and developed ETL processes for data migration and ingestions.
Supporting client’s database environments:
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.
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.
Conception and implementation of Data Warehouse system based on PostgreSQL including ETL processes by Talend and reports/data visualization by Tableau. Analysing and evaluating the requirements and business processes, identifying KPI and business data measures, designing dimensional model in continues integration environment (Scrum).
Manage Database Team and related projects, lead the successful delivery of complex IT Infrastructure and business solution projects from planning, design to implementation. Defined the work processes, technologies, policies and standards to provide efficient support and projects delivery.
Managed more than 100 high transactional mission-critical production database environments
(Oracle, SQL Server, MySQL) and DWH/ETL processes.
Managed large-scale mission critical OLAP/DWH/ETL Databases Environments and Business Applications, provided daily operations for Front/Backend Office and overall infrastructure environment
Technical Lead and Senior Database Expert in R&D project of IaaS Cloud Management Software.
Lead Oracle DBA and Infrastructure Expert in On-Going Support Team for Telecom Billing, Customer Management and CRM Systems. Responsible for delivery of consulting/technical services throughout all phases of the project lifecycle from conception, planning, implementation, post-implementation and through to production.
Application and Infrastructure technical support for various Telecom Billing customer delivery projects.
Served as Oracle Professional for varicose IT Infrastructure projects.
Certification
06/2000
Oracle Certified Professional
Database Administration, Backups/Recovery, Performance Tuning and Development
12/2013
Microsoft SQL Server 2012 Administrator
Administrating Microsoft SQL Server 2012 (MOC 10775)
Data Solutions and Engineering Expert
Over 20 years of extensive experience with cutting-edge data solutions, analytics, data warehousing, data engineering and database development. Strong proficiency and experience with data warehouse architecture and design, massively parallel processing (MPP) architecture, physical and logical data modeling (3NF, Star, Data Vault), data lake and data platform implementation in Cloud and On-Premises. Significant knowledge and experience with IoT systems, microservices, business intelligence, machine learning and data visualizations solutions. Experienced with data governance, security, quality and master data management. Efficient with ETL/ELT data processing, data pipelines and streams. Manage very large OLTP/OLAP databases in 24x7 production mission-critical environments. Experienced with performance tuning and optimization. Efficient in high-availability, scalability, disaster recovery and load balancing solutions. Experienced in writing, troubleshooting and debugging complex SQL queries and procedures.
Significant Technical Skills
Data Solutions and Engineering Expert
Over 20 years of extensive experience with cutting-edge data solutions, analytics, data warehousing, data engineering and database development. Strong proficiency and experience with data warehouse architecture and design, massively parallel processing (MPP) architecture, physical and logical data modeling (3NF, Star, Data Vault), data lake and data platform implementation in Cloud and On-Premises. Significant knowledge and experience with IoT systems, microservices, business intelligence, machine learning and data visualizations solutions. Experienced with data governance, security, quality and master data management. Efficient with ETL/ELT data processing, data pipelines and streams. Manage very large OLTP/OLAP databases in 24x7 production mission-critical environments. Experienced with performance tuning and optimization. Efficient in high-availability, scalability, disaster recovery and load balancing solutions. Experienced in writing, troubleshooting and debugging complex SQL queries and procedures.
Significant Technical Skills
Architect and implement new data warehouse platform and real-time data streaming in AWS Cloud using Redshift for DWH, S3/EMR/Spectrum for Data Lake, DMS/Kinesis/Kafka and Lambda for real-time data streaming, AWS Glue/Spark/Python for ETL, Tableau and Redash for data visualization and reporting. Implement data quality and security (GDPR) processes, data dictionary and glossary.
Assit technical team with the migration of data warehouse from Oracle to PostgreSQL in AWS Cloud. Trained team with best practice working with PostgreSQL. PoC for PostgreSQL in AWS. Developed ETL process for data migration. Developed optimal logical data model in PostgreSQL. Designed and implemented the high availability architecture for PostgreSQL.
Architect and development of data warehouse in AWS Redshift. Assist technical teams with the best practice, migration process and performance improvement. Developed logical data model for data warehouse and developed ETL processes for data migration and ingestions.
Supporting client’s database environments:
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.
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.
Conception and implementation of Data Warehouse system based on PostgreSQL including ETL processes by Talend and reports/data visualization by Tableau. Analysing and evaluating the requirements and business processes, identifying KPI and business data measures, designing dimensional model in continues integration environment (Scrum).
Manage Database Team and related projects, lead the successful delivery of complex IT Infrastructure and business solution projects from planning, design to implementation. Defined the work processes, technologies, policies and standards to provide efficient support and projects delivery.
Managed more than 100 high transactional mission-critical production database environments
(Oracle, SQL Server, MySQL) and DWH/ETL processes.
Managed large-scale mission critical OLAP/DWH/ETL Databases Environments and Business Applications, provided daily operations for Front/Backend Office and overall infrastructure environment
Technical Lead and Senior Database Expert in R&D project of IaaS Cloud Management Software.
Lead Oracle DBA and Infrastructure Expert in On-Going Support Team for Telecom Billing, Customer Management and CRM Systems. Responsible for delivery of consulting/technical services throughout all phases of the project lifecycle from conception, planning, implementation, post-implementation and through to production.
Application and Infrastructure technical support for various Telecom Billing customer delivery projects.
Served as Oracle Professional for varicose IT Infrastructure projects.
Certification
06/2000
Oracle Certified Professional
Database Administration, Backups/Recovery, Performance Tuning and Development
12/2013
Microsoft SQL Server 2012 Administrator
Administrating Microsoft SQL Server 2012 (MOC 10775)
Data Solutions and Engineering Expert
Over 20 years of extensive experience with cutting-edge data solutions, analytics, data warehousing, data engineering and database development. Strong proficiency and experience with data warehouse architecture and design, massively parallel processing (MPP) architecture, physical and logical data modeling (3NF, Star, Data Vault), data lake and data platform implementation in Cloud and On-Premises. Significant knowledge and experience with IoT systems, microservices, business intelligence, machine learning and data visualizations solutions. Experienced with data governance, security, quality and master data management. Efficient with ETL/ELT data processing, data pipelines and streams. Manage very large OLTP/OLAP databases in 24x7 production mission-critical environments. Experienced with performance tuning and optimization. Efficient in high-availability, scalability, disaster recovery and load balancing solutions. Experienced in writing, troubleshooting and debugging complex SQL queries and procedures.
Significant Technical Skills
Data Solutions and Engineering Expert
Over 20 years of extensive experience with cutting-edge data solutions, analytics, data warehousing, data engineering and database development. Strong proficiency and experience with data warehouse architecture and design, massively parallel processing (MPP) architecture, physical and logical data modeling (3NF, Star, Data Vault), data lake and data platform implementation in Cloud and On-Premises. Significant knowledge and experience with IoT systems, microservices, business intelligence, machine learning and data visualizations solutions. Experienced with data governance, security, quality and master data management. Efficient with ETL/ELT data processing, data pipelines and streams. Manage very large OLTP/OLAP databases in 24x7 production mission-critical environments. Experienced with performance tuning and optimization. Efficient in high-availability, scalability, disaster recovery and load balancing solutions. Experienced in writing, troubleshooting and debugging complex SQL queries and procedures.
Significant Technical Skills
Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.