Senior GIS Database Migration Architect

Job#: 3056432 Job Description: Senior GIS Database Migration Architect Location: Houston, Texas (Hybrid) or Remote Duration: 6 month Contract-to-Hire Role Overview 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. This engagement focus is strictly assessment-oriented; the professional in this role will validate current-state conditions, identify compatibility and dependency risks, define remediation options, and build the phased migration roadmap and runbook. Key Responsibilities 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. 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, date and time handling, spatial references, geometry behavior, indexing, constraints, privileges, and performance. Document known ETLs, source systems, schedules, transformation logic, and consuming services, while flagging dependencies and reconnection risks involving ArcGIS Portal, Survey123, FME, Spotfire, and Power BI. Contribute database-layer recommendations for ETL governance, naming, metadata, lineage, spatial reference and datum standards, access, change control, and lifecycle management. Own the technical content for a phased migration roadmap and runbook covering wave planning, sequencing, prerequisites, validation gates, rollback planning, and operational transition. Evaluate whether on-premises PostgreSQL/PostGIS recommendations align with potential future cloud-hosted patterns to prevent avoidable rework. Required 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 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. Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico. Everforth Apex uses a virtual recruiter as part of the application process. Click here for more details. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at <https://www.apexsystems.com/privacy-policy> Everforth Apex Benefits Overview: Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Everforth Apex team member can provide. Everforth Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you require an accommodation under the Americans with Disabilities Act to participate in an interview with a virtual recruiter or to use our website for a search or application, please contact our Benefits Department at [email protected] or 804-523-8228. Please note that this contact information is strictly to be used for medical ADA accommodations and that no other inquiries will be answered. UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems. © 2026 Everforth, Inc. All rights reserved. Everforth Apex Systems is part of the Commercial Segment of Everforth, Inc. NYSE: EFOR 4400 Cox Road Suite 200 Glen Allen, Virginia 23060 Everforth Apex is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Everforth Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at [email protected] or 804-523-8228. (Do not submit resumes or solicit consultants to this email address). UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex.