City of Chandler Salary Plan - 2013-14
Back to the Salary Plan
OT Status Legend:
Non-Exempt = Hourly Position
Exempt = Salaried Position
Excellence is the responsibility of everyone at the City of Chandler. We lead by
our core values in constant pursuit of excellence:
*Commitment – Dedicate oneself to consistent and excellent public service
*Innovation – Implement unique, creative and cost-effective solutions
*Communication – Communicate in a positive, honest and productive manner
*Integrity - Adherence to high ethical standards
*Diversity – Promote inclusiveness
and impartiality throughout the organization
*Personal Responsibility – Take initiative to achieve excellence and
*Respect – Demonstrate a high regard
*Teamwork – Promote cooperative efforts, open communication and trust
All City employees are expected to conduct themselves in a way consistent with the
|IT GIS DATABASE ANALYST
Pay Grade: 26 FLSA Status: Exempt
Job Group: Professional (P) Class Code: I046
Effective Date: 7/01 Revision Date: 8/03, 7/05, 2/09
The primary function of an employee in this class is to perform analysis, database design, planning, organization, implementation, maintenance and end user training and support for GIS applications; write programs to utilize GIS data technology to meet city needs through the development of a city-wide GIS Enterprise database; conduct projects in accordance with the city’s GIS plan and GIS Oversight Committee priorities, checks for accuracy and results achieved.
Essential Functions are not intended to be an exhaustive list of all responsibilities, duties and skills. They are intended to be accurate summaries of what the job classification involves and what is required to perform it. Employees are responsible for all other duties as assigned.
Analyzes, designs, programs, and implements GIS systems and applications for city departments;
Assists in the development and coordination of department use of the city’s GIS Enterprise database;
Creates and runs SQL scripts to conduct data analysis, accuracy validation, data maintenance; performs database fine tuning adjustments and database security;
Writes and executes Visual Basic programs to perform initial cleaning and loading, maintenance tasks and validation of spatial data;
Conducts functional and technical supervision over GIS II’s and other GIS data maintainers; monitors data maintenance priorities and data project work schedules;
Administers Oracle databases including upgrades, backups/restores, data migration, export/import of data and database duplication for GIS development databases separate from the live GIS database;
Performs complex tuning of GIS Oracle databases to maintain and continually improve performance levels and space allocation configurations;
Conducts GIS Oracle database maintenance functions (table space building, table structure and attribute changes, shape layer changes and re-indexing);
Manages, operates and supports the GIS system servers and operating systems;
Administers the release and distribution of GIS source data to all outside government and commercial entities;
Provides technical software support and advises GIS Tech II’s and other GIS data maintainers in utilizing GIS applications and principles to improve productivity, data accuracy and reach the objective of one source of data available for city-wide use;
Provides instruction, training and support for end-users working with the custom GIS applications, and ancillary application modules;
Coordinates the work of GIS consultants and other contract staff;
Designs, writes and maintains GIS documentation;
Monitors users’ requests to prioritize and implement requests for service;
Maintains projects and assignment schedules and plans; prepares reports; provides solutions and recommendations for improvements to contribute to GIS management decisions;
Uses SDE Administrative Commands to analyze, monitors and manipulates the GIS spatial data for fine tuning analysis and optimization of database performance;
Writes validation programs to analyze data integrity and ensures data adheres to the City’s business rules;
Generates reports and spatial data files of found data problems to be resolve and corrected; provides results and review with GIS II’s and other GIS data maintainers;
Generates maps using ArcView and ArcMap applications; assists other users in the city to use the same applications and accesses the GIS spatial data to generate maps to meet their business needs;
Develops standards and procedures for GIS databases to establish a set of rules relative to spatial data accuracy;
Conducts random audits of GIS databases to ensure that GIS IIs and other GIS data maintainers are accurately entering data;
Develops Enterprise applications/suites that are used to maintain timely and accurate data to city employees;
Implements automated procedures for backup recovery of GIS database;
Writes applications to find logical errors in the GIS database, to translate data from the GIS to other systems or from other systems into the GIS database;
Adds/removes users to the GIS database; keep passwords current;
Writes complex web applications;
Communicates and coordinates regularly with appropriate others to maximize the effectiveness and efficiency of interdepartmental operations and activities;
Performs all work duties and activities in accordance with City policies and procedures;
Works in a safe manner and reports unsafe activity and conditions. Follows City-wide safety policy and practices and adheres to responsibilities concerning safety prevention, reporting and monitoring as outlined in the City’s Safety Handbook.
Knowledge, Skills and Abilities:
Data systems, hardware and software as related to GIS, geobase theory, function and management;
Database management concepts and structures, analysis methods, design, practices and procedures;
Software applications relating to spatial data, indexing concepts and related functionality;
Administration, maintenance and implementation of database applications;
Data integrity concerns, safeguards and security;
Programming logic and writing code;
Hardware and network operating systems;
English grammar and punctuation.
Comprehend and problem-solve complex data bases systems and software;
Use organizational, project management and problem solving skills;
Use analytical though processing and sound research methods and techniques;
Work with others to re-engineer process to leverage GIS technology;
Communicate effectively with supervisor, co-workers and City staff;
Maintain a professional demeanor during stressful situations;
Understand and follow oral and/or written policies, procedures and instructions;
Perform a wide variety of duties and responsibilities with accuracy and speed under the pressure of time-sensitive deadlines;
Demonstrate integrity, ingenuity and inventiveness in the performance of assigned tasks.
The work is performed under the direct supervision of the IT GIS Coordinator.
Bachelor’s Degree in Computer Science or GIS Technology or related field; and
Five (5) years’ experience in administration, maintenance and implementation of database applications, GIS analysis, GIS databases, and application designs; or
Any equivalent combination of experience and training which provides the knowledge and abilities necessary to perform the work, and which meets licensing requirements.
*GIS Application Developer Specialty Only
Five (5) years experience in GIS technologies and ESRI products;
Experience with ESRI ArcGIS applications;
Client service experience providing a high level of customer service to end-users.
*GIS Application Developer Specialty Only
Experience working with RDBM’s Oracle, .NET (C# and VB) ArcObjects application development, ArcGIS Server development, GIS analysis and Geoprocessing using ModelBuilder and Python scripting, spatial database or Geodatabase management, technical writing skills, training and end-user support;
Public sector experience.
The primary duties of the position are performed in a general office environment.
Essential Physical Abilities:
Sufficient clarity of speech and hearing or other communication capabilities, with or without reasonable accommodation, which permits the employee to communicate effectively on the telephone, in writing and in person;
Sufficient vision or other powers of observation, with or without reasonable accommodation, which permits the employee to diagnose and detect database problems and develop effective system solutions;
Sufficient manual dexterity with or without reasonable accommodation, which permits the employee to operate computer equipment and other office equipment;
Sufficient personal mobility and physical reflexes, with or without reasonable accommodation, which permits the employee to work in an office setting.