GIS Database Administrator

SUNSHINE ENTERPRISE USA LLC • Charleston, WV

40m

About The Position

The West Virginia Department of Transportation (WVDOT) is seeking a skilled GIS Database Administrator to join our team on a temporary contract basis. In this role, you will be responsible for the maintenance and management of enterprise GIS database systems that support critical WVDOT operations. You will work with Esri ArcGIS Enterprise, ArcSDE, and relational database platforms while assisting GIS analysts and programming staff with debugging and optimization.

Requirements

• Bachelor's degree in Computer Science, Geography, Geomatics, or a related field from an accredited institution, OR Minimum of three (3) years of equivalent work experience
• Minimum of three (3) years of experience with the maintenance and management of enterprise GIS database systems, including Esri ArcGIS Enterprise, ArcSDE, and relational database platforms such as Oracle, SQL Server, or PostgreSQL/PostGIS
• Minimum of two (2) years of experience in providing connectivity between GIS applications and enterprise databases, including configuration of ArcGIS services, database connections, and integration with web-based GIS applications
• Minimum of two (2) years of experience in providing assistance to GIS analysts and programming staff in debugging stored procedures, spatial queries, geoprocessing scripts, and database functions
• Minimum of two (2) years of experience in optimizing spatial SQL execution for procedures, functions, packages, triggers, and geospatial queries to ensure high performance of GIS applications
• Minimum of two (2) years of experience in utilizing enterprise database backup functionality, including full and incremental backups, spatial database replication, and database cloning for GIS environments
• Excellent verbal and written communication skills, with demonstrated ability to work with project managers, business analysts, GIS analysts, application analysts, and business policy staff

Nice To Haves

• Experience in transportation or government IT environments
• Esri certification (e.g., Esri Technical Certification - Enterprise)
• Experience with ArcGIS Portal administration
• Familiarity with additional GIS platforms (QGIS, GeoServer)
• Knowledge of spatial data formats and conversion tools
• Experience with performance tuning for large-scale spatial databases
• Familiarity with public sector geospatial data standards (FGDC, NGDA)

Responsibilities

• Maintain and manage enterprise GIS database systems, including Esri ArcGIS Enterprise, ArcSDE, and relational database platforms such as Oracle, SQL Server, or PostgreSQL/PostGIS
• Provide connectivity between GIS applications and enterprise databases, including configuration of ArcGIS services, database connections, and integration with web-based GIS applications
• Assist GIS analysts and programming staff in debugging stored procedures, spatial queries, geoprocessing scripts, and database functions
• Optimize spatial SQL execution for procedures, functions, packages, triggers, and geospatial queries to ensure high performance of GIS applications
• Utilize enterprise database backup functionality, including full and incremental backups, spatial database replication, and database cloning for GIS environments
• Collaborate with project managers, business analysts, GIS analysts, application analysts, and business policy staff
• Produce clear technical documentation and communicate effectively with both technical and non-technical audiences

What This Job Offers

• Career Level: Mid Level
• Number of Employees: 11-50 employees