Francisco Serra Sitja，加拿大BC省高贵林的开发者
Francisco is available for hire
Hire Francisco

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拥有超过15年的Oracle数据库经验. 他的专长包括后端应用程序开发, refactoring, data modeling in OLTP and OLAP, Linux环境中的应用程序体系结构和数据库管理, 支持和配置Oracle RAC中的数据库, including database migrations, data masking for sensitive data, database patching, and more.

ProgrammingData ModelingOraclePL/SQLSQLOracle PL/SQLPL/SQL DeveloperOracle Database TuningData AnalysisData EngineeringData VisualizationOracle RACBusiness Intelligence (BI)Oracle SQL DeveloperData WarehousingSAP BWOracle Real Application Clusters (RAC)Oracle ExadataOracle FormsABAPToadDatabase Administration

Availability

Full-time

Preferred Environment

PL/SQL Developer, SQL Plus, Oracle SQL Developer

The most amazing...

...我完成的任务是数据库迁移和整合，在三天内持续了近50个小时.

Work Experience

Database Administrator

2019 - 2022
Insurance Corporation of British Columbia
  • 维护数据库和操作系统的两年一次的补丁计划. Negotiated with stakeholders, scheduled and executed technical work, 并与开发者进行沟通和跟进.
  • 提供专业的SQL调优建议，并与开发人员合作进行故障排除和调试. 经常修复会超时且不能工作的代码，并在短时间内使其正常工作, 节省了数百小时的开发预算.
  • 监控数据库和各自备份的状态，及时解决未解决的问题. 主动改进资源密集型SQL, often with gains of 1,000 times or more, 减少客户服务电话和管理成本.
Technologies: Oracle, Oracle RAC，数据库管理，SQL性能, 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
不列颠哥伦比亚省森林、土地和自然资源运营部
  • 对包含敏感数据的数百个表进行自动数据屏蔽.
  • 在Oracle企业管理器中使用RMAN Catalog历史数据对BI Publisher进行统一备份监控.
  • 对正在迁移的复杂应用程序进行自动化部署，从而将预期停机时间减少到三分之一以下，并减少人工干预造成的错误机会.
  • 为DevOps团队编写程序，在不同环境之间自动部署, 消除了DBA手动部署代码的需要，并赋予开发人员管理其部署的自主权.
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

应用数据库管理员(DBA) |数据库架构师

2012 - 2016
Petrobras
  • 领导一个小型IT团队，将SLA响应时间从30到90分钟缩短到10分钟. 在不扩大团队的情况下，将每月解决的门票从500多张增加到1200多张.
  • 用于审计特权DBA会话和对敏感数据的SQL查询的自动化Sarbanes-Oxley (SOX)控件.
  • 通过重新建模数据库表和迁移数据，将全国各地的区域数据库整合为一个中央数据库, 哪些能显著降低基础设施成本.
Technologies: Oracle, Oracle Exadata, PL/SQL, SQL DDL, SQL性能, 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
  • 通过整合来自巴西所有13个主要炼油厂的数据，自动化了人力资源报告解决方案.
  • 将一套商业智能解决方案从专有工具迁移到SAP业务仓库(BW), 每年节省超过100万美元的维护合同和Oracle云基础设施的托管成本.
  • 为下游精炼业务交付了两个首个在SAP BW上上线的企业数据仓库项目.
  • 为财务部门提供了公司第一个基于HANA解决方案的SAP BW, 将税收计算过程从一天缩短到不到一个小时.
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
  • 修改了一个应用程序，为具有复杂改造的投资引入新的税收计算，以在相对较短的时间内适应政府机构的法律要求.
  • 交付了一个新投资基金的原型. Led a multidisciplinary team, including senior accounting, securities, insurance, asset management, and IT. 向公司的高级副总裁赞助商展示原型.
  • 主动重构和调优现有PL/SQL代码，以降低复杂性, improve readability, simplify maintenances, and reduce the execution time of jobs. 设计和构建Oracle表单、报表应用程序及其相应的api.
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

Stack Overflow Oracle

这个项目是我在业余时间做的. 在Stack Overflow上，我通过回答有关SQL和PL/SQL编码解决方案的问题来支持其他Oracle数据库开发人员. 这是我早期在Oracle社区论坛中产生的热情，也是通过帮助他人来学习新技能的一种方式.

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

2000 - 2006

Bachelor's Degree in Computer Science

南里奥格兰德州联邦大学(UFRGS) -巴西阿雷格里港

FEBRUARY 2012 - PRESENT

SAP认证应用助理-商业智能与SAP NetWeaver 7.0

SAP

FEBRUARY 2012 - PRESENT

SAP认证应用助理- SAP HANA.0

SAP

JULY 2010 - PRESENT

Oracle数据库11g数据仓库认证实施专家

Oracle

NOVEMBER 2009 - PRESENT

Oracle高级PL/SQL开发人员认证专业人员

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

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

1

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
3

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring