GIS Database Administrator

City-of-Lubbock,-T; Texas; On-site; USD 65,000 - 85,000; Full time

Job summary

The City of Lubbock seeks a GIS Analyst to provide GIS support, maintain enterprise databases, and implement new GIS products and procedures for municipal services.

You will analyze emerging technology, coordinate with IT, design end‑user solutions, and ensure QA/QC for GIS data used by water, wastewater and stormwater utilities.

Qualifications

• Bachelor’s degree in geography, GIS, MIS, or related field.
• At least three years GIS-related experience.
• Advanced knowledge of GIS software and relational databases.
• Experience with Oracle, SQL, ESRI ArcGIS, Python, Arcade, FME and MS Office (Access) and integrations.
• Municipal government or utility systems experience welcome but not required.

Responsibilities

• Maintains GIS enterprise databases.
• Installs and maintains GIS software including operating systems, databases, servers, and applications.
• Supports multiple networks and client/server applications and software packages.
• Designs optimal end-user solutions for automation using best practices for client-server technology.
• Coordinates with IT personnel for GIS systems, software, and data.
• Performs related work as assigned.

Skills

GIS software

Relational databases

Data analysis

Communication

Education

Bachelor's Degree in geography, GIS, MIS, or related field

Tools

ArcGIS

ArcFM

FME

SQL

Python

Oracle

MS Access

Job description

The purpose of this class within the organization is to provide Geographic Information System (GIS) support functions including planned and emergency maintenance of GIS databases and implementation of new products and procedures; analyze emerging technology and make recommendations for increased network/system services and capabilities; assist with support of other software and systems using GIS technology.

Essential Functions:

• Maintains GIS enterprise databases.
• Installs and maintains GIS software including operating systems, databases, servers, and applications.
• Supports multiple networks and client/server applications and software packages.
• Designs optimal end-user solutions for justified automation requirements using best practices for client server technology.
• Coordinates with Information Technology personnel, including End User Support,, Systems, and Applications Programming in the use and maintenance of GIS systems, software, and data.

Additional Duties:

• Performs related work as assigned.

Requires a Bachelor's Degree in geography, GIS, MIS, or a related field,plus three years of GIS related experience, or any combination of relevant education and experience.

IT Positions:

Critical Infrastructure: This position has been determined to have close contact with, or control of Critical Infrastructure components. This position is subject to extensive background checks and random drug screening.

No Class B Misdemeanor convictions within last 10 years

No Class A Misdemeanor, Felony Convictions or Family Violence Conviction

Knowledge of:

• Advanced knowledge of Geographic Information Systems (GIS) software and relational databases and mapping and cartographic principles;
• Working knowledge of Oracle, SQL,ESRIArcGIS, Python, Arcade,FME, MS Office, including Access, particularly involvingintegrationswith other systems;
• Knowledge of Esri Versioned Workflows, ArcGIS Online, Esri Web Developer, ArcFM, and other GIS related programming languages is a plus;
• Data conversion and migration concepts and procedures;
• Experience with municipal government generally and/or governmental utility systems is welcome, but notrequired

Abilityto:

• Plan, design, implement, configure, administer, operate and maintain a Geographic Information System (GIS) for a municipal government, including water, wastewater andstormwaterutilities;
• Analyze complex technical data and deliver solutions within given deadlines;
• Provide technical leadership in the development and maintenance of electric utility GIS data models, data standards and systems integration;
• Develop, implement and enforce QA/QC procedures;
• Import and export data to and from a GIS;
• Communicate effectively orally and in writing.

Physical Requirements:

• Continuously lift and carry up to 10 pounds, and occasionally lift and carry up to 25 pounds;
• Ability to occasionally report at non-standard hours and under extreme weather conditions for emergency response;
• Frequently stand and walk during the shift;
• Occasionally climb stairs and other inclined surfaces;
• Occasionally bend and kneel during the shift;
• Frequently flex upper trunk forward at the waist and partially at the knees;
• Push and pull objects;
• Occasionally rotate upper trunk to the left or right while sitting or standing. Place arms above, at, or below shoulder height.