GIS Database Administrator (GIS Analyst III) jobs in United States
info-icon
This job has closed.
company-logo

Fairfax County Government · 2 weeks ago

GIS Database Administrator (GIS Analyst III)

Fairfax County Government is seeking a senior-level technical professional to support the development and delivery of advanced geospatial solutions. The GIS Database Administrator will be responsible for administering and maintaining the county’s enterprise GIS database, ensuring the accuracy and availability of critical geospatial data.

GovernmentService Industry

Responsibilities

Responsible for regular database maintenance tasks and administration of GIS enterprise SQL Server geodatabases
Recommend standards for GIS data development and implementation
Proactively monitors the GIS database for proper performance, troubleshoot issues, and collaborates with County IT to ensure the overall health of the GIS database system
Contacts/consults 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
Prepares data for use by County personnel. Management of versioned data and data QA\QC
Designs, develops, documents, data dictionaries, and implements procedures for the maintenance of spatial data within the County’s GIS database
Develops 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
Ensures the overall quality of the data within the GIS database using tools and/or scripts and making recommendations for improvements and implementing those recommendations
Manages and/or participates in complex projects to develop spatially based solutions for complex business problems in response to agency requests or needs
Publishes data services for internal and external use and maintains the GIS Open Data repository
Acts as project technical lead for data conversion projects, QA\QC and develop and maintain technical documentation
Creates or recommends policies and procedures for managing GIS data and enforces those policies
Participates in data governance committees for implementing standards for enterprise GIS data, web, and mobility
Liaises with vendors and regional partners on data modelling and GIS data related procedures
Develops and maintains 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
Performs other duties as assigned

Qualification

SQL ServerGIS technologyArcGIS EnterprisePythonSpatial analysisDatabase managementData modelingAnalytical problem-solvingProject managementCollaboration skillsOrganizational skills

Required

Bachelor's degree in computer science, geography or related field which included coursework in Oracle and/or another complex database platform
Two years of experience in working with and developing systems utilizing GIS platforms such as ESRI's ArcGIS Desktop or Server software suites
Experience performing GIS modeling (e.g., relationship classes, topologies, 3-D, object, data) and spatial analysis (e.g., proximity analysis, image analysis, routing analysis)
Completion of a criminal background check to the satisfaction of the employer

Preferred

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 ArcGIS Enterprise, ArcGIS Online, and ArcGIS Pro and extensions including Data Reviewer, Data Interoperability, and Spatial Analyst
SQL Database management competency and experience (e.g., SQL advanced queries, Entity Relationship diagram creation) including Esri Spatial Databases, MS SQL Server, and SQL Server Management Studio and developing scripts in SQL and Python
Skilled in designing and implementing large enterprise geospatial systems, working with enterprise architectures/solutions using ESRI products
Experience with database management systems, including creation of databases, tables, indexes, views, and stored procedures
Experience with SQL Server features such as spatial databases, spatial indexes, and spatial functions
Knowledge of relational database systems and existing programs used for GIS and geodatabase processing
Project management experience
Excellent organizational skills
Excellent verbal and written communication and collaboration skills
Strong understanding of GIS technology, including spatial analysis, and geospatial data processing and data modeling techniques
Strong attention to detail and ability to manage multiple tasks simultaneously
Strong analytical problem-solving skills with the ability to think critically and creatively
Ability to work well with others in a team environment and to work independently with minimal supervision, as required
Ability to be dynamic and proactive, take initiatives to propose and implement innovative solutions to improve processes and outcomes
Willing to work weekends or non-business hours for scheduled maintenance or emergency database support

Company

Fairfax County Government

twittertwittertwitter
company-logo
Fairfax County Government is a government administrator organization.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Andrew Baptista
Assistant Chief Election Officer (Office of Elections)
linkedin
leader-logo
Audra Michele Morris
Chief Election Officer
linkedin
Company data provided by crunchbase