Francisco is available for hire

Francisco Serra Sitja

Verified Expert in Engineering

Software Developer

Location

Coquitlam, BC, Canada

Toptal Member Since

January 26, 2022

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 the 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

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...

Petrobras

Oracle, Oracle Exadata, PL/SQL, SQL DDL, SQL Performance...

Experience

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

Availability

Full-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

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 Analyst

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 deployment of a complex application being migrated such that it reduced the expected downtime to less than a third and decreased the chance of error by manual intervention.
Coded procedures for 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.

Skills

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

Other

Programming, SQL Plus, 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

Tools

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

Paradigms

Business Intelligence (BI), UI Design, ETL

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

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.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

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