Senior GIS Database Migration Architect

Role: Senior GIS Database Migration Architect

Location: Houston, TX (hybrid) or Remote

Duration: 6 month Contract-to-Hire

Required Qualifications

• 8+ years of progressively responsible GIS, spatial database, database architecture, or data migration experience, including substantial hands-on work 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.
• Working knowledge of Azure architecture relevant to PostgreSQL/PostGIS and Esri workloads, including identity, networking, private connectivity, monitoring, backup, resilience, security, and migration planning.
• Ability to independently lead technical discovery, facilitate workshops, document complex environments, evaluate trade-offs, and convert findings into client-ready reports and roadmaps.
• Excellent written and verbal communication, with the ability to explain database and GIS risks to architects, operations leaders, project stakeholders, and executives.