GIS Database Administrator
Share
Job Location:
Monthly Salary:
Experience Required:
Posted on:
4 days ago
Vacancies:
1 Vacancy
Job Summary
Job Title: GIS Database Administrator
Location: West Virginia Department of Transportation (WVDOT)
About the Role
The West Virginia Department of Transportation (WVDOT) is seeking a skilled GIS Database Administrator to join our team on a temporary contract 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.
Key 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
Requirements
Required Qualifications
Education (one of the following):
Bachelors degree in Computer Science Geography Geomatics or a related field from an accredited institution OR
Minimum of three (3) years of equivalent work experience
Enterprise GIS Database Maintenance & Management:
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
GIS Database Connectivity:
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
Debugging Assistance:
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
Spatial SQL Optimization:
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
Backup & Replication:
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
Communication Skills:
Excellent verbal and written communication skills with demonstrated ability to work with project managers business analysts GIS analysts application analysts and business policy staff
Preferred Skills (Not Required but a Plus)
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)
Required Skills:
Required Qualifications Education (one of the following): Bachelors degree in Computer Science Geography Geomatics or a related field from an accredited institution OR Minimum of three (3) years of equivalent work experience Enterprise GIS Database Maintenance & Management: 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 GIS Database Connectivity: 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 Debugging Assistance: 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 Spatial SQL Optimization: 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 Backup & Replication: 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 Communication Skills: Excellent verbal and written communication skills with demonstrated ability to work with project managers business analysts GIS analysts application analysts and business policy staff Preferred Skills (Not Required but a Plus) 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)
