Saltar al contenido principal
Geoffer Lopez

Geoffer Lopez

Database Engineer | SQL Server | Oracle | DB2 | Postgres

Talento
Heredia20000 CRC/horaMiembro desde 22 de octubre de 2026
IBM DB2PostgreSQLAlwaysOn Availability GroupsOracle RACOracle Data GuardQuery StoreQuery OptimizationAWS RDS for SQL Server & PostgreSQLDockerAWS DMSPL/SQLConfluence
·

Contrata sus servicios

Solicitá un presupuesto sin compromiso

Sobre mí

Senior database engineer with 20 years of production ownership across SQL Server, Oracle, DB2 and PostgreSQL, and a long record of leading migrations and upgrades for global companies in logistics, financial services, healthcare and technology.

Has run migrations end to end: assessing the source environment, building a production-like test bed, writing the runbook, executing the cutover and tuning afterwards, with minimal downtime and no data loss. Used to leading DBA teams through the work while staying hands-on for the riskiest pieces, and to keeping application owners, infrastructure teams and business stakeholders informed along the way. Now extending that on-premises migration experience to the cloud through hands-on work with AWS RDS SQL Server.

Experiencia

Corporate Database Administrator at DSV (2021-11 – 2026-05)

  • Led the upgrade of a critical AlwaysOn platform from SQL Server 2016 to SQL Server 2022 with no disruption to users or clients, first building a test environment that replicated production and validating the migration there.
  • Support over 1,200 SQL Server and Oracle instances (largest database above 15 TB) by application, business impact and severity, and turned that into SLAs.
  • Led SQL Server Reporting Services (SSRS) migrations.
  • Tuned CargoWise One (SQL Server) and CargoWrite (Oracle 19c), the company's core logistics platforms, using Query Store, blocking analysis and OEM to fix bad execution plans and deadlocks.
  • Forecast storage growth and resource consumption with recurrence-pattern analysis and an internally built AI-assisted forecasting tool, used to size environments ahead of demand.
  • Recovered a critical database in under ten minutes after a failure broke synchronization between primary and secondary nodes, with no data loss.
  • Administered AlwaysOn Availability Groups and Oracle Data Guard; ran backups, restores and disaster recovery tests with Commvault backup software.
  • Automated Oracle 19c statistics gathering with shell scripts and documented procedures as runbooks in Confluence.

Global Database Administrator at Eurofins (2020-04 – 2021-10)

  • Designed and documented the standard procedures for SQL Server migrations and upgrades that global teams adopted, making migrations repeatable and lowering operational risk.
  • Found and resolved bottlenecks in critical enterprise applications using Oracle AWR and performance baselines.
  • Coordinated changes and incidents with infrastructure and application teams across several countries.

Corporate Database Administrator at Panalpina World Transport (2018-02 – 2020-04)

  • Database upgrades across SQL Server.
  • Trained the Lisbon Center of Excellence on SQL Server 2017 on Linux and AlwaysOn Availability Groups.
  • First member of the Costa Rica database team; worked with my manager to organize the follow-the-sun shift distribution and took part in interviewing candidates as the team grew.

Database SQL Developer at 3Pillars / Intel (2017-08 – 2017-11)

  • Worked on the Downtown Database migration project in an Agile/Scrum team: technical analysis, functional documentation and transition procedures for the support teams taking over.

Database Engineer at Fiserv (2016-07 – 2017-06)

  • Supported migration and technology decommissioning projects for strategic clients under tight timelines.
  • Validated database upgrade scripts through a Microsoft TFS pipeline before production releases of digital banking platforms.
  • Planned application upgrades together with application teams and developers.
  • Tightened change management procedures, improving traceability and control of production changes.

DBA Level 2, Level 3, Senior Project DBA at Hewlett-Packard Enterprise (2008-01 – 2016-04)

  • Led Oracle, SQL Server and DB2 migration and upgrade projects for clients across the Americas and Europe in high-availability environments, working with the Canada Project Management team.
  • Subject matter expert for strategic clients such as Delphi Automotive and Republic Tobacco, leading database installations, migrations and upgrades.
  • Cut a critical query from three hours to five minutes for a multinational client through AWR and ADDM analysis.
  • Rebuilt the DBA operations unit after a reorganization through onboarding and 1-on-1 coaching, restoring Level 2 support capacity in 8 weeks.
  • Patched and maintained Oracle RAC and Data Guard; owned incidents, changes and problems across more than 300 servers in North America and Europe.
  • Internal IBM DB2 instructor for the database area.

Professor at Universidad Hispanoamericana (2011-01 – 2011-08)

Developer & Application DBA at Vehículos Internacionales S.A. (VEINSA) (2000-04 – 2007-11)

  • Key player in the back-office modernization from AS/400 to client-server (MS Access/VB) and then to Oracle Database, covering both DBA and development work across four business modules.
  • Developed and supported PL/SQL enterprise applications; brought response times from about 90 seconds to under 5 seconds through Oracle query optimization.

Educación

PMI Project Management Ready (in progress) (2026-06)

Master's Degree in Information Technology Resource Management – Universidad Interamericana de Costa Rica

Bachelor's Degree in Computer Systems Engineering – Universidad Interamericana de Costa Rica

Habilidades

Database EngineerSQL ServerOracleDB2Postgres

Valoraciones

Relacionado