I am a seasoned Data Architect & Engineer with 15+ years of experience leading complex data and analytics initiatives across industries. I specialize in database design, migration, high availability, and secure cloud architectures, with a strong focus on GDPR compliance and data privacy. I enjoy bridging business needs with technical solutions and driving trusted, insight-driven decision making. In my career I have delivered multi-cloud database strategies, built scalable ETL pipelines, and implemented AI-enabled data platforms using Apache Spark, Airflow, and modern data lake technologies. I thrive in collaborative environments and enjoy mentoring teams to adopt best practices for reliability and performance.

Juan C. Farina

I am a seasoned Data Architect & Engineer with 15+ years of experience leading complex data and analytics initiatives across industries. I specialize in database design, migration, high availability, and secure cloud architectures, with a strong focus on GDPR compliance and data privacy. I enjoy bridging business needs with technical solutions and driving trusted, insight-driven decision making. In my career I have delivered multi-cloud database strategies, built scalable ETL pipelines, and implemented AI-enabled data platforms using Apache Spark, Airflow, and modern data lake technologies. I thrive in collaborative environments and enjoy mentoring teams to adopt best practices for reliability and performance.

Available to hire

I am a seasoned Data Architect & Engineer with 15+ years of experience leading complex data and analytics initiatives across industries. I specialize in database design, migration, high availability, and secure cloud architectures, with a strong focus on GDPR compliance and data privacy. I enjoy bridging business needs with technical solutions and driving trusted, insight-driven decision making.

In my career I have delivered multi-cloud database strategies, built scalable ETL pipelines, and implemented AI-enabled data platforms using Apache Spark, Airflow, and modern data lake technologies. I thrive in collaborative environments and enjoy mentoring teams to adopt best practices for reliability and performance.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more

Language

Spanish; Castilian
Fluent
English
Fluent
Portuguese
Intermediate

Work Experience

