Senior GIS Database Migration Architect

Oracle + Postgres
UNITED STATES
October 22, 2026
Contractor
Apply Now

Job Description

Company: Apex Systems
Location: Houston, Texas (Hybrid) or Remote
Workplace Type: Hybrid
Employment Type: Contract

About the Role

Seeking a senior, hands-on GIS database migration architect to serve as the primary technical lead for an enterprise Oracle-to-PostgreSQL/PostGIS GIS migration assessment. The successful candidate will perform the majority of the technical discovery, analysis, architecture, documentation, and roadmap development required to assess a large Esri Enterprise Geodatabase environment and prepare a defensible migration plan.

What You’ll Do / Key Responsibilities

  • Technical Discovery & Inventory: Plan and execute technical discovery for the in-scope Lower 48 Esri Enterprise Geodatabase environment, including the 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.
  • Dependency & Risk Analysis: Analyze Esri geodatabase constructs and relational dependencies, including spatial data types, domains, subtypes, relationship classes, attachments, Global IDs, attribute rules, and versioning. Assess Oracle-to-PostgreSQL/PostGIS conversion risks across schemas, data types, spatial references, geometry behavior, indexing, constraints, privileges, and performance.
  • Roadmap & Runbook Ownership: Own the technical content for a phased migration roadmap and runbook covering wave planning, sequencing, prerequisites, validation gates, rollback planning, and operational transition.

Requirements & Qualifications

  • Education: Bachelor degree in Geographic Information Systems, Computer Science, Database Administration, or a related technical discipline is required.
  • Experience: Eight or more years of progressively responsible GIS, spatial database, database architecture, or data migration experience, including substantial hands-on work in enterprise Esri environments.
  • Technical Skills: Demonstrated experience assessing or planning migrations from Oracle Enterprise Geodatabases to PostgreSQL/PostGIS; advanced SQL skills and schema analysis; strong working knowledge of ArcGIS Enterprise 11.x, Portal, and ArcGIS Pro; and experience analyzing ETL patterns using tools such as FME, Python, SQL, or ArcPy.

Preferred Qualifications (if applicable)

  • Experience in utilities, infrastructure, or another asset-intensive environment with large enterprise GIS estates.
  • Experience with ArcGIS Online, Survey123, Power BI, Spotfire, and hybrid on-premises/cloud architectures.
  • Experience designing data validation, reconciliation, profiling, lineage, metadata, and governance controls for spatial data migrations.
  • Familiarity with cloud-based PostgreSQL databases, networking patterns, infrastructure-as-code, and observability practices.
  • Relevant Esri, PostgreSQL, Oracle, or data architecture certifications.

Benefits & Perks (if applicable)

  • Medical, dental, vision, life, disability, and other supplemental insurance plans.
  • ESPP (Employee Stock Purchase Program) and a 401(k) program with a company match after 12 tenure months.
  • HSA (Health Savings Account) on the HDHP plan.
  • SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions.
  • Corporate discount savings program, on-demand training program, certification prep, and professional development resources.

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex, age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, marital status, disability, protected veteran status, or any other characteristic protected by law.

Related Jobs