Senior SQL & PL/SQL Database Engineer

Gilberto Waldelm

PL/SQL, SQL Developer Database Engineer

Open to Relocation

******@*****.*** linkedin.com/in/gilbertowaldelm github.com/GibaW Authorized to work in the U.S. (Green Card holder) PROFESSIONAL SUMMARY

Database Engineer Database Developer (SQL & PL/SQL) Senior Database Engineer with deep ownership of production relational databases supporting transactional and reporting systems in high-risk environments. Specialized in SQL Development (stored procedure, triggers, functions, packages), performance optimization and data integrity across Oracle

(PL/SQL), PostgreSQL, MySql and SQL Server platforms, with extensive experience delivering high performance code for cloud-hosted environments (AWS RDS / Azure SQL). Experienced in risk-aware technical decisions and incident resolution, stabilizing high-volume systems where downtime or data inconsistency directly impacts business operations. Focused on modernizing legacy database logic and ensuring production stability through expert query tuning and efficient schema design, bridging the gap between complex business rules and scalable database architecture.

CORE EXPERTISE

• Production database ownership, incident resolution, and root cause analysis

• SQL performance tuning, execution plan analysis, and query optimization

• Indexing strategies, concurrency control, and query scalability (opcional, complementar)

• SQL Development, Analytics and query optimization for AWS RedShift

• Relational data modeling (logical and physical, using tools like Erwin Data Modeler)

• Database migrations and post-migration stabilization

• Cloud-hosted relational databases (AWS RDS, Aurora, Redshift)

• Advanced SQL and PL/SQL development (stored procedures, packages, functions, triggers)

• Cross-platform SQL development (Oracle, PostgreSQL, MySQL, SQL Server)

• Transactional and reporting systems supporting high-volume workloads PROFESSIONAL EXPERIENCE

GFT Technologies SE, Remote, US Clients

Senior Database Engineer ETL Developer 02/2023 – 12/2025 Supporting enterprise U.S. clients through long-term database engineering engagements, with full ownership of production relational databases in financial and compliance-sensitive environments. Trusted for stabilizing high-risk systems, resolving production incidents, and making risk-aware technical decisions impacting reporting accuracy and operational continuity. Selected Client Engagements

HarbourVest Partners – Boston, MA

SQL Developer / Database Engineer

• Supported SQL Server production databases powering Private Equity investment reporting and portfolio analytics used by internal financial teams.

• Designed, developed, and optimized complex stored procedures, functions, and triggers supporting high-volume financial datasets including portfolio, holdings, and investment performance data.

• Built and maintained ETL pipelines (SSIS and Control-M) responsible for transforming and loading large volumes of investment and transactional data into enterprise reporting systems.

• Enabled portfolio and investment reporting workflows by designing and optimizing the database data layer consumed by enterprise BI platforms such as MicroStrategy.

• Performed SQL performance tuning across large financial datasets, including execution plan analysis, indexing strategies, and query refactoring for reporting and analytical workloads.

• Contributed to enterprise database migration and system integration initiatives, including schema refactoring, financial data validation, and post-migration stabilization.

• Used ERwin Data Modeler to analyze and refactor complex relational schemas supporting financial reporting and investment data processing.

• Provided production support and on-call monitoring for critical nightly financial data processing pipelines.

Technologies:

SQL Server, PostgreSQL, Oracle PL/SQL, T-SQL, SSIS, Control-M, ERwin Data Modeler Fiserv

• Developed, maintained, and optimized Oracle PL/SQL packages, stored procedures, functions, and triggers supporting core financial and payment-related systems.

• Tuned SQL and PL/SQL logic for high-volume transactional environments, focusing on execution plan analysis, efficient data access patterns, and performance stability.

• Supported database migration and system integration initiatives, ensuring data consistency, integrity, and performance across legacy and modernized platforms.

• Contributed to data modeling and schema refactoring efforts using ERwin Data Modeler as part of controlled migration and production stabilization initiatives.

• Designed and maintained Oracle-based data structures and PL/SQL processes supporting large- scale reporting workloads, with strong emphasis on query performance, scalability, and reliable data consumption.

• Worked closely with globally distributed application teams to support production database operations and resolve performance-related incidents in regulated environments. Technologies: Oracle PL/SQL, PostgreSQL, ERwin Data Modeler Razor Vision Consulting LLC, Remote, Chicago, IL

Selected Client Engagements

Braviant Holdings – Chigaco IL

Database Engineer / SQL Developer 09/2022 – 12/2022

• Supported SQL Development in databases for financial and loan-processing systems.

• Designed, developed, and optimized complex SQL stored procedures, packages, functions, and triggers to support high-volume transactional and reporting systems

• Designed and implemented a new relational loan database derived from legacy platforms, including schema definition, data validation, and reporting support.

• Analyzed legacy schemas and designed normalized relational models to ensure data integrity and traceability.

