AGENDA #6a
BUDGET WORKING PAPER
TO: W. Calvin Horton, Town Manager
FROM: Bob Avery, Information Technology Director
SUBJECT: Database Systems Analyst Position for the Information Technology Department
DATE: March 8, 2006
This memorandum recommends the addition of a Database Systems Analyst to the Information Technology (IT) Department.
BACKGROUND
Database systems are an integral part of the Town’s operations. These systems are comprised of computer hardware, software, and support services and are used both as enterprise systems (all departments) and as internal department systems. When viewed as a whole these systems represent a considerable investment as both a capital expense for installation and as a continuing expense for annual support services from the program vendors. There are 14 major database programs in use by departments including financial management (all), crime data management (Police), vehicle maintenance (Public Works and Transportation), building maintenance (Public Works and Housing), paratransit scheduling (Transportation), activity scheduling (Parks and Recreation), and catalog (Library).
Operational and maintenance support of these database systems is provided by vendors and staff personnel alike. Vendor contracts focus on program updates and staff members focus on day-to-day checks of both hardware and software operations.
DISCUSSION
The wide range of departmental needs for database services requires the use of many different programs from different vendors. Initially these needs were met with programs that were restricted to internal use by department personnel. In recent years, the Internet has driven a demand for database systems that can provide information and access directly to the public. Inter-departmental information needs have also increased the need for wider access to the data.
To keep pace with these needs the Town has worked steadily to ensure database systems are procured and updated with the features necessary to support reliable operations and interoperability with web and network services. In spite of this effort the list of desired improvements to database and related web-enabled applications continues to grow. Attachment 1 lists a number of the projects or goals related to databases and web access.
With the growing list of projects and the increased use of sophisticated database systems, the need for an expert in database operations and programming has reached a critical level. Currently there is no staff member with the level of expertise needed and no staff hours available to provide the service. Such a position could provide increased support of existing database systems, methodology for improving access to and use of existing data, and overall management of database systems development. This would, over time, provide a direct benefit to the public through better access to Town information and services.
RECOMMENDATION
I recommend a Database Systems Analyst position be added to the Information Technology Department with salary and benefits funded at $66,000 for 10 months.
This position would require ability in programming, operation, and maintenance procedures for database systems and would include the following responsibilities: