Programmer Analyst (ITS)ANTELOPE VALLEY COLLEGE
Programmer Analyst (ITS)
Full time, 12 months
WORK SCHEDULE: Monday – Friday: 8:00am – 4:30pm
SALARY: Range 26, $5,099.57/mo. + benefits
(Excellent Benefits: medical, vision, dental, paid holidays, vacation days, sick-time, and retirement)
DEADLINE: February 10th, 2012
BASIC FUNCTION:
Under the direction of the Computer Systems Manager in the Information Technology Services Department,
design and develop computer systems programs and utilities to facilitate District management information
system reporting, security, data warehousing, and system requirements; design and develop computer programs
to augment database system operations and correct computer and database system problems; design, develop,
document, test and implement computer programs as required; and perform other related duties as assigned.
REPRESENTATIVE DUTIES: E = indicates essential duties of the position
• Use District data element dictionary in developing programs to prepare MIS reports as required. (E)
• Design and develop programs to augment SCT Banner database(s) utilization and to facilitate District
business processes as requested. (E)
• Work with the Oracle and SCT Banner computer systems to extract required information as part of program
development and implementation. (E)
• Develop and maintain program specific documentation; including program operating procedures; prepare
documentation to accompany all programs and program changes, documenting dates and specific nature of design/change to all code developed/modified. (E)
• Maintain system code and configurations associated with District database and MIS systems and update
programs and parameters and client access and usage procedures as required. (E)
• Perform data extractions, migrations, back ups, merges, and integrations and prepare reports as required.
• Design and develop programs to facilitate automated workflow systems as required. (E)
• Recommend improvements to District systems, programs and utilities as needed.
• Analyze and recommend new or modified computer applications. (E)
• Conduct operational efficiency studies on programs and software applications used for database systems and
other District systems. (E)
• Interact with District personnel as required to provide database and management information system program
and operational information; provide documentation and assistance to program and system users.
• Learns and implements software provided by outside vendors. (E)
• Design, develop, and augment GUI forms utilizing the Oracle Developer suite.
• Design, develop, and implement web applications for District systems.
• Perform related duties as assigned.
EDUCATION AND EXPERIENCE: Any combination equivalent to: graduation with a Bachelor of Science
degree in Computer Science or Information Technology, and two years experience in relational database
systems programming (preferably Oracle) and UNIX.
KNOWLEDGE OF:
• Relational database design, development and programming methods.
• Database programming, documentation and technical support.
• System requirements analysis, program requirements analysis and documentation.
• District organization, operation, policies and objectives.
• District MIS reporting requirements and data element dictionary.
• Data processing, report production and technical documentation.
• Programming languages including: SQL and PL/SQL, C or C++ or Java, HTML with VBScript, JSP or ASP.
• Beneficial languages COBOL, UNIX shell scripting, and Visual Basic.
• Basic networked computer systems and operation.
• Automated workflow models.
• Oracle and UNIX.
• Database program problem identification and problem solving techniques.
ABILITY TO:
• Design, develop, implement, test and document relational database programs and utilities, data processing
system programs and utilities, and other computer programs and utilities as required.
• Identify and isolate database and system program problems and implement and document solutions.
• Develop programs and utilities to augment UNIX and Oracle systems, as well as District database
applications, including SCT Banner, as directed by Systems Manager.
• Establish, maintain and document database and systems program operational and usage procedures.
• Interact with District personnel to provide functional database and system services, such as systems
requirements analysis and database program requirements analysis, and information on how to operate
programs, queries, and forms.
• Communicate clearly and concisely, both orally and in writing.
• Establish and maintain cooperative working relationships with professional contacts.
• Plan and organize work.
• Maintain knowledge of current technological advances pertinent to relational database programming and
computer systems programming.
WORK DIRECTION, LEAD AND SUPERVISORY RESPONSIBILITIES: Not applicable – no permanent
full-time staff to supervise.
CONTACTS: Co-workers, third- party technical support, SCT ActionWeb, other departmental staff, and
colleagues from other educational institutions.
PHYSICAL EFFORT:
• Requires the ability to exert some physical effort, such as walking, standing and light lifting
• Minimal dexterity in the use of fingers, limbs and body in the operation of office equipment.
• Tasks require extended periods of time at a keyboard.
• Requires the ability to maintain effective audio-visual discrimination and perception required for
communicating with others.
WORKING CONDITIONS:
Indoors, office/computer center environment.
APPLICATION PROCEDURE
To be considered an applicant for a classified position in the Antelope Valley Community College District, all
of the following documents must be submitted no later than 4:30 p.m. on the deadline date.
If any of the listed materials are missing or incomplete, the application will not be considered.
1. A completed and signed Antelope Valley College Classified Application
2. Cover letter addressing your interest and qualifications
3. Re´sume´
4. Transcripts: If college-level coursework or a degree is required in the job announcement under “Education
and Experience”:
a. Submit transcripts of all college-level coursework as required (unofficial transcripts or photocopies will be
accepted to establish the application file).
b. No copies of degree/diplomas will be accepted as proof of college education.
c. Official documents will be required if the candidate is offered the position.
d. If “coursework” requirement is satisfied from a non-traditional college setting, submit photocopies of
certificates earned that apply to the position only.
The application must be filled out completely and signed. Do not indicate “See Re´sume´” on any part of the
application. Blank spaces, illegible entries or failure to sign the application may be cause for rejection. The
District will not return application materials submitted.
Application forms are available from the Human Resources Office and
must be returned to:
ANTELOPE VALLEY COLLEGE
Office of Human Resources
3041 West Avenue K
Lancaster CA 93536
Faxed or emailed materials cannot be accepted.
Unsolicited materials will not be included. Postmarks will not be accepted
A selection committee will screen applications of candidates meeting minimum requirements. Meeting
minimum requirements does not assure the applicant of an interview. Selection for an interview will be based
on your training and experience as outlined in your application. Applicants selected for interviews will be
notified by phone. Applicants should not expect notification of the status of their candidacy until the Board of
Trustees has acted upon the district’s recommendation for employment.
Candidates selected for employment will be required to provide verification of work authorization pursuant to
INS regulations.
Antelope Valley College offers an extensive benefit package that includes full-family medical, dental, and
vision plans and employee life insurance and income protection policies and eligibility to enroll in the Public
Employees Retirement System.
Antelope Valley College prohibits discrimination and harassment based on race, religious creed, color, national
origin, ancestry, physical disability, mental disability, medical condition, marital status, sex, age, or sexual
orientation.
Upon request, we will consider reasonable accommodations to permit individuals with protected disabilities to
(a) complete the employment or admission process, (b) perform essential job functions, (c) enjoy benefits and
privileges of similarly-situated individuals without disabilities, and (d) participate in instruction, programs,
services, activities, or events.
AVC is an equal opportunity employer.
Annual Security Report is provided by Antelope Valley College for prospective students and employees. A
copy of this report is available at
|
