Roy Sorero
Verified Expert in Engineering
Performance Tuning Developer
Tel Aviv-Yafo, Israel
Toptal member since January 30, 2020
With 20 years of experience in data systems for multiple industries, Roy helps companies solve complex tech problems and build better data-based solution stacks. As a seasoned remote worker, he is highly independent, adapts quickly, and communicates well. Improvement driven and always curious for a new approach, Roy brings a unique perspective and proficiency both in IT system internals as well as the business needs that drive them.
Portfolio
Experience
- Performance Tuning - 20 years
- PL/SQL - 20 years
- SQL - 20 years
- Oracle Database - 20 years
- Microsoft SQL Server - 12 years
- Oracle Data Guard - 10 years
- MySQL - 6 years
- PostgreSQL - 4 years
Preferred Environment
SQL, MongoDB, MySQL, Microsoft SQL Server, Oracle RDBMS
The most amazing...
...solution I've designed was an end-to-end live database site disaster failover mechanism that was completely transparent to application developers.
Work Experience
Oracle Database Administrator and Architect (Remote Freelance)
Evogene (Biotech)
- Maintained and monitored dual-site (Data Guard) large-scale Oracle data warehouse instances supporting biotech data scientists' analytics work and online applications.
- Planned and executed a successful minimal downtime dual-site upgrade and migration project to a new server and storage environment, orchestrating a delicate process involving multiple teams in the company.
- Handled countless cases of real-time physical and logical incidents, requiring delicate yet precise action at a minimal response time.
- Proactively and constantly improved database performance, using both automatic and manual monitoring practices, developer code reviews and SQL tuning.
- Served as the exclusive point of contact for anything database related.
Senior Database Architect (Freelance)
Axxana (Disaster Recovery & High Availability)
- Designed and implemented an Oracle RAC test environment deployment scheme for the QA department; installed and configured dozens of databases and eventually automated the process.
- Led the Oracle database knowledge acquisition for the QA and R&D departments, working with both team leaders and engineers and participating in the company's scrum process.
- Conducted large-scale technical research for the lead system architect, the result of which was a 70-page whitepaper which gave the company unique knowledge and expanded its disaster recovery solution to the realm of high availability.
Senior Database Architect (Freelance)
Check Point Software Technologies (IT Security)
- Designed and developed an end-to-end solution for the data layer of new cloud-based security products, serving hundreds of thousands software products and appliances used worldwide.
- Collaborated with multiple R&D teams on various projects simultaneously creating optimal customised solutions.
- Implemented top-to-bottom architecture, based on Oracle and MySQL RDBMS—from capacity planning and distributed high-availability solutions of software infrastructure via coding and performance tuning of real-time environments.
Senior Database Administrator
Isracard (Fintech)
- Implemented, integrated, and maintained corporate data infrastructures—acting both as a knowledge focal point for managers and a hands-on team member.
- Implemented in-depth know-how of multi-platform data systems with special expertise of Oracle products, mastering Oracle RDBMS.
- Conducted full-stack troubleshooting and resolution for live production environments including real-time incident handling and post-mortem.
IT Cadets Training Officer
IDF BAHAD7 (C4I Corps School for IT Cadets)
- Held the overall responsibility for the training of IT cadets, soon to be stationed as graduate IT officers at different IDF IT units.
- Engaged in close-up mentoring for technical, managerial and leadership abilities.
- Acted as part of a small hand-picked team of commanders, responsible for the planning, coordination, and improvement of a 12-week training course.
DevOps Team Leader
IDF Mamram (Center of Computing and Information Systems)
- Led a team of seven junior and senior programmers which developed and serviced full-stack deployment pipelines for multiple development teams.
- Managed the full software projects' lifecycles, from strategic planning through resource and risk management to on-time and budget delivery.
- Researched cutting-edge technology and defined organizational-wide standards, including development and provisioning of code infrastructure for application developers and implementation of elaborate testing methods.
- Defined and implemented a progressive service-level agreement for a cutting-edge, very large scale, military-grade data center.
- Entrusted as the POC for a wide range of clients, project managers, programmers, and in-field operators.
Junior Oracle Database Administrator and Developer
IDF Mamtal (Logistics IT Unit)
- Researched and implemented replication solutions over a distributed multi-platform production database environment.
- Serviced multiple development teams and mitigated infrastructural demands to IT.
- Participated in a large scale upgrade and consolidation project of military-grade redundant production systems.
Experience
Smartfish | Used Hardware Sales Lead Collector
Technologies: Python NLP, Bootstrap, Angular 2, MySQL
Used hardware is bought and sold in bulk via very basic premium online web platforms. The point was to automate the tedious work of manually looking for sellers and buyers by "fishing" for potential good deals. We used natural language processing to match records from different platforms and highlighted them for the trading agents of the company.
Alas, the company could not raise enough funds to continue the project while I was involved. It was fun though.
Bakery Auto-costing Calculator
I initially supported their MS SQL needs but recently designed a system to automate the entire process, including the automatic collection of data and migration from paper to full-stack web apps and from Excel to a multi-dimensional database model. This project is still ongoing.
Axxana's Far Sync Application Continuity Solution
Based initially on EMC storage, they came to me when they started expanding their product to Oracle Exadata. Apart from servicing all their database-related needs, I also conducted successful and extensive research (70+ page white paper) on how to integrate Oracle's high-availability features with their product. This research enabled them to offer services for the corporate application layer and expand their business and potential clientele.
To do so, I successfully developed a software solution that allowed all the applications that run on an Axxana protected database to seamlessly and transparently failover to a backup site without any need to attend to noncommitted transactions (e.g., Oracle Application Continuity). The real magic was making that work between sites and with minimal delay in the user experience.
The bottom line is if a client experiences a complete datacenter loss, users won't feel any operational effect (data loss or application crash).
Education
Bachelor's Degree in Political and Social Science
Tel Aviv Academic College - Tel Aviv, Israel
1st Lieutenant in IT/C4I Senior Team Leadership
IDF Computer Science School (Basmah) - Ramat Gan, Israel
2nd Lieutenant in IT/C4I Officers Course
IDF Officers School (Bahad 1+7) - Bahad, Israel
Completed in IDF Programmer Course (Computer Science)
IDF Computer Science School (Basmah) - Ramat Gan, Israel
High School Diploma in Computer Science
Amal High School - Rishon Lezion, Israel
Certifications
Python Automations
Udemy
Mobile Web Application Development for Android and iPhone
Tel Aviv Academic College
Programming the Microsoft .NET Framework using C# Technology
Microsoft Israel
IT Team Leader
Israeli Defence Force (Bahad 7)
Mastering Microsoft Visual Basic 6.0 Fundamentals
Israeli Defence Force (Basmah)
Administering Microsoft Windows Server 2003
Hi-Tec Academy Israel
Software Systems Design
Israeli Defence Force (Basmah)
Oracle DBA III — Database Tuning
John Bryce Training Israel
Oracle Advanced Query Optimization
Israeli Defence Force (Mamtal)
Oracle DBA V — Advanced Replication
John Bryce Training Israel
Software Design Basics
Israeli Defence Force (Basmah)
Oracle DBA II — Backup and Recovery
John Bryce Training Israel
Junior Military Programmer
Israeli Defence Force (Mamtal
Administering Microsoft Windows NT 4.0
Israeli Defence Force (Basmah)
Oracle DBA I — Architecture and Administration
John Bryce Training Israel
Military Programmer's Course (1,300 Hours)
Israeli Defence Force (Basmah)
Skills
Libraries/APIs
Node.js, jQuery, JDBC, REST APIs
Tools
VMware, Git, Oracle Forms, Oracle Reports, Mongoose
Languages
SQL, Transact-SQL (T-SQL), JavaScript, Batch, Bash, SQR, Active Server Pages (ASP), VB, Python, C#, HTML4, HTML5, CSS3, PHP, Perl, C, C++, Java, VBScript, CSH, Regex, Sh
Platforms
Oracle Database, Linux, Windows, MacOS, Windows Server, Unix, Oracle, Docker, Azure IaaS
Storage
PL/SQL, Oracle Database Tuning, ANSI SQL, Microsoft SQL Server, MySQL, PostgreSQL, Database Lifecycle Management (DLM), SQL Server Integration Services (SSIS), Oracle RDBMS, Oracle PL/SQL, MongoDB, Elasticsearch, Google Cloud, Storage Area Networks (SAN)
Paradigms
Agile Software Development, Waterfall Development, Kanban, ETL, Management
Frameworks
AngularJS, Express.js, ASP.NET, Bootstrap 3
Other
Oracle Data Guard, IT Project Management, PL/SQL Tuning, Performance Tuning, Oracle Performance Tuning, TCP/IP, Oracle Discoverer, Gantt Chart, IIS, COM, DCOM, Forms, Reports, SAP, Linux on Z, Oracle RMAN, Training, Team Management, Training & Training Content Development, IP Networks, Oracle Forms & Reports, Oracle Data Miner, XMPP, Ajax, Natural Language Processing (NLP), Oracle WebLogic Application Server, Oracle Fusion Middleware, Generative Pre-trained Transformers (GPT)
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring