Job Description & Details
This is a heavy-duty, assessment-focused architecture gig where you will lead an enterprise-scale migration strategy moving a massive Esri environment from Oracle to PostgreSQL/PostGIS. It is not about writing day-to-day code; it is about doing the deep technical discovery, risk analysis, and roadmap building required to make a complex infrastructure shift actually work without breaking downstream business intelligence and field tools.
What You'll Actually Be Doing
You will spend your days dissecting a massive Lower 48 Esri Enterprise Geodatabase environment, mapping out every hidden dependency, spatial relationship, and ETL pipeline. You will be auditing Oracle schemas, spatial data types, versioning behavior, and attribute rules, then figuring out how they map cleanly over to PostgreSQL/PostGIS. Expect to deal with political and technical hurdles alike as you document how tools like ArcGIS Portal, Survey123, FME, Spotfire, and Power BI tie into the current database and draft a bulletproof migration runbook.
The Core Tech Stack
You need absolute mastery over Oracle Enterprise Geodatabases and PostgreSQL/PostGIS, paired with deep knowledge of Esri ArcGIS Enterprise 11.x and ArcGIS Pro. Because this project touches everything downstream, having strong command over FME, Python/ArcPy, and spatial data governance is non-negotiable if you want to identify migration risks before they blow up the roadmap.
Interview Expectations
Expect the hiring team to present a complex scenario involving custom Oracle spatial types, geodatabase versioning, and heavy geometric networks, asking you to explain step-by-step how you would translate them into PostgreSQL without losing data integrity or breaking dependent web services. They want to see how you handle risk mitigation and dependency mapping, so be ready to walk through a previous migration failure you managed and how you diagnosed the root cause.
Application Advice
Your resume needs to heavily feature concrete keywords like 'Esri Enterprise Geodatabase', 'Oracle-to-PostgreSQL', 'PostGIS migration', and 'ArcGIS Enterprise 11.x' to make it past the automated ATS screening. Do not just list your titles; highlight specific large-scale migration assessments and architecture roadmaps you have personally authored in asset-intensive industries like utilities or infrastructure.