Summary
Overview
Work History
Education
Skills
Timeline
Generic

Yossi Levi

Queens,NY

Summary

With 16+ years of experience in database administration, architecture, business intelligence, and data engineering, I possess a deep understanding of the industry. Expertise includes big data ETL using pySpark, Python and shell scripting, and working with MySQL, postgreSQL, and MS SQL. Also developed skills in cloud development, primarily focusing on AWS, and have utilized Infrastructure as Code (IaC) tools like Terraform and Git. Leveraging diverse skill set and extensive knowledge, I am well-equipped to contribute to any organization's success in the field of database management and data engineering.

Overview

17
17
years of professional experience

Work History

Staff Data Engineer

Exactera
12.2018 - 06.2024

Exactera Solutions is a FinTech company centered around international trade law and finance

Responsibilities:

  • Designed and implemented novel ETL process used to normalizing private and public financial reports using PySpark on AWS infrastructure.
  • Built agnostic transfer system between our data-warehouse to data-marts transfer system .
  • Worked with Product, management and backend developers to design our product data-mart relational databases
  • Performed multiple POC’s into new technologies and design changes.
  • Set up BI upstream process with both CDC and data at rest replication
  • Worked with Development teams to better their SQL skills including best practices, performance tuning and design.

Senior Data Engineer

Lifion
09.2016 - Current

Lifion is one of the R&D branches of ADP responsible for developing ADP's own CRM software to compete with Salesforce

Responsibilities:

  • Refactored existing RDBMS structures for better performance and scalability.
  • Narrated and maintained MySQL Docker files for "per client" deployment.
  • Running Advance POC’s checking technologies, performance and maintenance options.
  • Enhanced system performance by designing and implementing scalable data solutions for high-traffic applications..
  • Developed automated cleanup systems using Jenkins and shell to clean ten's of thousands of unused indexes, and tables.

Senior Data Engineer and Tech Lead

PLYMedia
10.2013 - 10.2016

PLYMedia created the world’s leading Performance-Based advertising ecosystem

Responsibilities:

  • Managed a team of five data engineers through day to day maintenance, development and troubleshooting complex Hive, PySpark, Pig and MySQL architecture.
  • Responsible for administration, upgrades, maintenance, DR, HA, backup and recovery for the company's operational Databases and file based datalake
  • Writing, supporting and optimizing ETL processes to copy data from operational MySQL databases to our Hadoop datalake
  • Mentored junior team members in best practices for software development, code optimization, and troubleshooting techniques with Big Data and Relational Databases
  • Designed and created a complete database and data integrity monitoring framework from scratch
  • My team and I were responsible for our BI and data analysis. With a deep understanding of the company’s business requirements my We found new ways to look at our raw and digested data to improve client’s experience
  • Deployed and migrated from on-prem to Cloud platforms (Google Cloud and AWS)

Senior DBA

myThings
01.2012 - 01.2013

MyThings is a personalized retargeting specialist providing advertisers with display ads, in real time

Responsibilities:

  • Managed data-mart that grew from 1Tb to 4Tb as infrastructure and applicative Senior DBA
  • Integrated big data systems: HDFS, Hive, Mongo, Exasol and Redshift
  • Investigated and executed performance tuning routines on hardware, database and ETL.

Senior DBA

Valinor LTD
01.2008 - 01.2012

Started as a Junior MS SQL DBA, Ended as Senior DBA on MS SQL, MySQL and PostgerSQL

Education

Bachelor of Science - biotechnology

Bar Ilan University
Ramat Gan, Israel
06.2005

Skills

  • ETL development
  • Data Warehousing
  • Data Modeling
  • Data Migration (on-prem to cloud)
  • Scripting Languages
  • PySpark
  • Performance Tuning
  • SQL Expertise (MySQL, PostgerSQL, snowflake)
  • NoSQL Databases (Google BigQuery, Athena, DynamoDB, RedShift)
  • Business Intelligence
  • IAC (Terraform, Git)

Timeline

Staff Data Engineer

Exactera
12.2018 - 06.2024

Senior Data Engineer

Lifion
09.2016 - Current

Senior Data Engineer and Tech Lead

PLYMedia
10.2013 - 10.2016

Senior DBA

myThings
01.2012 - 01.2013

Senior DBA

Valinor LTD
01.2008 - 01.2012

Bachelor of Science - biotechnology

Bar Ilan University
Yossi Levi