HomeMy WebLinkAbout15 Human ResourcesCITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION
From: EDWARD S. RAYA Subject: REORGANIZATION OF THE
MANAGEMENT INFORMATION
Dept: HUMAN RESOURCES �� OR SYSTEMS DIVISION
16, . , .
Date: NOVEMBER 18, 1998
Synopsis of Previous Council Action:
On November 23, 1998 the Personnel Committee recommended this item for approval.
Recommended Motion:
1. Establish one (1) position of Communications Technician, Range 3361, $2,687-
$3,266 /month.
2. Adjust the salary range for the Programmer Analyst from Range 3439, $3,965-
$4,819 /month to Range 3449, $4,167 - $5,065 /month.
3. Establish one (1) position of Programmer - Public Safety, Range 3383, $2,998-
$3,645 /month.
4. Direct the Human Resources Department to update Resolution 97 -352 and
amend Resolution 6413, Section 5.5, to reflect this particular action.
5. Authorize the Director of Finance to amend the FY 1998 -99 revenue and
expenditure budget to reflect the transfer of $24,000 from the Police Evidence
Impound Account to fund a Programmer as outlined in the staff report.
gnature
Contact Person: Edward S Raya Phone: 384 -5161
Supporting Data Attached: Y
FUNDING REQUIREMENTS: Amount: $47,400 for FY 1998 -99
Source: (Acct No) 679 - 251 -5011
(Acct De.
nance:
Council
Ward:
Agenda Item No. 7T
CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION
STAFF REPORT
BACKGROUND
The Management Information Systems (MIS) Division is requesting establishment of
one (1) entry -level communications technical support position, and the addition of one
(1) Programmer - Public Safety. MIS is also requesting the salary range for the
Programmer Analyst be upgraded and that one existing Programmer position be
designated a Programmer Analyst/Communications.
ANALYSIS
The MIS Division began providing service to the Water Department on July 1, 1998.
Based on a preliminary needs analysis by MIS of the Water Department, four - and -a -half
(4.5) positions were budgeted in the Water Division of the MIS Fund. After completing
three months of actually working in the Water Department and now better able to more
clearly define Water's needs, MIS has determined that an additional position is needed
by the Water Department. The additional position being requested is a
Communications Technician. It is proposed this position be funded 50% from the Water
Department and 50% from the City MIS Fund.
In addition to the Water Department needing more communications support, the City
also has some of these same needs. Communications for the City includes support of
the City's network infrastructure, 800Mhz and UHF -VHF radios, mobile data terminals,
frame relay and a myriad of communications devices. Over the past eight years, the
City's network has grown to include communications within 47 physical building sites.
Back in FY 1990 -91, only one (1) Programmer Analyst was needed to monitor and
manage the City's communication network. Today, one employee is not enough for the
City's larger and more complex wide area network.
Due to the above City communication needs, MIS is requesting that an existing
Programmer Analyst position be designated to a Programmer Analyst/Communications
position and that the salary range be increased by five percent (5 %). The new
Communications Technician position discussed above would report to the Programmer
Analyst/Communications position and be trained as back -up for better City
communications support.
A new job description has been developed for the Communications Technician position,
and, a revised job description has been done for the Programmer
Analyst/Communications position, which accurately describes the functions of each
position.
Additionally, MIS is requesting that the remaining Programmer Analyst positions' salary
ranges also be increased five percent (5 %). This request is a result of the demand for
technical employees in the computer industry, which is at an all -time high and has made
it extremely difficult to attract and /or retain technical employees. A recent City
recruitment for a Programmer produced one candidate. A second recruitment with
wide -area advertising produced only three applicants. The fast approaching year 2000
has created an inordinate demand for individuals in the computer field, which further
impacts the ability to attract qualified applicants. MIS is requesting a change of salary
range for the Programmer Analyst classification to allow the City more flexibility in
retaining these employees. The move of the existing Programmer Analyst positions to
the new range would be at the step nearest their existing monthly pay. Implementing
the new salary range in this manner keeps the cost at a minimum, while at the same
time providing current employees the opportunity for future salary advancements.
MIS also has a significant list of priority projects in process for the Police Department
including replacement of their CAD and RMS systems. The department has been able
to substantially increase their use of technology in recent years through grant funding
sources. The current MIS staffing level of 3 employees for public safety is not sufficient
to handle the technical support workload being generated by the department's
technology projects. The Police department has proposed to add one additional MIS
Programmer for public safety technology support. This addition will help expedite
completion of the department's projects, as well as shorten the timeline to realize the
increased potential and benefits of their technology investments.
The recommended changes to the structure of the MIS department will result in
increased efficiencies Citywide and strengthen the departments' ability to attract and
retain quality employees.
COSTING
The new position of Communications Technician will cost the City $21,700 for FY 1998-
99 (approximately $43,400 annually). The Water Department will fund half of this
position. The remaining half will be covered the existing salary savings in the MIS fund.
In future years, the cost will be spread among all user departments.
The cost for adjusting the salary range of the four (4) Programmer Analysts by five
percent (5 %) is $1,700 for FY 1998 -99 (approximately $3,000 annually). The
implementation cost for these changes is minimal because current employees are being
placed in the step nearest to their current salary. These cost for FY 1998 -99 will be
paid from existing salary savings and in future years will be spread to all user
departments.
The cost of one (1) additional Programmer - Public Safety would cost the City
approximately $24,000 for the balance of the 1998 -99 fiscal year. The recurring annual
cost will be approximately $48,000. This position will be funded from available funds in
the Police Evidence Impound Account. Based on a recent audit of the Evidence
Impound Account by the Police Department, there is $24,000 that can be moved into
the General Fund as a revenue and then budgeted as an expenditure in the Police
budget for MIS internal service charges. The MIS budget will also be adjusted
accordingly.
In summary, the total costs for FY 1998 -99 are $47,400. Of this amount $10,900 will be
paid by Water, $12,500 being paid by the existing City MIS budget and $24,000 being
paid by the Police Evidence Impound account. Annually, the total costs are
approximately $94,400 with $21,700 being paid by Water, $24,700 being spread over
departments, which use communications support. The $48,000 annual cost for the
additional Programmer - Public Safety will be paid from available funds in the Police
Evidence Impound Account.
RECOMMENDATIONS
1. Establish one (1) position of Communications Technician, Range 3361, $2,687
- $3,266 /month.
2. Adjust the salary range for the Programmer Analyst from Range 3439, $3,965-
$4,819 /month to Range 3449, $4,167 - $5,065 /month.
3. Establish one (1) position of Programmer - Public Safety, Range 3383, $2,998-
$3,645 /month.
4. Direct the Human Resources Department to update Resolution 97 -352 and
amend Resolution 6413, Section 5.5, to reflect this particular action.
6. Authorize the Director of Finance to amend the FY 1998 -99 revenue and
expenditure budget to reflect the transfer of $24,000 from the Police Evidence
Impound Account to fund a Programmer as outlined in the staff report.
Attachments:
1) Communications Technician job description
COMMUNICATIONS TECHNICIAN
Iff• : •
Under general supervision, performs technical and skilled tasks in the support of
network infrastructure and associated peripherals; and, performs related work as
required.
COMMUNICATIONS ENVIRONMENT
The City data network operates on a collapsed FDDI backbone, the Cabletron
Gigaswitch. Physical medial includes fiber, unshielded twisted pair copper wiring,
coaxial cable, and wireless technologies. A variety of distribution hubs are used,
primarily the Cabletron Dechub 900. The primary network protocol is TCP /IP.
Management protocols include DNS, DHCP, and SNMP. Connection to remote sites is
achieved by routing IP over a switched frame relay network. Remote dial -ins is through
Cabletron's NetRider equipment using RAS technology. Internet mail and Web access
is provided through a Secure Computing Inc. Sidewinder firewall and onto a T-1
provided by GTE. GTE also provides external DNS services for the City's Web site.
Wireless communication systems include 800 - megahertz trunked voice radios and
mobile data terminals. Also utilized are VHF and UHF conventional radio systems.
Systems Environment
As of yearend 1998, the City will be a Client Server environment running TCP /IP. All
mini computer servers are DEC Alpha's. Several high -end PC's also function as
servers. There is a fiber backbone in the City Hall building, fiber between City and the
Police Station, and fiber between City Hall and the Economic Development Agency.
Communications with remote sites is via frame relay.
Business:
The City's financials and a number of various business applications run on a
DEC Alpha UNIX system. The financials software vendor is Creative Computer
Solutions. Unidata RDBMS and System Builder+ allow PICK based software
such as the CCS financials to run on the Unix system. This system also runs the
Informix RDBMS to accommodate Sierra's PERMITS software.
Optical Document Imaging is also served by a DEC Alpha system running
Windows NT. The software is a high -end product called VisiFLOW from
Datamax. Imaging is used primarily by public safety with a few non - public safety
departments sharing space on the imaging system and jukebox. Full text search
and OCR are both in use in various departments.
Page 1 of 4
The Internet web server is a high -end PC running Windows NT and Internet
Information Server. It is expected that web site authoring and development will
be accomplished with Microsoft Visual Studio and Microsoft Front Page.
Public Safety:
Police and Fire operate a Computer Aided Dispatch (CAD) system and a
Records Management System (RMS) under one united Computer Aided Public
Safety System (CAPS). The CAD portion uses dual DEC Alpha 1000 5/400's.
The RMS portion uses DEC Alpha 4000 5/400. Both use UNIX as their operating
system. Application software is written in COBOL. RMS system also utilizes
Oracle RDBMS.
Police utilize the City's document imaging system to store crime reports,
citations, and field interview cards.
The Geographic Information System is served by 3 Digital AlphaStations running
Windows NT for Workstations and ESRI's Arclnfo version 7.1.2. Three DEC
VaxStations running VMS and GDS (Graphic Data System) and several PC's
running Windows 95 and ESRI's ArcView and Avenue, version 3.0a. The city is
currently migrating from GDS to Arclnfo and will discontinue the use of GDS
12/31/98. Peripherals include a Calcomp 9100 digitizer and an Encad Novajet II
inkjet plotter.
Office Automation is served by two DEC Alpha NT servers running Microsoft
BackOffice, one for Public Safety and one for non- Public Safety departments.
Desktops run Windows 95 and Microsoft Office 97.
Water.
During 1998 -99, the Water Department utility billing will be converting to an IBM
AS /400 server. HTE is the software vendor. Financials are on a DEC Alpha
Unix platform running Unidata RDBMS and SB +. The software vendor is
Creative Computer Solutions.
REPRESENTATIVE DUTIES
Provides courteous and expeditious customer service to the general public and City
department staffs.
Troubleshoots, repairs, and maintains the City's data networks, performs firmware and
software downloads using the latest stable version according to manufacturer's
Page 2 of 4
specifications; maintains and troubleshoots services that support network applications
such as DHCP and DNS; stays current on new technologies and market trends to
integrate these technologies into the City's communications networks; maintains a
working relationship with vendors who are designated to provide maintenance for the
City's communications systems; maintains and troubleshoots personal computers, with
special emphasis on networking hardware, software, and protocols; assists in resolving
situations involving hung or crashed network devices, servers, and personal computers;
trains users on the use of network services and personal computers.
Routinely adheres to and maintains a positive attitude towards City and department
goals.
Provides 247 emergency call out support to network infrastructure.
MINIMUM QUALIFICATIONS
Any combination of education and/or experience that provides the required knowledge,
skills and abilities to meet the following requirements:
Graduation from high school or GED; one or more years of current experience involving
the use of and/or technical support of computers; two or more years of experience
supporting LANs and/or WANs.
Incumbent must be able to cant' a pager and be on call for support purposes 24 hours a
day, 7 days a week.
Incumbent must submit to and pass a police background investigation.
Incumbent must possess a valid Clas s
applicants, a valid drive('s license is
license must be obtained within ten
12405c).
GENERAL QUALIFICATIONS
Knowledge of:
"C' California driver's license. For out -of -state
required. A valid Class "C" Califomia driver's
(1 o) days of appointment (CA Vehicle Code
Current concepts of data communications and networking;
Analog and digital telecommunications services, specifically frame
relay switch networks; TCP /IP and NetBEUI protocols;
Domain name service;
All levels of communications terminology; computer capabilities and
configurations;
Basic principles of supervision,
Intemals of communications hardware and software;
Page 3 of 4
Modern principles of organization, time management, project management
and stress management;
Principles of provision of quality customer service levels.
Familiarity with:
Windows NT, Windows 95, UNIX, personal computers, client/server
environments, TCP /IP, NetBEUI, FDDI, Ethernet;
Bridging and routing concepts, firewalls, DNS, SNMP, DHCP, WINS,
Intemet/Intranet access;
Frame relay; fiber, twisted pair copper and coaxial cabling systems;
Structured horizontal and vertical cabling systems;
Wireless analog and digital communications systems;
Microsoft Office products;
Current principles and methods of security in complex network
environments;
Trunked and conventional radio systems;
Ability to:
See in the normal visual range with or without correction;
Hear in the normal audio range with or without correction;
Work indoors in varying temperatures with exposure to distracting noises,
vibrations and dust;
Establish and maintain effective relationships with those contacted in the
course of work;
Communicate effectively both orally and in writing;
Manage multiple projects simultaneously;
Learn quickly and independently;
Set and attain goals;
Demonstrate working knowledge of modem computer and
communications technology;
Work independently and make sound decisions;
Perform structured, methodical troubleshooting on complex systems.
Transport materials and supplies weighing up to 50 pounds.
QRGANIZATIONAL RELATIONSHIPS
The Communications Technician works under the general supervision of the MIS
Director or the Director's designated supervisory employee.
APPROVED: DATE:
Director of Human Resources
CSB APPROVED:
JD:COMMUNICATIONS.TECH 10113M do
Page 4 of 4