Luis Henrique Vibranovski, Developer in Tel Aviv-Yafo, Israel
Luis is available for hire
Hire Luis

Luis Henrique Vibranovski

Verified Expert  in Engineering

SQL Server Developer

Location
Tel Aviv-Yafo, Israel
Toptal Member Since
May 31, 2022

Luis's strongest skill is SQLPerformance. After more than twenty years of hands-on practice and training on SQL Server and gaining the SQL Server Microsoft certification, Luis is ready to work with MySQL and PostgreSQL, developing and fixing queries, indexes and procedures, and other SQL performance-related issues.

Portfolio

Britannica Knowledge System
Microsoft SQL Server, Amazon RDS, Optimization, CSV, SQL, Data Manipulation...
Salesforce
Microsoft SQL Server, SQL Server DBA, CSV, SQL, Data Manipulation...
Pix Software
Microsoft SQL Server, SQL Server Integration Services (SSIS)...

Experience

Availability

Part-time

Preferred Environment

SQL, Performance Tuning, Query Optimization, Microsoft SQL Server, Database Architecture, Relational Databases, MySQL, Database Schema Design, PostgreSQL, Amazon RDS

The most amazing...

...experience I've had on many projects was to see my users delighted after I delivered performance improvement from ten to a thousand times.

Work Experience

Senior SQL Server Database Administrator

2020 - PRESENT
Britannica Knowledge System
  • Worked on the research and development (R&D) database for one of the company's products. Developed database tasks and fixed bugs.
  • Added value to the product through the database by helping developers and CSMs, supporting production databases, and detecting and optimizing bad queries that created bottlenecks for the users.
  • Improved application functionalities and queries on SQL Server Reporting Services (SSRS) from 10x to 1000x.
Technologies: Microsoft SQL Server, Amazon RDS, Optimization, CSV, SQL, Data Manipulation, Amazon Web Services (AWS), Database Design, Databases, Amazon EC2, Amazon S3 (AWS S3), Data Modeling, Database Modeling, Schemas, SQL Server DBA, SQL Performance, Big Data, Relational Database Design, Database Architecture, Microsoft Report Builder, SQL Stored Procedures, Database Administration (DBA), Data Queries, Performance Tuning, SQL DML, Stored Procedure, JSON, T-SQL (Transact-SQL), Query Optimization, Query Composition, Data Warehousing, Relational Databases, Database Development, AWS Cloud Architecture, Partitioning, Azure SQL, Database Schema Design, SaaS, Architecture, Back-end, Cloud Infrastructure, Database Migration, Cloud, SQL Server 2016, Data Migration, Windows

Database SQL Server Administrator: Applicative and Infrastructure

2018 - 2020
Salesforce
  • Developed queries, stored procedures and functions, and created and altered tables and other objects to align the database to new business rules and correct bugs.
  • Optimized processes and the database due to the clients' high usage in multi-tenant environments.
  • Supported the business intelligence (BI) team with better queries to extract data from the SQL Server on ETL processes.
Technologies: Microsoft SQL Server, SQL Server DBA, CSV, SQL, Data Manipulation, Amazon Web Services (AWS), Database Design, Databases, Amazon EC2, Data Modeling, Database Modeling, Schemas, SQL Performance, Big Data, Relational Database Design, SQL Stored Procedures, Database Administration (DBA), Data Queries, Performance Tuning, SQL DML, Stored Procedure, JSON, T-SQL (Transact-SQL), Query Optimization, Query Composition, Database Architecture, Relational Databases, Database Development, Database Schema Design, SaaS, B2B, Architecture, Back-end, Cloud Infrastructure, SQL Server 2012, Database Migration, Cloud, SQL Server 2016, Data Migration, Windows

Senior Database Engineer | Head of Projects

2013 - 2017
Pix Software
  • Developed my database skills, especially SQL Server, and became the company's senior database engineer.
  • Managed five teams with a total of forty employees, providing development services to around twenty clients.
  • Contacted the clients directly, translating the business requirements to develop stories and detailed tasks when needed.
Technologies: Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), CSV, SQL, Data Manipulation, Amazon Web Services (AWS), ETL, Database Design, Databases, Microsoft Data Transformation Services (now SSIS), Data Modeling, Database Modeling, Schemas, SQL Server DBA, SQL Performance, MySQL, Relational Database Design, SQL Stored Procedures, Database Administration (DBA), Data Queries, Performance Tuning, SQL DML, Stored Procedure, C#, T-SQL (Transact-SQL), Crystal Reports, Query Optimization, Query Composition, Database Architecture, Relational Databases, PostgreSQL, Database Development, Azure SQL, Database Schema Design, SaaS, B2B, Architecture, Back-end, SQL Server 2012, SQL Server 2016, Microsoft Access, Visual Studio, Data Migration, Windows

Senior DBA | Outsourced Software and IT Manager

2004 - 2012
Pix Software
  • Worked on Pix's biggest client—a factory with 5,000 employees—as a Microsoft SQL Server DBA (both applicative and infrastructure DBA), including the 24x7 support for production environments on cloud and in-house databases.
  • Accumulated this position with R&D and IT manager with development, production, and infrastructure responsibilities.
  • Took hands-on responsibilities on subjects related to databases, mainly in Microsoft SQL Server, but also in Oracle and MySQL, for all other PIX clients and teams.
Technologies: Microsoft SQL Server, Visual Studio, Visual Basic 6 (VB6), Visual Basic, SQL Server DBA, SQL Performance, MySQL, Relational Database Design, SQL Stored Procedures, Database Administration (DBA), Data Queries, Performance Tuning, SQL DML, Stored Procedure, C#, T-SQL (Transact-SQL), SQL, Crystal Reports, Query Optimization, Query Composition, Database Architecture, Relational Databases, Database Development, Partitioning, Database Schema Design, Architecture, Back-end, SQL Server 2012, SQL Server 2016, Microsoft Access, Data Migration, Windows

