Data Solutions and Analytics Expert
- Verfügbarkeit einsehen
- 0 Referenzen
- 80€/Stunde
- 14169 Steglitz-Zehlendorf
- auf Anfrage
- he | de | en
- 29.01.2025
Kurzvorstellung
Qualifikationen
Projekt‐ & Berufserfahrung
9/2022 – 1/2025
Tätigkeitsbeschreibung
Worked closely with customers and prospects to deliver customized and strategic data solutions using a comprehensive architectural and strategic framework. Designed data solutions in accordance with customers technology and business requirements to optimize data storage, processing, analytics, and machine learning.
Significant Tasks:
• Designed and implemented a private cloud data platform customized to meet the customer's specific needs in technology, data analytics and AI/ML, leveraging Greenplum MPP Data Warehouse for data storage, processing, and analytics; Kafka for data streaming; Kubernetes for data workloads, and Apache Solr for text processing.
• Migrated the Oracle Exadata Data Warehouse to a new data platform running on Greenplum Cluster. This included completely data re-architecture, data transformation and conversion. Implementation of RabbitMQ and Debezium for change data capture (CDC) and streaming, VectorDB for utilization of Generative AI and Large Language Models (LLM).
• Lead the Data Cloud Migration PoC, identified the customer’s data use cases, developed the migration strategy, evaluated various cloud providers and technologies, established KPIs to measure the success of the PoC, including data transfer speeds and latency.
• Provided guidance to customers on data platform modernization and cloud adoption. Evaluated and recommended new technologies and tools to enhance data architecture.
• Collaborated with the customer's technical teams to ensure continuous improvement of the data architecture and systems, provided technical trainings and knowledge sharing.
• Conduct presentations to customers in both technical and executive workshops and presentations.
Amazon Web Services (AWS), BI-Spezialist Data Warehouse, Big Data, Data Engineer, Data Warehousing, Database Manager, Greenplum, Kubernetes, Kundenberater, Oracle Database, Postgresql
1/2021 – 9/2022
Tätigkeitsbeschreibung
Worked with multiple customers to provide in-depth technical support through solution design and customer engagements such as Proof of Concepts and Architectural Design. Designed and architected new solutions and worked with implementation teams from concept to operations, providing deep technical subject matter expertise for successfully deploying large scale data solutions, using modern data and analytics technologies on-premises and cloud. Lead detailed technical assessments of current state and architect a path to transformation into a modern data powered enterprise.
Significant Tasks:
• Migrated Oracle DWH to AWS data platform, using Redshift and Informatica Cloud DI. Designed new data model and DWH architecture, implemented data sharing across regions and clusters, data lake using object-storage S3 and Lambda for automatic data processing.
• Architected and implemented business intelligence platform in Azure Cloud, using Databricks for data processing, Data Lake and Synapse for data store and analytics, PowerBI for data reporting.
• Enhanced Data Vault model to optimize data loads and processing, meeting business requirements and improving data use cases.
• Migrated Master Data Management (MDM) to Informatica IDMC including data mapping, data transformation and conversion, data quality validation and performance improvement.
Amazon Web Services (AWS), BI-Spezialist Data Warehouse, Big Data, Data Analyst, Data Engineer, Data Vault, Data Warehousing, Microsoft Azure, Snowflake
8/2020 – 1/2021
Tätigkeitsbeschreibung
Architect and develop the cloud-based (AWS) data warehouse platform and real-time data streaming. Design and implement data streaming using DMS, Kinesis/Kafka, Lambda and Aurora PostgreSQL. Architect and develop data warehouse and data lake using Redshift Cluster, Spectrum and S3 storage. Develop ETL processes using AWS Glue, Spark, and Python/PySpark. Architect master data and develop dimensional data warehouse model as per business requirements for data analytics. Implement data dictionary and glossary repository, data visualization and reporting using Tableau and Redash.
Architect and develop the cloud-based (AWS) data warehouse platform and real-time data streaming. Design and implement data streaming using DMS, Kinesis/Kafka, Lambda and Aurora PostgreSQL. Architect and develop data warehouse and data lake using Redshift Cluster, Spectrum and S3 storage. Develop ETL processes using AWS Glue, Spark, and Python/PySpark. Architect master data and develop dimensional data warehouse model as per business requirements for data analytics. Implement data dictionary and glossary repository, data visualization and reporting using Tableau and Redash.
Skills: Data Warehousing · Amazon Aurora · Amazon Web Services (AWS) · Data Modeling · Apache Kafka · Business Intelligence (BI) · Data Analytics · Data Architecture · Data Migration · Data Visualization · AWS Glue · Data Streaming · Amazon Redshift · Apache Spark · Data Infrastructure
Database Developer, Database Manager, Data Engineer, Amazon Web Services (AWS), Apache Spark, Big Data, Data Warehousing, ETL, Tableau
7/2019 – 8/2020
Tätigkeitsbeschreibung
As a Data Solutions Architect, work with clients to identify and translate their business needs into solutions and services that combine hands-on expertise with the latest data solutions and analytics technologies. Develop the optimal architecture and delivery approach, including development and implementation plan, technology and tool selection. Lead the implementation of the solutions from defining the project requirements and objectives through to go-live. Solutions include data variety and advanced analytics, such as (big) data engineering, data architecture and modeling, machine learning, data interaction and visualization.
Main projects:
- External data monetization for telecommunications.
- Centralized enterprise data warehouse and data consolidation.
- IoT architecture and predictive maintenance analytics.
- Enterprise Data Transformation / Digitization.
- Data anonymization and data segmentation for business process benchmarking.
Significant task:
- Develop frameworks for data governance, data security, data strategy and cloud data migration.
- Architect, design and build integrated data platforms from multiple sources, including data flow design, data ingestion, data lake, building high-volume ETL pipelines for data warehouse.
- Model complex distributed data sets to build data warehouses and data lakes using cloud and on-premises technologies.
- Provide key management and thought leadership in advanced data techniques, including data modeling, data access, data integration, data visualization, text mining, data discovery, database design and implementation.
As a Data Solutions Architect, work with clients to identify and translate their business needs into solutions and services that combine hands-on expertise with the latest data solutions and analytics technologies. Develop the optimal architecture and delivery approach, including development and implementation plan, technology and tool selection. Lead the implementation of the solutions from defining the project requirements and objectives through to go-live. Solutions include data variety and advanced analytics, such as (big) data engineering, data architecture and modeling, machine learning, data interaction and visualization. Main projects: - External data monetization for telecommunications. - Centralized enterprise data warehouse and data consolidation. - IoT architecture and predictive maintenance analytics. - Enterprise Data Transformation / Digitization. - Data anonymization and data segmentation for business process benchmarking. Significant task: - Develop frameworks for data governance, data security, data strategy and cloud data migration. - Architect, design and build integrated data platforms from multiple sources, including data flow design, data ingestion, data lake, building high-volume ETL pipelines for data warehouse. - Model complex distributed data sets to build data warehouses and data lakes using cloud and on-premises technologies. - Provide key management and thought leadership in advanced data techniques, including data modeling, data access, data integration, data visualization, text mining, data discovery, database design and implementation.
Skills: Data Warehousing · Amazon Web Services (AWS) · Data Modeling · Google Cloud Platform (GCP) · Sales Presentations · Data Governance · Data Analytics · Microsoft Azure · Pre-Sales Technical Consulting · Data Visualization · Data Strategies · Data Solution Architecture · Pre-Sales Support · Data Security · Data Infrastructure · Post-Sales Support · Data Quality · Presales Technical Support
Amazon Web Services (AWS), Apache Hadoop, Big Data, Data Mining, Data Warehousing, ETL, Microsoft SQL-Server (MS SQL), Oracle Rac, Postgresql
4/2017 – 7/2019
Tätigkeitsbeschreibung
Lead Data Architect and Data Engineer for IoT system implementation 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.
Significant Tasks:
• 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.
• 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 product owners to identify backend processes and their 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, statistical calculations, data quality and consistency check.
• Review SQL queries of developers and assist in improving the efficiency of the code and SQL Framework/ORMs for best performance, guide developers on best practices.
• 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, stakeholders and product owners with data requirements.
• Collaborated with teams in US and India, to learn business models and data requirements.
Lead Data Architect and Data Engineer for IoT system implementation 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. Significant Tasks: • 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. • 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 product owners to identify backend processes and their 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, statistical calculations, data quality and consistency check. • Review SQL queries of developers and assist in improving the efficiency of the code and SQL Framework/ORMs for best performance, guide developers on best practices. • 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, stakeholders and product owners with data requirements. • Collaborated with teams in US and India, to learn business models and data requirements.
Skills: Data Warehousing · Amazon Aurora · Amazon Web Services (AWS) · Data Modeling · Apache Kafka · Data Governance · Snowflake · Linux · Data Analytics · Data Architecture · Data Migration · Data Visualization · Data Strategies · Machine Learning · AWS Glue · Amazon Redshift · Apache Spark · Data Infrastructure · Data Quality
Amazon Web Services (AWS), Business Intelligence and Reporting Tools (BIRT), Data Warehousing, ETL, Postgresql
12/2016 – 4/2017
Tätigkeitsbeschreibung
Conception and implementation Data Warehouse platform 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.
Significant Tasks:
• 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.
Conception and implementation Data Warehouse platform 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. Significant Tasks: • 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.
Skills: Data Warehousing · Windows Server · Data Modeling · Snowflake · Linux · Business Intelligence (BI) · Data Analytics · Data Architecture · Data Warehouse Architecture · Data Migration · Data Visualization · Amazon Redshift · Data Infrastructure · PostgreSQL
Snowflake, Amazon Web Services (AWS), Business Intelligence (BI), Data Warehousing, ETL, Postgresql, Tableau
9/2015 – 12/2016
Tätigkeitsbeschreibung
Managed Data Engineering Team and related projects, 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.
Significant Tasks:
• 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 and improved 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.
Managed Data Engineering Team and related projects, 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. Significant Tasks: • 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 and improved 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.
Skills: Data Warehousing · Amazon Web Services (AWS) · Windows Server · Data Modeling · SQL Server Analysis Services (SSAS) · MySQL · Linux · Data Analytics · SQL Server Integration Services (SSIS) · Oracle RAC · SQL Server Reporting Services (SSRS) · Microsoft SQL Server · Unix · Tableau · PL/SQL · Data Infrastructure · PostgreSQL · Oracle
Data Mining, Data Warehousing, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), Mysql, Online Analytical Processing, Online Transaction Processing, Tableau
10/2013 – 9/2015
Tätigkeitsbeschreibung
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.
Significant Tasks:
• 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.
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. Significant Tasks: • 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.
Skills: ETL · Data Warehousing · Amazon Web Services (AWS) · Windows Server · Data Modeling · MySQL · RabbitMQ · Linux · SQL Server Integration Services (SSIS) · Microsoft SQL Server · Unix · Tableau · PL/SQL · MySQL Adminstration · Data Infrastructure · SQL Database Administration · PostgreSQL · Oracle · Oracle Database Administration
Business Intelligence (BI), Data Warehousing, Linux Einführung, Microsoft SQL-Server (MS SQL), Mysql, Oracle Rac, Tableau, Windows Server (allg.)
4/2012 – 10/2013
Tätigkeitsbeschreibung
William Hill logo
Senior DBA and Systems Engineer
Senior DBA and Systems Engineer
William Hill · Full-timeWilliam Hill · Full-time
Apr 2012 - Oct 2013 · 1 yr 7 mosApr 2012 to Oct 2013 · 1 yr 7 mos
Tel Aviv, Israel · On-siteTel Aviv, Israel · On-site
Managed large-scale mission-critical OLTP/OLAP database environments and business applications, provided daily operations for front/backend application and overall infrastructure environment.
Significant Tasks:
• 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.
Managed large-scale mission-critical OLTP/OLAP database environments and business applications, provided daily operations for front/backend application and overall infrastructure environment. Significant Tasks: • 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.
Skills: Windows Server · Data Modeling · Linux · SQL Server Integration Services (SSIS) · Oracle RAC · Microsoft SQL Server · Unix · Data Infrastructure · SQL Database Administration · Oracle · Oracle Database Administration
Data Warehousing, Hardware-Design, IT-Support (allg.), Microsoft SQL-Server (MS SQL), Online Analytical Processing, Oracle-Anwendungen, Oracle Application Server (OC4J), Oracle Rac, Oracle RMAN (Recovery Manager), SOAP, Storage, Systemmigration, Systems Engineering, Windows Server 2003, Windows Server (allg.)
3/2011 – 4/2012
Tätigkeitsbeschreibung
Technical Lead and Senior Database Expert in R&D project of IaaS Cloud Management Software.
Significant Tasks:
• 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.
Technical Lead and Senior Database Expert in R&D project of IaaS Cloud Management Software. Significant Tasks: • 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.
Skills: Windows Server · Agile Methodologies · Linux · Java · Unix · PL/SQL · Oracle Streams · Data Infrastructure · Oracle · Oracle Database Administration
Design (allg.), Filtertechnik, Forschung & Entwicklung, Hardware-Design, Iaas, Indesign, Java (allg.), Konzeption (IT), Management (allg.), Öffentlichkeitsarbeit, Oracle-Anwendungen, Rechnergestütztes Betriebsleitsystem (RBL), Software Design, SQL, Übersetzungen
4/2006 – 3/2011
Tätigkeitsbeschreibung
Lead Oracle DBA and Systems Engineer in On-Going Support Team for Telecom Billing and CRM Systems. Responsible for delivery of consulting and technical services throughout all phases of the project life-cycle from conception, planning, implementation, post-implementation and through to production.
Significant Tasks:
• 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.
• 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
• Incidents, change requests and problems management for internals and clients platforms
• Performed performance analyze/tuning for OLTP apps and batch processes.
Lead Oracle DBA and Systems Engineer in On-Going Support Team for Telecom Billing and CRM Systems. Responsible for delivery of consulting and technical services throughout all phases of the project life-cycle from conception, planning, implementation, post-implementation and through to production. Significant Tasks: • 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. • 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 • Incidents, change requests and problems management for internals and clients platforms • Performed performance analyze/tuning for OLTP apps and batch processes.
Skills: Agile Methodologies · Linux · Oracle RAC · Unix · PL/SQL · Oracle Streams · Systems Engineering · Perl · Data Infrastructure · ITIL · Oracle · Oracle Database Administration
24/7 Leistungen, CRM Beratung (allg.), Data Warehousing, Hardware-Design, IT-Support (allg.), IT Sicherheit (allg.), Microsoft SQL-Server (MS SQL), Online Transaction Processing, Oracle-Anwendungen, Oracle Data Guard, Oracle Rac, PL/SQL, Qualitätsmanagement / QS / QA (IT), SAP Beratung (allg.), SAP IS-RE
5/2003 – 4/2006
Tätigkeitsbeschreibung
Application and Infrastructure technical support for various Telecom Billing customer delivery projects.
Significant Tasks:
• 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.
Application and Infrastructure technical support for various Telecom Billing customer delivery projects. Significant Tasks: • 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.
Skills: Agile Methodologies · Linux · Oracle RAC · Unix · PL/SQL · Oracle Streams · Perl · Data Infrastructure · ITIL · Oracle · Oracle Database Administration
Back up / Recovery, Hardware-Design, IT-Support (allg.), Online Transaction Processing, Oracle-Anwendungen, Telekommunikation / Netzwerke (allg.), UNIX
6/2000 – 5/2003
Tätigkeitsbeschreibung
Oracle professional for various IT Infrastructure projects.
Significant Tasks:
• 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
Oracle professional for various IT Infrastructure projects. Significant Tasks: • 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
Skills: ETL · Data Modeling · Agile Methodologies · Linux · Oracle RAC · Unix · PL/SQL · Oracle Streams · Perl · Data Infrastructure · ITIL · Oracle · Oracle Database Administration
Back up / Recovery, Hardware-Design, It-Beratung, Management (allg.), Oracle-Anwendungen, Oracle RMAN (Recovery Manager), Perl, Samba, SAP Beratung (allg.), Shell (CSH), Storage, Systemmigration, Telekommunikation / Netzwerke (allg.), UNIX
Zertifikate
Ausbildung
Hertfordshire
Beer-Sheva
Über mich
Weitere Kenntnisse
• Databases: Oracle, PostgreSQL, MSSQL, MySQL , AWS Redshift, AWS RDS/Aurora, Snowflake, Greenplum
• Big Data: Spark, Hadoop HDFS, Hive, AWS EMR, Kinesis, Kafka, RabbitMQ
• BI: Tableau, MS SSRS, MS BI/Power BI, Qlik
• ETL: Pentaho, Talend, MS SSIS, Matillion, AWS Glue, Spark, Python/PySpark, Azure Data Factory
• Cloud: AWS, Azure, GCP
• OS: Unix (HP, Solaris, AIX), Linux (RHEL, Debian, Ubuntu), Windows Server
• Replication/Disaster Recovery: Log Miner, Oracle Streams, Data Guard
• High Availability/Scalability: Oracle RAC, ASM, Clustering, Hyper-V, vSphere, AlwaysOn, Galera
• Backup/Recovery: RMAN, Veritas NetBackup, Legato, EMC-BCV, LVM Snapshots, XtraBackup
• Configuration/Monitoring: OEM, Grid Control, Quest, Promotheus, Grafana, Precise, Nagios/Icinga, Zabbix
• Scripting: Python, Perl, Shell, PowerShell, PL/SQL and SQL/T-SQL/pgSQL
• Programming: Java, J2EE, ANTLR, Agile/Scrum
• Proficient with ITIL Fundamentals (Incident, Problems and Change Management)
Persönliche Daten
- Hebräisch (Muttersprache)
- Deutsch (Fließend)
- Englisch (Fließend)
- Europäische Union
- Schweiz
- Vereinigte Staaten von Amerika
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden