Francisco Serra Sitja, Software Developer in Coquitlam, BC, Canada
Francisco Serra Sitja

Software Developer in Coquitlam, BC, Canada

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.
Francisco is now available for hire

Portfolio

Experience

Location

Coquitlam, BC, Canada

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.

Employment

  • 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 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, 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

  • Bachelor's Degree in Computer Science
    2000 - 2006
    Federal University of Rio Grande do Sul (UFRGS) - Porto Alegre, Brazil

Certifications

  • SAP Certified Application Associate – Business Intelligence with SAP NetWeaver 7.0
    FEBRUARY 2012 - PRESENT
    SAP
  • SAP Certified Application Associate – SAP HANA 1.0
    FEBRUARY 2012 - PRESENT
    SAP
  • Oracle Database 11g Data Warehousing Certified Implementation Specialist
    JULY 2010 - PRESENT
    Oracle
  • Oracle Advanced PL/SQL Developer Certified Professional
    NOVEMBER 2009 - PRESENT
    Oracle
  • Oracle PL/SQL Developer Certified Associate
    SEPTEMBER 2009 - PRESENT
    Oracle
  • Oracle Database SQL Certified Expert
    SEPTEMBER 2009 - PRESENT
    Oracle

To view more profiles

Join Toptal
Share it with others