Bruno is available for hire
Hire BrunoBruno Carvalho
Verified Expert in Engineering
Software Developer
Location
Campinas - State of São Paulo, Brazil
Toptal Member Since
June 18, 2020
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
The Estée Lauder Companies
Azure, Synapse, ADF, SQL, SharePoint, Jira, DataGrip, Azure Databricks...
BEOC Tech
PostgreSQL, Python, Database Modeling, PL/SQL, SQL, Agile Project Management...
Toptal
Agile Project Management, Business Requirements, Confluence
Experience
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
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
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
Tools
Confluence, Jira, Oracle Reports, Oracle Forms, Git, Jenkins, MySQL Workbench, Amazon CloudWatch, Synapse, DataGrip
Languages
SQL, Stored Procedure, Python
Paradigms
Database Development, Scrum, Agile, Agile Project Management, ETL, Data Science
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
Frameworks
ADF
Other
Cloud, Triggers, Views, Business Requirements, Requirements & Specifications, Amazon RDS, Azure Databricks
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