ROCKINGHAM COUNTY PUBLIC SCHOOLS

POSITION DESCRIPTION

JOB TITLE: Database Programmer	LOCATION: Central Office
	JOB CATEGORY: Non-Classified
IMMEDIATE SUPERVISOR: Director of Information Management	PAY GRADE: Database Programmer
	FLSA STATUS: Exempt

GENERAL DEFINITION AND CONDITIONS OF WORK

Responsible for developing, documenting, and maintaining software to provide access to, create interfaces with, and generate reports and data extracts from the division’s database management systems. Responsibilities include, but are not limited to participation in all stages of the software development cycle, including requirements analysis, design, coding, documenting, and testing, as well as the creation of custom html pages for the division’s student information system.

ESSENTIAL FUNCTIONS/TYPICAL TASKS

The minimum performance expectations include, but are not limited to, the following functions/tasks:

• Designs, develops, documents, and maintains custom database applications;
• Consults with Director of Information Management and Data Systems Support Specialist to determine functional requirements and identify solutions to resolve those needs;
• Creates prototypes for new applications;
• Analyzes, defines, and documents system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration;
• Writes and maintains functional and technical specifications;
• Creates test plans and carries out system testing to ensure all components of the system meet specifications;
• Analyzes code for problem resolution and performance optimization;
• Provides technical consulting and responds to error reports, problems or questions;
• Designs, creates, documents, and maintains custom PowerSchool html pages;
• Assists in troubleshooting issues related to PowerSchool connectivity with other division data systems via the Schools Interoperability Framework (SIF);
• Assists school and division personnel with spreadsheet applications such as Microsoft Excel;
• Assists the Director of Information Management with other tasks as needed;
• Keeps informed on the latest technologies, practices, and programs in the computer field;
• Assumes responsibility for professional growth and keeps materials, supplies, and skills up-to-date;
• Assists in the implementation of the county-wide technology plan;
• Cooperates with staff members in promoting a positive organizational climate;
• Takes all necessary and reasonable precautions to protect students, equipment, materials, and facilities;
• Models non-discriminatory practices in all activities;
• Complies with and supports school and division regulations and policies;
• Performs related duties as assigned by immediate supervisor(s) in accordance with the school/system policies and practices.

KNOWLEDGE, SKILLS AND ABILITIES

• Experience developing web-based relational database applications with complex SQL components using Oracle/MySQL/PostgreSQL/Microsoft SQL Server, perl/PHP, Apache, Java, and Java Script components;
• Ability to support end users in their use of spreadsheet applications such as Microsoft Excel, including the ability to write VBA macros;
• Demonstrated ability to develop formal application specifications and project plans using common documentation tools;
• Demonstrated ability to work as part of an application development team; create structured code for integration into larger systems, document work for maintenance in a production environment, create task lists, timelines and deliverables, work to meet project schedules determined by others;
• Ability to read, analyze, and interpret general business documentation, professional journals, technical specifications, and project management documentation;
• Ability to write reports, correspondence, and procedure manuals;
• Demonstrated ability to define problems, collect data, establish facts and draw valid conclusions. Ability to develop systematic testing plans for problem resolution;
• Ability to self-manage assigned tasks;
• Demonstrated ability and professional and personal characteristics necessary for working effectively with school personnel and members of the community;
• Ability to establish and maintain effective working relationships with other staff, teachers, and administrators.

EDUCATION AND EXPERIENCE

Bachelor’s degree in information science, computer science, or management information systems (MIS) strongly preferred.

Secure Web Development certifications (e.g. SANS Institute) desired.

SPECIAL REQUIREMENTS

Must be able to provide own transportation to schools throughout the division. Candidate must possess good moral character.

PHYSICAL DEMANDS/REQUIREMENTS

Duties performed typically in school settings to include: offices, computer labs, and classrooms. Frequent walking, sitting, standing, stooping, lifting, up to approximately 30 pounds, and occasional lifting of equipment such as technology equipment weighing up to approximately 75 pounds may be required. Frequent operation of a vehicle and office equipment is required. Vocal communication is required for expressing or exchanging ideas by means of the spoken word; hearing is required to perceive information at normal spoken word levels; visual acuity is required for preparing and analyzing written or computer data, determining the accuracy and thoroughness of work, and observing general surroundings and activities; the worker is subject to inside and outside environmental conditions, noise and hazards. Regular contact with staff members and administrators is required. Contact with technology professionals may be required. Frequent contact with vendors and other technicians by phone, e-mail, or in person is necessary Must be able to spend at least 75% of work time sitting and using standard desktop computing equipment.

EVALUATION

The Director of Information Management will evaluate performance on the ability and effectiveness in carrying out the above responsibilities.

Created 4/26/11