Software Developer and Team Lead

1992 - 2003
Pix Software
  • Started to work as a developer in 1997 and as an applicative DBA with T-SQL on Sybase in 1999. In 2002, also began working with the Microsoft SQL Server database.
  • Started to work as a developer and team leader, developing applications using Microsoft SQL Server, Sybase, and Microsoft Access.
  • Managed, hands-on, the complete downsizing from an IBM mainframe with SQL/DS to a network with Microsoft SQL Server and Sybase.
Technologies: Microsoft SQL Server, Sybase, Visual Basic, Microsoft Access, SQL Performance, MySQL, Relational Database Design, Database Architecture, Data Queries, Performance Tuning, SQL DML, T-SQL (Transact-SQL), SQL, Crystal Reports, Query Optimization, Query Composition, PHP, Relational Databases, PostgreSQL, Database Development, Database Schema Design, Back-end, Data Migration, Windows

Application Performance Improvement of up to 90%

When I started to work on this project, the application had several performance bottlenecks. The performance issues made an awful impression on the company's clients, even though the product was very rich and capable of covering all the business logic and legal requirements. We removed the worst bottlenecks related to the SQL Server and made the user experience much more enjoyable and productive.

Performance Improvement

In this short-term project, working as a Toptal talent, I had the opportunity to apply the techniques I know to solve the main problems in customer databases. These databases had tables with tens of millions of records, and their queries were built when the database was very small. Fixing indexes and queries resolved the customer's issues and prepared the database for future growth. The client, who had already doubled the database server size, could return the server to the original size and still had spare capacity.

Saving Money from Hardware and License Upgrades

I was called to be a consultant on this project because the SQL Server, installed in a virtual machine (VM) on the cloud, worked with 100% CPU during business hours. The decision to upgrade the VM was already made but not deployed yet. I suggested making a diagnosis before the company doubled its monthly fee to the cloud provider. After completing the diagnosis, we found that the problem was one single high-used SSRS report with many bad queries. We approached the problem by changing the report to create database views and new indexes. As a result, the CPU utilization dropped from 100% to 60% during business hours, and the hardware upgrade was canceled without being deployed.

Improving .NET Entity Framework Performance

On many occasions, I was called to solve the Entity Framework performance issues. The process is always the same when improving the Entity Framework with zero or very few code changes. First, I identify the query that is being generated, then diagnose the problem, and finally find and test a solution.

The solution, in most cases, is to create or modify the correct index to support the query or change this specific Entity Framework's call for a direct call to the database without using the Entity Framework.

A very few cases need a different approach. A loop in the application with a number of Entity Framework calls inside it may be solved by creating a stored procedure and transferring the process to the database. But this solution involves more resources and should be used with care.

SQL Expert for Optimizing Performance with MySQL

On this hourly short-term Toptal project with MySQL, the client's website was freezing and sometimes going down because of the traffic increase.

In the first phase, using only Amazon RDS Performance Insights and Amazon CloudWatch, I could identify and fix many queries, only adding the correct indexes to support them. This approach was enough to eliminate the website freezes.

In the second phase, the client gave me access to his application (Git repository), and I fixed the queries that could not be fixed only with indexes.

The final result, from an AWS RDS point of view, was the database's use dropped from 10 CPUs to less than 2 CPUs. The website has been very stable and fast since this project, and the client could decrease the RDS server size.

Data Engineer for Cloud Scalability Using PostgreSQL

On this middle-size Toptal assignment on PostgreSQL, the client—a PPC startup—already had a complete website developed. From a business perspective, I was doing a successful job acquiring new clients almost every week.

From a database perspective, the central table of the software, which controls all the keywords for every client, was multiplying its size daily, hurting the client's dashboard performance.

In the diagnostic phase, we identified that the software was built over layers of functions and views, which was the problem.

As the client decided to solve the problem with minimum intervention and take advantage of that, the data was updated only once a day. More than 80% of the keywords were not receiving any data. We decided to add a new layer between the dashboard and the base tables, work with materialized views, and let the dashboard data be prepared to be fetched by the clients as soon as they start using the dashboards.

The dashboards started to return data at a comfortable level, and the application that was also receiving timeout messages was stabilized.
FEBRUARY 2022 - JANUARY 2024

Certified SQL Server Engineer

Microsoft

Tools

Crystal Reports, Visual Studio, Microsoft Access, Microsoft Report Builder, pgAdmin

Languages

T-SQL (Transact-SQL), SQL, SQL DML, Stored Procedure, Visual Basic 6 (VB6), Visual Basic, C#, PHP

Paradigms

Database Design, B2B, ETL, Database Development

Platforms

Windows, Amazon Web Services (AWS), Amazon EC2, Azure

Storage

Microsoft SQL Server, Azure SQL, Databases, Database Modeling, SQL Server DBA, SQL Performance, MySQL, Database Architecture, SQL Stored Procedures, Database Administration (DBA), Relational Databases, PostgreSQL, SQL Server 2012, SQL Server 2016, SQL Server Integration Services (SSIS), Amazon S3 (AWS S3), Database Migration, SQL Server Reporting Services (SSRS), Sybase, JSON

Other

Optimization, CSV, Data Manipulation, Data Modeling, Schemas, Relational Database Design, Data Queries, Performance Tuning, Query Optimization, Query Composition, AWS Cloud Architecture, Database Schema Design, SaaS, Database Optimization, Architecture, Back-end, Amazon RDS, Microsoft Data Transformation Services (now SSIS), Partitioning, Server Security, Cloud Infrastructure, Cloud, Data Migration, Big Data, Data Warehousing, Materialized View

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