Job & Business Opportunities

Job Summary

This classification is primarily responsible for performing many of the complex tasks in the following areas: Database Administration, Programming and Analysis, User Support and Training, Systems Administration and Operations, and Staff Oversight. This is the journey, fully trained level within this series; incumbents are expected to be fully competent to independently perform the full range of duties. Work mainly involves the gathering and interpretation of data dealing with problems and difficult situations. Incumbents may put forth alternative solutions for consideration.

Supervision

Supervision Received: This class works under direction, wherein the employee receives general instructions regarding the scope and approach to projects or assignments, but procedures and techniques are left to the discretion of the employee.

Supervision Exercised: This class may provide indirect supervision to lower level personnel.

Distinguishing Characteristics

N/A

Essential Functions

A. Database Administration
Duties may include:
Schedule and monitor database backups. Manage databases and user authorizations; create transport packages and transport data between both SQL databases and other OBDC sources. Create tables and views for data warehousing and analysis. Monitor and adjust server performance parameters. Serve as a consultant for District users on data usage and analysis, data retention requirements, and data access and availability. Inform groups and individuals as to what data and tools are available and how they may make use of them. Other duties as assigned.

B. Programming and Analysis
Duties may include:
Enhance application programs as system needs evolve. Extract data into databases or text files. Analyze the source file for data. Perform various aggregate or conversion functions on the data. Extract salient subject matter elements from users. Determine data elements with relation entity charts. Interface dissimilar systems. Apply quality assurance principles. Write technical documentation. Serve as primary developer for custom programs for SAP. Determine functional requirements for TEAMS. Assess proposed projects for suitability of automation. Discuss complex business processes with managers and specialists. Negotiate solutions within computerization constraints. Integrate solutions into departmental vision and direction. Create data flow diagrams. Represent the District at regional technical meetings. Other duties as assigned.

C. User Support and Training
Duties may include:
Support risk management application. Support, analyze, and troubleshoot databases. Tutor users and demonstrate database capabilities. Assist users on database analysis, development, and problem resolution. Support department staff with technical information and knowledge sharing. Advise users on general computer software and hardware issues. Serve as backup for work order technicians. Other duties as assigned.

D. Systems Administration and Operations
Duties may include:
Provide system operations support, including interpreting program and system error messages, loading tapes, and handling printers. Provide business and operational service application support and programming. Analyze data errors and assist in corrections. Enhance application programs as systems needs evolve. Tutor users in application functionality. Perform operator timekeeping applications support and programming. Analyze data errors and assist in correction. Perform SAP BASIS administration, including transport change requests between clients and systems; monitor R/3 Servers and adjust operating parameters, maintain OSS and Client User Authorizations, and apply Component Support Packages. BSI Tax Factory Update Bulletin support. May act as system manager for systems, servers, and network hardware. Other duties as assigned.

E. Staff Oversight
Duties may include:
Technical lead for TEAMS implementation, which involves scheduling, driver dispatch, and timekeeping. Liaison for GIS development. Correspond with other project leads, and write status reports. Insure tasks are assigned and completed. Keep implementation aligned with business goals. Negotiate resolutions to problems of design, implementation, and timetables. Promote ITS (Integrated Transportation Systems) initiatives. Direct efforts of contracted developers. Other duties as assigned.

F. Other
Duties may include:
Examine commercial software and hardware. Read trade journals. Apply ITS initiatives. Other duties as assigned

Job Demands

Physical and Mental Requirements:

• Mobility: frequent use of keyboard; frequent sitting for long periods of time; occasional bending or squatting.


• Lifting: frequently up to 10 pounds; occasionally up to 25 pounds.


• Vision: constant use of overall vision; frequent reading and close-up work; occasional color and depth vision.


• Dexterity: frequent repetitive motion; frequent writing; frequent grasping, holding, and reaching.


• Hearing/Talking: frequent hearing and talking, in person and on the phone.


• Emotional/Psychological: frequent decision-making and concentration; frequent public and/or coworker contact; occasional working alone.


• Environmental: frequent exposure to noise.

Knowledge and Abilities

Required Knowledge of:

• ODBC connections and sources, including creation and reconfiguration.


• Relational database methods and normalization.


• SAP BASIS administration.


• Principles and practices of applications design and programming.


• Methods and techniques of de-bugging programs and applications.


• Principles and practices of database administration.


• Microsoft SQL Server architecture and programming.


• AS/400 operating system, commands, and control language.


• Advanced database language, including macros and models.


• Basic computer architecture, in both hardware and software components.


• Application programming interfaces, communication protocols, relational data model, programming languages, and various scripting languages.


• Quality assurance methodology.


• Methods and techniques of developing technical documentation.


• Methodologies for simulating business processing using hardware, software, GIS, and statistics.


• Software and hardware technologies, security protocols, and network devices.


• Hardware configuration and handling.


• A variety of operating systems.


• Methods and techniques of preparing and implementing technical training programs.

• Perform the full range of programming and database support in assigned systems area.


• Implement security on assigned systems.


• Reconcile user data needs with the HTE file structure and data types.


• Understand and interpret the user’s needs and ideas into specific data information technology solutions.


• Multitask with on-going conflicting demands.


• Develop and revise existing programs.


• Develop technical documentation.


• Install and integrate new software programs into existing programming systems.


• Prepare clear and concise reports and correspondence.


• Learn District-specific applications, functions, and data structures in assigned area.


• Learn departmental software tools, applications and libraries.


• Learn departmental operating policies and procedures.

• Common word processing software.


• Common spreadsheet software.


• Common database applications.


• ERMS software concepts.


• Accounting or operations software functionality.


• Email, contact management, and scheduling software.


• Project management software.


• Presentation software.

Minimum Qualifications — Any combination of education and experience that would likely provide the required knowledge and abilities is qualifying. A typical way to obtain the knowledge and abilities would be:

Required Prior Experience:
Three years of professional programming experience within the specialized discipline.

Required Prior Education:
A Bachelor’s Degree in Computer Science, Computer Programming, or closely related field. Six years of additional qualifying experience may substitute for the required education.