Luis is available for hire
Hire LuisLuis Patricio Moreno Buitrón
Verified Expert in Engineering
Enterprise Architect and BI Developer
Quito, Pichincha, Ecuador
Toptal member since December 13, 2022
Bio
Patricio is a TOGAF-certified Enterprise Architect, Master in IT Management, Master in Applied AI, Data Architect, Data Engineer, and multi-platform DBA with 25+ years of experience in enterprise architecture, cloud, databases, BI, integration, project management, and digital transformation. He combines strategic vision with deep technical expertise in AWS, Azure, Oracle, SQL Server, PostgreSQL, Snowflake, Databricks, SQL, Python, Power BI, and applied AI.
Portfolio
UNEMI
IT Management, Data Management, IT Project Management, Open Data, E-government...
Social Media Platform
SQL, Spark SQL, Apache Spark, Apache Airflow, Presto, Trino, Python, Superset...
LAHA Ventures, LLC
PostgreSQL, Supabase, Databases, Data Engineering, Data Analytics...
Experience
- Oracle - 20 years
- Business Intelligence (BI) - 15 years
- Linux - 15 years
- Enterprise Architecture - 10 years
- Platforms - 7 years
- IT Governance - 7 years
- Python - 5 years
- Data Engineering - 5 years
Preferred Environment
Enterprise Architecture, Business Intelligence (BI), IT Governance, Data Management, Data Engineering, Oracle DBA, Linux, Python, Microsoft Power BI, Artificial Intelligence (AI)
The most amazing...
...project I've delivered was the creation and startup of the BI area of the largest bank in Ecuador.
Work Experience
Postgraduate Professor
2025 - PRESENT
UNEMI
- Delivered graduate-level instruction on technology-driven public-sector transformation, integrating IT management, data management, IT project management, open data, e-government, and artificial intelligence into applied decision-making frameworks.
- Built practical assignments, evaluation rubrics, and case-based learning materials that helped postgraduate students translate emerging technology concepts into actionable improvement plans for public institutions.
- Mentored postgraduate professionals in analyzing digital government services, identifying technology capability gaps, and designing data- and AI-supported initiatives to improve institutional performance and service delivery.
Technologies: IT Management, Data Management, IT Project Management, Open Data, E-government, Artificial Intelligence (AI)
Data Engineer
2024 - PRESENT
Social Media Platform
- Designed and automated data pipelines using Apache Airflow, Python, SQL, Spark SQL, Apache Spark, Trino, and Presto to refresh large-scale analytical datasets on a recurring schedule.
- Delivered reliable, analytics-ready datasets in Amazon S3 with structured SQL-based transformations, supporting dashboarding, ad hoc analysis, and recurring business reporting across platform data domains.
- Built Superset charts and dashboards on top of governed datasets, improving stakeholder access to key metrics, operational insights, and periodic performance monitoring.
Technologies: SQL, Spark SQL, Apache Spark, Apache Airflow, Presto, Trino, Python, Superset, GitHub Copilot, GitHub, Amazon S3 (AWS S3), Helix, Snowflake
Data Strategy & Analytics Expert
2026 - 2026
LAHA Ventures, LLC
- Led a chunk-based Supabase and PostgreSQL modernization for The Wedding Ledger, delivering Chunk 1 through 10 SQL and validation scripts covering schema changes, backfill, governed cleanup, and production rollout.
- Translated an approved future-state design into a controlled migration path, moving Chunk 1 from planning through staging validation and production execution without a big-bang redesign.
- Redesigned the invoice, entitlement, and refund model by extending budget_files, entitlements, and refund_requests, then backfilled the new semantic fields using deterministic SQL logic.
- Planned and executed the cleanup of four deprecated invoice-related objects, including dependency analysis, controlled renaming, and final production removal while preserving active tables, columns, and data.
- Produced the full Chunk 1 delivery set—design, migration plan, staging validation summary, and final documentation—while incorporating stakeholder clarifications on refunds, entitlements, and invoice linkage.
Technologies: PostgreSQL, Supabase, Databases, Data Engineering, Data Analytics, Data Visualization, Cursor AI, Data Modeling, ChatGPT, DB
Undergraduate Professor
2009 - 2025
Universidad de las Américas
- Taught the Database Administration course as a professor for the cybersecurity engineering degree.
- Taught IT Management to undergraduate students.
- Instructed students in data analysis and visualization classes.
Technologies: Oracle DBA, MySQL DBA, PostgreSQL, SQL Server DBA, NoSQL, Amazon Web Services (AWS), MongoDB Atlas, IT Management, IT Strategy, COBIT, ITIL, TOGAF, Information Security, Digital Transformation, Data Warehousing, Data Lakes, Databricks, Microsoft Power BI, Big Data, IT Governance, Microsoft SQL Server, APIs, REST APIs, GitHub, Apache Kafka, Containers, Google BigQuery, DB
Python Developer
2024 - 2024
Boat Rocker Media Inc
- Evaluated the architecture and code of the current integration solution that the client had implemented.
- Developed the SQL statements to extract the data from the source system, based on the integration needs. Analyzed and tested the REST API of the target system.
- Developed a PoC (using the same technological Stack) as part of the proposal for a new integration solution that is simpler, more efficient, more scalable, and easier to maintain over time, based on the integration needs.
Technologies: Python, ETL, SQL, REST APIs, APIs, Linux, SSH, GitHub, Poetry, Containers, Docker Compose, Microsoft SQL Server, API Integration
Senior Database Administrator
2023 - 2023
L'Occitane - Main
- Stabilized the operation of the main database platform, through the implementation of good configuration, operation, and monitoring practices for SQL Server databases.
- Solved problems related to the execution of SSIS packages, as well as optimized the performance of some of them.
- Attended to requirements related to the operation, security, and availability of the database platform, including not only SQL Server databases but also Oracle, MariaDB, and MySQL.
- Responded to the audit requirements made by PwC staff on the administration and operation of the main database platform.
- Actively participated in the definition and execution of the migration strategy of the first group of databases to the Microsoft cloud, using the Azure SQL services.
Technologies: SQL, Oracle DBA, Database Administration (DBA), Databases, ETL, Microsoft DBA, MySQL DBA, MariaDB, Azure SQL, Data Pipelines, Azure, DB, Query Optimization, Database Security, Access Control, Backup & Recovery, Disaster Recovery Plans (DRP), Performance Tuning
MS Excel/VBA and Power BI Developer
2023 - 2023
Orlando Aguirre
- Helped the customer identify the most appropriate analytical requirements for real-estate cost analysis.
- Identified, analyzed, and understood the Excel sheets based on the analytical requirements previously defined, which will be the source data for real-estate cost analysis.
- Designed and implemented the data model in MySQL for the new transactional database that will contain real estate cost information.
- Designed a mockup with the preliminary version of the Power BI dashboard for the real-estate cost analysis.
Technologies: Data Engineering, Microsoft Excel, Reports, Dashboards, Excel VBA, Visual Basic for Applications (VBA), Microsoft Power BI, MySQL, Data Modeling, ETL
Data Engineer
2022 - 2023
Prodigy Education
- Built and maintained the different data pipelines for extracting, loading, and transforming all the required data for business users and customers.
- Executed the building and maintenance of different dbt models used by company analytical users.
- Developed and maintained jobs to synchronize the content of some tables of the Data Lake located in Databricks with their respective tables in Snowflake.
- Spearheaded the migration of some dbt models between the old Databricks production workspace and the new Databricks E2 workspace.
Technologies: Python, Apache Spark, PySpark, Databricks, Amazon Web Services (AWS), Apache Airflow, Snowflake, Data Build Tool (dbt), Datadog, Fivetran, Data Engineering, Data Lakes, Data Visualization, Reporting, APIs, Linux, ETL, SSH, REST APIs, GitHub, Amazon S3 (AWS S3), Data Pipelines, Spark, API Integration
DBA Engineer
2022 - 2022
BanEcuador
- Served as a database architect to define the deployment roadmap of the new MySQL 8 database platform.
- Carried out the installation and configuration of its new database platform with MySQL Enterprise 8 as a DBA specialized in MySQL.
- Migrated all databases from its infrastructure with MariaDB 5.5 to the new infrastructure with MySQL 8.
Technologies: MySQL Server, MySQL DBA, MariaDB, Database Architecture, Oracle Linux, Linux, SSH, Database Administration (DBA), DB, Query Optimization
IT Management Advisor
2019 - 2022
Pronaca
- Served as an IT management advisor for the IT strategic planning of 2021 and 2022 and for the realization of a SWOT for the IT infrastructure of the company.
- Acted as the enterprise architecture advisor focused on adopting this discipline.
- Oversaw the migration and upgrade of Pronaca's data warehouse and, subsequently, its migration from its on-premise environment to a private cloud at a Century Link data center.
- Performed health checks of the Oracle database of the company's ERP and acted as an expert DBA for SQL tuning.
- Assisted with the implementation of standby databases on Cascade using Oracle Data Guard in the new infrastructure of the ERP INFOR LN and for the implementation of Oracle ASM and Oracle RMAN in this new infrastructure.
- Implemented a local standby database for the second most critical database of the company, using Oracle Data Guard.
Technologies: Oracle DBA, Oracle Database, Oracle Database Architecture, Oracle RAC, Oracle Data Guard, Oracle RMAN, Oracle ASM, AIX, IT Strategy, TOGAF, Business Motivation Model (BMM), Business Model Canvas, COBIT, ITIL, IT Management, Oracle Cloud, IT Governance, Infor
DBA and Data Engineer
2021 - 2021
4Patriots
- Created, managed, and monitored the databases located in AWS Cloud.
- Managed the creation of the ETLs to consolidate the data needed for analytics and decision-making.
- Built data pipelines using AWS services to make the necessary data available to the company's data scientists.
- Developed a solution to identify and mask PII information stored in the company's databases.
- Built a solution to collect, process, and visualize the performance data for the company's most critical databases.
Technologies: Amazon Web Services (AWS), Amazon RDS, Amazon Aurora, Document Databases, AWS Well-Architected Framework, Amazon S3 (AWS S3), AWS Glue, AWS Lambda, Python, Pandas, Data Engineering, Data Visualization, Reporting, APIs, Linux, ETL, SSH, REST APIs, GitHub, Amazon Kinesis, Amazon Simple Notification Service (SNS), Data Pipelines, Database Administration (DBA), DB, Query Optimization
Data Engineer
2021 - 2021
Pronaca
- Identified the analytical specifications for the application performance Data Mart for application maintenance.
- Designed the data repositories and ETL layer for the application performance Data Mart for application maintenance.
- Implemented the ETL layer for the application performance Data Mart for application maintenance .
- Documented and released into production the application performance Data Mart for application maintenance.
Technologies: RHEL, PostgreSQL, Python, Pandas, Data Engineering, Server Migration, Linux, ETL, SSH, GitHub, API Integration
Multi-platform DBA
2021 - 2021
ARCERNNR
- Performed a health check of the Oracle databases of the agency for the regulation and control of energy and non-renewable natural resources to define the roadmap to improve their architecture, deployment, and operation.
- Completed a health check of the SQL Server and MySQL databases.
- Completed a health check of the DB2 and PostgreSQL databases.
Technologies: Oracle Database, Azure SQL Databases, MySQL Server, IBM Db2, PostgreSQL, Linux, AIX, Microsoft SQL Server, SSH, Database Administration (DBA), DB
Enterprise Architect
2021 - 2021
SERCOP
- Assisted a team of business architects in designing the new business architecture of the official state procurement system of the company.
- Formulated the business architecture of the official state procurement system, which included the roadmap for the systems' improvement.
- Defined the specifications for the new data architecture of the official state procurement system.
Technologies: TOGAF, ArchiMate, ADOIT, DMBoK, Architecture
DBA Engineer
2020 - 2020
Invitation Homes
- Executed a health check of the SQL Server databases in their production and UAT environments to establish a baseline for future improvements. Served as the SQL Server DBA on this project.
- Defined a new and more complete backup and recovery strategy for their SQL Server databases based on best practices and vendor recommendations.
- Deployed and managed a database monitoring solution for the SQL Server databases with IDERA products.
- Outlined a new framework for the company's database administration (vision, governance, architecture, deployment, monitoring, and improvement).
- Provided the necessary support in eventual issues related to the database platform.
Technologies: Azure SQL Databases, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), IDERA SQL Diagnostic Manager, IDERA SQL Safe Backup, IDERA SQL Query Tuner, IDERA SQL Workload Analysis, Windows, Microsoft SQL Server, SSH, GitHub, Azure, Database Administration (DBA), DB, Query Optimization
Cybersecurity Advisor
2020 - 2020
CPN
- Strengthened the IT infrastructure of the CPN, focusing on fraud prevention as the cybersecurity advisor.
- Defined a custom cybersecurity framework for CPN based on the NIST cybersecurity framework, ISO 27000, and COBIT 2019.
- Assessed the current cybersecurity controls of CPN and defined a roadmap for improving them.
Technologies: NIST, Cybersecurity, ISO 27001, ISO 27002, COBIT, Database Security
Database Engineer
2020 - 2020
IFTH
- Served as a PostgreSQL and Db2 DBA for the health check of critical databases.
- Performed the definition and execution of the improvement roadmap for the critical databases of the institution.
- Executed the recovery procedures for some critical databases after suffering unavailability events.
Technologies: Oracle DBA, Platforms, PostgreSQL, IBM Db2, Database Architecture, Linux, SSH, Database Administration (DBA), DB, Database Security
Scrum Master and Database Expert
2020 - 2020
Registro Mercantil Quito
- Improved the institution's data model by serving on the project as a scrum master.
- Improved the institution's data model serving as their expert SQL Server DBA.
- Led the technical team in consolidating information stored in MySQL and SQL Server databases into PostgreSQL.
Technologies: Scrum, Scrum Master, SQL Server DBA, PostgreSQL, MySQL Server, Server Migration, Windows, DB
Associate IT Consultant
2019 - 2020
Business IT
- Performed as a BI architect for a project in Color Republic to define its BI deployment architecture with SQL Server, SSIS, SSAS, SSRS, and DQS. As the data engineer, I designed the ETL layer's architecture for its new Data Warehouse.
- Acted as an instructor for workshops about COBIT 2019 for customers.
- Taught enterprise architecture in a TOGAF 9 workshop for the consulting staff of business IT in preparation for a project.
- Provided performance tuning support for customers as the SQL Server DBA in charge of the project.
- Developed a course on SQL database infrastructure for the IT staff of Universidad San Francisco de Quito.
Technologies: TOGAF, COBIT, Azure SQL Databases, SQL Server DBA, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL, Data Quality, MDM, Business Intelligence (BI), IT Governance, Data Engineering, Microsoft SQL Server, ETL, SSH, DB
Database Engineer and RPA Engineer
2019 - 2020
Hospital Vozandes de Quito
- Implemented a standby database with Oracle Data Guard 11g R2 for the current core of the Hospital Vozandes.
- Installed a database cluster with oracle RAC for the new core of the hospital.
- Provided a workshop for the DBAs team on the implemented infrastructure.
- Implemented RPA-based proofs-of-concept using UiPath to automate administrative, operational, and accounting processes in a hospital setting.
Technologies: Oracle Database, Oracle RAC, Oracle Data Guard, Server Migration, Linux, SSH, Robotic Process Automation (RPA), UiPath, Database Administration (DBA), DB
Enterprise Architect
2018 - 2020
Bayteq CIA. LTDA.
- Validated, for UTPL, the integration model of the new academic ERP with its legacy systems.
- Assessed and proposed initiatives and projects to improve IT support for business needs as an enterprise architect.
- Acted as a cloud and application architect to define road maps to improve the application management at UTPL.
Technologies: TOGAF, XML, JSON, REST, Talend ETL, Talend ESB, Talend Cloud Integration, NoSQL, PMBOK, DMBoK, Google Cloud Platform (GCP), Azure, Amazon Web Services (AWS), Oracle Cloud, Architecture, REST APIs
Associate IT Consultant
2018 - 2020
Businessmind Chile
- Performed, for Empresas Banmedica, the migration of the Oracle databases of six clinics between data centers with minimum downtime and applying Oracle MAA.
- Assessed the middleware platform of ENTEL SA, composed of Oracle WebLogic Server and Oracle Service Bus. I proposed initiatives and projects to improve it.
- Instructed the technical team of the Chilean air force in Oracle WebLogic Server 11g administration essentials.
- Managed a course on the adoption of SOA and architecture fundamentals for SODIMAC.
- Provided several customers with specialized consulting on architecture and health checks for Oracle databases.
Technologies: Oracle Database, Oracle RAC, Oracle Data Guard, Oracle Cloud, Oracle Fusion Middleware, Oracle WebLogic Application Server, Oracle Service Bus (OSB), Enterprise Service Bus (ESB), Service-oriented Architecture (SOA), Server Migration, Linux, SSH, REST APIs, DB
Associate Oracle Instructor
2017 - 2020
BesTechnology Group
- Instructed the courses on the Oracle Database learning path taken for the team of developers of IESS.
- Spearheaded the Oracle Linux 7 advanced administration course and the advanced SQL workshop for Fybeca.
- Provided a workshop on WebLogic Server basic administration for PetroEcuador and virtual courses on Oracle Database 12c R2 administration for Banco de Machala.
- Taught the courses Java EE 6 and web application development with JSF for Cancillería, and Oracle Solaris 11 system administration for Cooperativa Jardín Azuayo.
Technologies: Oracle Database, Oracle Solaris, Oracle Linux, Java EE (Jakarta EE), JSF, Linux, DB
Oracle University Certified Instructor
2007 - 2020
Oracle University
- Taught courses on all Oracle Database learning paths to clients from Ecuador, Venezuela, Colombia, Peru, and Chile.
- Taught courses on all Oracle Fusion Middleware learning paths to clients from Ecuador, Venezuela, Colombia, Peru, and Chile.
- Taught all courses on the Oracle Linux learning path to clients from Ecuador, Venezuela, Colombia, Peru, and Chile.
- Taught all courses on the Oracle Solaris learning path to clients from Ecuador, Venezuela, Colombia, Peru, and Chile.
Technologies: Oracle Database, Oracle Fusion Middleware, Oracle Solaris, Oracle Linux, Linux, REST APIs, DB, Query Optimization
Associate IT Consultant
2019 - 2019
Xenturion IT
- Performed as a certified instructor for Banco del Pacífico for a web application development workshop with Oracle JDeveloper.
- Served as a certified instructor for Banco del Pacífico for a basic administration workshop of Red Hat Enterprise Linux 7.
- Collaborated with the sales area of the company as a pre-sales consultant.
Technologies: Oracle WebLogic Application Server, Red Hat Linux, Linux, SSH, DB
Enterprise Architect
2018 - 2019
RConsulting Group
- Participated in the project “The Architecture Model of Information Systems and Technology Platforms and the Interoperability of Applications” at Coordinador Eléctrico Nacional of Chile as a business and application architect.
- Contributed to the definition of the portfolio of initiatives and projects to implement the company's new architecture model of information systems and technology platforms.
- Contributed to the definition of the new interoperability model for the company's applications.
Technologies: TOGAF, Application Lifecycle Management (ALM), Service-oriented Architecture (SOA), Business Analysis Body of Knowledge (BABOK), Architecture
Enterprise Architect
2018 - 2019
Seguros del Pichincha
- Defined the operational model and the organizational structure of the new IT department of Seguros del Pichincha.
- Advised the company on the assessment of information management's current practices.
- Defined the portfolio of initiatives and projects to improve information management in the company.
Technologies: DMBoK, Information Lifecycle Management (ILM), MDM, Business Intelligence (BI), COBIT, SFIA, IT Governance, Architecture
Associate IT Consultant
2018 - 2019
Conecta
- Provided a WebLogic Server basic administration workshop for the IT staff of Universidad San Francisco de Quito.
- Implemented a high-availability solution for Banco Pichincha with SQL Server failover clustering.
- Acted as a SQL Server DBA for the migration and improvement of the database infrastructure of Seguros Pichincha.
Technologies: Oracle DBA, SQL Server DBA, Oracle Database, Oracle WebLogic Application Server, Oracle Fusion Middleware, Oracle, Infrastructure, Linux, SSH, DB
Associate IT Consultant
2016 - 2019
Businessmind Corp
- Provided advanced PL/SQL workshops for CNT and building composite applications with Oracle SOA Suite 12c for Banco Bolivariano.
- Instructed Fybeca's DBAs team in Oracle Enterprise Manager Cloud Control.
- Supported Banco Bolivariano with Oracle WebLogic and as an Oracle Service Bus architect.
- Executed preventive maintenance on the Oracle RAC infrastructure installed at INDECOPI in Peru and implemented improvements to their Oracle WebLogic infrastructure.
- Installed all the environments of the Oracle Service Bus platform at Banco Bolivariano.
- Taught Java EE 6 web development with JAX-WS and JAX-RS, SOA adoption, and SOA architecture fundamentals at Banco del Pacífico.
- Installed the quality and production environments for the web, integration, implementation, and reporting layers at La Positiva Perú, using Oracle Web Tier, Oracle WebLogic Server, and Oracle BI Publisher.
Technologies: Oracle Database, SQL, Oracle PL/SQL, Oracle WebLogic Application Server, Oracle Service Bus (OSB), Oracle RAC, Oracle Enterprise Manager (EM), Oracle BI Publisher, Oracle SOA Suite, Enterprise Service Bus (ESB), Java EE (Jakarta EE), JAX-RS, JAX-WS, Service-oriented Architecture (SOA), Server Migration, Linux, ETL, SSH, REST APIs, DB
Data Architecture and Database Management Specialist
2018 - 2018
Agencia Nacional de Tránsito
- Defined the high-availability architecture of the agency databases and the policies for database security and administration.
- Defined an action plan for the adoption of best practices for the management of database backups.
- Diagnosed and defined the roadmap to improve the current situation of the core database.
Technologies: Oracle DBA, Oracle Database, Oracle RAC, Oracle WebLogic Application Server, TOGAF, Oracle Database Tuning, Oracle Database Architecture, Oracle Data Guard, Architecture, Server Migration, Linux, SSH, Database Administration (DBA), DB, Query Optimization, Database Security
Enterprise Architect
2018 - 2018
ESOFT
- Analyzed the management feasibility of the CENACE core systems to identify possible replacements or improvements.
- Instructed the EMAP business and technical staff in TOGAF 9 fundamentals.
- Acted as project manager for the project of surveying the processes of Cobiscorp’s Cobis operational model.
Technologies: TOGAF, Business Model Canvas, Business Analysis Body of Knowledge (BABOK), PMBOK, Business Motivation Model (BMM), Architecture
Associate Oracle Consultant
2017 - 2018
IT Cabarique
- Implemented the Oracle WebLogic 12c new platform at Banco D-Miro and provided them workshops on its deployment and management.
- Implemented a new middle-layer platform for Almacenes Jaher using Oracle WebLogic 12c, Forms, and Reports.
- Supported Telefónica Ecuador on the migration project of its billing core which was deployed in Oracle WebLogic, Oracle SOA Suite and Oracle Service Bus.
Technologies: Oracle WebLogic Application Server, WebLogic Diagnostic Framework (WLDF), WLST, Oracle Forms, Oracle Reports, Oracle SOA Suite, Oracle Service Bus (OSB), Linux, SSH, Database Administration (DBA), DB, Query Optimization
Associate IT Consultant
2017 - 2018
SeventeenMile S.A.
- Oversaw the technical team in OpenKM deployment projects.
- Migrated the DMS information stored in PostgreSQL to the OpenKM database in MySQL for the municipal company EMGIRS.
- Created a Java-XML API to load DINARDAP's database content to the RMDMQ system, consuming a web service from a SQL Server database.
- Deployed and administered the SQL Server, MySQL, and PostgreSQL databases in the OpenKM projects.
Technologies: Oracle DBA, Platforms, SQL Server 2016, PostgreSQL, MySQL Server, Java, XML, Web Services, OpenKM, Windows, Microsoft SQL Server, Linux, DB
Database Security Specialist
2017 - 2017
Ministerio del Ambiente, Agua y Transición Ecológica
- Identified the current vulnerabilities of SUIA's project databases.
- Diagnosed vulnerabilities of SUIA's project databases, comparing them with the best practices and vendor recommendations.
- Defined the portfolio of initiatives and projects to improve the security level of SUIA's project databases.
Technologies: PostgreSQL, TOGAF, Linux, Database Administration (DBA), DB, Database Security, Access Control
Data Architecture Specialist
2017 - 2017
SENPLADES
- Established strategies for the design, operation, monitoring, and platform security for the company's Oracle and PostgreSQL databases, utilizing enterprise architecture.
- Defined a procedure to address the requirements of direct queries, the updates on the Oracle and PostgreSQL databases, and the policies for capacity management, configuration management, and requirements management for the databases.
- Defined the Oracle 12c database and CentOS hardening standards for the company and a policy for the databases administration.
- Formulated a proposal to improve the current design of data replication from SRI to SENPLADES.
- Diagnosed the current deployment of Oracle Enterprise Manager Cloud Control and proposed recommendations.
- Designed a periodic mechanism to collect their databases' processor, memory, disk, and network statistics.
- Created and implemented pre-production environments for the databases.
- Defined and executed the technical capacity generation plan for the company's database administrators.
- Diagnosed the current audit status configured in the Oracle databases and proposed recommendations.
- Developed instructions to enable the auditing of the databases.
Technologies: Platforms, Oracle DBA, PostgreSQL, Oracle Database, Oracle Enterprise Manager (EM), CentOS, TOGAF, Architecture, Linux, SSH, Database Administration (DBA), DB, Query Optimization
Associate Oracle Consultant
2017 - 2017
Eserv
- Executed a health check on the Oracle WebLogic infrastructure of the port authority of Puerto Bolívar (APPB) at Machala Ecuador.
- Provided a workshop on the new features of Oracle database 12c for the DBAs of Hospital Vozandes.
- Delivered a workshop on the new features of Oracle database 12c for the DBAs of Diners Club.
Technologies: Oracle Database, Oracle WebLogic Application Server, Linux, SSH, DB
Technical Consultant
2016 - 2017
Registro de la Propiedad del Distrito Metropolitano de Quito
- Participated in the complete modernization of Registro de la Propiedad as the team's technical leader.
- Prepared the technical deliverables for the modernization program.
- Assessed the architecture of the real and personal folios registry system.
- Defined and implemented a methodology for the tests.
- Managed the team migration of legacy data from MySQL to SQL Server as the expert DBA overseeing the project.
Technologies: MySQL DBA, SQL Server DBA, SQL Server 2016, MySQL Server, Java, XML, TOGAF, Server Migration, Windows, DB
Postgraduate Professor
2015 - 2017
Universidad de las Américas (UDLA)
- Oversaw the Management of New Technologies course for a master's degree in IT management.
- Served as director of the master's degree program in IT administration.
- Assisted in evaluating the degree work of students for their master's degree in IT administration.
Technologies: IT Management, IT Governance, Enterprise Architecture, IT Service Management (ITSM), Data Management, Innovation, IT Project Management, DB
Associate Oracle Consultant
2016 - 2016
Refundation Consulting Group
- Provided Oracle Forms support to Hospital Metropolitano de Quito.
- Offered Oracle PL/SQL support to Colegio Americano de Quito.
- Gave technical and methodological support on Oracle Forms to Agencia de Regulación y Control de Hidrocarburos.
Technologies: Oracle Database, Oracle PL/SQL, Oracle Forms, Linux, SSH, DB
IT Architecture Responsable
2012 - 2016
Banco Pichincha C.A.
- Served as a product owner and enterprise architect. I was in charge of the information domain for adopting the enterprise architecture system at Banco Pichincha.
- Formulated the enterprise architecture of Banco Pichincha with tools such as BMM, BABoK, and TOGAF.
- Acted as a data architect for creating the BI Area of Banco Pichincha and managed one BI architect.
- Participated in the selection of the provider of the new administrative-financial ERP and participated as an enterprise architect in implementing the ERP Oracle E-Business Suite (EBS).
- Defined the guidelines for the management and use of information at Banco Pichincha.
- Redesigned the data architecture for reporting solutions, managed the migration of ETLs and reports, and built them with SQL Server, SSIS, SSAS, and SSRS.
- Defined the methodology for the selection and purchase of software.
- Created a plan for using database products included in the first Oracle unlimited license agreement in Ecuador, signed between Banco Pichincha and the Oracle Corporation.
- Oversaw the new architecture and consolidation of the Oracle and SQL Server databases of Banco Pichincha as an Oracle and SQL Server DBA.
- Monitored and controlled the impact of the projects planned and executed on the bank's enterprise architecture.
Technologies: Oracle DBA, SQL Server DBA, SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL, Data Quality, Data Management, Transact-SQL (T-SQL), Oracle Database, Oracle EBS, XML, REST, Azure, SAS, IBM WebSphere, IBM InfoSphere, TOGAF, COBIT, ITIL, Scrum, PMBOK, DMBoK, Business Analysis Body of Knowledge (BABOK), Business Motivation Model (BMM), Business Model Canvas, Business Intelligence (BI), Service-oriented Architecture (SOA), Oracle PL/SQL, IT Governance, Architecture, Server Migration, Windows, Microsoft SQL Server, Linux, DB
Consulting Services Manager
2007 - 2012
BusinessMind S.A.
- Managed the consulting services area and supervised almost 50 consultants.
- Provided SOA, ESB, CEP, BPM, BI, and IT architecture expertise as a project manager, IT auditor, and enterprise architect.
- Acted as a certified Oracle technologies expert, consultant, and instructor.
- Developed and implemented the workflow of the QMS for an electricity distribution company.
- Created and implemented the POC of the integration of databases via Oracle Enterprise Service Bus for a telecommunications company.
- Implemented analytical solutions with SQL Server, SSIS, SSAS, SSRS, and DQS for several customers.
- Acted as the principal consultant for SQL Server and MySQL database administration services.
- Managed customer projects and services using Oracle Primavera software.
Technologies: Oracle DBA, SQL, Oracle, Oracle Internet Directory (OID), Oracle Database, Oracle ADF, Oracle WebLogic Application Server, Oracle Enterprise Manager (EM), Oracle Fusion Middleware, Oracle Business Process Management (BPM), Oracle Designer, Oracle Discoverer, Oracle BI, Oracle EBS, Oracle JDeveloper 12c, Oracle Application Express (APEX), Oracle Data Integrator (ODI), Oracle Workflow, SQL Server DBA, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Quality, Transact-SQL (T-SQL), MySQL, Java, XML, Quality Management Systems (QMS), Service-oriented Architecture (SOA), BPM, Complex Event Processing (CEP), Business Intelligence (BI), TOGAF, PMBOK, Cloud Computing, Oracle RAC, Oracle Data Guard, Oracle Database Tuning, Oracle Database Architecture, Oracle PL/SQL, Oracle Forms, Oracle Reports, Server Migration, BizTalk Server, Oracle Primavera, Database Administration (DBA), DB, Query Optimization, Backup & Recovery, Disaster Recovery Plans (DRP), Performance Tuning
Technical Trainer
2005 - 2010
Centro de Estudios para la Comunidad
- Oversaw the learning path of Oracle databases.
- Managed the learning path of applications development with Java.
- Ran the learning path of Linux Fundamentals and Administration course.
Technologies: Oracle DBA, Java, Oracle PL/SQL, Linux, Linux Administration, SQL, DB
Undergraduate Professor
2001 - 2008
Escuela Politécnica Nacional
- Taught courses on databases.
- Taught courses on database administration.
- Taught courses on distributed databases.
Technologies: Databases, DB
Oracle Consultant
2006 - 2006
Banco Interamericano de Desarrollo
- Developed the risk and credit analysis functionality for the SISSEC 2.0 system for the Ministry of Economy and Finance of Ecuador.
- Installed all the infrastructure required to implement the risk and credit analysis functionality for the SISSEC 2.0 system for the Ministry of Economy and Finance of Ecuador.
- Implemented the requested improvements to the risk and credit analysis functionality for the SISSEC 2.0 system for the Ministry of Economy and Finance of Ecuador.
Technologies: Oracle Database, Oracle ADF, Oracle JDeveloper 12c, Oracle PL/SQL, Java, DB
Oracle Consultant
1999 - 2006
Kruger Corporation
- Served as an Oracle engineer and DBA on more than 30 projects.
- Developed the purchasing workflow for a TV company.
- Managed the tax management workflow for a customer.
- Acted as an IT auditor, solutions architect, and project manager.
- Created the data warehouse for the taxpayer information collection.
- Customized and implemented one of the first management information data marts in Ecuador.
- Developed and implemented the payroll, asset management, accounting, and bank systems for several clients.
Technologies: Oracle Database, Oracle ADF, Oracle Forms, Oracle Reports, Oracle Designer, Oracle Discoverer, Oracle Workflow, Oracle Application Server, SQL, Oracle PL/SQL, Business Intelligence (BI), Oracle DBA, Server Migration, DB
Oracle Consultant
1997 - 1999
Gestor Inc.
- Implemented the following modules to the company's trust management system general accounting system: Contract management for trusts, property management for trusts, and management of guarantees for trusts.
- Provided Oracle engineering, Oracle DBA, and project leadership services.
- Supervised five consultants in projects for the most important banks in Ecuador.
Technologies: SQL, Oracle PL/SQL, Oracle Database, Oracle Forms, Oracle Reports, Oracle Designer, Oracle DBA, DB
Oracle Instructor
1997 - 1998
Oracle Ecuador
- Performed as an Oracle instructor for Oracle SQL courses.
- Acted as an Oracle instructor for Oracle PL/SQL courses.
- Served as an Oracle instructor for Oracle Database courses.
Technologies: Oracle PL/SQL, Oracle Database, SQL, DB
Oracle Engineer
1996 - 1997
ISSFA
- Analyzed the process modeling and database design of an air force hospital's admission and billing system.
- Developed and implemented ISSFA's reserve fund, integrated payroll, human resources, and health insurance systems.
- Served as an Oracle engineer, Oracle DBA, data analyst, and intranet administrator.
Technologies: SQL, Oracle Database, Oracle Forms, Oracle Reports, Oracle Designer, Oracle DBA, Oracle PL/SQL, DB
Experience
Implementation of BI for a Bank
I was the data architect for a large bank and acted as the counterpart of the international consultant for the creation and startup of the BI unit in that financial institution. I was in charge of the implementation of the IBM data model for financial data warehouses, the definition of the bank's BI architecture, the establishment of the operating model of the BI unit, and the definition of the catalog of BI services that would be offered to the business areas of the bank.
Design of Enterprise Architecture of a Large Public Procurement System
I was part of the team of enterprise architects who generated a model that conceptually and technically supports the implementation of the client's transformation strategy in terms of business and technology.
The project's specific objectives were to:
-Identify improvements at the level of business processes, governance, information systems, procedures, and current regulations, which must be considered for a new implementation of the applications that support the company.
-Define the new data architecture with which information management can be improved.
-Identify the new architectural plan of the applications that support the company and from which the transition strategies of the current applications can be defined.
-Define a new deployment architecture for applications in accordance with the technological infrastructure of the client.
-Identify the current and future situation of the architecture, determine the gap, and establish the respective roadmap.
The project's specific objectives were to:
-Identify improvements at the level of business processes, governance, information systems, procedures, and current regulations, which must be considered for a new implementation of the applications that support the company.
-Define the new data architecture with which information management can be improved.
-Identify the new architectural plan of the applications that support the company and from which the transition strategies of the current applications can be defined.
-Define a new deployment architecture for applications in accordance with the technological infrastructure of the client.
-Identify the current and future situation of the architecture, determine the gap, and establish the respective roadmap.
Data Mart APM
A Data Mart and ETL solution for the consolidation of data about application monitoring taken from the APM tool database of a company. The solution encompasses four components: Extraction, transformation, load, and utility components.
Data Masking Solution
An application to mask the data of the databases of a USA company according to the PII regulation. The application has two components: A programmatic component to execute a PII scanning of the databases to detect PII data and a programmatic component to complete the masking of the PII data detected.
Database Performance Monitor Framework
A solution framework to obtain metrics about the performance of the AWS Autora database instances and generate performance reports. The framework has the following component: A repository for the collected metrics, a component to connect to the database instances to collect the metrics defined, a component to generate the diagnostics based on the variations of the metrics collected, and a component that will generate performance reports.
Migration with Minimal Downtime of Critical Databases
Oracle database migration between data centers and six clinics that are part of a healthcare and insurance company. The databases in question are classified as critical, so the defined migration strategy was based on Oracle MAA. It was oriented to minimize downtime, with which it was possible to migrate each database in an average time of 15 minutes.
Education
2024 - 2026
Master’s Degree in Applied Artificial Intelligence in Artificial Intelligence
Universidad de las Américas - Quito, Ecuador
2011 - 2014
Master’s Degree in Systems Management and Information Technologies in Information Technologies
Universidad de las Américas - Quito, Ecuador
1991 - 1999
Bachelor’s Degree in Systems Engineering in Systems Engineering
Escuela Politécnica Nacional - Quito, Ecuador
Certifications
SEPTEMBER 2022 - PRESENT
The Data Bootcamp: Transform your Data using dbt™
Udemy
AUGUST 2022 - PRESENT
Data Engineering using Databricks on AWS and Azure
Udemy
AUGUST 2022 - PRESENT
Learn DBT from Scratch
Udemy
AUGUST 2022 - PRESENT
Data Warehouse: The Ultimate Guide
Udemy
JULY 2022 - PRESENT
Apache Airflow: A Real-time & Hands-on Course on Airflow
Udemy
JULY 2022 - PRESENT
Snowflake Cloud Data Warehousing Basics to Advanced Concepts
Udemy
JULY 2022 - PRESENT
Databricks and Apache Spark for Big Data: From Zero to Expert
Udemy
JUNE 2022 - PRESENT
Big Data for Managers
Udemy
JUNE 2022 - PRESENT
Executive Briefing: Big Data and the Hadoop Ecosystem
Udemy
JUNE 2022 - PRESENT
The Complete SQL Bootcamp 2022: Go from Zero to Hero
Udemy
JUNE 2022 - PRESENT
Big Data with Apache Spark 3 and Python: From Zero to Expert
Udemy
JUNE 2022 - PRESENT
Agile Fundamentals Including Scrum and Kanban
Udemy
MAY 2022 - PRESENT
Git for Geeks: Quick Git Training for Developers
Udemy
MAY 2022 - PRESENT
Power BI & Business Intelligence 2022
Udemy
APRIL 2022 - PRESENT
Linux for Cloud & DevOps Engineers
Udemy
MARCH 2022 - PRESENT
The Data Analyst Course: Complete Data Analyst Bootcamp 2022
Udemy
MARCH 2022 - PRESENT
Docker Crash Course for Busy DevOps and Developers
Udemy
FEBRUARY 2022 - PRESENT
AWS Cloud Practitioner Training
Amazon Web Services
FEBRUARY 2022 - PRESENT
DevOps and CI/CD (Continuous Integration and Delivery) for Beginners
Udemy
FEBRUARY 2022 - PRESENT
The DevOps Essentials: The Handbook
Udemy
JANUARY 2022 - PRESENT
Google Cloud Platform (GCP) Fundamentals for Beginners
Udemy
APRIL 2020 - PRESENT
Oracle Certified Associate
Oracle
SEPTEMBER 2019 - PRESENT
Certified Scrum Master
Asociación Iberoamericana de Scrum
FEBRUARY 2017 - PRESENT
Microsoft Certified Professional
Microsoft
NOVEMBER 2015 - PRESENT
COBIT Foundation
APMG International
JULY 2015 - PRESENT
Oracle Certified Professional
Oracle
MARCH 2015 - PRESENT
Oracle Certified Associate
Oracle
DECEMBER 2014 - PRESENT
ITIL Foundation
Axelos
JULY 2013 - PRESENT
TOGAF 9 Certified
The Open Group
APRIL 2010 - PRESENT
Oracle PL/SQL Developer Certified Associate
Oracle
Skills
Libraries/APIs
Pandas, REST APIs, JAX-RS, JAX-WS, PySpark, Spark ML, Spark Streaming, NumPy
Tools
Oracle Forms, Oracle Reports, Oracle Designer, Oracle Workflow, Oracle JDeveloper 12c, Oracle RAC, Oracle Business Process Management (BPM), Oracle BI Publisher, Oracle SOA Suite, WLST, ArchiMate, Apache Airflow, GitHub, Oracle Internet Directory (OID), Oracle Application Express (APEX), MongoDB Atlas, Microsoft Power BI, Talend ETL, ADOIT, AWS Glue, Docker Swarm, Docker Compose, Docker Hub, Git, Bitbucket, Spark SQL, Microsoft Excel, Amazon Simple Notification Service (SNS), Superset, GitHub Copilot, Helix, ChatGPT
Languages
Python, SQL, Transact-SQL (T-SQL), Java, XML, Snowflake, SAS, Excel VBA, Visual Basic for Applications (VBA)
Frameworks
TOGAF, COBIT, COBIT 5, Oracle ADF, WebLogic Diagnostic Framework (WLDF), JSF, AWS Well-Architected Framework, Apache Spark, Jinja, Spark Structured Streaming, Spark, Presto, Trino
Paradigms
Oracle Database Architecture, ETL, Scrum, Business Intelligence (BI), Service-oriented Architecture (SOA), ITIL, REST, Application Lifecycle Management (ALM), PMBOK, DevOps, Agile, Kanban, Dimensional Modeling, Continuous Integration (CI), Continuous Delivery (CD)
Platforms
Oracle, Linux, Oracle Database, Oracle Enterprise Manager (EM), Oracle Linux, CentOS, Red Hat Linux, Amazon Web Services (AWS), Oracle Data Integrator (ODI), Windows, Oracle Application Server, Databricks, Azure, IBM WebSphere, Java EE (Jakarta EE), Google Cloud Platform (GCP), AIX, AWS Lambda, Docker, Apache Kafka, Azure Synapse
Storage
Databases, Oracle DBA, Oracle PL/SQL, SQL Server DBA, MySQL, PostgreSQL, MySQL Server, Oracle Database Tuning, Azure SQL Databases, Database Architecture, MariaDB, SQL Server Management Studio (SSMS), Database Security, Database Administration (DBA), Data Pipelines, DB, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), NoSQL, Data Lakes, SQL Server 2014, SQL Server 2016, JSON, Amazon Aurora, Amazon S3 (AWS S3), Database Performance, Oracle Cloud, IBM Db2, Datadog, Document Databases, Microsoft SQL Server, Microsoft DBA, Azure SQL
Industry Expertise
Cybersecurity
Other
IT Governance, Enterprise Architecture, Platforms, Data Engineering, IT Projects, Information Technology, IT Management, Oracle Discoverer, Oracle WebLogic Application Server, Linux Administration, MySQL DBA, IT Strategy, Data Warehousing, Oracle Data Guard, Oracle RMAN, Oracle ASM, RHEL, Data Warehouse Design, Architecture, Server Migration, SSH, Query Optimization, Access Control, Backup & Recovery, Disaster Recovery Plans (DRP), Performance Tuning, Data Management, Software Engineering, IT Project Management, Cloud Computing, DMBoK, Oracle Fusion Middleware, Oracle BI, BPM, Oracle Solaris, IT Service Management (ITSM), Innovation, Containerization, Information Security, Digital Transformation, Business Analysis Body of Knowledge (BABOK), Business Motivation Model (BMM), Business Model Canvas, Oracle Service Bus (OSB), Web Services, Information Lifecycle Management (ILM), SFIA, Scrum Master, Enterprise Service Bus (ESB), NIST, ISO 27001, ISO 27002, ITIL 4, Amazon RDS, ITIL V3 Foundation Certified, Dashboards, Data Transformation, Reporting, APIs, Infrastructure, Containers, API Integration, Large Language Models (LLMs), OpenAI, Oracle EBS, Quality Management Systems (QMS), Complex Event Processing (CEP), Big Data, IBM InfoSphere, OpenKM, MDM, Talend ESB, Talend Cloud Integration, IDERA SQL Diagnostic Manager, IDERA SQL Safe Backup, IDERA SQL Query Tuner, IDERA SQL Workload Analysis, Data Build Tool (dbt), Fivetran, Scrumban, ELT, Slowly Changing Dimensions (SCD), Azure Databricks, Data Visualization, Data Cleansing, Data Cleaning, Data Analysis, Big Data Architecture, Data Profiling, Directed Acrylic Graphs (DAG), Data Marts, Data Quality, IBM Banking Data Warehouse (BDW), ETL Tools, Cloud, Tools, Reports, Data Modeling, Amazon Kinesis, Poetry, Infor, BizTalk Server, Robotic Process Automation (RPA), UiPath, Oracle Primavera, Google BigQuery, Open Data, E-government, Artificial Intelligence (AI), Supabase, Data Analytics, Cursor AI, Applied AI, Machine Learning, Natural Language Processing (NLP), Responsible AI, Vibe Coding, Agentic AI
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