A subsidiary site of a global agribusiness brand was running on Drupal 9 / Pantheon with 188 legacy URLs containing a deprecated subsection prefix bleeding into Google Search Console as duplicate content. The same site needed hreflang implementation for its international language variants and a hover-preview regression that was exposing legacy URLs at the database level.

URL cleanup: Scoped and shipped across four phases via Dev → Test → Live on Pantheon. Sitemap regeneration was blocked by a stale alltech_plugins hook bug — unblocked by dropping a url_generators config override. 188 legacy URL patterns removed and validated in GSC. Hreflang implementation: Implemented across all language variants with proper x-default fallback. Validated across GSC and submitted for re-crawl.

Database remediation: The hover-preview regression required surgical multi-table DB rewrites — legacy URLs were embedded in serialized link field data across field_button_link, field_learn_more_link, and field_link, each with different column conventions (_value vs _uri). Resolved via direct DB migration scripts over SSH. Stack at a glance: CMS: Drupal 9 Hosting: Pantheon Deploy: Multi-environment SSH + Drush SEO: Hreflang + x-default, GSC validation DB: Direct migration scripts across 3 serialized link field tables Auth: RSA SSH key

Skills: Drupal · Technical SEO · Hreflang · International SEO · SSH · Drush · Database Migration · URL Migration · Pantheon · Multi-language SEO · Enterprise SEO