
Geoffer Lopez
Database Engineer | SQL Server | Oracle | DB2 | Postgres
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
