Geographic Information System Database Administrator 2

State of West Virginia; Charleston (WV); On-site; USD 75,000 - 110,000; Full time

Job summary

The State of West Virginia is seeking a GIS DBA 2 to lead the OEHS/GISTA GIS and technical applications team, overseeing GIS databases, servers, and related applications. You will drive data standards, QA/QC, and translation workflows while guiding staff in RDBMS concepts and software development.

You will collaborate with regulatory and engineering teams to align technical capabilities with policy directives and organizational objectives, ensuring secure and resilient GIS infrastructure and

Qualifications

• Bachelor's degree with six semester hours in computer science or GIS from an accredited college or university.
• Four years of full-time or equivalent experience in GIS design, implementation and management, including database management.
• Master's degree or doctorate may substitute for two years of the required experience.

Responsibilities

• Leads the GIS and technical applications team; supervises staff and oversees project planning.
• Manages the full GIS lifecycle including servers, databases, desktop applications, hardware provisioning, software installation, patching, and upgrades; administers ArcGIS Enterprise and Microsoft SQL Server focusing on performance, security, and disaster recovery.
• Leads GIS enhancements and web application development using ASP.NET Core and JavaScript; uses Python to automate complex workflows and system tasks; provides staff training in RDBMS and software development frameworks (server-side and client-side).
• Oversees QA/QC, data loading, and translation workflows; executes hydraulic modeling and geospatial layer translation.
• Serves as primary technical liaison between GIS, engineering, IT, and regulatory teams; translates complex technical concepts for management and diverse stakeholders.

Skills

ArcGIS Enterprise

SQL Server administration

Python

ASP.NET Core

JavaScript

GIS database design

Hydraulic modeling

Education

Bachelor's degree (CS or GIS)

Tools

ASP.NET Core

JavaScript frameworks

Python scripting

Job description

Responsibilities

The GIS DBA 2 leads the OEHS/GISTA GIS and technical applications team, performing high-level administrative and technical work to manage GIS database creation and maintenance. Acting as a multidisciplinary expert, this role bridges the gap between data management and functional application design, overseeing GIS data resources and line-of-business applications to ensure technical capabilities align with organizational objectives and policy directives. Key Responsibilities Include:

• Leadership & Supervision: Leads the GIS team and subordinate staff. Oversees project planning, ensures GIS operations align with organizational goals.
• Infrastructure & Administration: Manages the full GIS lifecycle, including servers, databases, and desktop applications. Handles hardware provisioning, software installation, patching, and upgrades. Administers ArcGIS Enterprise and Microsoft SQL Server environments, focusing on performance tuning, security, and disaster recovery.
• Data Management & Analysis: Develops and enforces data standards for coding, database design, and update procedures. Oversees QA/QC, data loading, and translation workflows. Executes technical workflows, including hydraulic modeling and geospatial layer translation.
• Liaison & Communication: Serves as the primary technical liaison between GIS, engineering, IT, and regulatory teams. Translates complex technical concepts for management and diverse stakeholders to facilitate informed decision-making.

Nature of Work

Responsibilities

The GIS DBA 2 leads the OEHS/GISTA GIS and technical applications team, performing high-level administrative and technical work to manage GIS database creation and maintenance. Acting as a multidisciplinary expert, this role bridges the gap between data management and functional application design, overseeing GIS data resources and line-of-business applications to ensure technical capabilities align with organizational objectives and policy directives. Key Responsibilities Include:

• Leadership & Supervision: Leads the GIS team and subordinate staff. Oversees project planning, ensures GIS operations align with organizational goals.
• Infrastructure & Administration: Manages the full GIS lifecycle, including servers, databases, and desktop applications. Handles hardware provisioning, software installation, patching, and upgrades. Administers ArcGIS Enterprise and Microsoft SQL Server environments, focusing on performance tuning, security, and disaster recovery.
• Development, Automation & Training: Leads GIS enhancements and web application development using ASP.NET Core and JavaScript. Utilizes Python to automate complex workflows and system tasks. Provides staff training in RDBMS and software development frameworks (server-side and client-side).
• Data Management & Analysis: Develops and enforces data standards for coding, database design, and update procedures. Oversees QA/QC, data loading, and translation workflows. Executes technical workflows, including hydraulic modeling and geospatial layer translation.
• Liaison & Communication: Serves as the primary technical liaison between GIS, engineering, IT, and regulatory teams. Translates complex technical concepts for management and diverse stakeholders to facilitate informed decision-making.

Technical Requirements For The Position Entails

• Expertise in ArcGIS Enterprise and Microsoft SQL Server administration (including performance tuning, security, and disaster recovery).
• Advanced proficiency in Python for workflow automation and system orchestration.
• Strong development skills in ASP.NET Core, JavaScript frameworks, and RDBMS.
• Comprehensive knowledge of GIS database design, spatial data and the enforcement of data standards.
• Ability to execute hydraulic modeling translation and complex geospatial analysis workflows.

Minimum Qualifications

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.

Experience: Four years of full-time or equivalent part-time paid experience in geographic information systems design, implementation and management, including experience in database management.

Substitution: Master's degree or doctorate from an accredited college or university in any of the above fields may be substituted for two years of the required experience.