Loading...
HomeMy WebLinkAbout2008-08-05; City Council; Resolution 2008-221'c \oi f 1 RESOLUTION NO. 2008-221 2 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD, CALIFORNIA, TO ESTABLISH NEW 3 JOB CLASSIFICATIONS IN THE INFORMATION 4 TECHNOLOGY DEPARTMENT AND TECHNOLOGY RELATED CLASSIFICATIONS IN OTHER DEPARTMENTS 5 THROUGHOUT THE CITY, AMEND THE SALARY SCHEDULES FOR CARLSBAD CITY EMPLOYEES' 6 ASSOCIATION AND THE MANAGEMENT SALARY SCHEDULE, AND AMEND THE LOCAL CONFLICT OF 7 INTEREST CODE. 8 9 WHEREAS, the City Manager recommends and the City Council concurs, that it 10 is desirable and necessary to focus the technology efforts throughout the City of 11 Carlsbad; and 12 WHEREAS, it is recommended that the Information Technology Department be reorganized to establish an organizational structure that meets the changing technology 15 needs of the City of Carlsbad and its employees and customers; and 16 WHEREAS, the data represented by the classification study warrants the 17 establishment of several new technology related job families and related classification 18 specifications; and 19 WHEREAS, the City Manager recommends and the City Council concurs, that it 20 is desirable and necessary to amend the Salary Schedule for the Carlsbad City 21 Employees' Association, the Management Compensation Schedule and the Local 22 Conflict of Interest Code to reflect these changes. 23 NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of ^H" 25 Carlsbad, California, as follows: 26 1. That the above recitations are true and correct. 27 28 1 2. That the City Council authorizes the establishment of an Applications 2 Support job family and a summary classification specification to describe each level of 3 the Applications Support series (Applications Associate Analyst, Applications Analyst, 4 and Senior Applications Analyst as outlined in Attachment A), the placement of the 5 Applications Associate Analyst, Applications Analyst, and Senior Applications Analyst 6 at salary grades 75, 94 and 109 respectively in the revised General Employees' Salary 0 Schedule (see Attachment B), and the deletion of the current job specifications ofo 9 Applications Specialist I, Applications Specialist II and Applications Specialist III. 10 3. That the City Council authorizes the establishment of a Senior Database 11 Administrator job classification specification (as outlined in Attachment A), the 17 placement of the Senior Database Administrator at salary grade 113 in the revised General Employees' Salary Schedule (see Attachment B), and the deletion of the 14 current job specification of Systems Administrator III. 15 4. That the City Council authorizes the establishment of a Senior Web16 . _ Administrator job classification specification (as outlined in Attachment A), the 1 g placement of the Senior Web Administrator at salary grade 109 in the revised General 19 Employees' Salary Schedule (see Attachment B), and the deletion of the current job 20 specification of Applications Specialist III. 71 5. That the City Council authorizes the establishment of a Network 22 Administration job family and a summary classification specification to describe each 23 level of the Network Administration series (Network Associate, Network Engineer and 24 Senior Network Engineer as outlined in Attachment A), the placement of the Network 25 Associate, Network Engineer and Senior Network Engineer at salary grades 70, 87 and26 27 113 respectively in the revised General Employees' Salary Schedule (see Attachment 28 1 B), and the deletion of the current job specifications of Systems Administrator I, 2 Systems Administrator II and Systems Administrator III. 6. That the City Council authorizes the establishment of a Client Systems 4 job family and a summary classification specification to describe each level of the 5 Client Systems series (Client Systems Associate Administrator and Client Systems 6 Administrator as outlined in Attachment A), the placement of the Client Systems Associate Administrator and Client Systems Administrator at salary grades 51 and 87o 9 respectively in the revised General Employees' Salary Schedule (see Attachment B), 10 and the deletion of the current job specifications of Systems Administrator I and 11 Systems Administrator II. 19 7. That the City Council authorizes the establishment of a Geographic 13 Information Systems (GIS) job family and a summary classification specification to 14 describe each level of the GIS series (GIS Technician, GIS Associate Analyst, GIS 15 Analyst, and Senior GIS Administrator as outlined in Attachment A), the placement of 16 the GIS Technician, GIS Associate, GIS Analyst, and GIS Administrator at salary 18 grades 60, 70, 84 and 109 respectively in the revised General Employees' Salary 19 Schedule (see Attachment B), and the deletion of the current job specification of GIS 20 Technician. 2! 8. That the City Council authorizes the establishment of a Business 22 Systems job family and a summary classification specification to describe each level of 23 the Business Systems series (Business Systems Associate, Business Systems 24 Specialist, and Senior Business Systems Specialist as outlined in Attachment A), the 25 placement of the Business Systems Associate, Business Systems Specialist, and26 Senior Business Systems Specialist at salary grades 70, 84 and 99 respectively in the 28 1 revised General Employees' Salary Schedule (see Attachment B), and the deletion of 2 the current job specification of Business Systems Specialist. 9. That the City Council authorizes the establishment of a Public Safety 4 Information Technology Manager job classification specification (as outlined in 5 Attachment A), the amendment of the Management Salary Structure to include the new 6 classification of Public Safety Information Technology Manager at salary grade 5 (see „ Attachment C), and the deletion of the current job specification of Systemso 9 Administrator III. 10 10. That the City Council authorizes the amendment of the "Local Conflict of Interest Code" to add the position of Public Safety Information Technology Manager to 12 the list of Designated Employees filing in disclosure categories 1, 2, 3, and 4, as shown 13 in Attachment D, attached to and incorporated into this resolution. 14 11. That the City Council authorizes the classification specifications included 15 in Attachment A (with the exception of the Public Safety Information Technology 17 Manager job classification) to be placed on the revised General Employees' Salary Schedule (see Attachment B), which is hereby approved. 19 // 20 // 21 // 22 // 23 // 24 25 26 27 28 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 12. That the City Council authorizes the movement of employees from the deleted job classification titles to the newly approved job classification titles as outlined above. PASSED, APPROVED, AND ADOPTED at a Regular Meeting of the Carlsbad City Council on the 5th day of August , 2008, by the following vote: AYES: Council Members Lewis, Kulchin, Nygaard NOES: Council Members Hall, Packard ABSENT: None , Mayor ATTEST: (SEAL) *1 '""// Attachment A CITY OF CARLSBAD CLASS SPECIFICATION JOB SERIES: APPLICATIONS ASSOCIATE ANALYST, APPLICATIONS ANALYST, SENIOR APPLICATIONS ANALYST DEPARTMENT: INFORMATION TECHNOLOGY Distinguishing Features and Summary Description: The primary objective of this job series is to is to evaluate, recommend, install/integrate, test, maintain and monitor performance of software products and provide technical support to end users and/or Business Systems Specialists in a multi-client, multi-vendor software environment. Incumbents in this job series confer with end users to determine types of hardware and software required and provide or assist with training in use of equipment and software. The Applications Associate Analyst is the basic level class in the applications job series; considered experienced but still a learner. Incumbents in this classification receive occasional instruction or assistance as new or unusual situations arise and are expected to be fully aware of standard operating procedures and change control processes to resolve end user problems. The Applications Analyst performs at the journey level and may perform as a lead on appropriate level projects. The Applications Analyst provides analysis, development and support for the network integration of applications that encompass end users across the City. The Applications Analyst is responsible to research unique solutions to multiple assigned software application(s) and is capable of performing custom implementations, upgrades, report development and installation packaging to deploy software applications. The Senior Applications Analyst performs at a lead and/or supervisory level and provides support to end users on sensitive or complex applications that have significant impact on the organization. The Senior Applications Analyst is responsible to independently create and deploy unique solutions to end users with or without assistance from vendors. This is the most senior level position in the job series. Essential Duties and Responsibilities: The following duties are typical for this job series and include the following. Incumbents may not perform all of the listed duties and/or may be required to perform additional duties from those listed below to meet the City's business needs and changing operating practices. Other duties may be required and assigned. APPLICATIONS ASSOCIATE ANALYST Facilitates vendor processes with Applications Analysts and Network Engineers. Supports end users by performing basic to moderate front end application interface development, programming or configurations. Provides basic or routine back end interfaces with guidance from Application Analysts or Network Engineers. Participates on community of interest team projects. Maintains and supports applications and/or databases necessary for efficient functionality of assigned software solution(s). Provides service response to requests by city staff in the utilization and development of database applications. Deploys tools, upgrades, patches or new software independently or in conjunction with appropriate vendors. APPLICATIONS ANALYST Performs the duties of the Applications Associate Analyst in addition to: Researches and analyzes problems with applications and resolves or formulates solutions. Develops, documents, maintains reports and interface programs using programming languages and/or applications such as Crystal Reports, MS SQL Reporting Services. Provides technical assistance on connectivity to peripheral equipment. Assists end users with implementation of new software releases and upgrades. Determines, translates and programs business needs and issues into appropriate programming code to resolve end user requests. Maintains and implements system security for software application(s) in conjunction with Business Systems Specialists. Develops and maintains application documentation. Conducts database analysis and subsequent troubleshooting activities. Researches system enhancements and executes implementation. Develops databases in conjunction with the database administrator for application software needs. /O Assists city-wide teams by providing expertise on software functionality issues and questions and provides deliverables to achieve team objectives. Designs and develops workflow to support assigned departments to enhance information flow and/or utilization of software and/or systems. Conducts software application testing and other preparation for software upgrades or new software implementation. Schedules regular project status meetings with end users and/or vendors. Ensures change control forms and processes are aligned with standards established by the Information Technology Department and approved by Senior Application Analysts and/or Network Engineers. Develops front and back end interfaces to integrate multiple software applications. Establishes appropriate relationships and ongoing dialogue with software vendors; ensures software applications are up-to-date; obtains and applies necessary software patches; obtains assistance from vendor to correct software flaws and/or inefficiencies. SENIOR APPLICATIONS ANALYST Performs the duties of the Applications Analyst in addition to: May perform the role of lead or supervisor; assigns work; distributes workload; authorizes timesheets; assists in recruitment processes and participates in performance reviews. Assists in the Information Technology Department strategic planning process. Carries out and develops assigned roadmap(s). Provides support to staff and ensures the necessary tools and resources required to support their assigned applications. Provides resources or resolves scheduling conflicts to projects in the Applications Group. Provides vital resources to significant projects of others. Assists the department on long range strategic planning. Provides input on developing department policies. Develops request for proposals, bids and information and performs contract management in accordance with City policies and purchasing ordinances. Provides custom or unique creation of scripts, tools and interfaces at a high level. JOB SERIES KNOWLEDGE AND ABILITIES Applications Associate Analyst • Basic understanding of project management practices • Knowledge of report writing concepts • Knowledge of programming and scripting such as SQL Transact SQL Scripting • Knowledge of database structures and systems • Knowledge of file system administration • Knowledge of ASP.Net preferred • Ability to write reports using basic reporting applications • Ability to provide excellent customer service • Ability to work independently and within a team Applications Analyst Knowledge and Abilities listed in the Applications Associate in addition to: • Knowledge of dynamic programming languages • Knowledge of enterprise network infrastructure environment • Knowledge of database concepts including design, tables, queries, functions, modules, reports and ODBC • Knowledge of relational databases • Knowledge of application development such as system analysis and software development lifecycle • Ability to prioritize and lead projects • Ability to program and analyze software application problems and issues • Ability to initiate work • Ability to support large scale, complex software application(s) • Ability to develop reports • Ability to create and meet deadlines • Ability to deal with multiple high priority issues simultaneously • Ability to perform basic commands and develop scripts in Unix • Ability to analyze and research solutions Senior Applications Analyst Knowledge and Abilities listed in the Applications Analyst in addition to: • Ability to develop database application utilizing MS Access, MS SQL, ASP.NET based on end user requirements Ability to develop complex reports using reporting tools Ability to understand MS SQL and create/maintain databases; create/maintain SSIS packages; assign security roles Ability to lead, develop and manage projects of significant scope with considerable impact on the organization Ability to deal with controversial or sensitive issues Ability to perform analysis at a high level Excellent written and oral communication skills JOB SERIES EXPERIENCE AND EDUCATION Applications Associate Analyst Bachelor's degree in Information Technology or Computer Science or equivalent experience in an Information Technology environment. Minimum of two years experience in an Information Technology environment or a related function performing user support, training, and supporting the installation, development and maintenance of the business intelligence application software and servers, including development of associated metadata and user interfaces. Applications Analyst All requirements of the Applications Associate Analyst in addition to: Minimum three years experience in an Information Technology environment or a related function performing user support, training, and supporting the installation, development and maintenance of the business intelligence application software and servers, including development of associated metadata and user interfaces. Senior Applications Analyst All requirements of the Applications Analyst in addition to: A minimum of five years of professional experience in an Information Technology environment or a related function performing user support, training, and supporting the installation, development and maintenance of the business intelligence application software and servers, including development of associated metadata and user interfaces. JOB SERIES ESSENTIAL FUNCTIONS The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Language Ability: • Requires ability to compare, count, differentiate, measure, measure and/or sort, assemble, copy, record and transcribe data and information. Must be able to classify, compute, tabulate, and categorize data. Must be able to advise and provide interpretation to others on how to apply policies, procedures, and standards to specific situations. Needs to be able to use a variety of descriptive data and information such as: a variety of plans; resolutions; maps; reports: computer software operating manuals; procedures; guidelines; and routine correspondence. • Must be able to communicate orally and in writing, clearly and concisely and in a non-technical manner with City personnel at all levels; consultants; vendors; and the general public. • Needs the ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Must be able to write reports, business correspondence, and procedure manuals. Needs to effectively present information and respond to questions from groups of managers, clients, and the general public. Mathematical Ability: Knows how to apply mathematics, including basic algebraic, plane geometric and trigonometric formulas. Must be able to demonstrate ability to calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships. Needs to be able to interpret basic, descriptive statistical reports. Judgment and Situational Reasoning Ability: Must be able to use functional reasoning and apply rational judgment when performing diversified work activities. Needs to be able to analyze data and information using established criteria in order to determine consequences and identify and select alternatives. Physical Requirements: • Needs to be able to operate equipment and machinery with some requiring rapid adjustments such as a computer keyboard and terminal, digitizer, plotter, blue line printers, photocopier, calculator, drafting instruments, and engineer and architect scale. Must be able to coordinate eyes, hands, feet and limbs in performing skilled movements such as rapid keyboard use. Needs to be able to recognize and identify degrees of similarities or differences between characteristics of colors, textures, and forms associated with job-related objects, materials, and tasks. • Essential and marginal functions may require maintaining physical condition necessary for sitting for prolonged periods of time. Must be able to exert light physical effort, typically involving lifting, carrying, pushing and pulling of up to 30 pounds. Tasks may involve extended periods of time at a keyboard or workstation. Needs to be able to perform frequent downward flexion of neck, side-to-side turning of the neck, fine finger dexterity and grasp to manipulate the keyboard, telephone, writing instruments, papers, books, manuals, and reports. • Job entails occasional walking, standing, bending, stooping, climbing, reaching at and above shoulders, twisting at the waist, upward and downward flexion of the neck. On an infrequent basis, the incumbent must be able to squat and kneel. • Work may involve occasional outdoor fieldwork. Overtime and attending meetings outside regular work hours may be required. Work environment is professional and both team and autonomy oriented. This position is impacted by urgent time deadlines due to various reporting and filing requirements. There is some repetitiveness in program coding, a need for extreme accuracy, and paying attention to detail. Additionally, there is a need to be able to shift attention before tasks are completed to be able to balance user demands, telephone and other interruptions. • Must be able to drive and maintain a California Class C Driver's license or ability to arrange transportation for fieldwork or visits to other City facilities when necessary. This classification specification does not constitute an employment agreement between the employer and employee and is subject to change by the City and the needs of the City and requirements of the job change. The City of Carlsbad is an Equal opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodation to qualified individuals with disabilities and encourages both current and prospective employees to discuss potential accommodations with the employer. CITY OF CARLSBAD CLASS SPECIFICATION POSITION: SENIOR DATABASE ADMINISTRATOR DEPARTMENT: INFORMATION TECHNOLOGY Distinguishing Features and Summary Description: Under general direction of the Information Technology Manager, the Senior Database Administrator is responsible to design, develop and maintain the City's databases hosted on database servers that serve applications across the enterprise. The Senior Database Administrator may supervise and/or lead the work of others. The Senior Database Administrator has significant discretion and may supervise the work of others. Essential Duties and Responsibilities: The following duties are typical for this position. Incumbents may perform some but not all of the listed duties and/or may be required to perform additional duties from those listed below to meet the City's business needs and changing operating practices. Other duties may be required and assigned. Participates in the Information Technology Department's strategic planning processes. Designs, develops and maintains City databases hosted on various database servers that serve applications across all departments. Troubleshoots database performance problems and provides solutions based on analysis and research using knowledge of operating systems, relational databases and database technologies. Designs, develops and maintains a data warehouse that serves as a central repository of data from disparate data sources across the City. Designs and develops reporting and data analysis solutions based on the data warehouse using industry standards and methodologies. Provides technical input to management regarding proposed applications that would utilize the database Performs, maintains and ensures database backups, restores, security, and data corruption/correction. Monitors performance and database connectivity issues. Stays abreast of current and emerging technologies related to areas of expertise. Applies latest service packs and patches. Monitors space issues and performs housekeeping of database. Develops assigned areas of technology roadmap(s). Determines database specific configurations and architecture. Obtains quotes and bids and performs request for proposals; identifies vendors and/or software and/or tools associated with database or data warehouse solutions. Creates, analyzes and troubleshoots complex queries. Leads and participates in project management including scheduling and prioritizing resources. Supervises, schedules and evaluates direct reports and other staff assigned during various projects. KNOWLEDGE AND ABILITIES • Knowledge of database administration using MS SQL Server • Strong database development skills using MS SQL Server • Knowledge of database warehousing and business intelligence • Knowledge of trends and developments in database technologies, operating systems and application development • Knowledge of project management practices • Knowledge of programming or shell scripting • Knowledge of production support experience utilizing effective communication, troubleshooting skills • Knowledge of business intelligence services for analytics, reporting and data transformation • Ability to develop applications using .NET • Ability to establish relational data modeling • Ability to manage multiple projects simultaneously • Ability to write reports • Ability to work well in teams EXPERIENCE AND EDUCATION Bachelors degree in Information Technology, Management Information Systems, Computer Science or related field from an accredited college or university. 7 Minimum of five to seven years with database administration and three years in database warehousing; minimum of three years experience with SQL. ESSENTIAL FUNCTIONS The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Language Ability: • Requires ability to compare, count, differentiate, measure, measure and/or sort, assemble, copy, record and transcribe data and information. Must be able to classify, compute, tabulate, and categorize data. • Must be able to advise and provide interpretation to others on how to apply policies, procedures, and standards to specific situations. • Needs to be able to use a variety of descriptive data and information such as: a variety of plans; resolutions; maps; reports: computer software operating manuals; procedures; guidelines; and routine correspondence. • Must be able to communicate orally and in writing, clearly and concisely and in a non-technical manner with City personnel at all levels; consultants; vendors; and the general public. • Needs the ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Must be able to write reports, business correspondence, and procedure manuals. Needs to effectively present information and respond to questions from groups of managers, clients, and the general public. Mathematical Ability: Knows how to apply mathematics, including basic algebraic, plane geometric and trigonometric formulas. Must be able to demonstrate ability to calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships. Needs to be able to interpret basic, descriptive statistical reports. Judgment and Situational Reasoning Ability: Must be able to use functional reasoning and apply rational judgment when performing diversified work activities. Needs to be able to analyze data and information using established criteria in order to determine consequences and identify and select alternatives. Physical Requirements: • Needs to be able to operate equipment with some requiring rapid adjustments such as a computer keyboard and terminal, digitizer, plotter, printers, photocopier, calculator. Must be able to coordinate eyes, hands, feet and limbs in performing skilled movements such as rapid keyboard use. Needs to be able to recognize and identify degrees of similarities or differences between characteristics of colors, textures, and forms associated with job-related objects, materials, and tasks. • Must be able to remain seated for prolonged periods of time as tasks may involve extended periods of time at a keyboard or workstation. Needs to be able to perform downward and upward flexion of neck, side-to-side turning of the neck, fine finger dexterity and grasp to manipulate the keyboard, telephone, writing instruments, papers, books, manuals, and reports. Job entails occasional walking, standing, bending, stooping, climbing, reaching at and above shoulders, and twisting at the waist. On an infrequent basis, the incumbent must be able to squat and kneel. • Overtime and attending meetings outside regular work hours may be required. Work environment is professional and team oriented. • There is some repetitiveness in program coding, a need for extreme accuracy and attention to detail. Additionally, there is a need to be able to shift attention before tasks are completed to be able to balance user demands, telephone and other interruptions. • Must be able to drive and maintain a California Class C Driver's license or ability to arrange transportation for fieldwork or visits to other City facilities when necessary. This classification specification does not constitute an employment agreement between the employer and employee and is subject to change by the City and the needs of the City and requirements of the job change. The City of Carlsbad is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodation to qualified individuals with disabilities and encourages both current and prospective employees to discuss potential accommodations with the employer. CITY OF CARLSBAD CLASS SPECIFICATION POSITION: SENIOR WEB ADMINISTRATOR DEPARTMENT: INFORMATION TECHNOLOGY Distinguishing Features and Summary Description: Under general direction of the Information Technology Manager, the Senior Web Administrator manages the design, format and functionality of the City's entire Internet and Intranet presence by determining the needs of the organization and the requirements for the Internet and Intranet systems. The Senior Web Administrator may supervise or lead the work of direct reports or other staff assigned during various projects. Essential Duties and Responsibilities: The following duties are typical for this position. Incumbents may perform some but not all of the listed duties and/or may be required to perform additional duties from those listed below to meet the City's business needs and changing operating practices. Other duties may be required and assigned. Participates in the Information Technology Department's strategic planning efforts. Manages and maintains the day-to-day operation of the City's Internet and Intranet sites including the transfer, testing, and updating of Web materials. Converts submitted materials to Web documents as necessary. Secures programming, graphics, word processing, and authoring support as needed. Obtains bids quotes and administers request for proposals and selection of associated web based applications, tool or services as prescribed. Advises and trains City departments in content management and design of Web documents. Researches new Web features and tools which might be useful for managing the Internet and Intranet sites, and for expanding on-line offerings. Serves as a catalyst for stimulating interest and new directions for the Internet. Stays abreast of current and emerging technologies related to areas of expertise. Develops and maintains a roadmap(s) for the City's Internet presence, based on policy directions and management goals. 2 c- Develops, maintains and enhances online transaction capabilities and services as warranted. Develops and maintains practices for the City's presence on the Internet, incorporating all relevant laws and regulations. Maintains awareness of ongoing Information Technology Departmental policy and management initiatives, and identifies opportunities to use the Internet to facilitate initiatives. Meets with departments and cross functional teams to provide guidance and support for developing hosted solutions. Coordinates Internet presence with the Intranet and with other related systems containing public information. Reports on the City's Internet presence as needed or requested. Develops and articulates the overall focus and concept for the City's home page, in keeping with Departmental priorities and objectives. Searches and reviews links for new categories. Determines content management applications to support various departments placement of all new information. Meets with Information Technology staff to address and resolve technical problems, and discuss new directions and technology. Performs maintenance activities and other support activities for stakeholders. Fine tunes home or satellite site(s) based on feedback from users and monthly statistics. Supervises, develops and evaluates direct reports. Distributes and assigns workload to reports or other staff assigned during various projects. KNOWLEDGE AND ABILITIES • Knowledge of project management practices and the ability to manage multiple projects simultaneously • Knowledge of UNIX and Windows environments • Proficiency with programming and scripting languages including HTML, DHTML, XML/XSL, RSS, C++, Visual Basic, ASP, and Advanced JavaScript • General knowledge of programming and scripting languages including CGI/PERL, Oracle CGI, ActiveX, Flash, Java and shell scripting • Knowledge of database applications, developing large applications for Intranets or migrating existing applications to Intranets • Ability to produce management reports • Ability to collaborate and work well in teams • Ability to have constant interface with end users and provide high levels of service EXPERIENCE AND EDUCATION A bachelor's degree in computer science or a related subject. Minimum 5 years providing web services to the enterprise or end users, including development and maintenance of high-traffic web sites and satellite sites for a government enterprise. ESSENTIAL FUNCTIONS The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Language Ability: • Requires ability to compare, count, differentiate, measure, measure and/or sort, assemble, copy, record and transcribe data and information. Must be able to classify, compute, tabulate, and categorize data. • Must be able to advise and provide interpretation to others on how to apply policies, procedures, and standards to specific situations. • Needs to be able to use a variety of descriptive data and information such as: a variety of plans; resolutions; maps; reports: computer software operating manuals; procedures; guidelines; and routine correspondence. • Must be able to communicate orally and in writing, clearly and concisely and in a non-technical manner with City personnel at all levels; consultants; vendors; and the general public. • Needs the ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Must be able to write reports, business correspondence, and procedure manuals. Needs to effectively present information and respond to questions from groups of managers, clients, and the general public. Mathematical Ability: Knows how to apply mathematics, including basic algebraic, plane geometric and trigonometric formulas. Must be able to demonstrate ability to calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships. Needs to be able to interpret basic, descriptive statistical reports. 72- Judgment and Situational Reasoning Ability: Must be able to use functional reasoning and apply rational judgment when performing diversified work activities. Needs to be able to analyze data and information using established criteria in order to determine consequences and identify and select alternatives. Physical Requirements: • Needs to be able to operate equipment and machinery with some requiring rapid adjustments such as a computer keyboard and terminal, digitizer, plotter, blue line printers, photocopier, calculator, drafting instruments, and engineer and architect scale. Must be able to coordinate eyes, hands, feet and limbs in performing skilled movements such as rapid keyboard use. Needs to be able to recognize and identify degrees of similarities or differences between characteristics of colors, textures, and forms associated with job-related objects, materials, and tasks. • Must be able to remain seated for extended periods. Tasks may involve extended periods of time at a keyboard or workstation. Needs to be able to perform frequent downward flexion of neck, side-to-side turning of the neck, fine finger dexterity and grasp to manipulate the keyboard, telephone, writing instruments, papers, books, manuals, and reports. Job entails occasional walking, standing, bending, stooping, climbing, reaching at and above shoulders, twisting at the waist, upward flexion of the neck. On an infrequent basis, the incumbent must be able to squat and kneel. • Overtime and attending meetings outside regular work hours may be required. Work environment is professional and both team and autonomy oriented. This position is impacted by urgent time deadlines due to various reporting and filing requirements. Position involves support of a 24/7/365 days environment and/or duties to support the Safety Department or City emergency operations. • There is some repetitiveness in program coding, a need for extreme accuracy, and paying attention to detail. Additionally, there is a need to be able to shift attention before tasks are completed to be able to balance user demands, telephone and other interruptions. • Must be able to drive and maintain a California Class C Driver's license or ability to arrange transportation for fieldwork or visits to other City facilities when necessary. This classification specification does not constitute an employment agreement between the employer and employee and is subject to change by the City and the needs of the City and requirements of the job change. The City of Carlsbad is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodation to qualified individuals with disabilities and encourages both current and prospective employees to discuss potential accommodations with the employer. CITY OF CARLSBAD CLASS SPECIFICATION JOB SERIES: NETWORK ASSOCIATE, NETWORK ENGINEER, SENIOR NETWORK ENGINEER DEPARTMENT: INFORMATION TECHNOLOGY Distinguishing Features and Summary Description: The primary purpose of positions in this job series is to use experience and expertise to resolve technical problems and design new solutions relating to servers, networking and infrastructure. The Network Associate is the entry level in the Network Engineer job series. The Network Associate is responsible to perform routine network maintenance. Positions at this level are not expected to function with the same amount of program knowledge as the Network Engineer. The Network Engineer is the journey level of the Network Engineer series. The Network Engineer develops, configures, deploys and maintains the enterprise network server systems to avoid interruptions in network services. Network Engineers assigned to the telecommunications network are responsible for the management of the City's enterprise voice network, voice mail system and cabling projects. Network Engineers may lead the work of less experienced team members or project teams. The Senior Network Engineer is the senior level of the network engineer job family. The Senior Network Engineer is differentiated from the Network Engineer because of their primary role of overseeing and ensuring smooth operation and reliability and access to the entire enterprise system and networks. This position takes an end-to-end view of all systems and the network with a strong eye towards system integration and security. A secondary role of the Senior Network Engineer may be to supervise the work of Network Engineers. The Senior Network Engineer may be staffed alternatively by a Senior Security Engineer primarily assigned to system engineering efforts to define future architecture views and the strategies to realize them. The definition of future architecture views includes mapping business strategies to technology strategies, mapping business needs to the IT infrastructure, and recommending architectural and security standards. The Senior Security Engineer may supervise the work of Network Engineers. Essential Duties and Responsibilities: The following duties are typical for this job series and include the following. Incumbents may not perform all of the listed duties and/or may be required to perform additional duties from those listed below to meet the City's business needs and changing operating practices and overall technological trends. Other duties may be required and assigned. NETWORK ASSOCIATE Performs routine network maintenance i.e. network servers, routers and switches. Creates new users and associated file access rights. Identifies and resolves computer and network problems. Performs a variety of duties in the monitoring, installation, testing, configuration and troubleshooting of hardware and software and system or application upgrades. Installs cabling and wiring for systems, telecommunication systems and peripheral equipment. Conducts repairs and maintains preventative maintenance schedules for application, network and access services. Conducts troubleshooting on assigned user rights, file access, security settings, server and server communication, and enterprise print systems. Conducts system and database backups as necessary; files backup tapes and maintains tape library. Provides assistance to information systems staff in the evaluation, selection, acquisition and implementation of computer hardware and software. Monitors antivirus definition updates for servers/desktops. Provides technical training to end users. NETWORK ENGINEER Includes all duties listed in the Network Associate in addition to: Maintains network, file and print server(s) and network infrastructure for the city. Maintains network service on Inter and Intranet, manages and maintains assigned directory infrastructure, group policies, protocols and account management within defined ranges. Performs testing, applies patches and writes code to enable network systems integration. Plans, configures and maintains network and file and print server(s) and network infrastructure for the city. Builds and maintains city-wide data storage. Designs and implements Local Area Network and Wide Area Network projects and coordinates outside vendors or agencies as needed. Integrates and maps business needs and strategies of internal and external customers and maps into technology infrastructure and solutions. Designs and maps assigned areas to navigate the Information Technology Roadmap(s). Manages and maintains server OS patches and upgrades, including virtualized environments. Analyzes system and network security risks and secure access; current posture; network stability and usage. Plans and builds Disaster Recovery replication practices. Acquires system products and makes preparations for implementation and integration. Supervises and/or assisst in cabling, including installation and design of cable/fiber installs inside City buildings. Monitors and maintains email systems. Provides project support on server/application projects. Makes recommendations on software and hardware upgrades, capacity requirements and creation of virtual environments. Conducts request for proposals, purchasing of hardware and software supplies and negotiate with vendors. Leads and manages technology vendors in the scope of assigned work for the City of Carlsbad. Leads and or participates and contributes on projects of moderate scope relating to server maintenance, backup maintenance and/or audio visual system maintenance. Recommends and assists in establishing technology user policies and procedures. Makes recommendations for budget planning. Telecommunications Responsibilities Typically assigned at the Network Engineer level Manages administrates voice network for the enterprise. Manages and administrates voice mail system. Manages and administrates cabling projects. Configures and manages wide area communication devices. Coordinates installation, maintenance and troubleshooting of wide area communication lines. Researches, analyzes, acquires and maintains voice and data communication lines and circuits. Provides technical guidance to ensure installed phone systems, voice mail and data communications are reliable and current. Public Safety Systems Responsibilities Typically assigned at the Network Engineer level Performs analytical duties in the development, operation, administration, and support of the City's public safety information systems including the Computer Aided Dispatch (CAD) System for E9-1-1. Supports operations of the Mobile Dispatch Terminals in police vehicles and Geographic Information Systems images for fire vehicles. Works with client systems administrators on Police and Fire Departments on laptop hardware and software. Works with regional and state consortiums to study and/or implement safety related technology. Senior Network Engineer Includes all duties listed in the Network Engineer in addition to: Performs the role of lead or supervisor; assigns work; distributes workload; authorizes timesheets; approves vacation requests and assists in recruitment and evaluation processes. Plans and integrates technology to meet milestones and timelines and management of highly visible and complex projects. Ensures the health and reliability of City's computer networks, system access, operation and security. Plans resource allocation and develops work plans for the Information Technology Department. Manages multiple and simultaneous complex technology projects. Participates and contributes in the strategic plan for the City's enterprise system. Supervises and/or resolves escalated types of complex network, system limitation and access problems for all enterprise systems. Manages new services, business solutions, service delivery and or migration to new systems. Enforces Information Technology standards. Senior Network Security Engineer Staffed at the Senior Network Engineer level with focus on network security and the same requirements as Senior Network Engineer. Manage multiple enterprise projects of a complex nature with significant impact to the organization. Ensures secure local and remote access to enterprise computing systems and information. Monitors network(s), LAN, WAN, devices, device logs, utilization and availability. Monitors firewall availability and utilization. Analyzes information collected from monitoring system and network security risks and current posture as well as network stability and usage. Review Information Technology Departments policies and deliver recommendations based on current and future needs. Industry best practices and national cyber security alerts. Designs and implements scalable solutions with security, manageability and reliability as the cornerstone to every project. Resolves customer issues that are escalated for all enterprise systems and support all other Information Technology staff, projects, issues and systems as challenges arise. JOB SERIES KNOWLEDGE AND ABILITIES Network Associate • Knowledge of Microsoft Windows Operating Systems • Knowledge of general E-mail and other collaboration technologies • Basic knowledge of infrastructure device installation, configuration and maintenance (i.e. firewalls, routers, switches) • Knowledge of network servers, storage systems and maintenance • Knowledge of network connectivity • Knowledge of computer network operations limited to moderate scope • Ability to learn and utilize general networking protocols • Ability to troubleshoot end user network access • Ability to perform basic purchasing • Ability to work independently with occasional supervision Network Engineer Knowledge and abilities required of the Network Associate in addition to: • Knowledge of infrastructure device installation, configuration and maintenance (i.e. firewalls, routers, switches) Working knowledge of batch scripting Knowledge of Cisco networking Ability to implement backup technologies Ability to design, plan and manage virtualization environments Knowledge of Microsoft clustering Ability to utilize RAID configurations Knowledge of directories, group policies, file systems, domains and protocols • Knowledge of network security issues Senior Network Engineer / Security Engineer Includes knowledge and abilities of the Network Engineer in addition to: • Knowledge of principles and practices of management and supervision • Broad knowledge of multiple technologies, servers, storage and security at the enterprise level. • Deep working knowledge of network and information security principals and practices • Strong background and abilities in project management • Strong background and abilities in contract management • Expertise in Local and Wide Area Networks • Ability to perform file auditing • Ability to implement file transfer protocols • Ability to maintain a high degree of accuracy • Ability to track project or other schedules • Ability to build and maintain servers • Ability to supervise Email • Ability to establish network and system recovery practices • Ability to implement storage practices and policies • Knowledge of user-id account management • Ability to execute senior level project management • Ability to make complex business based decisions • Ability to create and evaluate system proposals • Ability to articulate cost-benefit solutions JOB SERIES EXPERIENCE AND EDUCATION Network Associate Requires an AA degree and a minimum of 2 years experience with an enterprise system of the same or greater scope and complexity. Network Engineer Experience and Education requirements of the Network Associate in addition to: Bachelors degree in Management Information Systems, Computer Science, Information Technology or a related discipline, or equivalent experience/combined education, with 5 years of professional experience. Senior Network Engineer/Senior Network Security Engineer Experience and Education requirements of the Network Engineer in addition to: 7 years of professional experience or equivalent. Three years of supervisory experience or demonstrated ability to lead complex projects with important impacts. JOB SERIES ESSENTIAL FUNCTIONS The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Language Ability: • Requires ability to compare, count, differentiate, measure and/or sort, assemble, copy, record and transcribe data and information. Must be able to classify, compute, tabulate, and categorize data. Must be able to advise and provide interpretation to others on how to apply policies, procedures, and standards to specific situations. Needs to be able to use a variety of descriptive data and information such as: a variety of plans; resolutions; maps; reports; computer software operating manuals; procedures; guidelines; and routine correspondence. • Must be able to communicate orally and in writing, clearly and concisely and in a non-technical manner with City personnel at all levels; consultants; vendors; and the general public. • Needs the ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Must be able to write reports, business correspondence, and procedure manuals. Needs to effectively present information and respond to questions from groups of managers, clients, and the general public. Mathematical Ability: Knows how to apply mathematics, including basic algebraic, plane geometric and trigonometric formulas. Must be able to demonstrate ability to calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships. Needs to be able to interpret basic, descriptive statistical reports. Judgment and Situational Reasoning Ability: Must be able to use functional reasoning and apply rational judgment when performing diversified work activities. Needs to be able to analyze data and information using established criteria in order to determine consequences and identify and select alternatives. Physical Requirements: • Needs to be able to operate equipment and machinery with some requiring rapid adjustments such as a computer keyboard and terminal, digitizer, plotter, blue line printers, photocopier, calculator, drafting instruments, and engineer and architect scale. Must be able to coordinate eyes, hands, feet and limbs in performing skilled movements such as rapid keyboard use. Needs to be able to recognize and identify degrees of similarities or differences between characteristics of colors, textures, and forms associated with job-related objects, materials, and tasks. • Essential and marginal functions may require maintaining physical condition necessary for sitting for prolonged periods of time. Must be able to exert light physical effort,, typically involving lifting, carrying, pushing and pulling of up to 30 pounds. Tasks may involve extended periods of time at a keyboard or workstation. Needs to be able to perform frequent downward flexion of neck, side-to-side turning of the neck, fine finger dexterity and grasp to manipulate the keyboard, telephone, writing instruments, papers, books, manuals, and reports. • Job entails occasional walking, standing, bending, stooping, climbing, reaching at and above shoulders and twisting at the waist. On an infrequent basis, the incumbent must be able to squat and kneel. • Work may involve occasional outdoor fieldwork. • Overtime and attending meetings outside regular work hours may be required. Work environment is professional and both team and autonomy oriented. This position is impacted by urgent time deadlines due to various reporting and filing requirements. This position is impacted by urgent time deadlines due to various reporting and filing requirements. Positions in Public Safety involve support of a 24/7/365 days environment and/or duties to support the Safety Department or City emergency operations. • There is some repetitiveness in program coding, a need for extreme accuracy, and paying attention to detail. Additionally, there is a need to be able to shift attention before tasks are completed to be able to balance user demands, telephone and other interruptions. • Must be able to drive and maintain a California Class C Driver's license or ability to arrange transportation for fieldwork or visits to other City facilities when necessary. This classification specification does not constitute an employment agreement between the employer and employee and is subject to change by the City and the needs of the City and requirements of the job change. The City of Carlsbad is an Equal opportunity Employer. In compliance with the Americans with Disabilities act, the City will provide reasonable accommodation to qualified individuals with disabilities and encourages both current and prospective employees to discuss potential accommodations with the employer. CITY OF CARLSBAD CLASS SPECIFICATION JOB SERIES: CLIENT SYSTEMS ASSOCIATE ADMINISTRATOR, CLIENT SYSTEMS ADMINISTRATOR DEPARTMENT: INFORMATION TECHNOLOGY Distinguishing Features and Summary Description: The primary objective of this job series is to provide direct support for client systems and resolve technical problems in the installation and maintenance of personal computers, printers, peripheral devices and mobile devices. Many of the duties in this job series are centered on providing direct support for client systems. The Client Systems Associate Administrator works independently with occasional instruction or assistance as new or unusual problems arise. The Client Systems Associate Administrator is expected to be fully aware of standard operating procedures to resolve end user problems. The Client Systems Administrator is the senior in this job series and performs at a lead and/or supervisory level and provides client systems support for client computer activity throughout the City. The Client Systems Administrator is responsible to research unique solutions to client computer problems and performs custom installation packaging to deploy software applications and system configurations. Essential Duties and Responsibilities: The following duties are typical for this job series. Incumbents may perform some but not all of the listed duties and may be required to perform additional duties from those listed below to meet the City's business needs and changing operating practices. Other duties may be required and assigned. CLIENT SYSTEMS ASSOCIATE ADMINISTRATOR Provides support to end users to resolve problems and maintain proper utility for personal computer, laptop and mobile device operations. Provides proper working operations and quality support for peripheral devices including local network printers, plotters, faxes, scanners, all in ones, etc. Ensures client software operate effectively. Installs and tests personal computers, printers, and other peripheral devices. Performs basic contract management on desktop hardware and maintenance contracts. Provides user training on new products, applications and devices. Sets up mobile devices for customer use and provides technical support for related issues. Configures operating systems, shrink-wrap programs, and applications software programs. Performs password resets; may use tools to assign passwords, create user accounts, and assign access rights. Supports policies for laptops and peripheral device utilization and enforces desktop standards. Utilizes imaging tools to deploy client devices. Ensures operating structures for small network functions related to client device operations. Manages projectors and other multi-media devices located in staff meeting rooms. Performs station network cabling. Performs system support for small and niche applications. Troubleshoots small network based switches, routers and wireless access points as directed. Assists with system security to avoid violating firewalls and other system security i.e. internet access. Makes decisions regarding replacement of equipment; use of specialty software; changes to desktop support procedures; planning the deployment of new personal computer assets; laptop and desktop standards. Determines types and sizes of personal computers in relation to user specifications. Identifies suppliers; performs request for bids; obtains proposals and quotes; encumbers funds to acquire goods and services. Purchases client devices as directed. Assumes responsibility for vendor communications when vendor is unable to resolve problems. Assists with asset lifecycle management - acquisition - deployment - obsolete processing. Documents and tracks support activity and records of equipment and software as necessary. Consults with; acts as liaison and coordinates meeting with vendors and IT staff as needed. Provides guidance to those with less experience. CLIENT SYSTEMS ADMINISTRATOR Performs Associate Administrator duties in addition to: Performs the role of supervisor; assigns work; authorizes timesheets; provides performance input. Creates complex application packaging for automated deployment. Ensures hardware and software assets are tracked throughout their useful life. Assists in management of organization wide Active Directory. Collaborates with the Network Group to establish and maintain user group policies consistent with operating standards. Manages the annual cycle for replacement of personal computers. Manages processes for appropriate citywide application upgrades. Manages wireless device configuration. Makes recommendations on the budget for annual computer installations, replacements and software management tools. JOB SERIES KNOWLEDGE AND ABILITIES Client Systems Associate Administrator Knowledge of Microsoft Windows Operating Systems Knowledge of PC hardware Installation and maintenance of personal computer hardware Basic Information Technology terminology such as IP addresses Knowledge of network connectivity and VPN support are preferred Knowledge of technology life cycles Knowledge of modern practices for application deployment Knowledge of computer network operations of limited to moderate scope Ability to provide customer service in person, via remote control technologies and over the telephone • Ability to troubleshoot personal computer hardware and software and provide repair • Ability to troubleshoot local/network printers • Ability to troubleshoot end user network access • Ability to perform basic purchasing • Ability to work independently with occasional supervision Client Systems Administrator Knowledge and abilities required of the Client Systems Associate Administrator in addition to: • Knowledge of basic supervisory practices • Knowledge of basic forecasting and budget processes • Knowledge of computer network operations of moderate to advanced scope • Knowledge of Windows Server Operating Systems, and the TCP/IP protocol • Knowledge of network management protocols and related tools • Knowledge of network-based application software such as Email and other collaboration applications • Ability to perform unique application deployment • Ability to analyze and diagnose problems effectively • Ability to establish best practices for purchasing of personal computers, printers and other devices and equipment • Ability to assist in the planning and designing of personal computer support systems JOB SERIES EDUCATION AND EXPERIENCE: Client Systems Associate Administrator Bachelors of Science or Arts degree from an accredited college in a related discipline and 2 years of experience troubleshooting end user problems in a help desk environment. Client Systems Administrator Education and Experience required of the client Systems Associate Administrator in addition to: Bachelors in Management Information Systems, Computer Science or Information Technology or a related discipline and 3 years experience administering, deploying, maintaining, and securing a City-wide help desk operation (mid-size network). In addition, experience in testing PC/LAN technologies and computer system applications and 1 year serving in the capacity as a technical lead or supervisor are preferred. ESSENTIAL FUNCTIONS FOR JOB SERIES: The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Language Ability: • Requires ability to compare, count, differentiate measure and/or sort, assemble, copy, record and transcribe data and information. Must be able to classify, compute, tabulate, and categorize data. Must be able to advise and provide interpretation to others on how to apply policies, procedures, and standards to specific situations. Needs to be able to use a variety of descriptive data and information such as: a variety of plans, resolutions, maps, reports, computer software operating manuals, procedures, guidelines, and routine correspondence. • Must be able to communicate orally and in writing, clearly and concisely and in a non-technical manner with City personnel at all levels; consultants; vendors; and the general public. • Needs the ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Must be able to write reports, business correspondence, and procedure manuals. Needs to effectively present information and respond to questions from groups of managers, clients, and the general public. Mathematical Ability: Knows how to apply mathematics, including basic algebraic, plane geometric and trigonometric formulas. Must be able to demonstrate ability to calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships. Needs to be able to interpret basic, descriptive statistical reports. Judgment and Situational Reasoning Ability: Must be able to use functional reasoning and apply rational judgment when performing diversified work activities. Needs to be able to analyze data and information using established criteria in order to determine consequences and identify and select alternatives. Physical Requirements: • Needs to be able to operate equipment with some requiring rapid adjustments such as a computer keyboard and terminal, digitizer, plotter, printers, photocopier, calculator, drafting instruments. Must be able to coordinate eyes, hands, feet and limbs in performing skilled movements such as rapid keyboard use. Needs to be able to recognize and identify degrees of similarities or differences between characteristics of colors, textures, and forms associated with job-related objects, materials, and tasks. • Functions may require sitting for prolonged periods of time; the ability to exert light physical effort involving lifting, carrying, pushing and pulling of up to 30 pounds. Needs to be able to perform frequent downward or 37 upward flexion or turning of the neck, fine finger dexterity and grasp to manipulate the keyboard, telephone, writing instruments, papers, books, manuals, and reports. • Job entails walking, standing, bending, stooping, climbing, reaching at and above shoulders and twisting at the waist. On an infrequent basis, the incumbent must be able to squat, kneel, and/or work while reclined. May be exposed to loud noises during field visits. • Overtime and attending meetings outside regular work hours may be required. Work environment is professional and team oriented. This position is impacted by urgent time deadlines due to various reporting and filing requirements. Positions in Public Safety involve support of a 24/7/365 days environment and/or duties to support the Safety Department or City emergency operations. • There is some repetitiveness in program coding, a need for extreme accuracy, and paying attention to detail. Additionally, there is a need to be able to shift attention before tasks are completed to be able to balance user demands, telephone and other interruptions. • Must be able to drive and maintain a California Class C Driver's license or ability to arrange transportation for fieldwork or visits to other City facilities. This classification specification does not constitute an employment agreement between the employer and employee and is subject to change by the City and the needs of the City and requirements of the job change. The City of Carlsbad is an Equal opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodation to qualified individuals with disabilities and encourages both current and prospective employees to discuss potential accommodations with the employer. 3 CITY OF CARLSBAD CLASS SPECIFICATION JOB SERIES: GEOGRAPHIC INFORMATION SYSTEMS GIS TECHNICIAN, GIS ASSOCIATE ANALYST, CIS ANALYST, GIS ADMINISTRATOR DEPARTMENT: GEOGRAPHIC INFORMATION SYSTEMS DISTINGUISHING FEATURES AND SUMMARY DESCRIPTION: This objective of this job series is to process and deliver on service requests, data creation and database management activities and specialized GIS application programming. The GIS Technician is the entry level position in the multi level GIS job family. The GIS Technician creates and maintains the various layers of the City's geodatabase. The GIS Technician performs the more routine manual and computerized geographic information processing tasks that are assigned. The Associate GIS Analyst is distinguished from the GIS Technician by the Associate GIS Analyst's increased breadth of GIS technical expertise, and scope of departmental responsibilities. The Associate GIS Analyst level requires the ability to apply mid-level to advanced GIS techniques for analysis and product production for a variety of City clients. The GIS Analyst is the journey-level in the GIS Analyst series. The primary purpose of this position is to be the lead resource for the application of GIS technology to all City uses. The GIS Analyst sets up and manages complex projects involving GIS staff, city client staff, and IT resources, and produces advanced data products for all City clients. The GIS Systems Administrator is responsible for implementing and maintaining the various databases of spatial information making up the enterprise GIS, as well as the maintenance of client-side and server-based GIS applications. Additionally the GIS Systems Administrator organizes, coordinates, maintains, and upgrades system databases, software, and hardware. The GIS Systems Administrator ensures that data quality and information is reliable and consistently maintained. The GIS Systems Administrator serves as the technical liaison with the Information Technology Department for all matters related to GIS database and software systems. ESSENTIAL DUTIES AND RESPONSIBILITIES GIS TECHNICIAN Operates a GIS workstation to create and maintain the wide variety of spatial information contained in an enterprise GIS that supports City operations. Performs related technical duties in the development, implementation, operation and maintenance of the City's enterprise geographic information systems. 3 *»0 / Under direction, creates simple graphic displays and maps for various departments' needs. Operates a variety of geographic information system input and output devices such as: scanners, printers, and large-format inkjet plotters. Utilizes a variety of City systems to find and collect data for use in everyday work such as: Document Management System, Permit Processing System, and manual files. Researches and analyzes geographic and tabular data from public and private sources for integration into the City's enterprise GIS. Within their work assignments, demonstrates an effort to improve operations, decrease turnaround times, streamline work processes, and work cooperatively to provide seamless and quality customer service. Must be able to work under time constraints and deadlines, accomplish project tasks in cooperation with other employees. Maintains and continually upgrades knowledge of GIS functionality, principles and practices. Attends and participates in local professional group meetings as required. Participates in online professional list serves and/or blogs. Stays abreast of new trends and innovations in the field of GIS, database design, and related hardware and software. GIS ASSOCIATE ANALYST Performs all the duties of the GIS Technician in addition to: Maintains and enhances GIS data sets according to evolving needs and resources including: digitizing and editing spatial data, conducting office and field research, creating, calculating and editing of attributes and merging of data from different sources. Utilizes Global Positioning System (GPS) receivers and data loggers to collect field data and post-process the results to the GIS. Configures software on field collection devices to optimize data collection work. Utilizes all available information systems to search for and collect data required for GIS related tasks. Converts data received from outside sources to make it available for future projects. Downloads data from other systems. Under direction, collaborates with other GIS staff and various City departments to understand their geographic data needs, and generates standard and customized products from the GIS such as presentation maps, digital graphics and reports for users in all City departments. Under direction, assists in the maintenance of desktop GIS software; applies patches, and troubleshoots technical problems. Responds to inquiries and gives problem solving assistance. Utilizes various scripting languages (VB, C++, C#) to customize and automate GIS processes. Assists in training City staff in the use of appropriate GIS applications. Maintains documentation for administrative and record keeping purposes, system documentation and training materials, and adheres to change control and security procedures and protocols set by the Information Technology department. Responds to public inquiries in a courteous and professional manner. Provides information within the area of assignment. Resolves complaints in an efficient and timely manner. Assists in monitoring, evaluating, and improving the efficiency and effectiveness of service delivery methods and procedures. Maintains and continually upgrades knowledge of GIS functionality. Attends and participates in local professional group meetings, online professional list serves and/or blogs; stays abreast of new trends and innovations in the field of GIS, database design, and related hardware and software. GIS ANALYST Performs all the duties of the GIS Associate Analyst in addition to: Performs complex geoprocessing and geospatial analysis, and designs and produces advanced cartographic products. Acquires spatial information from diverse sources. Refines and manipulates data including the merging data from dissimilar sources. Documents data sets, applications and procedures. Leads the collaboration with other GIS staff and various City departments to understand their geographic data needs, and generates standard and customized products from the GIS such as presentation maps, digital graphics and reports for users in all City departments. Leads, in collaboration with the GIS Systems Administrator, the maintenance of desktop GIS software; applies patches, and troubleshoots technical problems. Responds to inquiries and gives problem solving assistance. Leads the development of data quality and cartographic standards, and defines best practices for GIS operations. Makes recommendations to the GIS Manager on software acquisitions and configurations. Assists in the maintenance of GIS and related software systems. 1-1 Provides information, resources, support and assistance to users of GIS software and/or custom applications. Responds to inquiries and gives problem solving assistance. Assists in training City staff in the use of GIS on an individual basis or in a classroom setting. GIS ADMINISTRATOR May perform duties within the series in addition to: Under the direction of the GIS Manager, participates in the design, development, and implementation of the GIS to meet various needs and functions of various City departments. Coordinates with other GIS staff to plan, design, and implement procedures that enhance access and responsiveness of GIS. Maintains the enterprise geodatabase, and uses relational database technologies to prepare and deliver GIS products and applications. Develops automated programs to make routine database maintenance procedures more efficient. Designs and develops tools for displaying or retrieving GIS information from relational databases using modern database utilities and develops strategies for integrating GIS with other existing City databases and applications. Configures and maintains intranet/internet web-based GIS applications. Administers GIS servers and workstations including application software upgrades and patches, and the addition and configuration of peripheral devices. Utilizes a variety of programming tools (Visual Basic, Visual Studio, Python, C, C++, C#) to create automated system administration scripts, models, and other automated routines. Researches and provides recommendations for computer hardware and GIS software purchases. Establishes projected equipment and supply requirements. Participates in the development and implementation of goals, objectives, policies, and priorities for the enterprise GIS. Maintains and continually upgrades knowledge of GIS functionality. Attends and participates in local professional group meetings, online professional list serves and/or H blogs; stays abreast of new trends and innovations in the field of GIS, database design, and related hardware and software. JOB SERIES KNOWLEDGE AND ABILITIES: GIS Technician • Must know how to use ESRI ArcGIS software to enter, edit and output geographic information, and be familiar with the Windows operating system and file systems. • Be proficient in the use of standard hardware such as Windows workstations, scanners, digitizers, large format inkjet plotters, office printers. • Know the methods and techniques of designing and creating basic cartographic products. • Be familiar with the geographic concepts of location, scale, resolution and generalization. • Must be able to apply knowledge of the principles and practices of effective customer service. • Basic project management principles to facilitate own work in small group processes. GIS Associate Analyst Knowledge and abilities required of the GIS Technician in addition to: • GIS concepts, including techniques of spatial analysis, and basic geographical concepts of location, scale, resolution and generalization. • Must have moderate to advanced knowledge of the use ESRI ArcGIS software to enter, edit and output geographic information, and be familiar with the Windows operating system and file systems. • Knowledge of the use of GPS receivers and programming of data loggers to collect and post-process field data. • Familiar with the various methods of data collection and in the sources of spatial data available and appropriate for use by local agencies. • Be proficient in the use of standard hardware such as Windows workstations, scanners, digitizers, large format inkjet plotters, office printers. • General knowledge of municipal agency GIS uses, within planning, public works, parks and recreation, and public safety departments. • Basic project management principles to facilitate own projects. • Must be able to apply knowledge of the principles and practices of effective customer service. • Able to write scripts to automate processes and customize ArcGIS settings using VB, C++, or C#. GIS Analyst Knowledge and abilities required of the GIS Associate Analyst in addition to: • GIS concepts, including advanced techniques of geoprocessing and spatial analysis, and geographical concepts of location, scale, resolution and generalization. • Advanced knowledge and experience in the use of ArcGIS software and its extensions for 3-D visualization and analysis, and network and raster analysis. • Experienced in the various methods of data collection and in the sources of spatial data available and appropriate for use by local agencies. • Knowledge of the use of GPS receivers and the programming of data loggers to collect and post-process field data. • Be proficient in the use of standard hardware such as Windows workstations, scanners, digitizers, large format inkjet plotters, and office printers. • Able to write programs in Visual Basic, C++ or C# to automate GIS processes and customize interfaces. • General knowledge of municipal agency GIS uses, within planning, public works, parks and recreation, and public safety departments. • Map production; methods and techniques of conducting research and analyzing geographic and other related data. • Effective customer service practices. • Principles of project management to manage the technical aspects of departmental projects. • Pertinent federal, state and local laws, codes, and regulations. GIS Administrator Knowledge and abilities of the GIS Analyst in addition to: • Comprehensive knowledge of geographic information systems (GIS) theory and practices, as well as with general principles and practices of enterprise information technology systems and structures. • Geographic concepts of location, scale, resolution and generalization. • Advanced ArcGIS skills. • Operation and maintenance of plotters, digitizers, and scanners. • Working with relational database systems, specifically MS Access and SQL Server, and in the creation and maintenance of the systems. • Proficient in the use of Visual Basic, C++ or C# to create and edit new and existing programs used for GIS and geodatabase processing. • Creating and analyzing complex land based data systems involving interdepartmental interactions. Requires familiarity with techniques of spatial analysis of areas and networks. • Project management principles and techniques to manage system administration tasks and conversion/implementation projects. EDUCATION AND EXPERIENCE GIS Technician • Equivalent to an Associate's degree or equivalent coursework from an accredited college or university or technical or vocational school with major course work in geography, planning, landscape architecture, civil engineering, natural resources, or computer science including coursework in GIS. A Bachelor's degree is desirable. • At least two years of experience using ESRI ArcGIS software in the development and maintenance of a multi-user geographic information system. Experience interpreting topographic maps, engineering improvement plans, and "as built" plans is also required. GIS Associate Analyst • Equivalent to a Bachelor's degree from an accredited college or university with major course work in geography, planning, landscape architecture, civil engineering, natural resources, or computer science including coursework in GIS. • At least three years experience using ESRI ArcGIS software in a municipal or related environment of diverse user needs. Experience in assessing client needs and translating them into GIS products and services. GIS Analyst All education required of the GIS Associate Analyst in addition to: • At least four years of progressive experience designing, implementing, and maintaining GIS databases and applications, along with substantial GIS project experience utilizing a wide range of GIS software tools and specialized extensions. Needs to know how to use one of several programming languages such as Visual Basic, C++ or C# to create scripts for customizing the ArcGIS processing environment. GIS Administrator All education required of the GIS Analyst in addition to: • At least five years of progressive experience designing, implementing, and maintaining complex geodatabases in a relational environment, principally with ESRI SDE and MS SQL Server. Must also have substantial GIS project experience using ESRI GIS software products, and programming experience with Visual Basic, C++ and/or C#.. ESSENTIAL MENTAL AND PHYSICAL REQUIREMENTS FOR THE GIS SERIES The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Language Ability: • Requires ability to compare, count, differentiate, measure and/or sort, assemble, copy, record and transcribe data and information. Must be able to classify, compute, tabulate, and categorize data. Must be able to advise and provide interpretation to others on how to apply policies, procedures, and standards to specific situations. • Needs to be able to use a variety of descriptive data and information such as: a variety of plans; resolutions; maps; reports: computer software operating manuals; procedures; guidelines; and routine correspondence. • Must be able to communicate orally and in writing, clearly and concisely and in a non-technical manner with City personnel at all levels; consultants; vendors; and the general public. • Needs the ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Must be able to write reports, business correspondence, and procedure manuals. Needs to effectively present information and respond to questions from groups of managers, clients, and the general public. Mathematical Ability: Knows how to apply mathematics, including basic algebraic, plane geometric and trigonometric formulas. Must be able to demonstrate ability to calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships. Needs to be able to interpret basic, descriptive statistical reports. Judgment and Situational Reasoning Ability: Must be able to use functional reasoning and apply rational judgment when performing diversified work activities. Needs to be able to analyze data and information using established criteria in order to determine consequences and identify and select alternatives. Physical Requirements: • Needs to be able to operate equipment and machinery with some requiring rapid adjustments such as a computer keyboard and terminal, digitizer, plotter, blue line printers, photocopier, calculator, drafting instruments, and engineer and architect scale. Must be able to coordinate eyes, hands, feet and limbs in performing skilled movements such as rapid keyboard use. Needs to be able to recognize and identify degrees of similarities or differences between characteristics of colors, textures, and forms associated with job-related objects, materials, and tasks. • Must be able to exert light physical effort in sedentary to light work, typically involving lifting, carrying, pushing and pulling of up to 30 pounds. Tasks may involve extended periods of time at a keyboard or workstation. C; • Needs to be able to perform frequent downward flexion of neck, side-to-side turning of the neck, fine finger dexterity and grasp to manipulate the keyboard, telephone, writing instruments, papers, books, manuals, and reports. • Job entails occasional walking, standing, bending, stooping, climbing, reaching at and above shoulders and twisting at the waist. On an infrequent basis, the incumbent must be able to squat and kneel. • Work may involve occasional outdoor fieldwork. Overtime and attending meetings outside regular work hours may be required. Work environment is professional and team oriented. This position is impacted by urgent time deadlines due to various reporting and filing requirements. There is some repetitiveness in program coding, a need for extreme accuracy, and paying attention to detail. Additionally, there is a need to be able to shift attention before tasks are completed to be able to balance user demands, telephone and other interruptions. • Must be able to drive and maintain a California Class C Driver's license or ability to arrange transportation for fieldwork or visits to other City facilities when necessary. This classification specification does not constitute an employment agreement between the employer and employee and is subject to change by the City and the needs of the City and requirements of the job change. The City of Carlsbad is an Equal opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodation to qualified individuals with disabilities and encourages both current and prospective employees to discuss potential accommodations with the employer. CITY OF CARLSBAD CLASS SPECIFICATION JOB SERIES: INFORMATION TECHNOLOGY MANAGER DEPARTMENT: POLICE DEPARTMENT Distinguishing Features and Summary Description: Under the general direction of the Police Captain, the Public Safety Information Technology Manager (PSITM) is responsible for the management of the applications, systems/networks and staff that support Public Safety. The PSITM has considerable latitude and discretion to manage the Public Safety business applications, databases, and assigned systems/networks. The public safety applications, systems and networks are the center of many of the Police and Fire operations, both at tactical and strategic levels. The PSITM is responsible to manage the implementation, integration, enhancement and maintenance of diverse public safety applications and systems/networks by ensuring the highest reliability and performance. Essential Duties and Responsibilities: The following duties are typical for this position. Incumbents may not perform all of the listed duties and/or may be required to perform additional duties from those listed below to meet the City's business needs and changing operating practices. Other duties may be required and assigned. Manages group priorities, coordinates and reports department activities. Helps in building relationships with various entities. Determines and directs strategic planning related to the support of Public Safety, as well as assists in managing tactical responses. Recruits, hires, evaluates and supervises assigned work of technical staff. Provides guidance and assistance to staff and department users in the development, implementation and maintenance of systems and applications. Ensures delivery of public safety technology solutions and services supporting Public Safety's strategic direction and/or technology roadmap(s). Effectively delivers projects/initiatives, including capability to work in large cross- functional teams. Facilitates the deployment of technology application projects. Maintains and improves system stability. Establishes best practices to be followed by technology staff. Plans and coordinates processes required for the provision of public safety applications and systems. Plans and facilitates meetings and presentations. Authors, compiles and generates complex reports. Prepares and monitors the public safety technology budget. Communicates with all levels of the organization and elected officials. KNOWLEDGE AND ABILITIES • Technical competency in understanding elements of a system/application architecture, conceptual understanding of various components, while engaging both sides of the spectrum - internal and external business/architects and engineers/support staff. • Strong knowledge of information technology capabilities and characteristics, software languages and applications, data base technology, web technologies and data security techniques related to public safety. • Strong knowledge of systems and network capabilities and characteristics. • Strong knowledge of the application of security practices, procedures and ongoing maintenance of security to relevant system. • Conversant with the future direction of public safety applications and systems, how that direction will impact the department(s), and how future and current systems can be exploited for the benefit of the department(s). • The ability to develop and evaluate business processes and strategies that support Public Safety's business goals and objectives in a cost effective method. • Expert knowledge of Public Safety application software such as Computer Aided Dispatch (CAD) and other justice systems. • Familiarity with database administration, particularly SQL Server and/or Oracle. • Familiarity with web and enterprise application servers including administration, configuration, troubleshooting, performance tuning, preventative maintenance, implementation, and security procedures. • Strong leadership, interpersonal, negotiation and communication skills; ability to foster a collaborative team environment and provide excellent customer service; ability to communicate effectively and respectfully to a diverse community. • Excellent problem resolution and data analysis skills. • Must be able to simultaneously manage multiple technology projects and support a number of customers. EDUCATION AN AND EXPERIENCE A bachelor's degree in Computer Science, Information Technology, Management of Information Systems or equivalent. A minimum of 5 years experience managing major applications implementation projects and/or administration of moderate to large scale technology systems, with at least 3 years supervisory or management experience, preferably in technology in a public safety or government environment. ESSENTIAL FUNCTIONS The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Language Ability: • Requires ability to compare, count, differentiate, measure, measure and/or sort, assemble, copy, record and transcribe data and information. Must be able to classify, compute, tabulate, and categorize data. • Must be able to advise and provide interpretation to others on how to apply policies, procedures, and standards to specific situations. • Needs to be able to use a variety of descriptive data and information such as: a variety of plans; resolutions; maps; reports: computer software operating manuals; procedures; guidelines; and routine correspondence. • Must be able to communicate orally and in writing, clearly and concisely and in a non-technical manner with City personnel at all levels; consultants; vendors; and the general public. • Needs the ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Must be able to write reports, business correspondence, and procedure manuals. Needs to effectively present information and respond to questions from groups of managers, clients, and the general public. Mathematical Ability: Knows how to apply mathematics, including basic algebraic, plane geometric and trigonometric formulas. Must be able to demonstrate ability to calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships. Needs to be able to interpret basic, descriptive statistical reports. Judgment and Situational Reasoning Ability: Must be able to use functional reasoning and apply rational judgment when performing diversified work activities. Needs to be able to analyze data and information using established criteria in order to determine consequences and identify and select alternatives. Physical Requirements: • Needs to be able to operate equipment and machinery with some requiring rapid adjustments such as a computer keyboard and terminal. Must be able to coordinate eyes, hands, feet and limbs in performing skilled movements such as rapid keyboard use. Needs to be able to recognize and identify degrees of similarities or differences between characteristics of colors, textures, and forms associated with job-related objects, materials, and tasks. • Must be able to remain seated for extended periods. Needs to be able to perform frequent downward flexion of neck, side-to-side turning of the neck, fine finger dexterity and grasp to manipulate the keyboard, telephone, writing instruments, papers, books, manuals, and reports. Job entails occasional walking, standing, bending, stooping, climbing, reaching at and above shoulders, and twisting at the waist. On an infrequent basis, the incumbent must be able to squat and kneel. • Work may involve occasional outdoor fieldwork. Overtime and attending meetings outside regular work hours may be required. Work environment is professional and both team and autonomy oriented. This position is impacted by urgent time deadlines due to various reporting and filing requirements. Position involves support of a 24/7/365 days environment and/or duties to support the Safety Department or City emergency operations. • There is some repetitiveness in program coding, a need for extreme accuracy, and paying attention to detail. Additionally, there is a need to be able to shift attention before tasks are completed to be able to balance user demands, telephone and other interruptions. • Must be able to drive and maintain a California Class C Driver's license or ability to arrange transportation for fieldwork or visits to other City facilities when necessary. This classification specification does not constitute an employment agreement between the employer and employee and is subject to change by the City and the needs of the City and requirements of the job change. The City of Carlsbad is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the City will provide reasonable accommodation to qualified individuals with disabilities and encourages both current and prospective employees to discuss potential accommodations with the employer. CITY OF CARLSBAD CLASS SPECIFICATION JOB SERIES: BUSINESS SYSTEMS ASSOCIATE, BUSINESS SYSTEMS SPECIALIST, SENIOR BUSINESS SYSTEMS SPECIALIST DEPARTMENT: VARIOUS DEPARTMENTS Distinguishing Features and Summary Description: The Business Systems Specialist series performs an internal consultancy role with responsibility for investigating business systems, identifying options for improving business systems and bridging the needs of the business through technology solutions. The Business Systems Associate is an emerging professional able to provide business analysis through the use of technology with general supervision. The Business Systems Specialist is an emerging expert responsible to provide unique and complex business solutions through the use of technology. The position has a high degree of discretion and independence. The Senior Business Systems Specialist is a seasoned professional and an expert in providing unique solutions to complex business problems through the use of technology. The Senior Business Systems Specialist works closely with the senior management in assigned department(s) or Major Service Areas. Essential Duties and Responsibilities: The following duties are typical for this job series. Incumbents perform some but not all of the listed duties and/or may be required to perform additional duties to meet the City's business needs and changing operating practices. Other duties may be required and assigned. BUSINESS SYSTEMS ASSOCIATE Responds to end users requests, runs reports and formulates custom reports. Supports basic, common business processes and tools. Carries out assignments under direct supervision. Contributes to technology projects, may lead small to medium projects of a basic scope. Installs, sets up and maintains new computer hardware and software. Identifies and researches specific client requirements for projects and builds a working knowledge of application and/or system workflow, basic system and reporting specifications. Troubleshoots hardware and software problems; corrects or coordinates outside repair; works with a variety of vendors and computer repair specialists. Develops and implements alternatives to address or correct problems of a basic to moderate scope of complexity. Resolves and supports end users with access and utilization of work management systems; may work with vendors to solve specific issues. Conducts testing; coordinates software implementation and maintenance. Writes training materials for basic system functions; conducts basic training on the functionality of assigned technology. Ensures data required by business group is tracked and reported correctly. Develops and maintains system operation manuals for assigned computer activities including updating, tracking and managing software licenses. BUSINESS SYSTEMS SPECIALIST Performs the duties of the Business Systems Associate in addition to: Contributes to or leads technology projects. Conducts business process analysis to ensure reporting requirements. Builds business cases through evaluation and analysis and documents business processes. Creates quality assurance processes for data entry, utilization and reporting. Facilitates communication between assigned departments and the Information Technology Department, vendors for technology support and implementation. Performs assigned application administration. Converts and integrates data and writes reports. Addresses data problems and inconsistencies. Ensures course correction, timelines, communications and other aspects of project management. Designs and develops workflow to support assigned department needs for information and/or utilization of software and/or systems. Resolves integration issues with various data systems. Ensures compliance with software licensing agreements. Provides performance input. Identifies suppliers, obtains request for bids, encumbers funds to acquire goods and services. Performs backup activities in restoring software database; purges databases as required. Obtains bids, quotes; performs Requests for Proposals; selects vendors for technological services; works with vendors through installation and maintenance. Maintain hardware and software inventory, including tracking information relating to equipment problems, repair and maintenance and developing methodologies to analyze equipment usage, problems and repairs. Analyze and implement system optimization strategies designed to improve computer performance. Develop and implement methodologies to ensure data integrity and disaster recovery. SENIOR BUSINESS SYSTEMS SPECIALIST Performs the duties of the Business Systems Specialist in addition to: Plans and establishes the strategic plan and/or roadmap(s); strategic initiatives and deliverables in coordination with the City's Information Technology Department. Performs the role of lead or supervisor; assigns work; distributes workload; authorizes timesheets; approves vacation requests; assists in recruitment processes and conducts performance evaluations. Performs the role of liaison between business groups and the Information Technology Department, developing and maintaining effective working relationships. Makes recommendations to management and other staff regarding the use of technology and processes to provide solutions for business needs. Ensures support and/or leads the development of technology strategies and initiatives that integrate the vision, mission and values of the assigned major service area and the Information Technology Department technology road map. Researches and analyzes appropriate technology and processes to resolve business problems. Obtains necessary project approvals with senior management of assigned departments and the Information Technology groups. Determines what management systems and applications will be utilized; how the management system will be utilized; reporting requirements; permissions, security and customizations. Manages all project elements, i.e. budgeting, scheduling and communication. Conducts short and long range planning. Administration and troubleshooting of the library's various server and client- based systems, network communications, and library web-based interfaces; in conjunction with the Information Technology Department establishes technology related procedures, standards and protocol. Surveys and analyzes major existing or proposed systems in complex computer network areas; confers with Library Divisions to determine system requirements, functions, procedures, desired results and problem definition. JOB SERIES KNOWLEDGE AND ABILITIES: May vary depending on assignment. Business Systems Associate • Basic principles, methods and techniques to respond to user requests • Ability to troubleshoot hardware and software problems of a basic scope • Ability to establish working relationships with department users, the Information Technology Department, vendors or professionals • Ability to provide excellent customer service • Basic knowledge of assigned department operations • Knowledge of report writing concepts and tools • Knowledge of basic project management practices • Knowledge of standard personal computer software packages, including word processing, spreadsheet, database, desktop publishing • Ability to perform analysis and reach sound, logical conclusions regarding user needs and requirements • Ability to organize, plan and complete projects • Ability to perform connectivity testing and trouble shooting including use of diagnostic tools and equipment • Ability to write basic reports • Ability to develop training materials • Ability to support projects or cross-functional teams • Knowledge of basic principles and methods of computer configuration and operation • Knowledge of basic principles of computer science • Ability to troubleshoot hardware and software problems Business Systems Specialist Knowledge and abilities of the Business Systems Associate in addition to: • Advanced knowledge of assigned department operations and business processes • Knowledge of relational databases • Knowledge of and the ability to perform project management • Ability to generate and write complex reports by extracting data and information • Ability to design and develop workflow, custom reports or various custom integration of assigned applications • Ability to lead and manage projects • Ability to perform process and data analysis, research business problems • Ability to set-up, fix errors and change procedures and protocols for utilization of software applications • Ability to support multiple business processes • Ability to maintain and manage the operations of software applications and achieve optimal technical performance and user support • Excellent written and oral communication skills • Knowledge of Integrated Library Systems, RFID • Knowledge of Windows and Unix Operating Systems • Knowledge of local area and wireless network design and installation, systems analysis principles and techniques Senior Business Systems Specialist Administrator Knowledge and abilities of the Business Systems Analyst in addition to: • Ability to lead and supervise others • Ability to establish relationships with all levels in the organization • Ability to lead, develop and execute project management of significant projects with considerable impact on assigned departments • Ability to deal with controversial or sensitive issues • Ability to create, manage and meet deadlines for self and others • Ability to establish and recommend technology solutions to senior management • Ability to deal with multiple high priority issues simultaneously • Knowledge of computer programming principles, techniques and architecture; procedures for administrative and business applications; • Ability to prepare complete and concise network and personal computer system specifications and documentation • Ability to investigate proposals for new systems or modifications, and prepare feasibility reports and time and labor estimates; coordinate and control the development and implementation of major system design or modification projects JOB SERIES EDUCATION AND EXPERIENCE: Business Systems Associate Bachelor of Computer Science or Information Technology, Business Administration or related field or related experience. Progressively responsible experience, two to three years, in applicable business applications. Basic to moderate knowledge of specific applications and systems may vary depending on the assignment and will be specified. Business Systems Specialist Experience and Education required of the Business Systems Associate in addition to: Progressively responsible experience, three to five years, providing user support, performing business analysis and providing technology solutions in a medium size. Moderate to advanced knowledge of specific applications, systems and/or programming languages may vary depending on the assignment and will be specified. Business Systems Specialist assigned to the Library a Masters in Library and Information Science is preferred. Senior Business Systems Specialist Experience and Education required of the Business Systems Specialist in addition to: Progressively responsible experience, five to seven years, performing business analysis and providing technology solutions in a medium size environment. . Advanced knowledge of specific applications, systems and/or programming languages may vary depending on the assignment and will be specified. Senior Business Systems Specialist assigned to the Library also require four years experience working with a library automated system and performing in the role of a Library Information Systems Administrator or in a similar capacity. ESSENTIAL FUNCTIONS FOR ALL POSITIONS IN THE JOB SERIES: The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Language Ability: • Requires ability to compare, count, differentiate, measure and/or sort, assemble, copy, record and transcribe data and information. Must be able to classify, compute, tabulate, and categorize data. Must be able to advise and provide interpretation to others on how to apply policies, procedures, and standards to specific situations. Needs to be able to use a variety of descriptive data and information such as: a variety of plans, resolutions, maps, reports, computer software operating manuals, procedures, guidelines, and routine correspondence. • Must be able to communicate orally and in writing, clearly and concisely and in a non-technical manner with City personnel at all levels; consultants; vendors; and the general public. • Needs the ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Must be able to write reports, business correspondence, and procedure manuals. Needs to effectively present information and respond to questions from groups of managers, clients, and the general public. Mathematical Ability: Knows how to apply mathematics, including basic algebraic, plane geometric and trigonometric formulas. Must be able to demonstrate ability to calculate percentages, fractions, decimals, volumes, ratios, and spatial relationships. Needs to be able to interpret basic, descriptive statistical reports. Judgment and Situational Reasoning Ability: Must be able to use functional reasoning and apply rational judgment when performing diversified work activities. Needs to be able to analyze data and information using established criteria in order to determine consequences and identify and select alternatives. Physical Requirements: The conditions below are representative of those that must be met by an employee to successfully perform the essential functions of the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. • Needs to be able to operate equipment with some requiring rapid adjustments such as a computer keyboard and terminal, digitizer, plotter, printers, photocopier, calculator, drafting instruments. Must be able to coordinate eyes, hands, feet and limbs in performing skilled movements such as rapid keyboard use. Needs to be able to recognize and identify degrees of similarities or differences between characteristics of colors, textures, and forms associated with job-related objects, materials, and tasks. • Functions may require sitting for prolonged periods of time; the ability to exert light physical effort involving lifting, carrying, pushing and pulling of up to 30 pounds. Needs to be able to perform frequent downward or upward flexion or turning of the neck, fine finger dexterity and grasp to manipulate the keyboard, telephone, writing instruments, papers, books, manuals, and reports. • Job entails walking on uneven ground, standing, bending, stooping, climbing, reaching at and above shoulders and twisting at the waist. On an infrequent basis, the incumbent must be able to squat, kneel or be reclined while assembling hardware in close workspaces. May be exposed to loud noises during field visits. • Overtime and attending meetings outside regular work hours may be required. Work environment is professional and both team and autonomy oriented. This position is impacted by urgent time deadlines due to various reporting and filing requirements. There is some repetitiveness in program coding, a need for paying attention to detail. Additionally, there is a need to be able to shift attention before tasks are completed to be able to balance user demands, telephone and other interruptions. • Must be able to drive and maintain a California Class C Driver's license or ability to arrange transportation for fieldwork or visits to other City facilities. This classification specification does not constitute an employment agreement between the employer and employee and is subject to change by the City and the needs of the City and requirements of the job change. The City of Carlsbad is an Equal opportunity Employer. In compliance with the Americans with Disabilities act, the City will provide reaspnable accommodation to qualified individuals with disabilities and encourages both current and prospective employees to discuss potential accommodations with the employer. Attachment B CLASSIFICATION SALARY SCHEDULE - GENERAL EMPLOYEES Effective July 22,2008 RANGE CLASSIFICATION RANGE ACCOUNT CLERK I 17 ACCOUNT CLERK II 25 ACCOUNTANT 68 ACCOUNTING SUPERVISOR 54 ACCOUNTING TECHNICIAN 40 ADMINISTRATIVE SECRETARY 42 APPLICATIONS ANALYST 94 APPLICATIONS ASSOCIATE ANALYST 75 AQUATICS SPECIALIST 49 ASSISTANT ENGINEER 82 ASSISTANT PLANNER 64 ASSISTANT TO THE TREASURER 73 ASSOCIATE CONTRACT ADMINISTRATOR 52 ASSOCIATE ENGINEER 98 ASSOCIATE PLANNER 78 BUILDING INSPECTOR I 55 BUILDING INSPECTOR II 70 BUILDING MAINTENANCE WORKER I 29 BUILDING MAINTENANCE WORKER II 41 BUILDING TECHNICIAN II 50 BUSINESS SYSTEMS ASSOCIATE 70 BUSINESS SYSTEMS SPECIALIST 84 BUYER/CONTRACT ADMINISTRATOR 63 CLIENT SYSTEMS ADMINISTRATOR 87 CLIENT SYSTEMS ASSOC. ADMINISTRATOR 51 CIRCULATION SUPERVISOR 37 CODE ENFORCEMENT OFFICER I 43 CODE ENFORCEMENT OFFICER II 55 COMMUNITY OUTREACH SUPERVISOR 58 CRIME PREVENTION SPECIALIST 44 CROSS CONNECTION CONTROL TECHNICIAN 56 CUSTODIAN 6 CUSTODIAN II 16 DEPUTY CITY CLERK/TECHNICIAN 39 ELECTRICIAN 41 ENGINEERING TECHNICIAN I 45 ENGINEERING TECHNICIAN II 57 ENVIRONMENTAL SPECIALIST I 52 ENVIRONMENTAL SPECIALIST II 69 EQUIPMENT SERVICE WORKER 18 EQUIPMENT TECHNICIAN I 34 EQUIPMENT TECHNICIAN II 51 GIS ADMINISTRATOR 109 GIS ANALYST 84 GIS ASSOCIATE ANALYST 70 GIS TECHNICIAN 60 GRAPHIC ARTIST 45 HOUSING ASSISTANT 20 HOUSING SPECIALIST I . 46 HOUSING SPECIALIST II 61 HUMAN RESOURCES TECHNICIAN 52 JUNIOR PLANNER 50 JUVENILE JUSTICE PROGRAM COORD. 58 LEAD EQUIPMENT TECHNICIAN 61 LEGAL ASSISTANT 56 LEGAL SECRETARY 49 LIBRARIAN I 45 LIBRARIAN II 58 LIBRARY ASSISTANT I 26 LIBRARY ASSISTANT II 37 LIBRARY CLERK I 3 LIBRARY CLERK II 6 MAINTENANCE AIDE 10 MAINTENANCE WORKER I 14 MAIL CLERK/MESSENGER 1 METER SERVICES WORKER I 20 METER SERVICES WORKER II 33 METER SERVICES WORKER III 46 NETWORK ASSOCIATE 70 NETWORK ENGINEER 87 OFFICE SPECIALIST I 5 OFFICE SPECIALIST II 11 OPERATIONS/MAINTENANCE STOREKEEPER 43 PARK MAINTENANCE SPECIALIST 41 PARK MAINTENANCE WORKER II 28 PARK MAINTENANCE WORKER III 46 PARK PLANNER 85 PLANNING TECHNICIAN I 35 PLANNING TECHNICIAN II 50 POLICE TRAINING COORDINATOR 49 POLICE RECORDS SPECIALIST I 17 POLICE RECORDS SPECIALIST II 22 PRODUCTION TECHNICIAN 39 PUBLIC WORKS INSPECTOR I 55 PUBLIC WORKS INSPECTOR II 70 RECORDS MANAGEMENT SUPERVISOR 56 RECREATION ASSISTANT 10 RECREATION SPECIALIST 29 RECREATION SUPERVISOR 54 SANITATION SYSTEMS OPERATOR I 24 SANITATION SYSTEMS OPERATOR II 46 SANITATION SYSTEMS OPERATOR III 56 SECRETARY 34 SENIOR APPLICATIONS ANALYST 109 SENIOR BUILDING INSPECTOR 85 SENIOR BUILDING MAINTENANCE WORKER 51 SENIOR BUSINESS SYSTEMS SPECIALIST 99 SENIOR CIRCULATION SUPERVISOR 50 SENIOR CONSTRUCTION INSPECTOR 85 SENIOR CONTRACT ADMINISTRATOR 79 SENIOR CROSS CONN. CONTROL TECH. 66 SENIOR DATABASE ADMINISTRATOR 113 7/11/2008 CLASSIFICATION RANGE SENIOR ELECTRICIAN 51 SENIOR ENVIRONMENTAL SPECIALIST 84 SENIOR LIBRARIAN 73 SENIOR NETWORK ENGINEER 113 SENIOR OFFICE SPECIALIST 22 SENIOR PLANNER 91 SENIOR STORM DRAIN MAINT. WORKER 48 SENIOR WEB ADMINISTRATOR 109 SITE MANAGER 4 STOREKEEPER 18 STORM DRAIN MAINTENANCE WORKER 34 STREET MAINTENANCE WORKER II 28 STREET MAINTENANCE WORKER III 46 TECHNICIAN I 35 TREE TRIMMER I 20 TREE TRIMMER II 32 TREE TRIMMER LEADWORKER 46 UTILITY MAINTENANCE WORKER III 45 UTILITY WORKER I 24 UTILITY WORKER II 40 UTILITY WORKER III 50 VALVE MAINTENANCE WORKER 45 WAREHOUSE TECHNICIAN 43 WATER CONSERVATION SPECIALIST 40 WATER SYSTEMS OPERATOR I 34 WATER SYSTEMS OPERATOR II 54 WATER SYSTEMS OPERATOR III 64 ClicK here to view Biweekly Salary Schedule ' /<o( Attachment C Management Salary Structure (Base Pay) FY 08/09 JOB TITLE GRADE MINIMUM MARKET RANGE Administrative Services Director Assistant City Manager Community Development Director Deputy City Manager Fire Chief Police Chief Public Works Director Assistant City Attorney Deputy Public Works Director Finance Director Fire Division Chief Human Resources Director Information Technology Director Library Director Planning Director Police Captain Recreation Director Special Projects Director Assistant Finance Director Assistant Planning Director Building & Code Enforc. Manager City Communications Manager Deputy City Attorney Deputy City Engineer Economic Dev & Real Est Manager Fire Battalion Chief Fire Marshal Housing & Redevelopment Director Information Technology Manager Police Lieutenant Public Works Manager Development Services Manager Emergency Medical Services (EMS) Paramedic Nurse Coordinator Environmental Programs Manager Finance Manager Geographic Info. Systems Manager Human Resources Manager 8 8 8 8 8 8 8 7 7 7 7 7 7 7 7 7 7 7 6 6 6 6 6 6 6 6 6 6 6 6 6 5 5 5 5 5 5 $ 124,300 $ 108,100 $ 88,500 $ 80,700 $143,000 - $ 180,300 $123,800 - $ 154,600 $101,700 - $ 128,300 $90,700 - $ 111,000 Management Salary Schedule 07-15-08.xls Attachment C Management Salary Structure (Base Pay) FY 08/09 JOB TITLE GRADE MINIMUM MARKET RANGE Municipal Projects Manager Park Development Manager Police Communications Manager Principal Planner Public Safety Info. Technogy Manager Public Works Superintendent Recreation Services Manager Risk Manager Senior Civil Engineer Cultural Arts Manager Construction Manager Deputy Library Director Emergency Preparedness Coordinator Housing Program Manager Public Information Officer Records Manager Senior Accountant Senior Management Analyst Video Production Manager Management Analyst Principal Librarian Public Works Supervisor Aquatic Supervisor Assistant City Clerk Associate Analyst Benefits Administrator Gallery Curator Media Services Specialist Recreation Area Manager Secretary to City Attorney Secretary to City Council Secretary to City Manager Community Coordinator Management Assistant 5 5 5 5 5 5 5 5 5 4 4 4 4 4 4 4 4 4 4 3 3 3 2 2 2 2 2 2 2 2 2 2 1 1 $ 80,700 $ 66,700 $ 59,300 $ 52,800 $ 48,000 $90,700 - $ 111,000 $75,000 - $ 91,600 $66,600 - $ 81,300 $59,500 - $ 72,600 $54,200 - $ 65,900 Management Salary Schedule 07-15-08.xls Attachment D APPENDIX TO THE LOCAL CONFLICT OF INTEREST CODE OF THE CITY OF CARLSBAD, THE HOUSING & REDEVELOPMENT AGENCY, CARLSBAD, CALIFORNIA PUBLIC FINANCING AUTHORITY AND THE CARLSBAD MUNICIPAL WATER DISTRICT The positions and categories within the City listed in this appendix are "designated positions." Any person whose position with the City is a designated position is a designated employee. Designated employees shall disclose in the manner provided in the Local Conflict of Interest Code of the City of Carlsbad those financial interests, which are within the categories represented by the number(s) following the listed position. The categories correspond to the subsections of Title 2, California Code of Regulations Section 18730, subsection 7 and represent the following disclosures: "1" investment and real property disclosure; "2" personal income disclosure; "3" business entity income disclosure; "4" business position disclosure. DESIGNATED POSITIONS DISCLOSURE CATEGORIES Mayor and Members of the City Council * City Manager * City Attorney * City Clerk Chairman and Members of the Housing and Redevelopment Commission * Executive Director to the Housing and Redevelopment Commission ** Attorney of the Housing and Redevelopment Commission ** Secretary of the Housing and Redevelopment Commission * President, and Members of the Board of Directors of the Carlsbad Municipal Water District * Executive Manager of the Carlsbad Municipal Water District ** General Counsel for the Carlsbad Municipal Water District ** Secretary of the CMWD Board Chairman and Members of the Public Financing Authority * Executive Director of the Carlsbad Public Financing Authority ** General Counsel of the Carlsbad Page 1 of 5 7/11/2008 Officials Who Manage Public Investments: Administrative Services Director Assistant to the Treasurer City Treasurer Deputy City Treasurer Finance Director City Staff under City Manager: Accountant Accounting Supervisor Aquatics Supervisor Assistant City Manager Assistant to City Manager Assistant Engineer Assistant Finance Director Assistant Planner Assistant Planning Director Associate Analyst Associate Engineer Associate Planner Benefits Administrator Building & Code Enforcement Manager Building Inspector I & II Buyer City Communications Manager Code Enforcement Officer I & II Community Development Director Community Coordinator Construction Manager Cultural Arts Manager Deputy City Engineer Deputy Fire Marshall Deputy Library Director Deputy Public Works Director Economic Development & Real Estate Manager Emergency Preparedness Coordinator & Training Officer Environmental Programs Manager Environmental Specialist I & II & Senior Equipment Maintenance Supervisor Facilities Superintendent Finance Manager Fire Chief Fire Division Chief Fire Battalion Chief Fire Marshal Fire Prevention Specialist I & II Gallery Coordinator Geographic Information Systems Manager Housing & Redevelopment Director 2,3,4 2,3,4 2,3 1,2,3,4 1,2,3,4 1,2 2,3,4 2,3,4 2,3,4 2,3,4 2 1,2,3,4 2,3 1,2,3 1,2,3 1,2,3,4 1,2,3,4 1,2,3 1,2,3,4 2,3,4 1,2,3,4 1,2,3,4 1,2,3,4 1,2,3 1,2,3,4 1,2,3,4 1,2,3,4 2,3 1,2,3 1,2,3 2,3 1,2,3,4 1,2,3,4 1,2,3,4 1,2,3,4 1,2,3,4 1,2,3,4 1,2,3 2,3 2,3 1,2,3,4 Page 2 of 4 7/11/2008 Housing Program Manager 1,2,3 Human Resources Director 1,2,3,4 Human Resources Manager 2, 3 Information Technology Director 1, 2, 3, 4 Information Technology Manager 1,2,3,4 Library Director 1,2,3,4 Management Analyst 1,2,3,4 Management Assistant 2, 3 Management Intern 1,2,3,4 Media Services Specialist 2, 3 Municipal Projects Manager 1,2,3,4 Park Development Manager 1, 2, 3, 4 Park Planner 1,2,3,4 Parks Superintendent 1,2,3,4 Planning Director 1,2,3,4 Planning Technician I & II 1,2,3,4 Police Chief 1,2,3,4 Police Captain 2, 3 Police Communications Manager 2, 3 Police Lieutenant 2, 3 Principal Librarian 2, 3 Principal Planner 1,2,3,4 Public Works Director 1,2,3,4 Public Safety IT Manager 1,2,3,4 Public Works Inspector I & II 1,2,3 Public Works Manager 2, 3 Public Works Supervisor 2, 3 Records Supervisor (Police) 2, 3 Recreation Area Manager 2, 3 Recreation Director 1,2,3,4 Recreation Services Manager 2, 3, 4 Risk Manager 1,2,3,4 Senior Accountant 1,2,3,4 Senior Building Inspector 1,2,3,4 Senior Civil Engineer 1,2,3,4 Senior Construction Inspector 1, 2, 3, 4 Senior Librarian 2, 3 Senior Management Analyst 1, 2, 3, 4 Senior Planner 1,2,3,4 Video Production Manager 2, 3 Warehouse Technician 1,2,3,4 City Attorney's Office: Assistant City Attorney 1,2,3,4 Deputy City Attorney 1,2,3,4 City Clerk's Office: Assistant City Clerk 2, 3, 4 Deputy City Clerk/Technician 2, 3, 4 Page 3 of 4 7/11/2008 ^V Records Manager 2, 3 Records Management Supervisor 2, 3 City Employees under the Executive Manager of the Carlsbad Municipal Water District: Accountant 2, 3, 4 Accounting Supervisor 2, 3 Associate Engineer 1, 2 Cross Connection Control Technician 1, 2 Deputy City Engineer 1,2,3,4 Deputy Public Works Director 1,2,3,4 Management Analyst 2, 3 Public Works Manager 2, 3 Public Works Supervisor 2, 3 Senior Civil Engineer 1, 2, 3, 4 Senior Engineering Inspector 1,2,3,4 Consultants *** Boards and Commissions: Members of the Agricultural Conversion Mitigation Fee Ad Hoc Citizens' Advisory Committee 1,2,3,4 Members of the Arts Commission 1,2,3,4 Members of the Board of Library Trustees 1,2,3,4 Members of the Design Review Board 1,2,3,4 Members of the Housing Commission 1,2,3,4 Members of the Parks and Recreation Commission 1, 2, 3, 4 Members of the Planning Commission * Members of the Senior Commission 1,2,3,4 Members of the Sister City Committee 1,2,3,4 Members of the Traffic Safety Commission 1,2,3,4 * This position is required to report by virtue of Government Code Section 87200.lt is included for disqualification purposes only. See Government Code Section 87200 for disclosure requirements. ** When a designated employee is also required to file a conflict of interest form under Article 2 (Gov't Code §87200, Form 700) of the Act, he-or she may expand their statement to cover reportable interests in both jurisdictions or both positions and file copies of this expanded statement with the City Clerk provided that each copy of such expanded statement filed in place of an original is signed and verified by the designated employee as if it were an original. *** The duties of each consultant will be separately evaluated to determine whether or not disclosure will be required, and the categories which will apply. The evaluation of the consultant's duties will be conducted by the department head of the department which is responsible for the hiring of the consultants. The disclosure requirement shall be included in the consultant's contract approved by the City Council, Housing and Redevelopment Commission, City Manager or Executive Manager of the Carlsbad Municipal Water District. Page 4 of 4 7/11/2008