Database Architect – MySQL on AWS RDS Aurora at Umony
February 1, 2025 - November 2, 2025
Led multi-environment analysis (DEV, STAG, Q&A, PROD), created replicas across environments, migrated MySQL 5.7 to 8.0, advised CAB on production changes, provided BAU support for AWS RDS Aurora, addressed performance issues, defined a DR policy, and documented architectural changes for Aurora implementations.
DB Engineer (MariaDB and MSSQL) Production Support On-Premises and AWS at LexisNexis
December 31, 2024 - December 31, 2024
Managed migration planning and execution for ~5 TB databases from on‑prem to AWS; performed backups, tested recovery in TEST, replicated on-premise to AWS Aurora, and provided BAU support post-migration; created MIS reports and supported SQL Server and MariaDB environments.
Oracle Database Architect – Database Standardization Project at Schneider Electric
October 31, 2023 - October 31, 2023
Authored SoW and Reference Architecture for Oracle databases; defined operations reference cards; led Asset Management and discovery phases; established database standards across global environments.
Database Engineer - Software Engineer/PostgreSQL and Oracle MySQL DBA at DENSE AIR
April 30, 2023 - April 30, 2023
Configured PostgreSQL MySQL on-premise, AWS, and GCP; designed HA options (Patroni), implemented backups, set up PostgreSQL/MySQL HA, utilized PySpark for real-time processing, and built automation with PowerShell and Python.
Senior Python Backend Developer and DBA (MariaDB) at RAVENTRACK
July 31, 2022 - July 31, 2022
Created ETL reports with Python, Luigi and Pandas; analyzed slow queries, designed performance optimization tasks, and managed Azure database administration; integrated Azure-based apps and automation.
Senior Python Backend Developer at Tata Consultancy Services (TCS)
February 28, 2022 - February 28, 2022
Built MIS reports from database sources, launched data pipeline applications, developed Python apps to enhance data workflows, used PySpark for real-time processing, and prepared Ansible playbooks for deployments on-premises and GCP.
Senior DBA (MariaDB) and Python Backend Developer at Telrock
September 30, 2021 - September 30, 2021
Supported production, deployed on-premises and GCP databases via Ansible, migrated databases to GCP using DMS, automated maintenance with Python, implemented ETL pipelines, and established disaster recovery policies.
Database Engineer - Senior DBA (XtraDB Server) and Python Backend Developer at Statera Energy
May 31, 2021 - May 31, 2021
Deployed reliable database structures, implemented replication, created backup policies, built ETL procedures using SQL and Python, performed data analysis with Excel/PowerBI, and set up Airflow for task automation.
Python Backend Developer at Arcadia Group
December 31, 2020 - December 31, 2020
Reviewed and documented a Python test application; automated multi-unit tests and prepared a mechanism to run tests in UAT; used xlwings/pywinauto to interface with MS Excel and Windows apps.
Senior DBA and Python Backend Developer at comparethemarket
June 30, 2020 - June 30, 2020
Led migration from MongoDB Ops Manager to Atlas; performed MS-SQL Server monitoring; supervised Azure migrations and supported GDPR-related Python APIs for data export and reporting.
Python Backend developer and DB2 DBA at RSA Group
July 31, 2019 - July 31, 2019
Installed and configured PostgreSQL; HA implementations; ETL with Python (petl, Luigi, bonobo) and Pandas; implemented ABP address-based premium logic; GIS integrations with PostGIS; logging, and security hardening.
Database Production Support at TRADEWEB
September 30, 2018 - September 30, 2018
Supported Cassandra clusters, managed MS SQL Server deployments on Azure; automated admin tasks with Python; ensured 24x7 HA and Disaster Recovery readiness; documented architecture and failover procedures.
Database Production Support at YOOX NET-A-PORTER
March 31, 2018 - March 31, 2018
Production support for MySQL, PostgreSQL, MSSQL and MongoDB clusters; migration planning and execution; GDPR reporting APIs with Python; cluster design and HA/DR implementation.
MySQL and MariaDB DBA at O2 London
October 31, 2016 - October 31, 2016
Migrate databases to SSDs, manage cross-region replication, optimize performance, and adjust DB architecture for scale and HA.
MySQL and MariaDB DBA at EE London
August 31, 2016 - August 31, 2016
Production support, KPI definition, bottleneck analysis, migration planning, and HA/DR for Hybris on AWS RDS and on-premise deployments.
MySQL, MariaDB DBA at DVLA
May 31, 2016 - May 31, 2016
Migrations and administration for MySQL, MariaDB, MongoDB, and PostgreSQL; design and implement backup and DR plans; ensure HA and data integrity.
Database Architect at Kyndryl
September 1, 2025 - Present
Role focused on MySQL migration to AWS RDS Aurora, HA cluster design, on-premise HA cluster setup, DR policy, and multi-cloud SRE practices. Responsible for architecture reports, CAB changes, and production support for AWS/Azure/GCP database environments.
DB Engineer (MariaDB and MSSQL) at LexisNexis
January 1, 2024 - December 31, 2024
Production support for on-premises and AWS MySQL/MariaDB and MS-SQL databases; migration of ~5TB data using AWS DMS; creation of QA reports; BAU support and DR testing.
Oracle Database Architect at Schneider Electric
May 1, 2023 - October 31, 2023
Database Standardization project; design of reference architectures; asset management policy, and migration guidance.
Database Engineer - PostgreSQL/MySQL DBA at Dense Air
September 1, 2022 - April 30, 2023
Install/configure PostgreSQL and MySQL across On-Prem, AWS, GCP; setup HA with Patroni; backup strategies; PySpark-based real-time data processing; ArcGIS data migration considerations.
Senior Python Backend Developer at Tata Consultancy Services
October 1, 2021 - February 28, 2022
Senior Python backend development; data pipeline orchestration with PySpark for real-time processing; Ansible deployment to GCP/on-prem; documenting migration tasks and markdown docs.
Senior DBA (MariaDB) & Python Backend Developer at Telrock Systems
May 1, 2021 - September 30, 2021
Production support; Ansible deployment; migration to GCP, performance tuning, ETL pipelines in SQL/Python; disaster recovery planning; Airflow-based tasks for automation.
Database Engineer - Senior DBA (XtraDB) & Python Backend Developer at Statera Energy
February 1, 2021 - May 31, 2021
Deploy HA database structures; design ETL with SQL/Python; set up Airflow-based scheduling; implement DR and monitoring; ArcGIS data integration planning; BigQuery exploration for management reporting.
Senior DBA and Python Backend Developer at comparethemarket
August 1, 2019 - June 30, 2020
Migration from MongoDB Ops Manager to Mongo Atlas; MS-SQL Server monitoring; Python ETL for GDPR reports; database migration for 3TB+; BAU support post-migration.
Python Backend Developer & DB2 DBA at RSA Group
December 1, 2018 - July 31, 2019
PostgreSQL and DB2-related DB work; ETL with Python; GIS data considerations; Python-based GDPR reporting; PostgreSQL/DB2 migrations and DBA tasks.
Database Production Support at YOOX NET-A-PORTER
October 1, 2016 - March 31, 2018
MySQL, PostgreSQL, MSSQL, MongoDB production support; high availability; migration planning; Python/API development for GDPR data exports; cluster deployments.
MySQL/MariaDB DBA at DVLA
January 1, 2015 - May 31, 2016
Migrate and manage MySQL, MariaDB, PostgreSQL and MongoDB; design HA architectures; DR planning; BAU support and backups.
MySQL/MariaDB DBA at EUROFOODS
November 1, 2014 - December 31, 2014
Database architecture & development; clustering, replication; backups and DR planning; on-premises deployments.
MySQL & MongoDB DBA - Production Support at MASTERNAUT
May 1, 2014 - November 30, 2014
Migration team; database installation; backups and DR; MongoDB deployments; ETL from MongoDB and MySQL to data warehouse.
MySQL & MariaDB DBA at WONGA
April 1, 2014 - April 30, 2014
Production support; performance tuning; migration from Windows to Linux; replication setup and HA.
MySQL DBA at IPACCESS
December 1, 2013 - March 31, 2014
High-availability platform for 30k TPS; deployment across DEV/UAT/PROD; backup and DR; security controls.
MySQL DBA at Financial Times
August 1, 2013 - December 31, 2013
Migration planning (MySQL 5.0 to MariaDB 5.5); production migration; schema redesign; HA; DR; documentation.
MySQL/MSSQL DBA at WHIZZ Education
April 1, 2013 - July 31, 2013
MSSQL & MySQL DBA; production support; AWS Lambda testing; migration planning; partitioning; HA on AWS/RDS.
DBA at AIMIA
October 1, 2012 - April 30, 2013
DBA for MySQL, PostgreSQL, MongoDB; cloud deployments (AWS); data migration; backup policy; documentation; project management.
DBA at ECKOH Ltd
January 1, 2012 - September 30, 2012
DBA and Production Support for MySQL and MSSQL; cluster/replication; HA; documentation; out-of-hours support.
I+D DBA/Production Support at TELEFONICA
July 1, 2011 - December 31, 2011
Cloud computing project; cluster/replication design; data model design; HA; documentation; support for production deployments.
MSSQL and MySQL Production Support at SECURITAS DIRECT
May 1, 2008 - July 31, 2011
MSSQL and MySQL production support; HA strategies; backup policies; documentation; ISO 27001 alignment; DR planning.

Education

Degree in Systems Analysis at Universidad Católica-Paraguay
January 11, 2030 - November 2, 2025
University-Grade in Mathematics at UNED Spain
January 11, 2030 - November 2, 2025
Degree in Systems Analysis at Universidad Católica-Paraguay
January 11, 2030 - February 18, 2026
Grade in Mathematics at UNED Spain
January 11, 2030 - February 18, 2026

Qualifications

MCSE - Microsoft Certified Systems Engineer
January 11, 2030 - November 2, 2025
Oracle Certified Professional (MySQL Administration)
January 11, 2030 - November 2, 2025
MCSE - Microsoft Certified Systems Engineer
January 11, 2030 - February 18, 2026
Oracle Certified Professional (MySQL Administration)
January 11, 2030 - February 18, 2026

Industry Experience

Software & Internet, Financial Services, Telecommunications, Professional Services, Government, Media & Entertainment