Bruno Carvalho, Developer in Campinas - State of São Paulo, Brazil
Bruno is available for hire
Hire Bruno

Bruno Carvalho

Verified Expert  in Engineering

Software Developer

Campinas - State of São Paulo, Brazil

Toptal member since June 18, 2020

Bio

Bruno is an enthusiastic database engineer and software developer with experience analyzing and developing systems using various tools, including AWS, PostgreSQL, MySQL, Oracle Database, PL/SQL, PSQL, SQL, and more. He quickly learns new technologies and workflow methodologies and easily adapts to new teams and operating norms.

Portfolio

Deckers Brands
SQL, Python, Data Engineering, Amazon Web Services (AWS), Spark...
Oliver Wyman - Data Science
Data Engineering, Amazon Web Services (AWS), ETL, Amazon EMR Studio, Python...
Ellement
SQL, PostgreSQL, Grafana

Experience

  • Database Development - 17 years
  • SQL - 17 years
  • Stored Procedure - 12 years
  • PL/SQL - 12 years
  • Databases - 12 years
  • Agile - 10 years
  • Amazon Web Services (AWS) - 5 years
  • ETL - 5 years

Availability

Part-time

Preferred Environment

Oracle PL/SQL, Amazon Web Services (AWS), SQL, Stored Procedure, ETL, Agile, Databases

The most amazing...

...project I’ve worked on was the migration of a legacy database into a micro-service-oriented database structure with replication to multiple AWS regions.

Work Experience

Data Engineer

2025 - 2025
Deckers Brands
  • Performed data migration using dbt and Redshift. Worked on the creation of multiple data models and the necessary validations and layers, according to dbt best practices, to transform and move large volumes of data.
  • Created complex views to be used on Tableau reports.
  • Created alerts and monitoring queries on Monte Carlo.
  • Worked also on the investigation of incidents and data discrepancies.
Technologies: SQL, Python, Data Engineering, Amazon Web Services (AWS), Spark, Amazon Elastic Container Registry (ECR), Amazon Elastic Container Service (ECS), Amazon S3 (AWS S3), Data Build Tool (dbt), Redshift

Data Engineer

2024 - 2024
Oliver Wyman - Data Science
  • Implemented complex notebooks (EMR Studio) for transformation and migration of large financial datasets from Oracle database into AWS for future implementation of risk modeling.
  • Implemented Python scripts of incremental data load for granularity change and refinement of data, to be later executed directly on PySpark servers through orchestration.
  • Implemented new tables in AWS Glue based on the parquet files (generated by tailor-made Python/PySpark programs) to facilitate the ingestion of data into new data models.
Technologies: Data Engineering, Amazon Web Services (AWS), ETL, Amazon EMR Studio, Python, PySpark, AWS Glue, Amazon Athena, SQL

SQL Expert

2024 - 2024
Ellement
  • Created a set of database objects (PostgreSQL) to allow Grafana to process complex reports with pivot capabilities, without the dependency on plugins, allowing the company to migrate to a new tool for visualization on future initiatives.
  • Created dashboards to display complex data, still considering performance and easy utilization by final users.
  • Developed multiple reports considering the business requirements and creation of the necessary structures in the database to keep the SQL queries as simple to maintain as requested by the business.
Technologies: SQL, PostgreSQL, Grafana

Tech Lead / PJM

2022 - 2023
The Estée Lauder Companies
  • Joined this project to reorganize the department and guarantee the success of the ongoing deliverables and new functionalities and create a better work structure for the dev team.
  • Created database objects such as views and stored procedures for data processing and summarization of information for reports and email marketing.
  • Defined and documented the architectural design of new solutions for a customer data platform based on Azure. Aligned with technical and non-technical stakeholders on the implementation steps, timelines for implementation, and effort estimations.
  • Managed a team of engineers with different experience levels and specializations to implement new functionalities while redefining the team's culture to achieve a more organic knowledge transfer process and increase the sense of ownership.
  • Managed the ongoing initiatives applying Scrum methodology and oversaw the ceremonies and backlog maintenance, but also managed timesheets, vacation scheduling, and feedback cycles.
Technologies: Azure, Synapse, ADF, SQL, SharePoint, Jira, DataGrip, Azure Databricks, Stored Procedure, ETL, Confluence, MySQL, PL/SQL, Agile, Data Pipelines, Oracle, Git, Jenkins, Linux, Requirements & Specifications, Oracle Database, Cloud, Agile Project Management, Databases, Views, Business Requirements, Microsoft SQL Server

Data Engineer | PJM

2021 - 2022
BEOC Tech
  • Co-founded a company to provide consultancy services in areas including, but not limited to, data, data engineering, and project management.
  • Optimized SQL queries for large amounts of data and creation of custom SQL reports.
  • Created database objects such as triggers, views, and stored procedures for different purposes.
  • Offered services as project manager and used Scrum methodology for activities.
Technologies: PostgreSQL, Python, Database Modeling, PL/SQL, SQL, Agile Project Management, Scrum, Linux, Stored Procedure, Agile, ETL, Oracle, Git, Jira, Requirements & Specifications, Oracle Database, Cloud, Databases, Views, Business Requirements, Confluence

Director of Engineering

2018 - 2021
Toptal
  • Assisted great companies in identifying outstanding engineers for their needs, considering each project's technological stack and specific aspects.
  • Gathered requirements on technical meetings and specifications of project characteristics to be used in the filtering of engineers.
  • Helped manage the relationship between the parts to achieve the best results in the project.
Technologies: Agile Project Management, Business Requirements, Confluence

DBA

