Tania Lugo García

Database Administrator and Data Architect with over 25 years of experience designing, migrating, and supporting mission-critical database platforms — Oracle, SQL Server, PostgreSQL, MySQL, DB2, MongoDB, and Cloudera Hadoop — across telecom, automotive, insurance, and government sectors. Proven track record leading high-availability implementations (RAC, Data Guard, Golden Gate), large-scale cloud migrations (AWS, Azure), and enterprise data modeling initiatives. Combines deep hands-on DBA expertise with project and team leadership experience.

Oracle Cloud DBA / SQL Server DBA at ASTECI, S.A. de C.V. (2025-12 – Present)

• Lead database migration to AWS Cloud using AWS Database Migration Service (DMS).
• Refactor PL/SQL and T-SQL programs and database objects to improve performance.
• Set up Kafka Streams pipelines and design/program APIGee integrations.
• Create and modify stored procedures, functions, triggers, and views using T-SQL.
• Design data models, including table structures, key relationships, and entity-relationship diagrams.
• Develop ETL scripts for data extraction, transformation, and loading using tools such as bcp.
• Analyze query execution plans and design clustered/non-clustered indexing strategies to improve performance.
• Implemented data governance, data lineage, data quality in new development for customer database.

Azure Data Engineer & Oracle Cloud DBA at KOF, S.A. de C.V. (2025-02 – 2025-10)

• Gathered and integrated data from Oracle, PostgreSQL, and cloud platforms (AWS, Azure, GCP) via APIs.
• Developed and supported PL/SQL programs; monitored pipelines for anomalies and security issues.
• Led validation and migration of SAP ECC tables into the Azure Data Lake, resolving cross-system conflicts.
• Managed Oracle Cloud environments: patching, backup strategy, recovery, capacity planning, and DR plans.
• Used Informatica MDM for Master Data Management, Data Governance, and data quality on Azure Data Lake models.
• Optimized PostgreSQL queries and pipelines for performance.

Database Administrator at Hyundai Mexico, S.A. de C.V. (2021-04 – 2025-02)

• Served as Oracle and SQL Server Database Administrator across enterprise environments.
• Managed Python and Visual Studio development teams as Development Manager.

Database Administrator, Data Architect — Big Data (AWS) at Wipro Technologies, S.A. de C.V. (2021-01 – 2024-03)

• Led data migration to AWS and configured ETL pipelines within AWS.
• Managed Azure Data Migration Services and built AWS Glue jobs.
• Built Databricks jobs using Delta Lake and Spark SQL.

Database Administrator, Data Architect — Big Data at Experis Manpower, S.A. de C.V. (2019-10 – 2021-01)

• Installed, upgraded, and administered Oracle 12c/18c and Oracle RAC 12c environments.
• Implemented Oracle Data Guard and Golden Gate replication for high availability.

Database Administrator, Data Architect — Big Data at Addecco Solutions, S.A. de C.V. (2019-03 – 2019-10)

• Developed ETL processes in Pentaho Data Integration, Snowflake, and Daytona.
• Worked as a SAS Analytics developer.

Database Administrator, Data Architect — Big Data at RedStar Solutions, S.A. de C.V. (2018-02 – 2019-02)

Cloudera Hadoop on AWS EC2; Oracle 12c RAC & Golden Gate HA setup

Oracle & SQL Server DBA, Golden Gate at Misión Sistemas, S.A. de C.V. (2017-06 – 2018-01)

Oracle RAC/Data Guard/Golden Gate HA; SQL Server 2016 with TFS

Database Administrator at Harbinter Soluciones, S.A. de C.V. (2016-10 – 2017-06)

Oracle 12c HA environments; Cloudera Hadoop & MongoDB administration

Database Administrator at Darch, S.A. de C.V. (2016-03 – 2016-09)

Oracle 12c HA setup with Golden Gate; Oracle Gateway to SAP HANA

Database Administrator at INFOTEC, S.L. (2015-08 – 2016-03)

Oracle 12c & Exadata X5-2; Oracle/MongoDB migration; OEM 13c

Database Administrator at KODE Knowledge on Demand, S.A. de C.V. (2015-04 – 2015-06)

SQL Server 2005→2012 upgrade & performance tuning

Database Administrator – FLM Engineer at Comunicaciones Nextel de México, S.A. de C.V. (2013-05 – 2015-01)

PeopleSoft FSCM; Hadoop administration; DR planning for core telecom DB

IT Specialist – Database Administrator at Ibérica Telecomm, S.A. de C.V. (2012-09 – 2013-05)

Oracle, MySQL & SQL Server administration; Teradata support

Database Administrator at Harbinter Soluciones, S.A. de C.V. (2010-06 – 2012-09)

Oracle 11g RAC on ASM; Data Guard; large data-integration project

Database Administrator at Tata Consultancy Services (IMSS account) (2008-10 – 2010-05)

Oracle E-Business Suite support, upgrades, and performance tuning

Database Administrator at Softtek (2007-09 – 2008-09)

Oracle Data Guard DR administration; RMAN backup/recovery

Database Administrator & PeopleSoft SysAdmin at CONACYT (2003-09 – 2005-10)

PeopleSoft 7.5 implementation and administration

Database Administrator at ITESM Monterrey (2003-09 – 2003-09)

Security audit of Oracle databases and UNIX servers

Database Administrator & UNIX SysAdmin at MAXCOM (2000-11 – 2001-09)

Oracle & UNIX administration; OpenView monitoring

Database Administrator & Test Engineer at TELMEX (1997-10 – 2000-11)

Oracle administration; system testing

Database Administrator at IFE – RFE (1996-08 – 1997-10)

Oracle upgrade (v3.1 → 7); AIX system administration

Master of Computer Science in Computer Science – Center for Computing Research, Instituto Politécnico Nacional (2003)

Bachelor of Computer Science in Computer Science – Universidad Veracruzana (1996)