Specialist, GIS/Database

Job Summary:

The incumbent coordinates the Geographic Information System, administers database applications and develops applications for the City.

Duties and Responsibilities:

Develops, implements and manages custom applications for the organization Assist with data base management activities such as backup and recovery, tuning and performance evaluation. Develops, implements and manages the GIS system within the organization including planning, designing and maintaining GIS applications to meet the needs of users. Promotes the concept and use of GIS throughout the organization and collaborates with departmental managers in assessing training requirements and develops, implements, evaluates and provides training programs. Creates and maintains database applications, queries and reports from the corporate database platforms (MS SQL, MySQL). Provides second level support for CityWorks, SharePoint, ERP and other corporate applications. Establishes standards and operating procedures for use of GIS and database applications and ensures compliance. Coordinates conversion projects of corporate land-based information, Databases and Applications from various platforms and environments. Researches, tests and evaluates GIS software and concepts for compatibility with the hardware environment and recommends the future direction. Researches, tests and evaluates Applications, Databases and environments for compatibility with the Corporate environment and recommends the future direction. Develops and maintains standards for data backup and business continuity plans. Assists other members of the Business and Technology Systems department and other City departments with Databases, GIS and other Information Systems activities. Assists with the preparation of the annual, capital and 5-year budget for related capital projects applications. Follows, so far as is reasonably practicable, established safety procedures and standards. Acts as Manager Business and Technology as assigned. Number of Hires Needed 1 Position Requirements

Working Conditions:

Required to work primarily inside. Extended periods of concentration required. Regular travel between City buildings required. May be exposed to dust, dirt and noise.

Required Knowledge, Skill and Abilities:

4-year University Degree in Computer Science or a related field Previous Experience - 5 years related On-the-job Experience – 6 months Valid Class 5 Drivers’ License Knowledge of Database platforms including MS SQL Server, MySQL Knowledge of Application development  Knowledge of Geographical Information Systems

An equivalent combination of education, training and experience may be considered.

---