GIS Database Administrator; GIS Analyst III

Job Announcement

This position supports the development and delivery of advanced geospatial solutions to both county government operations and the public. This is a senior-level technical position responsible for administering and maintaining the county's enterprise Geographic Information Systems (GIS) database and the data stored within it, ensuring the accuracy, performance, and availability of geospatial data critical to county services. Oversees daily operations of the enterprise geodatabase, implements data management best practices, and possesses in-depth knowledge of GIS technology to conduct advanced database administration tasks using SQL Server.

This role is essential to the county's GIS infrastructure and requires proactive maintenance, excellent analytical and problem‑solving abilities, troubleshooting, and collaboration with internal departments and external stakeholders.

• Responsible for regular database maintenance tasks and administration of GIS enterprise SQL Server geodatabases.
• Recommend standards for GIS data development and implementation.
• Proactively monitor the GIS database for proper performance, troubleshoot issues, and collaborate with County IT to ensure the overall health of the GIS database system.
• Contact/consult with new and experienced County users in data development efforts including design, implementation, and maintenance of County inter‑agency data flow and database synchronization efforts as well as developing and maintaining the GIS database schema and associated documentation.
• Prepare data for use by County personnel. Manage versioned data and data QA/QC.
• Design, develop, document, data dictionaries, and implement procedures for the maintenance of spatial data within the County's GIS database.
• Develop automated processes using Python, SQL scripting and modeling techniques for data processing and maintenance.
• Troubleshoot database issues, including debugging scripts and resolving performance issues.
• Collaborate with County GIS developers, data stewards, analysts, and other stakeholders to ensure that databases meet business requirements and are integrated with other systems.
• Ensure the overall quality of the data within the GIS database using tools and/or scripts and making recommendations for improvements and implementing those recommendations.
• Manage and/or participate in complex projects to develop spatially based solutions for complex business problems in response to agency requests or needs.
• Publish data services for internal and external use and maintain the GIS Open Data repository.
• Act as project technical lead for data conversion projects, QA/QC and develop and maintain technical documentation.
• Create or recommend policies and procedures for managing GIS data and enforce those policies.
• Participate in data governance committees for implementing standards for enterprise GIS data, web, and mobility.
• Liaise with vendors and regional partners on data modelling and GIS data related procedures.
• Develop and maintain applications, maps, and dashboards using GIS software such as ArcGIS Online and ArcGIS Enterprise.
• Stay up-to-date with the latest developments in GIS technology, SQL Server, and related tools.
• Perform other duties as assigned.

Any combination of education, experience, and training equivalent to the following:
Bachelor's degree in computer science, geography or related field which included coursework in Oracle and/or another complex database platform; plus two years of experience in working with and developing systems utilizing GIS platforms such as ESRI's ArcGIS Desktop or Server software suites; or performing GIS modeling (e.g., relationship classes, topologies, 3-D, object, data) and spatial analysis (e.g., proximity analysis, image analysis, routing analysis).

The appointee to this position will be required to complete a criminal background check to the satisfaction of the employer.

At least seven years of GIS project experience, including three years with a large multi‑user geographic information system and using advanced level spatial analysis. Experience with…