Francisco Serra Sitja, Developer in Coquitlam, BC, Canada
Francisco is available for hire
Hire Francisco

Francisco Serra Sitja

Verified Expert  in Engineering

Bio

Enthusiastic about SQL and PL/SQL coding, performance tuning, and Oracle database architecture, Francisco has over 15 years of experience with Oracle databases. His expertise includes back-end application development, refactoring, data modeling in OLTP and OLAP, application architecture and database administration in Linux environments, support and provisioning databases in Oracle RAC, including database migrations, data masking for sensitive data, database patching, and more.

Portfolio

Susquehanna Technology Management, Inc. (STMI) - Main
Oracle PL/SQL, Oracle, SQL, ETL, Data Warehousing
Insurance Corporation of British Columbia
Oracle, Oracle RAC, Database Administration (DBA), SQL Performance...
British Columbia Ministry of Forests, Lands, and Natural Resource Operations
Oracle, Oracle Multitenant, Oracle Exadata, RMAN...

Experience

  • SQL - 17 years
  • PL/SQL Tuning - 15 years
  • SQL Performance - 15 years
  • PL/SQL - 15 years
  • Oracle - 15 years
  • Oracle PL/SQL - 15 years
  • Oracle Database Tuning - 7 years
  • Oracle RAC - 4 years

Availability

Part-time

Preferred Environment

PL/SQL Developer, SQL Plus, Oracle SQL Developer

The most amazing...

...assignment I've completed was a database migration and consolidation that lasted nearly 50 hours over three days.

Work Experience

Oracle Database Engineer

2022 - 2024
Susquehanna Technology Management, Inc. (STMI) - Main
  • Added new functionality to incorporate foreign currency calculation into two different compliance solutions.
  • Developed a new compliance reporting solution, loading data, optimizing for performance due to high volumes, and validating business requirements.
  • Oversaw periodic execution of critical reporting processes. Improved and documented process execution, particularly redesigning and streamlining XML file generation PL/SQL packages and procedures.
  • Rewrote extensive legacy code in PL/SQL to migrate its underlying tables and views to utilize the new data model, validating backward compatibility and functional results between versions.
Technologies: Oracle PL/SQL, Oracle, SQL, ETL, Data Warehousing

Database Administrator

2019 - 2022
Insurance Corporation of British Columbia
  • Maintained a bi-yearly patching schedule for databases and operating systems. Negotiated with stakeholders, scheduled and executed technical work, and communicated and followed up with developers.
  • Provided expert SQL tuning advice and partnered with developers in troubleshooting and debugging. Often fixed code that would time out and not work and made it functional on short notice, saving hundreds of hours of the development budget.
  • Monitored the status of databases and respective backups and promptly resolved outstanding issues. Proactively improved resource-intensive SQL, often with gains of 1,000 times or more, reducing calls to customer service and administration costs.
Technologies: Oracle, Oracle RAC, Database Administration (DBA), SQL Performance, PL/SQL Tuning, Oracle Enterprise Manager (EM), RMAN, Jira, SQL Plus, Programming, Databases, Linux, SQL DDL, Oracle SQL Developer, SQL, Data Modeling, Oracle PL/SQL

Database Administrator

2018 - 2019
British Columbia Ministry of Forests, Lands, and Natural Resource Operations
  • Automated data masking for hundreds of tables with sensitive data.
  • Consolidated backup monitoring with BI Publisher in Oracle Enterprise Manager using RMAN Catalog historical data.
  • Automated the deployment of a complex application being migrated, reducing the expected downtime to less than a third and decreasing the chance of error by manual intervention.
  • Coded procedures for the DevOps team that automated deployment between environments, eliminating the need to have DBA manually deploy code and giving autonomy to developers to manage their deployment.
Technologies: Oracle, Oracle Multitenant, Oracle Exadata, RMAN, Oracle Enterprise Manager (EM), SQL DDL, SQL Performance, PL/SQL, Neo4j, Jira, Toad, PL/SQL Tuning, Database Administration (DBA), Oracle RAC, SQL Plus, Programming, Databases, Linux, SQL, Oracle BI Publisher, Oracle PL/SQL

Application Database Administrator (DBA) | Database Architect

2012 - 2016
Petrobras
  • Headed a small IT team in improving SLA responsiveness from between 30 and 90 minutes to 10 minutes. Increased tickets resolved from over 500 per month to over 1,200 on average without growing the team.
  • Automated Sarbanes-Oxley (SOX) controls for auditing privileged DBA sessions and SQL queries to sensitive data.
  • Consolidated regional databases across the country into a central database by re-modeling database tables and migrating data, which significantly decreased infrastructure costs.
Technologies: Oracle, Oracle Exadata, PL/SQL, SQL DDL, SQL Performance, Oracle Database Tuning, Jira, Toad, Database Modeling, PL/SQL Tuning, Oracle RAC, SQL Plus, PL/SQL Developer, Programming, Databases, SQL, Data Modeling, Data Engineering, Data Analysis, Oracle PL/SQL

Business Intelligence Developer

2008 - 2012
Petrobras
  • Automated the HR reporting solution by consolidating data from all 13 major Brazilian refineries.
  • Migrated a suite of business intelligence solutions from a proprietary tool into SAP Business Warehouse (BW), saving over one million yearly in maintenance contracts plus hosting costs in Oracle Cloud Infrastructure.
  • Delivered two first enterprise data warehouse projects to go live on SAP BW for the downstream refining business.
  • Delivered the first SAP BW on the HANA solution in the company for the fiscal department, improving tax calculations from a day-long process to less than one hour.
Technologies: SAP Business Warehouse (BW), SAP BW on HANA, Oracle, ETL, ABAP, Data Warehousing, SAP BusinessObjects (BO), Database Modeling, PL/SQL Tuning, SQL Performance, Programming, Databases, SQL DDL, SQL, Business Intelligence (BI), Data Modeling, Data Engineering, Data Visualization, Data Analysis, Dashboards, Oracle PL/SQL

Systems Analyst

2005 - 2008
Previ
  • Modified an application to introduce a new tax calculation for investments with complex remodeling to accommodate a government agency's legal requirements within a relatively short period of time.
  • Delivered a prototype of a new investment fund. Led a multidisciplinary team, including senior accounting, securities, insurance, asset management, and IT. Presented the prototype to top VP sponsors in the company.
  • Refactored and tuned existing PL/SQL code proactively to reduce complexity, improve readability, simplify maintenances, and reduce the execution time of jobs. Designed and built Oracle Forms, reporting applications, and their respective APIs.
Technologies: Oracle, SQL, PL/SQL, PL/SQL Tuning, Oracle Designer, Oracle Forms, Oracle Reports, Database Modeling, SQL Performance, PL/SQL Developer, Programming, Databases, SQL DDL, UI Design, Data Modeling, Data Visualization, Data Analysis, Oracle PL/SQL, Oracle Forms & Reports

Experience

Stack Overflow Oracle

This project is something I worked on in my free time. I supported other Oracle database developers on Stack Overflow by answering questions about coding solutions in SQL and PL/SQL. This is an early passion I developed in Oracle community forums and a way to learn new skills by helping others.

Education

2000 - 2006

Bachelor's Degree in Computer Science

Federal University of Rio Grande do Sul (UFRGS) - Porto Alegre, Brazil

Certifications

FEBRUARY 2012 - PRESENT

SAP Certified Application Associate – Business Intelligence with SAP NetWeaver 7.0

SAP

FEBRUARY 2012 - PRESENT

SAP Certified Application Associate – SAP HANA 1.0

SAP

JULY 2010 - PRESENT

Oracle Database 11g Data Warehousing Certified Implementation Specialist

Oracle

NOVEMBER 2009 - PRESENT

Oracle Advanced PL/SQL Developer Certified Professional

Oracle

SEPTEMBER 2009 - PRESENT

Oracle PL/SQL Developer Certified Associate

Oracle

SEPTEMBER 2009 - PRESENT

Oracle Database SQL Certified Expert

Oracle

Skills

Tools

SQL Plus, Oracle RAC, Oracle Exadata, RMAN, Jira, Toad, Oracle Designer, Oracle Forms, Oracle Reports, Oracle BI Publisher

Languages

SQL DDL, SQL, ABAP

Platforms

Oracle, Oracle Enterprise Manager (EM), SAP HANA, Linux

Storage

PL/SQL Developer, PL/SQL, Oracle Database Tuning, Database Modeling, Oracle PL/SQL, Oracle SQL Developer, Database Administration (DBA), Oracle Multitenant, Databases, SQL Performance, Neo4j

Paradigms

Business Intelligence (BI), UI Design, ETL

Other

Programming, PL/SQL Tuning, Data Modeling, SAP Business Warehouse (BW), Data Engineering, Data Visualization, Data Analysis, Algorithms, Operating Systems, Complexity Theory, SAP BW on HANA, Data Warehousing, SAP BusinessObjects (BO), Dashboards, Oracle Forms & Reports

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