Geographic Information System Database Administrator 1

West Virginia; Charleston (WV); On-site; USD 65,000 - 90,000; Full time

Job summary

West Virginia is seeking a GIS DBA 1 to support the OEHS/GISTA GIS and technical applications team. Under supervision, you will assist with spatial dataset lifecycle, enterprise database administration, and GIS application development to ensure data integrity and secure geospatial infrastructure.

Responsibilities include managing spatial datasets, validating data quality, and automating workflows with Python and ASP.NET Core, while collaborating with GIS, IT, and regulatory teams to translate

Qualifications

• Bachelor's degree, including six semester hours in computer science or GIS.
• Preference for degrees in computer science, geology, geography, natural or earth sciences, forestry, planning, engineering, engineering technology, mathematics, or related fields.

Responsibilities

• Data & Database Support: Manage and maintain spatial datasets; query the SDWIS database and update the Enterprise Geodatabase; administer ArcGIS Enterprise and SQL Server environments; perform monthly QA/QC for public publication datasets.
• Technical Workflows & Analysis: Conduct GIS analysis in hydraulic modeling processes and translate results into geospatial layers; communicate data updates to SWPP and ensure data integrity.
• Development & Automation: Support web applications using ASP.NET Core and JavaScript; use Python to automate data workflows and orchestrate system tasks.
• Liaison & Support: Serve as technical contact for GIS, engineering, IT, and regulatory teams; provide end-user support and translate technical findings to stakeholders.

Skills

ArcGIS Enterprise

Microsoft SQL Server

SDWIS querying

Python for automation

ASP.NET Core

JavaScript

Geospatial analysis

Hydraulic modeling translation

Education

Bachelor's degree (CS or GIS) with six semester hours in CS or GIS

Tools

Enterprise Geodatabase maintenance

ASP.NET Core web development

JavaScript frameworks

Job description

The GIS DBA 1 provides essential technical support for the GIS and technical applications team within the Office of Environmental Health Services (OEHS/GISTA). Under direct supervision, the incumbent contributes to the end-to-end lifecycle of spatial datasets, the administration of enterprise databases, and the support of GIS application development. This role serves as a technical resource in bridging the gap between raw data management and functional database design, ensuring the integrity, security, and accuracy of the organization's geospatial infrastructure.

Key Responsibilities include:

• Data & Database Support: Assist in managing and maintaining critical spatial datasets, specifically those related to public drinking water sources. This includes querying the SDWIS database to identify changes in drinking water sources and performing necessary updates to the Enterprise Geodatabase. Support the administration of ArcGIS Enterprise and Microsoft SQL Server environments, including troubleshooting, performance tuning, and the implementation of security and disaster-recovery procedures. Execute monthly QA/QC workflows to ensure the accuracy and reliability of data intended for public publication.
• Technical Workflows & Analysis: Participate in complex technical workflows by conducting GIS analysis within hydraulic modeling processes and translating results into actionable geospatial layers. Facilitate program coordination by communicating critical data updates to the Source Water Protection Program (SWPP) and ensuring system-wide data integrity.
• Development & Automation: Support the development of web applications using ASP.NET Core and JavaScript frameworks. Utilize Python to automate complex data workflows and assist in orchestrating routine system tasks and data translation.
• Liaison & Support: Serve as a technical contact for GIS, engineering, IT, and regulatory teams. Provide end-user support and communicate technical findings to diverse stakeholders, including management and department officials, translating complex technical terminology into understandable terms.

Technical Requirements for the Position Entails:

• Proficiency in ArcGIS Enterprise and Microsoft SQL Server environments.
• Experience or familiarity with SDWIS database querying and Enterprise Geodatabase maintenance.
• Ability to utilize Python for workflow automation and data processing.
• Exposure to/knowledge of web development frameworks (ASP.NET Core, JavaScript).
• Understanding of hydraulic modeling translation and geospatial analysis workflows.

Training:

Bachelor's degree, including six semester hours in computer science or GIS from an accredited college or university. Preference may be given to those with a degree in computer science, geology, geography, natural or earth sciences, forestry, planning, engineering, engineering technology, mathematics, or related field.