JGJonatas Gomes Alves
Oracle Developer · Since 2001

Jonatas Gomes Alves

Senior Oracle PL/SQL & APEX Developer

Two-and-a-half decades building, integrating and modernizing Oracle systems — from mainframe migrations to mobile APEX apps — across insurance, aviation, healthcare and government.

jonatasgomes@gmail.com Mississauga, ON, Canada linkedin.com/in/jonatasgomes github.com/jonatasgomes
24+
Years of Oracle experience
10
Companies & roles
5
Industries served
2
Oracle certifications

Professional Summary

Who I am, in a paragraph

Oracle Developer with over two decades of continuous experience (since 2001) designing, developing and optimizing database solutions from Oracle 8i through 19c. Deep specialization in PL/SQL, Oracle APEX (versions 3.2 → 24+) and Oracle Forms & Reports (4.5 → 11g), with an extensive background in large-scale ERP development, integration and data-migration projects. Hands-on with Oracle E-Business Suite customization, mainframe-to-Oracle migrations and REST-based integrations. Certified Oracle PL/SQL Developer and APEX Cloud Developer, comfortable across Agile/Scrum and Waterfall teams, and currently expanding into Artificial Intelligence, Python and LLMs through a two-year program. Proven delivery in insurance, aviation, healthcare, government and retail.

Core Competencies

Proficiency built over 24+ years
Oracle PL/SQL98%
Oracle APEX (3.2 – 24+)96%
Oracle Forms & Reports92%
Oracle Database (8i – 19c)90%
ERP Development & Maintenance90%
REST API Integration86%
Linux / AWS EC282%
Python / LLMs (in progress)72%

Databases & Oracle Stack

Oracle DB 8i–19cOracle APEX 3.2–24Forms & Reports 4.5–11gE-Business Suite 11iORDSSQL / SQL*Plus / SQLcl

Integration & Reporting

REST APIsJSONStripeDocuSignIBM webMethodsIBM MaximoJasper ReportsOracle BI PublisherApex Office Print (AOP)

Cloud, DevOps & Languages

AWS EC2LinuxTomcatGit · GitHub · GitLabJavaScript / CSSPythonC++ / QML (Qt)DelphiJava (Swing/JPA)

Practices & Tools

Agile / ScrumWaterfallJIRAConfluenceCA Erwin (DB design)Unit TestingData MigrationMS Teams · Slack

Professional Experience

10 roles · insurance · aviation · healthcare · government · retail
City of Toronto
Oracle APEX PL/SQL Developer
Mississauga, Canada
May 2025 – Present
  • iTRAC application: designed and built a new app for daily work assignment, tracking and distribution for Toronto Water and customer-care stakeholders, maintaining a log of work completed by the Emergency Contracts Unit (ECU) and Planned Contracts Unit (PCU) contractors.
  • Led the migration from the legacy Hansen system to IBM Maximo, developing PL/SQL procedures and REST API integrations orchestrated through IBM webMethods.
  • Authored PL/SQL packages, procedures and complex queries; performed unit testing and coordinated deployment activities within JIRA sprints.
Oracle APEX 24.2Oracle DB 19cREST / JSONIBM MaximowebMethodsJIRAGitLab
Cargojet
Oracle APEX PL/SQL Developer
Mississauga, Canada
May 2022 – Nov 2024
  • Built and deployed 7 mobile & web applications for cargo operations — Live Load, Warehouse Acceptance, Quote App, Stations Management, Checklists, ULD Damage Report and Offloading — writing PL/SQL business logic, stored procedures and unit tests for each.
  • Served as technical lead for the KargoMine Operations module.
  • Delivered in Agile/Scrum sprints with cross-functional teams; produced BI Publisher and Jasper reports and maintained technical documentation.
Oracle APEX 22.1Oracle DB 19cJSON CLOBBI PublisherJasper ReportsJIRAGitHub
Oliver (formerly CDAT Systems)
Oracle APEX PL/SQL Developer
Burnaby, Canada
Jul 2017 – May 2022
  • Full-cycle development and maintenance of a SaaS benefits-management ERP (Group Benefits, Hour Bank, HSA, Pension).
  • Customized the Oracle Universal Theme for a bespoke look and feel; extended standard APEX behavior with JavaScript and CSS (fetch/AJAX background calls).
  • Built REST API integrations with Stripe, DocuSign and HR partners, and exposed selected data to partners via REST.
  • Administered Oracle 18c on AWS EC2 Linux — setup, tuning and deployment coordination.