2016 - 2018
iFood
  • Migrated a core database from Oracle to PostgreSQL, refactoring stored procedures, functions, triggers, and other database objects, respecting the best practices on both.
  • Created stored procedures to transform and move data to different schemas, preparing the structure for new data migration. The data should be split into many smaller databases allowing a fault-tolerant microservice architecture.
  • Configured the database environment using Oracle and PostgreSQL in an Amazon EC2 and RDS cloud environment.
  • Built performance monitoring in PostgreSQL database servers and did SQL optimization.
  • Configured Amazon CloudWatch Dashboards to monitor EC2 servers running database instances.
  • Created backup and restore routines in AWS RDS and AWS EC2 servers for PostgreSQL databases.
  • Configured and monitored the replication processes.
Technologies: Jira, PL/SQL, Oracle, SQL, Amazon CloudWatch, Amazon S3 (AWS S3), Amazon EC2, Cloud, PostgreSQL, Amazon Web Services (AWS), Amazon RDS, Database Development, PSQL, Database Modeling, Python, Stored Procedure, Databases, Scrum, Linux, ETL, Git, Jenkins, MySQL, Oracle Database, Triggers, Views, Data Pipelines

Database Specialist

2016 - 2016
Daitan Group
  • Developed stored procedures and scripts to perform data migration between databases, using bulk operations to handle a high volume of data to allow the company to transform and move specific consumer data between data centers.
  • Performed daily work using Oracle database and PL/SQL language for the creation, execution, and monitoring of database scripts to perform transformation and transference of large volumes of data.
  • Worked with the client's international team on this temporary project coordinating time zones with UK, USA, and India.
  • Created reports and data extractions according to customer needs.
Technologies: PL/SQL, Oracle, SQL, Database Development, Database Modeling, Python, Databases, Stored Procedure, Scrum, ETL, Oracle SQL Developer, Oracle Database, Views, Confluence

Systems Analyst

2014 - 2016
Informática de Municípios Associados S/A (IMA)
  • Acted as a technical leader while implementing data-related functionalities and going hands-on to implement reports, SQL queries, and database objects such as stored procedures, views, tables, and triggers on the Oracle database.
  • Updated the client weekly on remote and on-site meetings where the newly implemented functionalities were demonstrated. The client's approval was collected during these meetings so the features could go to the production environment.
  • Applied Scrum techniques to organize the team's work and deliverables.
  • Developed and updated software functionalities using Python, PHP, and MySQL.
  • Created test scenarios and test cases for the software developed by the team. Executed tests manually, reporting possible issues.
  • Made stored procedures in Oracle (PL/SQL) to transform, denormalize when necessary, and summarize high volumes of data, allowing report extraction.
Technologies: MySQL Workbench, Oracle SQL Developer, PL/SQL, SQL, Database Development, Requirements & Specifications, Database Modeling, Scrum, MySQL, Databases, Stored Procedure, Agile, Oracle, Jira, Oracle Database, Triggers, Views, Business Requirements

System Analyst

2012 - 2014
Matera Systems
  • Developed new functionalities for a system focused on bank back office using PL/SQL (Oracle database) and Oracle Forms and Reports.
  • Implemented new database structures and objects like packages, functions, stored procedures, tables, tables, and views.
  • Participated in the definition of the automated test structure of the company and provided training to the team. Provided support to clients and created and applied hotfixes when necessary.
  • Applied Scrum methodology for the organization of the work and actively participated in the training of newcomers.
  • Created and adjusted stored procedures to process the financial operation data generating the credit operation registers.
Technologies: Oracle, PL/SQL, Oracle Reports, Oracle Forms, SQL, Database Development, Scrum, Stored Procedure, Triggers, Databases, Views, Agile, Oracle SQL Developer, Jira, Oracle Database, Confluence

Tech Lead

2006 - 2011
Compusoftware
  • Performed a technical lead role on different modules of the ERP and provided support to internal and external clients.
  • Created new functionalities based on database objects and structures. Provided maintenance to complex processes using Oracle PL/SQL and both Linux and Windows environments.
  • Created the Electronic Invoice (NF-e) module, participating in all the project steps from client interviews, requirement analysis, the project scope definition, team coordination, and following deliveries.
  • Received training and participated in the migration to the Scrum framework as the new methodology for all projects in the company.
  • Created the stored procedures responsible for generating the electronic invoice data, following the guidelines regulated by the federal government.
Technologies: PL/SQL, Oracle Database, SQL, Database Development, Requirements & Specifications, Database Modeling, Scrum, Stored Procedure, Triggers, Views, Linux, Agile, Oracle, MySQL Workbench, Oracle SQL Developer, Agile Project Management, Databases

Education

2003 - 2006

Bachelor of Science Degree in Information Systems

Toledo University Center - Araçatuba - São Paulo State, Brazil

Skills

Libraries/APIs

PySpark

Tools

Confluence, Jira, Oracle Reports, Oracle Forms, Git, Jenkins, MySQL Workbench, Amazon CloudWatch, Synapse, DataGrip, Amazon Elastic Container Registry (ECR), Amazon Elastic Container Service (ECS), Grafana, AWS Glue, Amazon Athena

Languages

SQL, Stored Procedure, Python

Paradigms

Database Development, Scrum, Agile, Agile Project Management, ETL

Platforms

Oracle Database, Oracle, Amazon EC2, Linux, Amazon Web Services (AWS), Azure, SharePoint, Jupyter Notebook

Storage

Oracle SQL Developer, PostgreSQL, Databases, PL/SQL, Database Modeling, Amazon S3 (AWS S3), PSQL, MySQL, Data Pipelines, Microsoft SQL Server, Redshift

Frameworks

ADF, Spark

Other

Cloud, Triggers, Views, Business Requirements, Requirements & Specifications, Amazon RDS, Azure Databricks, Data Science, Data Engineering, Data Build Tool (dbt), Amazon EMR Studio

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