Jobs → Data & Analytics → GIS Database Migration Architect

About the Role We are seeking a GIS Database Migration Architect to lead technical assessments and compatibility analysis for migrating from Oracle to PostgreSQL/PostGIS in a Lower 48 Esri Enterprise Geodatabase environment. Key Responsibilities • Lead current-state technical assessment for the in-scope Esri Enterprise Geodatabase environment, including Oracle database, ArcGIS Enterprise/Portal services, ETLs, source systems, and downstream consumers. • Create and maintain an inventory of candidate databases, schemas, tables, feature classes, layers, services, schedules, interfaces, and ownership information. • Perform Oracle-to-PostgreSQL/PostGIS compatibility analysis across schemas, data types, date and time handling, sequences and identifiers, spatial references, geometry behavior, indexing, constraints, privileges, and performance considerations. • Evaluate Esri library and platform-functionality gaps between current Oracle/Esri implementation and proposed PostgreSQL/PostGIS target. • Determine how attachments, related records, Global IDs, relational integrity, and service dependencies can be preserved and validated. • Identify technical gaps, migration blockers, assumptions, decisions, and remediation options. • Assess feasibility and implications of parallel operations, dual-write ETL patterns, reconciliation, rollback, and phased cutover approaches. • Work with GIS Operations Lead to understand operational workflows, service criticality, support patterns, outage tolerance, and sequencing constraints. • Define validation and reconciliation approaches for data completeness, schema conformance, spatial accuracy, service behavior, and downstream connectivity. • Contribute database-layer recommendations for ETL governance, naming, metadata, lineage, spatial reference and datum standards, access, change control, backup, retention, and lifecycle management. • Produce clear diagrams, inventories, findings, decision matrices, risk registers, and executive-ready recommendations. • Present findings to technical and business stakeholders and incorporate review feedback while maintaining alignment to the agreed assessment scope. Requirements • Expertise in GIS database technologies, particularly Esri Enterprise Geodatabase environments. • Strong knowledge of Oracle and PostgreSQL/PostGIS databases. • Experience with database migration projects, including schema conversion and data type mapping. • Understanding of ETL processes and data integration techniques. • Familiarity with GIS operations and workflows. • Ability to lead technical assessments and compatibility analysis. • Strong analytical and problem-solving skills. • Excellent communication and presentation abilities.