Bruno Machado Agostinho, Developer in Florianópolis - State of Santa Catarina, Brazil
Bruno is available for hire
Hire Bruno

Bruno Machado Agostinho

Verified Expert  in Engineering

Data Build Tool (dbt) Developer

Location
Florianópolis - State of Santa Catarina, Brazil
Toptal Member Since
June 18, 2020

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.

Data WarehousingData Warehouse DesignSQLMySQLPL/SQLOracle PL/SQLPostgreSQLETLOracleBusiness Intelligence (BI)Microsoft Power BISnowflakeBig Data ArchitectureBig DataData VisualizationHadoopiTunes Connect

Availability

Part-time

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

2019 - 2019
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.
Technologies: Microsoft Excel, SQL, Snowflake, Looker

Database Analyst

2017 - 2019
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 to the buildings monitoring system of the ministry of health.
  • Shared my knowledge and experiences in a lecture program.
Technologies: PostgreSQL, Oracle

Senior Database Analyst

2016 - 2017
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.
Technologies: Oracle PL/SQL

Database Analyst

2013 - 2016
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.
Technologies: Python, Linux, PostgreSQL, PL/SQL, Oracle

Database Administrator (DBA)

2011 - 2013
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.
Technologies: PHP, Linux, MySQL

PL/SQL Developer

2010 - 2011
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.
Technologies: Oracle PL/SQL

Database Administrator

2008 - 2010
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.
Technologies: Linux, PHP, MySQL

Datahub

This is an application so that customers can do their own counts and be able to download the data without needing support. The system has a variety of companies' data, such as the number of employees and monthly revenue range. It has modules to evaluate the viability of new businesses in specific regions and alerts companies with the same profile that are opening in the region.

DM Online

This is a system to collect and crosscheck the data of people and companies. The data comes from various internet sources and make it possible to search by name or by the identifiers of person or companies.

For this project, I developed the procedures, modeled the database, and handled the database instances.

Ring By Name

https://www.ringbyname.com
This is a system for VoIP telephony solutions. For this project, I worked on database modeling and implementing procedures.

Cellmidia Center

This is an SMS and email marketing system with the possibility for users to set up their own user profiles and trigger campaigns using a predefined database.

For this project, I developed the database layer; all of the business rules were already in the database.

Languages

SQL, Snowflake, PHP, Python, Java

Frameworks

Angular, Hadoop, Spark

Storage

PL/SQL, MySQL, PostgreSQL, Oracle PL/SQL, Redshift, MongoDB, NoSQL, Elasticsearch

Other

Data Warehousing, Data Warehouse Design, Data Build Tool (dbt), Big Data Architecture, Big Data, Data Visualization

Tools

Looker, Microsoft Power BI, DataGrip, Git, Stitch Data, iTunes Connect, Microsoft Excel

Paradigms

ETL, Business Intelligence (BI)

Platforms

Oracle, Linux, Apache Flink, Docker

Libraries/APIs

Stripe

2017 - 2019

Master's Degree in Computer Science

Federal University of Santa Catarina - Florianopolis, SC, Brazil

2016 - 2018

Postgraduate Degree in Data Science and Big Data

IGTI | Institute of Management and Information Technology - Minas Gerais, Brazil

2007 - 2015

Bachelor's Degree in Information Systems

Federal University of Santa Catarina - Florianópolis, SC, Brazil

APRIL 2014 - PRESENT

Oracle Database SQL Certified Expert

Oracle

JULY 2012 - PRESENT

Oracle Certified Associate, MySQL 5

Oracle

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