Programmer Specialist 1

Using SQL codes, administers & maintains statewide client application server, Fleet management System (FleetOhio) & FleetAnywhere application software: uses system administration tools (e.g., SQL worksheet/MS Access) to maintain indexes within the system (e.g., update, extract, query, & manipulate data from relational databases); works closely with GSD/MIS to assist in operation of the FleetOhio database management system & Microsoft NT application server; performs application configuration changes (e.g., writes SQL code, uses relational database design) as assigned; assists in installation of new software & system upgrades or patches to application server & department desktops; administers license & maintenance agreements between State of Ohio & Maximus & other software providers as required; administers & maintains statewide, internet-based Vehicle Pre-Approval application (e.g., writes SQL code & troubleshoots). Develops & assists in implementation of statewide policy pertaining to Fleet management System. Acts as liaison between state Fleet Administrator, GSD/MIS, & other state agencies. Provides technical support to all Fleet Management System customers. Oversees statewide data within FleetOhio: performs audits of data & works with all agencies in correcting data entry errors; extracts data from database; manipulates data in SQL 7, Microsoft Access or Excel to create numerous weekly, monthly, quarterly & annual reports; serves as application security administrator to create user rights & security profiles; creates & provides timely turnaround of specialized exception reports for internal & customer agencies; prepares all correspondence pertaining to Fleet Management System.

Minimum Qualifications:

1 course in algebra, statistical analysis or mathematical foundations for computer science; 1 course or 3 mos. exp. in microcomputer system applications & software package programming; 1 course or 3 mos. exp. in systems analysis & design; 2 courses or 6 mos. exp. in computer programming & programming techniques; 6 mos. trg. or 6 mos. exp. in operation of computer hardware & peripheral equipment.

-Or 2 yrs. trg. or 2 yrs. exp. in computer science which included computer programming & programming techniques, operation of computer hardware & peripheral equipment, systems analysis & design, computer software package programming & mathematical concepts for use in computer science.

-Or equivalent of Minimum Class Qualifications for Employment noted above.

Major Worker Characteristics:

Knowledge of computer software package (e.g., LOTUS, SAS) programming; computer hardware systems; algebra, statistical analysis or mathematical foundations for computer science. Skill in operation of computer terminal & peripheral equipment (e.g., printers, modems). Ability to interpret variety of technical computer manuals &/or hardware instructions; write software applications instruction manuals; communicate verbally on technical & non-technical matters; gather, collate & classify information about data, people or things; move hands/fingers easily to operate computer equipment.

Supplemental Information:

Work involves operation of computer terminal for long periods of time.

Must meet the Position Specific Minimum Qualifications:
Position Specific Minimum Qualifications: 12 mos. trg. or exp. in writing SQL codes; 12 mos. trg. or exp. in data modeling & relational database design; 12 mos. trg. or exp. in Crystal/Cognos reporting.