GIS Database Analyst

City of Gastonia; Gastonia (NC); On-site; Full time

Job summary

The City of Gastonia is seeking a skilled professional for a challenging role in managing core applications and GIS databases. The ideal candidate will demonstrate strong technical aptitude, analytical skills, and the ability to work independently. Responsibilities include supporting applications, ensuring data integrity, and providing user training. This position offers a unique opportunity to contribute to public safety systems and enhance community services.

Qualifications

• Experience supporting complex applications systems and software development.
• Ability to generate structured systems logic and translate into programming code.

Responsibilities

• Plan, develop, and administer core applications and GIS databases.
• Provide user training and support for applications.
• Monitor and evaluate database problems and initiate corrective actions.

Skills

Technical Aptitude

Analytical Skills

Problem Identification

Creativity

Critical Thinking

Education

Bachelor’s degree in Information Systems

Job description

Performs difficult administrative and skilled technical work in the planning, development, implementation, and administration of core applications and GIS databases; provides direct support for core and related applications; does related work as required. Work is performed under the limited supervision of the Information Systems Administrator.The following job functions are typical for a position of this nature. These are not to be construed as exclusive or all-inclusive. To perform this job successfully, an individual must be able to perform each function satisfactorily. Other job functions and duties may be required as assigned. Percentages for each function are subject to fluctuations.

Comprehensive knowledge of supported software modules and business practices to fully support applications, which includes upgrading software, testing and evaluation, and direct coordination with software vendors regarding software issues and performance.	30%
Performs and/or ensures the GIS data is properly maintained to allow for maximum application optimization; Performs and/or ensures that GIS applications meet the user's analysis requirements; Assists in coordinating external GIS support services, including hardware and software maintenance.	30%
Effectively interacts with users, analyzing user problems, gathering, and studying data, and translating user requirements into logical, effective, and practical systems designs that support business practices and objectives; Provides training to the users when necessary to ensure business practices are being followed which may include compiling/creating instruction materials and documentation.	20%
Provide support, direction, and technical advice as related to application, report writing, and database development.	10%
Monitor and evaluate database problems related to system management and initiate corrective actions regarding database reorganization, schema/subschema redesign, program modification, performance tuning, and backups/restores.	5%
Ensure disaster recovery procedures are in place in the event of database, dataset, or field corruption within any database; used within the county-wide public safety system; work as part of a team to develop policies and procedures for providing complete redundancy for all Computer Aided Dispatch mission critical databases; maintain and perform scheduled operational tests to ensure usability.	5%

• Thorough knowledge of industry standards, methods, best practices, and procedures related to application development and database administration
• Ability to generate structured systems logic which can be translated into computer programming code; thorough knowledge of relational database structures and tools
• Ability to test and troubleshoot database and application issues, and provide appropriate feedback to the administrator
• Must possess and demonstrate technical aptitude through strong analytical skills, organizational skills, problem identification and troubleshooting skills, creativity and critical thinking skills
• Ability to work with minimum or no supervision
• Must demonstrate the ability to set priorities based on the value being delivered to the overall organization and coordinate and manage multiple simultaneous projects and events
• Thorough knowledge of GIS data processing principles, tools and techniques and their application
• Thorough knowledge of GIS mapping and cartographic standards is required;
• Ability to communication and work effectively with vendors to resolve software issue or make enhancements; as well as the user community

EDUCATION AND EXPERIENCE
Minimally qualified starting pay $34.73 hr.

• Bachelor’s degree in Information Systems or related field with considerable experience supporting complex applications systems and software development
• Or any combination of education and equivalent experience

SPECIAL REQUIREMENTS

• Valid driver’s license
• National Incident Management System (NIMS) IS-700, IS-100, IS-200, IS-300, and IS-400 training within 12 months of hire
• Applicant must complete all job screening(s) requirements necessary to work in the Public Safety environment such as undergo fingerprinting, a comprehensive background investigation, and drug screening.

PHYSICAL DEMANDS/WORK ENVIRONMENT

CHECKLIST FOR PHYSICAL ACTIVITIES AND REQUIREMENTS, VISUAL ACUITY, AND WORKING CONDITIONS

1. The physical activity of this position includes:

A. Reaching: Extending hand(s) and arm(s) in any direction.

B. Fingering: Picking, pinching, typing, or otherwise working, primarily with fingers rather than with the whole hand or arm as in handling.

C. Grasping: Applying pressure to an object with the fingers and palm.

D. Talking: Expressing or exchanging ideas using the spoken word. Those activities in which they must convey detailed or important spoken instructions to other workers accurately, loudly, or quickly.

E. Hearing: Perceiving the nature of sounds at normal spoken word levels with or without correction. Ability to receive detailed information through oral communication, and to make fine discriminations in sound, such as when making fine adjustments on machined parts.

F. Repetitive Motions: Substantial movements (motions) of the wrists, hands, and/or fingers.

2. The physical requirements of this position:
A. Office Environment Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects, including the human body. Office environment work involves sitting most of the time. Jobs are categorized as office environment if walking and standing are required only occasionally, and all other Office Environment Work criteria are met.


3. The visual acuity requirements including color, depth perception, and field of vision:
A. The worker is required to have close visual acuity to perform one or more of the following. (Check all of the following which apply): preparing and analyzing data and figures; computer terminal; extensive reading.


4. The conditions the worker will be subject to in this position:
A. None:The worker is not substantially exposed to adverse environmental conditions (such as in a typical office or administrative work environment).



Drug screening, criminal background, and reference checks are required.

Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

The City of Gastonia is committed to creating and maintaining a work environment that is inclusive, equitable, and welcoming. We value diversity and promise to honor your experiences, perspective, and unique identity.

The City of Gastonia is an Equal Opportunity Employer (M/F/H)