Essential Functions:

1. Reviews and identifies the work unit's information system needs and makes recommendations for program design, development, purchase, implementation and modification.
2. Plans, leads, oversees and participates in defining requirements, the configuration, design, modification, upgrade, testing, troubleshooting, implementation and maintenance of department specific and enterprise-wide applications.
3. Plans, oversees and leads the configuration, design, modification, upgrade, testing, troubleshooting, modification, implementation, maintenance, and upgrade of all software, interfaces, triggers, procedures or other customized efforts used in conjunction with departmental software such as mobile solutions, electronic document management systems, records management systems, financial systems, GIS systems, web applications, IVR/IWR, grants management solutions, and all other software used by the department.
4. Administers and supports current and future specialized systems such as hosted databases, performance plus, electronic plan review and other software as identified by the department and the city.
5. Performs initial assessment of application problems with all systems used by the department and resolves them in cooperation with the vendor, project teams and outside agencies as needed; resolves functional problems that users are experiencing; researches and corrects data entry errors made by users.
6. Develops, prepares and runs reports, views and table joins using a variety of tools including online reporting tools, Crystal X or higher, Oracle Developer and Oracle Discoverer to provide useful data at the request of department and city management and as required by governing agencies and other authorities. Recommends additional reports based on knowledge of system capabilities and department needs; reviews and analyzes reports and reports issues to management.
7. Collaborates with staff from Information Technologies, Project Management, department management and various teams to maintain and monitor system environments and provide application and terminal support to users; provides in-depth analysis and recommendations for operational enhancements to systems; configures application parameters; coordinates change control management activities in conformance with accepted practices; ensures data is protected in accordance with security guidelines.
8. Performs database analysis to determine the most effective file structure; develops and implements new and improved database structures; monitors database performance.
9. Assesses and recommends system modifications and enhancements to accommodate changes in business practices and newly identified needs; interprets business requirements and translates functional design into technical specifications; coordinates implementation with appropriate staff.
10. Designs, develops and implements the integration of computer-based solutions with existing internal and external systems; provides recommendations on various integration and interfacing systems to optimize efficiency; leads and coordinates integration initiatives.
11. Documents system requirements and testing results. Prepares related technical documentation.
12. Trains staff on automation projects and proper application of equipment and software. Provides first-line support to all users of the systems, including setup and administration of user accounts; conducts regular site visits to assist users; schedules and facilitates periodic user group meetings to discuss issues and solutions. Coordinates and facilitates meetings with users concerning proposed and current business processes. Recommends modifications as appropriate.
13. Coordinates maintenance and repair of equipment with the Information Technologies Department.
14. Participates in the procurement process, including researching materials, equipment and vendors, assisting with specifications and requisitioning materials as needed.
15. Serves as technology liaison between the work unit, outside agencies and service and product vendors; works with the Information Technologies Department and outside agencies to provide for the technology needs of the work unit; keeps work unit staff and management apprised of the status of all technology systems projects; reviews cost estimates and makes recommendations on appropriate software and hardware purchases.
16. May lead, assign and review the work of staff, consultants or contractors responsible for providing specialized programming, systems analysis and technical support within the assigned work unit.
17. Ensures employees adhere to established work methods, techniques and schedules, and comply with applicable city and department policies, procedures, standards and specifications; reviews needs with appropriate management staff; allocates resources accordingly.
18. Assists with developing and implementing policies and procedures; prepares performance statistics and reports.
19. Responds to inquiries in a courteous manner; provides information within the area of assignment; resolves complaints in an efficient and timely manner.

Marginal Functions:

1. Assists in the development and coordination of the division or function budget.
2. Perform related duties and responsibilities as required.

Experience:

Three years of increasingly responsible experience in supporting, managing or implementing information systems, especially in an end-user environment.

Training:

Bachelor's degree from an accredited college or university with major in computer science, information systems, public administration, business administration or a field related to the area of assignment.

May substitute a combination of equivalent education and related experience. The city assesses 1.5 years of fulltime experience as equivalent to one year of education.
Licenses and Certifications:

Possession of a certification in databases, an operating system or software application applicable to the area of assignment is desirable.

Designation as an Oracle Certified Developer may be desirable depending on area of assignment.

Special Requirements

The Fire and Rescue Department operates on a 24-hour, seven days per week schedule. When assigned to Fire and Rescue, must participate in rotating call-outs for service after normal scheduled work hours.

Knowledge of:

Advanced principles and techniques of computer programming, on-line programming and programming documentation.
Advanced concepts, principles and practices of modern computer science or information systems.
Advanced computer testing techniques and methodologies.
Intermediate knowledge of programming languages, such as VisualBasic, HTML, ASP, or SQL.
One or more on-line report writing applications, such as Crystal Reports X or higher, Oracle Reports, Discoverer or Microsoft Access.
Principles and practices of database design and administration.
Oracle or SQL Database structure sufficient to allow the creation of database tables and the design of relational databases.
Interfaces between Oracle Applications and third party applications such as Hansen, Telestaff, CLASS, and IRS software.
Research techniques and data analysis.
Basic principles of budgeting and accounting.
Principles and techniques of lead supervision.

Skills in:

Reading and comprehending complex technical materials and manuals.
Planning, organizing and prioritizing assignments.
Managing multiple assignments.
Learning the unique needs and computer hardware and applications of the assigned work unit.
Explaining complex technical systems in clear and simple terms understandable to non-technical staff.
Using initiative and independent judgment within established guidelines.
Interpreting, applying, explaining and enforcing applicable city, department and division policies and procedures.
Analyzing problems, identifying alternative solutions, projecting consequences of proposed actions, recommending best options and implementing approved solution in support of goals.
Establishing and maintaining close and positive working relationships and open lines of communication with applicable city staff in other departments, external agencies and vendors to ensure the smooth functioning of the systems.
Learning business and operations of assigned work unit to the extent necessary to perform essential functions, enhance system value and achieve established goals.
Communicating effectively with assigned work unit staff and management and outside agencies.
Communicating clearly and concisely, both orally and in writing.
Establishing and maintaining effective working relationships with those contacted in the course of work.
Competencies:

Core Workforce Competencies

Professionalism – Demonstrates core values by being honest, respectful and positive.

Effective Communication – Expresses verbal and written thought in a clear and understandable manner.

Customer Focus – Demonstrates genuine concern and satisfies external and/or internal customers based on the CLV core purpose and values.

Adaptability – Able to effectively modify behavior to suit changing workforce demands.

Problem Solving – Solves problems by considering all causes, solutions and outcomes.

Productive Partnerships – Develops, maintains and strengthens partnerships with others.

Technical and Safety Expertise – Possesses a depth of knowledge, skill and ability in a technical (job) area.