Bruno Machado Agostinho
Verified Expert in Engineering
SQL Developer
Florianópolis - State of Santa Catarina, Brazil
Toptal member since November 14, 2018
For over the past decade, Bruno's been working with databases in various fields. He also has an Oracle SQL Expert certification and specializes in optimizing SQL queries and PL/SQL procedures, but he's also developed with PostgreSQL and MySQL. Bruno likes to keep himself up to date, and that's why he's undertaking a Ph.D. in computer science.
Portfolio
Experience
- SQL - 20 years
- ETL - 10 years
- Data Warehousing - 10 years
- Business Intelligence (BI) - 6 years
- dbt Cloud - 6 years
- Data Build Tool (dbt) - 6 years
- Looker - 6 years
- BigQuery - 5 years
Preferred Environment
Docker, Linux, Git, DataGrip
The most amazing...
...database optimization I've done was to reduce a company's critical process of sending SMS from seven hours to two minutes.
Work Experience
Data Engineer
The Estee Lauder Companies Inc. - Main
- Optimized Looker reports by partitioning and clustering big PDTs.
- Migrated Looker Studio and Oracle BI dashboards to Looker.
- Developed Airflow DAGs to preprocess data, reducing some view response times from minutes to seconds.
Data Engineer
Backstage LLC
- Configured ETL layer using DBT and Stitch from scratch.
- Migrated all ETL and DW to use dbt, creating a robust data transformation layer, removing duplicate sources for the same information.
- Optimized by more than 50% the execution time for Looker reports by moving part of the LookML logic to persisted tables.
- Introduced a large language model (LLM) prediction to forecast users' behavior.
- Optimized BigQuery queries by identifying bottlenecks and adding partitioning and clustering to tables.
Data Engineer
TV Time (via Toptal)
- Created BI reports being used on the decision-making process.
- Developed data import scripts from AWS to Snowflake.
- Analyzed data and generated charts using Excel and Snowflake.
Database Analyst
Bridge Lab | Federal University of Santa Catarina
- Optimized a health data reporting system at the national level, making it possible to use it.
- Contributed to the planning of the implementation of a business intelligence system for health data.
- Developed a database benchmark system for building the monitoring system of the Ministry of Health.
- Shared my knowledge and experiences in a lecture program.
Senior Database Analyst
Suntech
- Developed a review of database procedures, eliminating some security breaches.
- Contributed to the development of new modules of the company's system.
- Deployed new modules of the system.
- Reviewed system queries in order to improve the performance.
Database Analyst
Dataminer
- Automated the backup portion of all the company's systems.
- Helped to develop a tool where clients can cross data from companies and individuals and that can apply the filters the way they prefer.
- Contributed to the process of applying machine learning techniques to trace the profile of the company's customers and generate a data model to complete missing data.
- Developed crawlers for data capture from companies on the internet.
Database Administrator (DBA)
Inphonex LLA
- Contributed to the development of a tool for control of VoIP telephony, enabling several user facilities.
- Migrated the business rules from one of the company's systems to the database, keeping the maintenance centralized.
- Helped to develop a replication control system for the company's databases, making it easier to generate new snapshots and restore points.
PL/SQL Developer
Brasil DB
- Automated the ETL process for capturing data from companies on the internet.
- Developed several procedures to speed up the cross-checking of data by the production team.
Database Administrator
Cellmidia Communication
- Helped to migrate the company database from SQL Server to MySQL.
- Migrated the servers to machines outside the country, switching the operating system from Windows to Linux.
- Initiated the project of monitoring the SMS boards and the automatic services, sending messages to the team in case of problems.
- Supported the development of a tool for generating data profiles by clients, with support for SMS sending and market campaign generation.
- Increased the capacity of sending messages (using new technologies, such as tables in memory) by more than tenfold.
Experience
Datahub
DM Online
For this project, I developed the procedures, modeled the database, and handled the database instances.
Ring By Name
https://www.ringbyname.comCellmidia Center
For this project, I developed the database layer; all of the business rules were already in the database.
Education
Ph.D. Degree in Computer Science
University of Pisa - Pisa, IT
Master's Degree in Computer Science
Federal University of Santa Catarina - Florianopolis, SC, Brazil
Postgraduate Degree in Data Science and Big Data
IGTI | Institute of Management and Information Technology - Minas Gerais, Brazil
Bachelor's Degree in Information Systems
Federal University of Santa Catarina - Florianópolis, SC, Brazil
Certifications
Oracle Database SQL Certified Expert
Oracle
Oracle Certified Associate, MySQL 5
Oracle
Skills
Libraries/APIs
Stripe
Tools
dbt Cloud, BigQuery, Looker, Microsoft Power BI, DataGrip, Git, Stitch Data, iTunes Connect, Microsoft Excel, Google Kubernetes Engine (GKE), Apache Airflow, GitHub
Languages
SQL, Snowflake, Python
Frameworks
Angular, Hadoop, Spark
Storage
PL/SQL, MySQL, PostgreSQL, Oracle PL/SQL, Redshift, MongoDB, NoSQL, Elasticsearch
Paradigms
ETL, Business Intelligence (BI)
Platforms
Oracle, Google Cloud Platform (GCP), Linux, Apache Flink, Docker, Blockchain
Other
Data Warehousing, Data Warehouse Design, Data Build Tool (dbt), Google BigQuery, Data Analytics, Data Engineering, Metabase, Big Data Architecture, Big Data, Data Visualization, Large Language Models (LLMs), Amplitude, Fivetran, Data Modeling, CI/CD Pipelines
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