Job Abstract

The duties listed below are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to this class.

1. Performs a variety of specialized, highly technical and complex computer database system or network system duties in support of specialized functions or programs.
2. Provides operational support to the District's network and database infrastructure. This includes but is not limited to programming, building, analyzing, diagnosing, maintaining, securing and operating various systems.
3. Answers questions, responds to end-user requests in a timely manner; provides information, assistance and training to personnel and departments on technology-related issues.
4. Coordinates information system activities with users; assists in the assessment of output requirements, data processing schedules, volume of transaction data and other factors to determine the level and type of computer information system support required.
5. Analyzes, diagnoses, tests, recommends, or provides appropriate solutions for problems with computer, mobile, E-mail, Internet, software, hardware, business system, telecommunications or other technology related issues.
6. Supports the installation and maintenance of the network, server, and telecommunications infrastructure; monitors and maintains local and wide area computer network; manages network file and print server functions; creates and maintains user connectivity; creates user accounts based on established protocols; coordinates installation of network and application software.
7. Implements internal control, network security methodologies and other security systems for data, systems, and hardware protection and recovery procedures; ensures timely and accurate back-up of data; implements disaster recovery procedures as needed; maintains appropriate confidentiality of sensitive information.
8. Installs, configures, programs and tests workstations, servers, network systems and other computer related software and hardware; monitors systems and network resources; performs appropriate testing functions as needed; coordinates network and software upgrades;
9. Maintains availability of network systems; reviews system logs and trouble shoots network malfunctions; allocates and monitors server disk storage space for users on the network; allocates and monitors server memory usage to insure efficient dynamic memory usage.
10. Provides technical support for the database environment; plans, designs, develops, modifies, tests and implements all aspects of database administration and relational database management system support. This includes support of the District GIS, ERP, CIS, EAM, and CPM systems.
11. Prepares recommendations to users for the collection of data to be stored in tables; maintains/creates schematics, data models and/or schemas for databases; manages naming conventions and data dictionaries; performs routine maintenance to the District’s database tables as required.
12. Implements and maintains database and data file security features and procedures to assure the integrity and security of data resources and maintains appropriate confidentiality of sensitive information.
13. Creates and maintains scheduled tasks to automate routine procedures and processes; develops test plans and scripts; monitors logs; Tests backup, restore and disaster recovery procedures.
14. Monitors, supports and oversees vendor software release cycles and deployment activities; develops time and cost estimates for new updates and maintenance changes as needed.
15. Reviews database utilization and performs tuning to ensure optimal performance; conducts and reviews tests of database servers to verify performance objectives and quality standards.
16. Creates tables, custom queries, and export/import data as needed; designs and creates reports.
17. Stays current with technology advancements; develops and presents instruction to District staff on relevant technology related information, new equipment, and software upgrades.
18. Prepares and maintains documentation and instructions; maintains and updates manuals, templates, web and intranet pages and related documents; follows protocols and procedures.
19. Assists with research of solutions and the procurement of technology related equipment or services; researches specifications and costs; tests beta and experimental systems, applications, and equipment; and researches and prepares related reports with recommendations.
20. Acts as liaison between vendors, technical support, and departments to resolve system problems; resolves user problems and maintains user contact to assess needs, answer questions and provide technical information.
21. May plan, prioritize, and review the work of consulting staff, develop schedules and methods to accomplish assignments, and provide and coordinate staff training.
22. Provides technical assistance for desktop and mobile support issues; interviews, analyzes and documents end-user work processes and accompanying system requirements.
23. Builds and maintains positive working relationships with co-workers, other District employees and the public using principles of good customer service.
24. Performs related duties as assigned.

QUALIFICATIONS

Skill/Ability to:

• Perform a variety of professional level duties related to technical and operational support, programming, and internal customer service for District departments.

• Work efficiently and effectively with various software, hardware, operating systems, databases, network systems, business functional systems, and telecommunications systems. This includes the installation, upgrade, maintenance and troubleshooting of these systems.

• Write and perform programming functions in appropriate computer languages in a clear and well-documented style.

• Monitor computer information system utilization and recommend appropriate revisions to processes.

• Develop and test programs; prepare test data, and test and debug application programs.

• Establish and maintain effective working relationships with those contacted in the course of work. This includes the ability to always exhibit a positive customer service attitude.

• Communicate clearly and concisely, both orally and in writing. This includes a strong understanding or proper business communications.

• Safeguard confidential and private information in the course of business. This includes understanding the proper and improper ways to distribute information in the course of business. Exhibits appropriate business professionalism.

• Know and understand all aspects of the job;

• Intermittently analyze work papers, reports and special projects;

• Identity and interpret technical and numerical information;

• Observe and follow operational and technical policy and procedures.

• On a continuous basis, sit at a desk for long periods of time;

• Intermittently twist to reach equipment surrounding desk;

• Lift or carry weight of 25 pounds or less.

PHYSICAL AND MENTAL DEMANDS

The physical and mental demands described here are representative of those that must be met by employees to successfully perform the essential functions of this class. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical Demands

Position requires the ability to communicate in a professional manner with District management, coworkers, the public, inter-agency, and elected officials through verbal and written communication in face-to-face, one-on-one, and group settings. This is primarily a sedentary office classification although standing in work areas and walking between work areas may be required; must have the ability to lift, carry, push, and pull materials and objects up to 25 pounds. Requires vision to read printed materials and computer screens; hearing and speech to communicate in person and over the telephone; and finger dexterity to access, enter, and retrieve data using a computer keyboard, copy machine, telephone, and other standard office equipment. Position requires ability to operate a motor vehicle and travel to conduct District business.

Mental Demands

While performing the duties of this class, an employee uses written and oral communication skills; reads and interprets data, information, and documents; analyzes and solves problems; uses a math; learns and applies new information and skills; responds to emergency situations; and interacts with others encountered in the course of work, including frequent contact with customers and/or the public.

WORK ENVIRONMENT

The employee works in an office environment and may be required to work various hours at night, on weekends and holidays as needed.