Job Summary
The Senior GIS Database Migration Architect will serve as the primary technical lead for an enterprise Oracle-to-PostgreSQL/PostGIS GIS migration assessment. This hands-on role focuses on technical discovery, current-state analysis, architecture, documentation, compatibility assessment, and migration roadmap development for a large Esri Enterprise Geodatabase environment. The engagement will identify dependencies, compatibility risks, migration blockers, and remediation options while developing a phased migration roadmap and runbook. This phase is assessment-focused; production migration execution is out of scope.
Key Responsibilities
• Lead technical discovery and current-state assessment of the in-scope Esri Enterprise Geodatabase environment, including Oracle databases, ArcGIS Enterprise/Portal services, ETLs, source systems, and downstream consumers.
• Create and maintain inventories of candidate databases, schemas, tables, feature classes, layers, services, schedules, interfaces, and ownership information.
• Analyze Esri geodatabase constructs and relational dependencies, including spatial data types, domains, subtypes, relationship classes, attachments, Global IDs, attribute rules, versioning, and related behaviors that must be preserved or redesigned.
• Validate environment documentation through stakeholder interviews, metadata reviews, SQL analysis, service inspection, and limited exploratory testing in the existing PostgreSQL/PostGIS development environment.
• Assess Oracle-to-PostgreSQL/PostGIS compatibility risks across schemas, data types, date and time handling, sequences and identifiers, spatial references, geometry behavior, indexing, constraints, privileges, and performance.
• Evaluate Esri library and platform functionality gaps between the current Oracle/Esri implementation and the 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, clearly distinguishing confirmed findings from items requiring client validation.
• Assess the feasibility and implications of parallel operations, dual-write ETL patterns, reconciliation, rollback, and phased cutover approaches without executing a production migration.
• Document ETLs, source systems, schedules, transformation logic, and consuming services for candidate layers.
• Identify and flag dependencies and reconnection risks involving ArcGIS Portal, Survey123, FME, Spotfire, Power BI, APIs, scheduled jobs, and other real-time or batch consumers.
• Collaborate with the 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.
• Support the definition of future-state data-domain ownership and an operating model that reduces unmanaged data and service sprawl.
• Translate assessment evidence into practical architecture decisions, standards, decision logs, risks, and remediation priorities.
• Ensure recommendations align with supported Esri, PostgreSQL/PostGIS, security, networking, monitoring, resilience, and operational requirements.
• Own the technical content of a phased migration roadmap and runbook covering wave planning, sequencing, prerequisites, resource needs, validation gates, cutover considerations, rollback planning, risk mitigation, and operational transition.
• Develop estimates and planning assumptions for a subsequent migration phase based on assessed complexity, dependencies, remediation requirements, and client decisions.
• Produce architecture diagrams, inventories, findings, decision matrices, risk registers, and executive-ready recommendations supporting the assessment deliverables.
• Present findings to technical and business stakeholders and incorporate review feedback while maintaining alignment with the agreed assessment scope.
• Evaluate whether on-premises PostgreSQL/PostGIS recommendations support a potential future move to Azure Database for PostgreSQL or another approved Azure-hosted pattern.
• Partner with the Cloud Architecture Reviewer on targeted questions involving identity, connectivity, security, monitoring, backup, resilience, integration dependencies, and Esri supportability.
• Document cloud-related considerations and decision points as future-state guidance without designing or executing the subsequent cloud migration.
Required Qualifications
• 8+ years of progressively responsible experience in GIS, spatial databases, database architecture, or data migration, including substantial hands-on experience in enterprise Esri environments.
• Demonstrated experience assessing or planning migrations from Oracle Enterprise Geodatabases to PostgreSQL/PostGIS. Direct migration implementation experience is strongly preferred.
• Advanced Oracle skills, including SQL, schema and dependency analysis, data types, spatial capabilities, indexing, query analysis, security, and migration risk identification.
• Advanced PostgreSQL/PostGIS skills, including spatial types and functions, schema design, indexing, query tuning, permissions, backup and recovery considerations, and operational support patterns.
• Strong working knowledge of ArcGIS Enterprise 11.x, Portal for ArcGIS, ArcGIS Server, Enterprise Geodatabases, ArcGIS Pro, services, attachments, Global IDs, relationship classes, versioning, and spatial references.
• Experience analyzing ETL and integration patterns using tools such as FME, Python, SQL, ArcPy, APIs, scheduled jobs, or comparable orchestration approaches.
• Ability to independently lead technical discovery, facilitate workshops, document complex environments, evaluate trade-offs, and translate findings into client-ready reports and roadmaps.
• Excellent written and verbal communication skills, including the ability to explain database and GIS risks to architects, operations leaders, project stakeholders, and executives.
• Strong database, DBA, or data architecture background rather than a primarily core development background.
• Experience managing enterprise databases, with hands-on PostgreSQL/PostGIS experience.
• Experience with migration planning or migration assessment.
Preferred Qualifications
• Experience in oil and gas, utilities, infrastructure, or other asset-intensive environments with large enterprise GIS estates.
• Experience with ArcGIS Online, Survey123, Power BI, Spotfire, Snowflake-hosted PostgreSQL patterns, and hybrid on-premises/cloud architectures.
• Experience designing data validation, reconciliation, profiling, lineage, metadata, and governance controls for spatial data migrations.
• Familiarity with Azure Database for PostgreSQL, Azure networking and identity patterns, infrastructure as code, CI/CD, and observability practices.
• Relevant Esri, PostgreSQL, Oracle, Microsoft Azure, or data architecture certifications. Certifications are valued, but demonstrated delivery experience is more important.