Oracle APEX 20.2ORDSOracle DB 18cAWS EC2AOPJasper ReportsStripeDocuSign
VemPraCar Consórcios
Oracle APEX PL/SQL Developer · Freelance
Fortaleza, Brazil
Oct 2015 – Feb 2023
  • Designed and built a sales-management portal with sales, revenue and payroll/commission modules — an ERP-style system covering the full business workflow.
  • Administered the entire backend stack: AWS EC2 Linux instances, Oracle Database, Tomcat/ORDS application server and Jasper Server Community Edition.
Oracle APEX 20.1ORDS 18.1Jasper ReportsAWS EC2Tomcat
Casa Magalhães
Qt / QML C++ Developer
Fortaleza, Brazil
Jun 2015 – Jul 2016
  • Developed a cross-platform mobile POS product for retail customers (Windows and Android) using C++ and QML.
C++QML / QtAndroidWindows
Chubb Insurance of Brazil
Oracle PL/SQL, Forms & Reports Developer
São Paulo, Brazil
Feb 2012 – Aug 2014
  • Developed the System of Accepted Coinsurance using Oracle Forms & Reports 11g, handling complex business rules and multi-screen workflows.
  • Mainframe-to-Oracle migration: moved legacy data to Oracle 11g via PL/SQL — end-to-end extract, transform and load with full validation.
  • Built a multi-platform Data Conciliation System to reconcile records across insurance platforms; modeled the database with CA Erwin.
Forms & Reports 11gOracle DB 11gPL/SQLCA Erwin
Letter of recommendation on file
LiberCard
Oracle APEX Developer
Fortaleza, Brazil
Jan 2011 – Feb 2012
  • Maintained and enhanced the company ERP built on Oracle APEX 3.1 and Oracle Database 10g; developed new reports and control tools.
Oracle APEX 3.1Oracle DB 10gPL/SQL
Alejandro Informatics
Oracle PL/SQL, Forms & Reports Developer
Fortaleza, Brazil
Mar 2010 – Dec 2010
  • Oracle E-Business Suite 11i customization — adapted EBS for Brazilian legislation and NF-e (electronic invoicing), a large-scale ERP integration project.
  • Maintained a healthcare client's ERP on Oracle Forms & Reports 6i / Oracle 10g, and built a consultant time-tracking system in APEX 4.0.
  • Enhanced a Java desktop application (Swing, JPA, PostgreSQL); database design with CA Erwin.
Oracle EBS 11iForms & Reports 6iAPEX 4.0Java Swing / JPAPostgreSQL
Hapvida Health Care
Oracle PL/SQL, Forms & Reports Developer
Fortaleza, Brazil
Jun 2004 – Mar 2010
  • Analyzed and developed a CRM for the commercial department using Oracle Forms & Reports 6i and Oracle 9i.
  • Ongoing maintenance and new-feature development on the company's core financial ERP module.
Forms & Reports 6iOracle DB 9iPL/SQL
Uniodonto Fortaleza
Delphi Developer
Fortaleza, Brazil
Jun 2001 – Jun 2004
  • Analyzed and developed the financial module of the company's management system using Delphi 5 and MS SQL Server 2000, plus new features and reports on other modules.
Delphi 5MS SQL Server 2000CA Erwin

Certifications

Verified Oracle credentials

Oracle APEX Cloud Developer

Certified Professional · Oracle

Oracle PL/SQL Developer

Certified Associate (OCA) · Oracle

Python Programming

Certificate · FIAP

Languages

Spoken
PortugueseNative
EnglishFluent (professional)

Education

Academic & professional training
CV

Computer Vision — Post-Baccalaureate

STAR Research Institute, LLC · USA (online)
2026 – Present
AI

Artificial Intelligence

2-year program · FIAP, Brazil (online)
2024 – 2026
JV

Java SE Development

BCIT · Vancouver, Canada
2015
EN

English as a Second Language

Georgia College · Vancouver, Canada
2014 – 2015

Bachelor of Computer Science

Federal University of Ceará (UFC) · Brazil
2000 – 2003
Accent color
Appearance