Data Sql Server

Address: Tel Aviv, Israel Phone: +972-**-***-**** Email: ***.*****@*****.***

CAREER SUMMARY

Professional DBA and SQL enthusiastic with over 11 years of experience in design, data flow processing, databases migration and resolving big data issues. Data–driven and highly skilled BI and Big Data specialist. Expertise in performance tuning, both for queries and complex processes. Excellent communicator of complex technological concepts to professional and non-professional audiences. Possessed outstanding leadership and communication skills.

EDUCATION BACKGROUND

The Hebrew University of Jerusalem. 2005

BA in Economics and Management

IDF Elite Computer Unit, MAMRAM 1997

Center of Computing and Information Systems

CORE SKILLS AND COMPETENCES

Databases: SQL Server, MySQL, Redshift

NoSQL: Hive, Impala, MapReduce

OS: Linux, Windows

Programming Languages: C, VB, C#, PHP

ETL tools: SSIS, Pentaho

Database Security

Data formats: XML, JSON

Scripting: Python, Bash

Reporting tools: Tableau, BO

Database management and administration

Big data & MPP concepts

Tuning and optimization

Effective and productive in data analysis.

Highly creative & analytical

Scrum and agile methodology

PROFESSIONAL EXPERIENCE

Perion LTD, Israel (former Conduit) Jan 2014 – Present

Big Data DBA

Perion is a global performance-based media and internet company, providing online publishers and app developers advanced technology and a variety of intelligent, data-driven solutions.

Designed, built and maintain several Redshift DWHs from scratch for different teams, supporting over 200M rows per day traffic.

Designed and implemented all infrastructure data flow solution.

Actively led the BI team.

Processes and queries performance tuning and optimization.

Effectively monitored and resolved data flow and database related issues.

Defined data requirements for database design.

Implemented cloud based solutions.

Conduit Limited, Israel May 2011 – Dec 2013

Senior DBA

Online platform that allows web publishers to create custom toolbars

Responsible for 8T compressed SQL Server database

Designed and implemented ETL processes and Data Model. Focus on the infrastructure processes.

Improve ETL running time from hours to minutes.

Effectively worked with Developers from design phase to production.

DR, HA design and databases upgrades.

Query optimization (SQL Server, Hive and Impala).

Different databases and ETL tools POC.

Hadoop file formats POC.

Metacafe, Israel May 2006 – Apr 2010

Database developer

One of the world's largest video sites.

Optimized OLTP databases processes and queries.

Built DWH from scratch.

Applicative responsible for all database aspects.

Composed PHP code to develop and maintain data access layer.

Performed Database Installations, Upgrades and Configurations.

Participated in all aspects of Application Software Development Life Cycle.

Supported development teams, review its queries and database related processes.

Celebros LTD, Israel July 2004 – Apr 2006

Database developer in analytic team

Global leader in semantic site-search, merchandizing and navigation conversion technologies

Prepared complex code in database level – both function and procedures.

Composed C# code to develop and maintain data access layer.

Designed database analytic layer and table’s structure to enable fast data retrieval.

IDF elite computer unit, MAMRAM Dec 1996 – Mar 2002

REFERENCE: Available on request

Contact this candidate