Yaron is available for hire
Hire YaronYaron Ben Oved
Verified Expert in Engineering
Data Architecture Developer
Cape Town, Western Cape, South Africa
Toptal member since April 1, 2021
Bio
Yaron is a developer and DBA with a passion for all things data and over 20 years of experience building and maintaining data-centric applications. He is passionate about providing tangible business value through data. In the last 14 years, Yaron has led and mentored young development teams and continued to build and maintain warehousing and BI projects.
Portfolio
CT International
SQL Server 2016, Azure, Microsoft Power BI, Data Modeling...
Rhithm, Inc.
SQL, Database Design, Microsoft SQL Server, Database Performance, Data Marts...
Codeworkshop.io
Amazon S3 (AWS S3), Amazon Aurora, Agile Delivery, Data Modeling, SQL...
Experience
- Microsoft SQL Server - 20 years
- Databases - 20 years
- SQL - 20 years
- Data Architecture - 20 years
- Data Modeling - 20 years
- T-SQL (Transact-SQL) - 20 years
- SQL Server DBA - 17 years
- Microsoft Power BI - 3 years
Availability
Part-time
Preferred Environment
SQL Server 2016, Microsoft Power BI, T-SQL (Transact-SQL), SQL Server DBA, Databases, Microsoft SQL Server, Amazon Aurora, SQL Server 2019, PostgreSQL, MySQL
The most amazing...
...project I've helped is an edtech startup that scaled their operation almost 10x. I then ported their MS SQL to AWS Aurora and achieved 60% savings in billing.
Work Experience
SQL Developer, Data Analyst
2020 - PRESENT
CT International
- Provided guidance and leadership to the processes associated with data management and integrated solutions.
- Designed and built their data warehouse using Kimball methodology. Built ETL from various operations systems.
- Performed DBA function to optimize existing operational databases, build maintenance plans, and rebuild indexes.
- Developed and rolled out several reports and dashboards for senior management and operations team.
- Reduced monthly operation costs on Azure by 20% through a better structure.
- Developed stored procedures and complex UDFs to assist with new application development.
Technologies: SQL Server 2016, Azure, Microsoft Power BI, Data Modeling, SQL Server Management Studio (SSMS), Data Architecture, Data Migration, SQL, Business Intelligence (BI), T-SQL (Transact-SQL), Solution Design, SQL Server DBA, Solution Architecture, Database Architecture, Databases, Microsoft SQL Server, Data Analysis
SQL Expert
2021 - 2023
Rhithm, Inc.
- Stabilized and improved database performance utilizing various techniques. Worked on index management procedures, rewrites, and back-end changes where needed.
- Used Jira for issue tracking epic management and Confluence for documentation.
- Designed and implemented a new data warehouse, ETL, designed and implemented multiple application modules.
- Managed the migration from on-premise to AWS RDS and managed various aspects throughout the process.
- Provided mentorship and training to back-end developers and performed code reviews. Managed solution design oversight for various application modules.
- Migrated databases from SQL Server to AWS Aurora MySQL and PostgreSQL, achieving drastic savings in monthly costs.
Technologies: SQL, Database Design, Microsoft SQL Server, Database Performance, Data Marts, Amazon Aurora, AWS Database Migration Service (DMS), Agile Delivery, Amazon S3 (AWS S3), Amazon RDS, Azure SQL, Business Intelligence (BI)
Co-founder, Developer, Operations
2018 - 2020
Codeworkshop.io
- Developed the database for a loyalty program (mobile app).
- Designed and managed the requirements for custom CRM; implemented on AWS.
- Did full migration from MS SQL on-premise (SQL 2012) to AWS AURORA (MySQL compatibility).
- Performed various business analysis, data modeling, and solution architecture engagements for various projects.
Technologies: Amazon S3 (AWS S3), Amazon Aurora, Agile Delivery, Data Modeling, SQL, Azure Data Studio, MySQL, SQL Server Management Studio (SSMS), App Support, Data Architecture, Data Migration, T-SQL (Transact-SQL), Solution Design, SQL Server DBA, Solution Architecture, Database Architecture, Databases, Microsoft SQL Server, Data Analysis
IS Manager
2013 - 2018
Mango5
- Managed and mentored .NET and SQL developers.
- Implemented Agile methodologies to project delivery.
- Managed the implementation and rollout of Microsoft Power BI.
- Liaised with various internal and external stakeholders to design, develop, and rollout a collab project with Cohort Australia.
- Managed large-scale SQL databases and implemented Kimball-methodology warehouse.
- Developed and managed various data extractions and transformations for various B2B endeavors.
- Built and rolled out Interactive intelligence integration.
- Managed and secured large volumes of voice recordings.
Technologies: SQL Server 2012, Data Marts, Microsoft Power BI, Agile Product Delivery, Business to Business (B2B), Mentorship & Coaching, App Support, Data Modeling, SQL, VB.NET WinForms, VB.NET, SQL Server Management Studio (SSMS), Data Architecture, Data Migration, SQL Server 2008 R2, Business Intelligence (BI), T-SQL (Transact-SQL), Solution Design, .NET, SQL Server DBA, Solution Architecture, Database Architecture, Databases, Microsoft SQL Server, Data Analysis
Developer, DBA
2005 - 2013
Freelance Developer
- Designed and built a complete call center CRM for BPO operations.
- Designed, built, and maintained various data marts using SQL Server.
- Managed migrations and installations of SQL server through its various versions (2000, 2005, 2008 r2, and 2012).
- Built various integrations between large insurers and outsourced telesales companies.
- Built an end-to-end solution integrating telco consumer applications, distributed sales team, and outsourced fulfillment agencies (stock management and distribution of cellular devices) SA Telkom Mobile.
- Built a mass billing system for short-term insurers.
Technologies: SQL Server 2005, Data Modeling, VB.NET WinForms, VB.NET, SQL Server Management Studio (SSMS), App Support, Data Architecture, Data Migration, SQL, SQL Server 2008 R2, Business Intelligence (BI), T-SQL (Transact-SQL), Solution Design, .NET, SQL Server DBA, Solution Architecture, Database Architecture, Databases, Microsoft SQL Server, Data Analysis
Developed and Managed Various Systems
2001 - 2005
CDN
- Designed and built a system to manage the sales, quotes, and integration with the accounting system for Panasonic business systems.
- Managed customer requirements, specifications, and maintenance.
- Managed the rollout and further enhancements, upgraded to the solution using .NET 1.1.
- Performed DBA functions and built a custom replication utility over 54kb connection (extremely low bandwidth).
- Rolled out and managed additional branch office installations and support.
Technologies: Microsoft Access, Visual Basic for Applications (VBA), MySQL, SQL Server 2000, .NET, Data Modeling, SQL Server Management Studio (SSMS), Data Architecture, T-SQL (Transact-SQL), Solution Design, Database Architecture, Databases, Microsoft SQL Server
Experience
CT-International
Designed, modeled, and built a full warehouse, implemented ETL, and built reports and dashboards.
Performed several deep-dive data analyses and presentations of results for complex elements affecting the business. Formed the data-related policy.
Performed several deep-dive data analyses and presentations of results for complex elements affecting the business. Formed the data-related policy.
AWS Aurora Migration
Migrated a SQL Server 2012 database and built new requirements.
Converted TSQL stored procedures and functions to MySQL equivalent functionality. Migrated data and work closely with the mobile app dev team.
Converted TSQL stored procedures and functions to MySQL equivalent functionality. Migrated data and work closely with the mobile app dev team.
Call Center CRM
A .NET and MS SQLServer application to manage leads, priority queues, and tracking of customer interactions.
Features included:
• Integrations with third-party automated dialers.
• Telesales for varied products from cellular devices to short-term insurance and lifestyle surveys.
The architecture was made of a few core modules and product-specific modules.
Each product module was built as a loosely coupled independent module and is only loaded if required (config). The system was used by over 200 concurrent sales agents and across two sites, logging an average of 3 to 4 million calls per month.
Features included:
• Integrations with third-party automated dialers.
• Telesales for varied products from cellular devices to short-term insurance and lifestyle surveys.
The architecture was made of a few core modules and product-specific modules.
Each product module was built as a loosely coupled independent module and is only loaded if required (config). The system was used by over 200 concurrent sales agents and across two sites, logging an average of 3 to 4 million calls per month.
Skills
Tools
Microsoft Power BI, Microsoft Access
Languages
SQL, T-SQL (Transact-SQL), VB.NET, Visual Basic for Applications (VBA)
Storage
Database Architecture, Databases, Microsoft SQL Server, SQL Server 2012, SQL Server 2008 R2, SQL Server 2016, SQL Server Management Studio (SSMS), MySQL, SQL Server DBA, SQL Server 2000, SQL Server 2005, Amazon S3 (AWS S3), Amazon Aurora, SQL Server 2019, PostgreSQL, Database Performance, Azure SQL
Frameworks
VB.NET WinForms, .NET
Paradigms
Object-relational Mapping (ORM), Business Intelligence (BI), Object-oriented Programming (OOP), Database Design
Platforms
Azure, SharePoint 365
Other
Data Modeling, Data Architecture, Azure Data Studio, Data Migration, Solution Design, Data Analysis, Data Marts, Agile Product Delivery, Business to Business (B2B), Mentorship & Coaching, App Support, Agile Delivery, AWS Database Migration Service (DMS), SOAP, Solution Architecture, Amazon RDS
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring