Jobs → Data & Analytics → GIS Database Migration Architect

About the Role We are seeking a GIS Database Migration Architect to lead technical discovery and assessment of enterprise Esri GIS environments. This role involves analyzing Oracle-to-PostgreSQL/PostGIS compatibility and developing migration strategies. Key Responsibilities • Lead technical discovery and assessment of enterprise Esri GIS environments • Analyze Oracle-to-PostgreSQL/PostGIS compatibility, dependencies, and migration risks • Assess geodatabase structures, spatial data types, Global IDs, attachments, versioning, and relationship classes • Map ETL workflows, integrations, APIs, scheduled jobs, and downstream dependencies • Evaluate ArcGIS Enterprise, Portal, ArcGIS Server, FME, Survey123, Power BI, and Spotfire integrations • Define data validation, reconciliation, cutover, rollback, and migration strategies • Recommend database governance, metadata, security, backup, and lifecycle standards • Develop a phased migration roadmap, technical runbook, risk register, and architecture documentation • Assess future Azure readiness and collaborate with cloud architecture stakeholders Requirements • 8+ years of GIS, spatial database, database architecture, or data migration experience • Oracle Enterprise Geodatabase migration assessment and planning • Advanced Oracle SQL, schema analysis, indexing, and query optimization • PostgreSQL / PostGIS architecture, spatial functions, indexing, and performance tuning • ArcGIS Enterprise 11.x, Portal for ArcGIS, ArcGIS Server, and ArcGIS Pro • Enterprise GIS concepts: Global IDs, attachments, relationship classes, versioning, and spatial references • ETL and integration tools: FME, Python, SQL, ArcPy, and APIs • Azure architecture fundamentals, including identity, networking, monitoring, backup, and resilience • Technical discovery, architecture documentation, risk assessment, and migration roadmap development