Loading...
HomeMy WebLinkAbout8.3 AmndPersonnelStaffingIncrease .:- .. -- -- .:- CITY CLERK File # DIT1[Q][[Q1-[2J[QJ AGENDA STATEMENT CITY COUNCIL MEETING DATE: (May 20,1997) SUBJECT: Proposed Amendment To Personnel Staffing To Address Data Processing Issues _~ ,~ Encountered With Increase In Computer Applications And Systems VJJr (Prepared By: Paul S. Rankin, Assistant City Manager) EXIDBITS ATTACHED: Excerpt From Information Systems Matrix Prepared By Cayuga Information Systems - July 1996 1. 2. Resolution Amending the Classification Plan RECOMMENDATION: I: Resolution Amending the Salary Plan qN Adopt the Resolutions and authorize Staff to initiate a recruitment for the new position. FINANCIAL STATEMENT: Staff proposes to include the position in the Proposed 1997/98 Preliminary Budget. The change will be accommodated without increasing the number of authorized positions, as discussed below. DESCRIPTION: During Fiscal Year 1996/97 Staff has advanced a review of adding Internet access to the City computer network. In addition a second local area network (LAN) was established at Shannon Community Center, with a communications link to the Civic Center LAN. These activities as well as planned future enhancements to the City Data Processing system have resulted in a need to evaluate the scope and need for additional staff support to maintain the City Information systems. . The City has an investment of over $370,000 in computer and communications equipment. This excludes the investment in software systems. In addition, the complexity of the systems maintained are beginning to be more complex, with a need to provide communications links and an increase in the number of users and applications being supported. Current Staffing Currently the City Information Systems are supported primarily by the Administrative Assistant position assigned to the Administrative Services Department. This position has other responsibilities and therefore limited time is available for Data Processing support. When data processing demands are high it impacts the ability for the Department to achieve the identified goals. Due to the limited time available from the Administrative Assistant other Department Staff have had spend time assisting with the support of these systems. The primary areas of support include: troubleshooting problems; procurement of equipment and new systems; coordinating third party repair; and evaluating new systems. The technical nature of the d,,:~a processing system is also growing more complex with the addition of new applications. ------------------------------------------------------------------- COPIES TO: ITEM NO. 6.~ IDee-forms! The current network has approximately 50 users and support needs are expanding. In addition to City Staff needs there are also items such as coordinating Fire Inspection Staff computers, to allow access to the City Network. In order to improve customer service it will be important to have access for those personnel working from the Civic Center. Since the service is a contract arrangement with Alameda County they also require data connections to the County computer system. In addition to computer support this position has also been assigned to coordinate other communications services such as the City telephone and voice mail system. For complex data processing problems the City has utilized contractors to troubleshoot and correct any problems affecting operations. . Evaluation of Typical Staffing Staffhas surveyed the level of support found in surrounding agencies. Livermore, Pleasanton, and San Ramon all have a minimum of three full-time positions which assist with the support of information and communication systems. The City of Danville has one full-time position. Attached as Exhibit 1 is an excerpt from a report prepared under the direction of the City of Dublin. Cayuga Information Systems was requested to prepare a report evaluating the City Data Processing Masterplan as well as the issue of support requirements to adequately maintain the City investment and to keep the system operational in order to provide services. The Consultant indicated that it is typical to expect to require one full-time employee to support a system consisting of between 30-50 computers. The actual requirement is going to be impacted by the complexity of the system maintained. In this area the City Masterplan has attempted to minimize the support needs by standardizing the configuration of the hardware and utilizing standard software for office applications. .'.. .' With the addition of Computer Aided Design, Permit Tracking, Internet Routers, etc. the City systems become more complex in terms of complexity and variety. The conclusion reached by the Consultant is that the current needs support one full-time position and that there may remain a need for additional support, which could be obtained in the form of contract services. Staff concurs that the need for supplemental support in the areas of training and for complex technical repairs could best be provided by third party contractors. Proposed Accommodation of New Position In recognition of anticipated budget constraints in Fiscal Year 1997/98, Staff is proposing to address the current needs without increasing the total number of full-time positions currently authorized. A vacancy currently exists in the Police Services Department, which was a new Administrative Assistant position added with the 1996/97 Budget. Staff proposes to assign the current Administrative Assistant in the Administrative Services Department (Steve Honse) to this vacancy. -- - The vacancy created in the Administrative Services Department would be filled with a Computer Systems Specialist. The new position can be solely focused on addressing the support of the City Data Processing and Information Systems. This will also provide greater depth to the organization in the number of personnel capable of assisting with computer issues. It will provide the City with back-up support, since Mr. Honse also has a great deal of knowledge of the current systems. This type of back-up support is important in a small organization to avoid being vulnerable to system failures during absences of .-: personnel. .- .A - . .::. -- -- e:> . .... Es!ablishment of Job Specification Attached to the Resolution (Exhibits 2 and 3) is the proposed job description and salary range for the Computer Systems Specialist. A qualified individual will have substantial technical knowledge of computer systems and their support needs. The position is under the supervision of the Assistant to the City Manager who supervises the Central Services Division. The position is comparable to mid-level positions in other agencies which have both a manager level and technical level personnel. The salary range for the Computer Systems Specialist has been benchmarked with the Administrative Assistant position, following a survey of similar positions in surrounding agencies. For this reason there will be no impact on the current budget since both positions fall into the same salary range. Consistent with the City's personnel system, a salary range must be identified for each adopted position. Recommendation Staff recommends that the City Council approve this change in the staffing and adopt the two Resolutions, which will establish a job description and salary range for the Computer Systems Specialist. It is recommended that the City Council take action at this time, as the need for staffmg is immediate in both the Police Services Department and Data Processing. This change will assist with the ability of Staff to continue progress towards goals identified by the City Council and to continue supporting existing data processing operations. -)- ..:. -. EXCERPTS Information Systems Matrix for the City of Dublin July 15, 1996 e. ":;.. . Cayuga Infonnation Systems 175 Sierra Drive, Suite 208 Walnut Creek, CA 94596 (510) 937-8262 EXHIBIT 1 I Information Systems Matrix for the City of Dublin 7/15/96 .: .5 Support Requirements - - Projecting and budgeting the time required for MIS 'support is unfortunately an inexact science. Most MIS support at the City of Dublin is provided by the Administrative Assistant, who provides end-user support, purchasing, and implementation services. MIS support at the City can be divided into five components: Troubleshooting and repair. Includes diagnosis of failed components, and repair or replacement. This item refers to both software and hardware troubleshooting, or basically any diagnostic procedure on computer equipment. Often it is unclear whether a particular problem is hardware or software related, or if software, whether it is in the application program, workstation operating system, network operating system, or . Page 33 . ;z .,.: .: - --- .. .Information Systems Matrix for the City of Dublin 7/15/96 workstation configuration. User error and insufficient training also increases the maintenance and troubleshooting requirement. End-user training and support. Includes phone or onsite end-user support, such as helping to recover lost files, training users on special features of software, and advising users on the types of software or hardware solutions that may meet their needs. No formal training program has been developed at the City for word processing, spreadsheet, E-mail, or other common applications. A formal training program would require additional hours (if carried out in-house), as new applications are implemented. Most applications require one to two days of training to reach proficiency, although specialized applications such as desktop publishing or computer-aided drafting may require a week or more. Development of specifications and purchase of hardware/software. Specifications are required for routine equipment replacement, and for installation of new equipment and software. The purchasing process usually requires collection and comparison of bids, and paperwork associated with purchase requisitions and approval of payments. Installation and configuration of hardware/software. Once computer-related items are purchased, they must be installed, configured, tested, and documented. Routine replacements and upgrades include installation of new or upgraded workstations and installation of peripherals such as printers, mice, keyboards, and modems. This labor does not include the requirements of special projects, detailed in the next section. Special projects. Special projects consist of capital improvement projects, such as the Finance system upgrade~ and expansion of information systems, such as increasing the number of network users. A commonly accepted standard for MIS support in business and public agencies is one full- time employee (FTE) for every thirty to fifty computer users. This translates to an average of about one hour per user per week. Over half of this time is spent "behind the scenes", in creating specifications, purchasing, and configuration of new hardware and software. The remaining time is spent on more visible end-user support, such as troubleshooting and training. Whether an organization will require more or less support than average depends on a number . of factors, including: The variety and complexity of applications software. Since the City uses a limited number of standard applications for word processing, spreadsheet, and database management, the average support requirement per user is reasonably low. However, there are a significant number of custom applications in use at the City, since it is a Page 34 ~ 7/15/96 . Information Systems Matrix for the City of Dublin heterogenous environment. Presently, about half of the support provided to City staff relates to specialized applications. Each department may have one or two specialized applications, which require occasional support from MIS. Most front-line support for these programs is provided by the software vendor; however, MIS staff is responsible for determining whether problems are hardware or software related, and for resolving conflicts between the custom programs and other packages or operating systems. Overall, the City is average in complexity and variety of software applications. MIS staff typically contributes project management and systems integration skills to computer-related capital projects undertaken at the City. The distinction between capital projects and routine support is somewhat blurred, as systems that are acquired under capital projects become part of the City's overall information systems. The requirements of capital projects are included in the support estimate of one FfE to every thirty to fifty users. Age and condition of hardware. Again, the workstations, cabling, and peripherals in use at the City are typical in age and level of maintenance. Older workstations require e: maintenance on a more regular basis; conversely, installing new equipment often results in additional support calls for configuration assistance or for diagnosis and replacement of new components which are faulty. Quality of hardware and installation. Almost without exception, the City has - purchased hardware and installed cabling and communications gear which is of good quality and reliability. The City is above average.in the reliability of systems, based on component quality. ..... - Level of user training, and an appropriate fit between user capabilities and software/hardware capabilities. In some organizations, novice users are expected to self-teach or self-support new applications and systems, often with poor results. Although the City has invested in some user training, especially for custom applications, the overall level of expertise in word processing, spreadsheet, and database applications is no better than average. In some instances, computer users may not be making the most efficient use of the software and hardware tools at their disposal, due to lack of training. When these situations are encountered, MIS staff usually offers assistance or additional training. Ad-hoc training is not always the best use of MIS staff resources, since this type of e training is typiciII y one-an-one. . . . .. ,. Page 35 v .- .~': ~ _. - Information Systems Matrix for the City of Dublin 7/15/96 Rate at which applications are upgraded or replaced. If an organization prefers to use the most recent versions of software and the most advanced hardware available, then the additional support requirement for upgrade and installation can be substantial. The City has been conservative in its approach to new software and systems, preferring to use established solutions rather than cutting edge technologies. From this standpoint, then, the support requirement for the City is somewhat less than average. Level of user sophistication and self-support. Computer users at the City are average to above-average in their abilities to grasp the technical and procedural aspects of computer use. Most departments have one or more staff members who can provide limited technical support to other users within the department, or who can assist in specifying new equipment and software. Management outlook. Many organizations limit the use of computers or data processing methods, either due to lack of capital funds, or due to a perception that computers would not improve staff efficiency or the organization's image. The City tends to be progressive in implementing computerized systems, as these systems have proven to be cost-effective and well received by staff and the public. To the extent that this leads to more complex systems, the support requirement is increased. Overall, compared to other public agencies and businesses, the City has an average to slightly below average support requirement. Based on standards, and anticipated support and training demands, the fifty computer users at the City can be supported by a minimal MIS staff of one FfE, or an optimal MIS staff of two FfE's. Our observation is that, over time, any lesser staffmg level will cause delays in implementation of capital projects, such as operating system upgrades or major systems design and installation, but will not necessarily lead to a degradation in day-to-day support, which is given the highest priority. If the City wishes to establish an in-house training program for computer users, then a one- quarter to one-half time individual would-be required as an instructor. If available half-time, the instructor could also provide initial troubleshooting and/or installation support. At this time, the Administrative Assistant is able to provide MIS support services on a one-half to three-quarters time basis, due to other work required of the job position. If the City intends to provide timely end-user support, and to install and maintain modern information systems, then the support level must be increased. The MIS staff required by the City should have different skill levels and responsibilities. We recommend two job positions or titles for the City: MIS Manager, and Field Technician. The MIS Manager will typically work routine business hours, and will take call for the Field Technician when the technician is on holiday or otherwise unavailable for work. Page 36 ::; Information Systems Matrix for the City of Dublin 7/15/96 e: MIS Manager The MIS Manager administers-the City's information systems, and provide quality data processing support to all City departments in a timely and effective manner. The selected individual must have interpersonal communications and project management skills, necessary to carrying out routine operations and projects. The MIS Manager must have a thorough knowledge of systems design and analysis principles, and be familiar with municipal operations and budget management. The selected individual should have at least five years of progressive experience in information systems management, in a Windows NT or other LAN environment. Job responsibilities for the MIS Manager include: Manage the hardware rental and replacement pool, through specification and purchase of replacement equipment, and through distribution and installation of equipment; - Manage the standard software applications and workstation configurations in use at the City; - - Coordinate the acquisition of new hardware and software; .': Assist in end-user training; Maintain an audit list of City-owned hardware and software; Maintain a schematic of cable layouts and communications equipment; Administer computer hardware and software maintenance contracts. In addition, the MIS Manager will be responsible for planning and executing a number of capital improvement and development projects. The particular projects to be completed will depend on timing, staging, and other factors which are not fixed at this time. ~ Field Technician The Field Technician will perform routine troubleshooting, repair, installation, and upgrade of computer hardware and software for the City. The technician will report directly to the MIS Manager, who will dictate the work schedule and tasks to be undertaken by the technician. The selected individual must have interpersonal communications and project management . skills, necessary to carrying out routine operations and projects under direction of the MIS Page 37 ~ . e: -- -- e. .>",' - Information Systems Matrix for the City of Dublin 7 /15/96 Manager. The technician must also have a thorough knowledge of PC and network principles and repair methods. The selected individual should have at least three years of progressive experience in end-user support, and hardware and software maintenance, preferably in a Windows NT environment. Job duties for the Field Technician include: Diagnose and repair hardware elements, including PC workstations, cabling, and communications gear; Diagnose and correct configuration or installation problems with standard applications software in use at the City, such as Microsoft Office, Aldus Pagemaker, and other commercial packages; Respond to problems with specialized third-party applications, such as the Police Department's record management system and Recreation's class management program. Perform initial diagnoses of problems with these programs, and arrange for repair or upgrades as necessary from the software vendor; Provide end-user training, both the introduce new users to unfamiliar software, and to correct misinterpretations or incorrect use of applications. Training Coordinator If the City decides to support an in-house computer training program, the Training Coordinator would provide organization, instruction, and follow up for the program. All classes would serve from one to five students. Course topics may include: Introduction to the PC (hardware, general information) - half-day sessions Introduction to Windows (3.1 or 95 as appropriate) - half-day sessions. May also combine e-Mail instruction Introductory Word Processing - one-day sessions Advanced Word Processing - one-day sessions Introductory Spreadsheet - one-day sessions Page 38 1 7/15/96 .-: .. Information Systems Matrix for the City of Dublin . Other courses on a one-on-one basis may include desktop publishing, database construction, computer-aided design, etc. Options for Providing MIS Support The most critical factors in determining the quality of MIS support are the skills of the support personnel, and the skills of the MIS manager. Most MIS professionals work at both salaried and contract positions at some point in their career, and the decision to work as staff or as an independent, or as a consultant for a private firm, is often one of personal preference and opportunity. When shopping for MIS support, it is reasonable to expect that you will see the same skill sets and abilities in interviewees for a permanent or temporary position, as compared to private contractors and consultants. Factors which affect the quality of support staff include: Compensation. Billing rates for MIS management services ranges from $50.00 to $90.00 per hour, for a non-specialized environment such as the City. Rates for field technicians and support staff ranges from $30.00 to $60.00 per hour, and trainers from $20.00 to $40.00 per hour. .' The same individuals should be available as employees at a base salary of $25.00 to $35.00 per hour for the MIS manager, $20.00 to $25.00 per hour for the technician, and $15.00 to $20.00 per hour for the trainer. A common mistake in business and public agencies is to offer too little compensation to field technicians. We have seen numerous instances where companies have attempted to obtain technical staff for $12.00 to $20.00 per hour, and have either received little or no interest in the positions, or have hired individuals who were underqualified for the position, and were unable to complete their assignments or to work independently. . - Presuming a burden of 100% for taxes, retirement, vacation/sick leave, insurance, and incidental costs, the same three individuals hired as permanent staff would be somewhat less expensive than contract staff, depending on the negotiated contract rate vs. salary offered. - Length of contract or duration of job position. Permanent positions are much more attractive to prospective employees; similarly, private contractors may offer substantial discounts for long-term contracts. Level of effort expended in locating applicants and/or contractors. The chances of . fmding the right employee or contractor improve as one casts a wider net. _ _ .: Page 39 g- . .. -:: e. . Information Systems Matrix for the City of Dublin 7/15/96 Other factors influence the decision to use in-house versus contract staff. These include: Flexibility. It is far easier to modify a relationship with a contractor than with a permanent employee. Although new employees may be placed on probation, and dismissed if they are not adequate to the job, it is riskier for the organization and more disruptive to hire and fire, rather to seek other contractors. Also, it is much easier to adjust the number of hours provided by a contractor than by a permanent employee. Depth. A contract or consulting firm may have a larger number of technicians who can service the organization, so that if one staff member is unavailable, others may take their place. This is especially important where operations must be maintained on a continuous basis with high reliability and quic!c response time, such as in the Police Department. Continuity. Typically, one may expect slower turnover with permanent staff than with temporary or contract staff. However, experience shows that turnover in MIS staff is high whether permanent or contract employees are used. MIS professionals tend to be younger, more mobile, and more independent than other types of employees and contractors. There is no guarantee that a permanent employee will stay in a position longer than two or three years. Also, there is little advancement potential for MIS staff within the City organizational structure, which may tend to frustrate individuals who have substantial technical and management skills. A contract employer may actually provide a greater level of continuity to the City, since it is more likely that upper management will stay with the company, and therefore stay associated with the City, over many years. Effort required to hire and administer staff. Permanent employees require a substantially larger effort by City management in hiring, employee support, and replacement. Contract companies carry out most or all of the hiring, insurance, and compensation issues for their employees, which would relieve City management of a number of difficult and time-consuming tasks. Integration with City staff. A permanent employee becomes part of the family within the organization, which may improve comraderie and provide a greater comfort level for computer users. On the other hand, it may be more difficult for City management to resolve conflicts or to reassign jobs or priorities for a permanent employee, as compared to a contractor. At this time, we recommend a combination of in-house staff and contract labor for MIS support. As a permanent employee who is familiar with the City organization and personnel, the Administrative Assistant is best equipped to provide MIS management services, such as Page 40 q Information Systems Matrix for the City of Dublin 7/15/96 system specification and pur~hasing. A contract field technician could supply a majority of end-user support, hardware setup and configuration, and troubleshooting. By combining in- house staff with a contract employee, the City can gain the depth of experience and other specialized resources of the contracting company. By combining the existing time commitment of the Administrative Assistant with a full-time contract field technician, the City would -b~ able to provide one and one-half to two FTE's for MIS support, which would be reasonably close to the optimal level of two FIE's. .- - Page 41 /D .. . . . e- - - RESOLUTION NO. - 97 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF DUBLIN ********* AMENDING THE CLASSIFICATION PLAN WHEREAS, in accordance with the Personnel System, the City Council adopted Resolution No. 30-84 and subsequent amendments which comprise the City's Classification Plan; and WHEREAS, resulting from the creation of a new position: Computer Systems Specialist, an additional job classification is required; and WHEREAS, the adoption of a j ob classification is required for all authorized positions. NOW, THEREFORE, BE ITRESOL VED that Resolution No. 30-84 and subsequent amendments shall be further amended to include the new job classification and job description for the position of Computer Systems Specialist as set forth in Attachment A. BE IT FURTHER RESOLVED that this document shall become part of the official Classification Plan for the City of Dublin. PASSED, APPROVED AND ADOPTED this 20th day of May, 1997. AYES: NOES: ABSENT: ABSTAIN: Mayor ATTEST: City Clerk .- H:\CC-FORMS\RESOCLAS.DOC II EXHIBIT 2 CITY OF DUBLIN POSITION TITLE: COMPUTER SYSTEMS SPECIALIST The following key elements describe the basic duties and responsibilities of the position, but are not all inclusive. e'. KEY ELEMENTS 1. Installs, configures, and maintains management information technologies for the City (e.g., computers, networks, phones, voice mail, Internet, etc.). 2. Coordinates the integration of hardware, operating systems, and applications for minicomputer and microcomputer networked environments. 3. Installs, configures, administers, troubleshoots and coordinates maintenance of local areas networks (LANs) and related equipment and software (e.g., file servers, computers, printers, network interface cards, routers, cabling, modems, etc.). 4. Participates with staff to conduct needs assessments, define system requirements, determine system capabilities; and performs cost/benefit analyses. Evaluates proposed systems to determine compatibility with current system requirements. 5. Develops and implements all aspects of user training. Coordinates and assists users with training and troubleshooting problems to identify solutions. 6. Develops security procedures and systems. 7. Writes reports, documentation and procedures. 8. Coordinates with vendors and contractors regarding the acquisition, installation and servicing of computers. CANDIDATE QUALIFICATIONS Required 1. Any combination of education and training that could likely provide the required knowledge, skills and ..-'~':: abilities would be qualifying; as follows: a. EITHER graduation from a college or university with a Bachelor's degree in Computer Science or a related field, plus 2 years of progressively responsible experience with information management systems, including technical experience with local area networks, wide area networks, mini and micro-computers, and typical office environment applications; Q.8. b. Possession of an Associate degree in Computer Science or related area; plus 4 years of experience as described above. 2. Ability to analyze systems data and situations, identify and resolve various information systems and applications problems. 3. Knowledge of computer networks, hardware, software and peripherals such as cabling, network systems, printers, plotters, bridges, routers, data lines and modems. 4. Knowledge of Windows NT operating system, including creation and maintenance of multiple domains. 5. High level of interpersonal skills to work effectively with others. 6. Valid California driver's license. - - Preferred 1. Local government computer system management experience. 2. Knowledge of GIS database and mapping applications. 3. Experience with Local Area Networks and communication links to off-site networks. General Purpose of the Position: Under general direction, provides maintenance and customer support service for the City's information systems (computers, networks, telephones, Internet); performs installatio... configuration, troubleshooting and maintenance of hardware, software, peripheral and related . : communication equipment. Receives and responds to requests for assistance from users; researches, analyzes, and provides solutions to information systems problems. Evaluates proposals to integrate new systems. /r Attachment A . Major Duties and Responsibilities: Duties may include, but are not limited to the following: . Network & Information Systems Administrator - Perform basic installations of cables, plugs, modems and . related communication equipment; establish schedules for back-up; maintain records of data and programs; maintain inventory of data processing equipment, supplies and materials; assist in long-term planning for City networking and management information systems. . Software Administrator - Assist in acquisition of software based on City's needs and technological advancements; maintain software database and library; test the operation of new and modified programs; assist in maintaining back up of data and program disks; monitor the operation of equipment and programs; assist users in resolving program and operational problems. . Hardware Administrator - Assist in planning and acquisition of new equipment and equipment modifications or enhancements; maintain equipment; install new equipment and peripherals; configure equipment and install operating and applications software; analyze operating instructions and documentation; operate a variety of microcomputers and auxiliary equipment such as printers, modems, telecommunications equipment; perform, monitor and/or schedule third party equipment maintenance and repair activities. . Technical Resource & Trainer- Provide technical assistance and training to users (equipment and programs); train and assist staff on various applications which include but are not limited to Microsoft Word, Excel, Access, Pagemaker, AutoCad, civil engineering, and graphics programs; act as a resource for City staff on operation of computers and peripheral equipment; make standard adjustments in operating instructions; investigate and trace sources of error; log computer usage and operating difficulties; run standard diagnostic programs to identify equipment and software problems; establish procedures related to office support, recordkeeping, disc handling and related management information systems. . Contract Administrator - Identify operational and equipment problems and confer with other City staff and vendors to correct problems; identify malfunctioning equipment requiring repairs (e.g., computers, phones, . voicemail, etc.); coordinate outside repair services. .: . Staff Support - Prepare various reports and related documentation. Attend meetings, conferences and seminars during work and non-work hours. Conduct training and make presentations. Organize and prioritize own work assignments. Perform related duties as assigned. Knowledge, Skills and Abilities: Knowledge of: - Principles and operations of management information systems and peripheral equipment (computers, networks, phones, Internet, software and hardware applications, etc.). - Operating system and standard applications programs (mini and microcomputers, terminals, printers, modems and related hardware). - Techniques and practices in utilizing standard applications software including word processing, database, telecommunication, desktop publishing and spreadsheet. - Principles and techniques of systems analysis and development; information systems trends and developments. ~ Skill in: - Operating computer and related equipment. - Installing, monitoring, modifying and maintaining systems software, hardware and related information systems equipment; and preparing basic computer programs for business applications. - Interpersonal communications and project management. e., Ability to: - Observe and problem solve operational and technical deficiencies; interpret and verbally explain technical concepts to less knowledgeable individuals. - Maintain a current understanding of technological advancements and trends. - Sit at a desk for long periods of time; intermittently stand, walk, bend, climb, kneel and twist while working I'!J on mainframe computer equipment, peripherals, and ancillary equipment; perform simple grasping and fine manipulation; use telephone and write and use keyboard to communicate; discern wire colors and se~ small text and numbers on wiring and circuitry; routinely move equipment weighing up to 30 pounds and occasionally move equipment weighing up to 75. ... .. - Use various hand tools and testing equipment in repair, adjustment and problem identification of personal computers and related equipment. - Communicate clearly and effectively in writing and verbally. - Establish and maintain effective working relationships with those contacted in the course of work. - Work independently; utilize good judgment and take initiative to identify and recommend solutions. Work flexible hours if necessary. Education and Training: Any combination of education and training that could likely provide the required knowledge, skills and abilities would be qualifying; as follows: a. EITHER graduation from a college or university with a Bachelor's degree in Computer Science or a closely related field, plus 2 years of progressively responsible experience in information management systems, including technical experience with mainframe, local area networks, mini and micro computers applications; QR b. Possession of an Associate degree in Computer Science or related area; plus 4 years of experience as described above. Licenses and Certifications: Requires a valid California Class C Driver's License to be secured prior to employment and maintained as a condition of continued City employment. '. --- - :. I~ ~ RESOLUTION NO. -97 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF DUBLIN **************** . AMENDING THE SALARY PLAN FOR FULL-TIME PERSONNEL IN ACCORDANCE WITH THE PERSONNEL RULES WHEREAS, the City Council has adopted a Salary & Benefit Plan pursuant to the Personnel System Rules; and WHEREAS, the City Council adopted Resolution No. 36-96 and subsequent amendments which establish a Salary Plan for full-time personnel in accordance with the Personnel Rules; and WHEREAS, the City Council has determined that there is a need to have a new classification established to provide support for the City Computer systems; and WHEREAS, it is necessary to amend the Benefit Plan to account for the new position. NOW, THEREFORE, BE IT RESOL VED that the following salary shall be established in accordance with the City's Personnel System Rules. BE IT FURTHER RESOLVED that this amendment shall be incorporated with the salary provisions contained in Resolution No. 36-96 and subsequent amendments. REGULAR EMPLOYEES EXEMPT FROM FAIR LABOR STANDARDS ACT (FLSA) OVERTIME PROVISIONS .imPIOyeeS covered under this Section shall be paid a monthly salary within the following ranges with the exclusion of any Performance Pay Adjustment granted in accordance with the Personnel Rules. IN THE EVENT TIiAT IT IS DEEMED BY THE CITY MANAGER TO BE IN THE BEST INTEREST OF THE CITY, TEMPORARY APPOINTMENTS OF NO MORE THAN 6 MONTHS, WHERE THE WORK ASSIGNMENTS ARE SUCH TIiAT THEY CAN BE COMPLETED WITH LESS THAN A 40 HOUR WORK WEEK, MAY BE APPROVED BASED UPON THE HOURLY RATES. THE TOTAL SALARY PAID FOR SUCH WORK SHALL NOT BE LESS THAN THE "SALARY TEST" REQUIRED FOR AN EXEMPTION UNDER FLSA. Minimum Maximum Monthly Minimum Maximum Position Title Monthly Salary Salary Hourly Salary Hourly Salary Computer Systems Specialist $3,503 $4,379 $20.21 $25.26 PASSED, APPROVED AND ADOPTED this 20th day of May, 1997. ""S- AYES: NOES: ABSENT: ABSTAIN: .I-TI~ST: Mayor City Clerk H DrivelSalary/RESOCMP .DOC EXHIBIT 3 L5