Jorge Delgado

Data Engineer

Aera Technology

Aug 2021 - Current (4 years 10 months)

working with Snowflake, python, airflow and github, here I create and support ETL pipelines to extract data from different sources and moving this data through csv, json and parquet files, transform and cleaning data with Python (Pandas) and load it into Snowflake tables using snowpipe and tasks,DAGs created to orchestrate this are created with airflow.

Application DBA

Infosys

Aug 2020 - Aug 2021 (1 year 1 month)

working with Altice USA oracle database versions 11-19c on premise and cloud with Oracle Cloud Infrastructure, golden gate tool managed to replicate data information from SaaS to PaaS, and ETL jobs that move information from Oracle to Postgres DB, daily operation, troubleshooting, SQL code and application support, new deployments and patches,also involved in project implementing Kafka in Google Cloud

C

Database Architect

Cadena Comercial Oxxo, SA. de CV:

Mar 2014 - Jul 2015 (1 year 5 months)

performance tuning approach, project data encryption for new reforms, Oracle DBA support level 3 (the highest) in Mexico and Colombia, working with 9i, 10g, 11g and 12c versions with environments Standalone and RAC under platforms Exadata, HP-UX, AIX, Oracle Linux, Red Hat and Solaris. Oracle DBA with 10g version, giving international support under platforms UNIX/Linux (AIX 5.x, 6.x , Solaris 10, Red Hat 6), performance tuning approach and designing the new database solutions. Project manager activities, migration SAP Business One to new cloud platform. Oracle DBA working with 10g and 11g versions under Windows platform, I redesigned the databases and implement new process to ensure the good performance in the database. Recruitment to apply

G

Database Architect

Getic S.A. de C.V.

Jan 2008 - Jul 2015 (7 years 7 months)

Assigned to OXXO installed the news DBs and applications to deploy Oracle Retail Suite, which involve Fusion Middleware (weblogic 12c), Oracle DBs (12c) and GoldenGate (12.3), checking, testing and applying best practices, DB and App support and daily activities, also I implemented golden gate in a RAC environment with different architectures (unidirectional, broadcast and cascading), also compared replication versus other tools like Shareplex 8.6 & 9 and Mimix. I worked in other tasks like automating tasks, data replication, benchmarks of performance, migrations heterogeneous, data guard, installation of patches and daily support as requested, also I implemented delphix tool that helps to create new environments in short time, in this time

About

Detail

Timeline

Résumé