• Performed SQL performance tuning through query refactoring and indexing strategies to stabilize production workloads.

• Supported database migration initiatives to PostgreSQL and Redshift with post-migration performance optimization.

Technologies: PostgreSQL, AWS RedShift, Oracle PL/SQL, ERwin Data Modeler, ERwin Data Modeler POLI Solucoes Digitais, Brazil

Database Engineer / SQL Developer 11/2021 – 09/2022

• Led database migration and stabilization efforts across PostgreSQL, SQL Server, MySQL, Oracle, and Amazon Aurora environments.

• Refactored and validated relational schemas to support cross-platform data movement and reporting requirements.

• Implemented SQL-driven data transformations prioritizing data quality, traceability, and performance.

o Designed, developed, and optimized complex PL/SQL & SQL stored procedures, packages, functions, and triggers to support high-volume transactional and reporting systems

• Optimized SQL queries supporting analytical and reporting workloads across multiple relational platforms.

• Supported reporting and analytical workloads across multiple database platforms (Oracle, SQL Server, MySQL, and PostgreSQL), designing and tuning data models and SQL logic to ensure consistent performance and scalability over large datasets.

• Supported ETL workflows through database-centric logic and limited Python scripting. Technologies: PostgreSQL, RedShift, SQL Server, MySQL, Oracle PL/SQL, AWS Aurora, AWS Redshift Genova Industria EPI, Brazil

Senior Database Engineer / PL/SQL Developer 08/2020 – 09/2021

• Owned Oracle and PostgreSQL databases support ERP and financial systems with strict transactional requirements.

• Developed and optimized complex PL/SQL code supporting daily production operations. o Designed, developed, and optimized complex PL/SQL stored procedures, packages, functions, and triggers to support high-volume transactional and reporting systems

• Performed execution plan analysis and indexing strategies to stabilize core operational processes.

• Designed and evolved logical and physical data models aligned with financial business rules.

• Supported database-centric ETL and reporting workflows. Technologies: Oracle, PostgreSQL, PL/SQL, Pentaho, Power BI, ERwin Data Modeler SafeGold Performance Empresarial LTDA, Brazil

Senior Database Engineer 05/2018 – 09/2021

• Held end-to-end ownership of relational database engineering supporting core financial and operational systems where data accuracy directly impacted cash flow and financial reporting.

• Designed and evolved logical and physical data models across Oracle, PostgreSQL, SQL Server, MySQL, and AWS-hosted databases, ensuring transactional integrity and consistency.

• Led multi-platform database migration initiatives, including schema redesign, data validation, reconciliation, and post-migration performance stabilization.

• Performed SQL and PL/SQL performance tuning through execution plan analysis and indexing strategies to support high-volume transactional workloads. o Designed, developed, and optimized complex PL/SQL & SQL stored procedures, packages, functions, and triggers to support high-volume transactional and reporting systems

Technologies: Oracle PL/SQL, PostgreSQL, SQL Server, MySQL, AWS RDS, AWS Redshift, PL/SQL, ERwin Data Modeler, PowerBi

EARLIER CAREER SUMMARY

Held progressive database engineering and technical leadership roles supporting enterprise business systems across consulting and in-house environments. Experience includes SQL and PL/SQL development, data modeling, performance tuning, ETL support, and multi-platform database migrations. Summary of Early Roles:

Database Engineer / PLSQL Developer / T-SQL Developer K&M Informática S.T.I. LTDA 2017 – 2018

• Team support and technical leadership

• Hands-on development and tuning of PL/SQL stored procedures and packages supporting transactional and reporting workloads

Database Engineer / PLSQL Developer / T-SQL Developer ZZTECH Informática LTDA 01/2015 – 06/2017

• Team Support role

• Development of complex stored procedures and SQL routines, with focus on performance and data consistency

Database Engineer / T-SQL Developer

REPOR Brasil LTDA 2012 – 2014

• Data Migration initiatives

• Stored procedure–based data transformation and reconciliation across legacy and target systems T-SQL Developer, PL/SQL Developer

KAMAI Auditoria Tributária LTDA 2010 – 2011

• Data migration and reconciliation

• SQL and PL/SQL stored procedure development supporting auditing and financial reporting processes

Database Engineer / PLSQL Developer

FUJIWARA Equipamentos de Proteção Individual LTDA 1993 – 2010

• Long-term role supporting business-critical databases

• Extensive experience developing and maintaining PL/SQL stored procedures, data migration routines, and core business logic

EDUCATION

Bachelor of Science in Information Systems

Faculdade de Apucarana, Brazil

Professional in Development

• Modern Data Platforms: Snowflake and DBT, applied from a SQL and data modeling perspective

• Cloud Fundamentals for Database Engineers, relational databases on AWS

• Python for database automation and data processing

• Ongoing learning focused on data reliability, performance, and production stability LANGUAGES

English: Professional working proficiency

Portuguese: Native, Spanish: Basic

Contact this candidate