Under the direction of the Manager, Enterprise Applications & Development, incumbent will design and develop enterprise applications, programs and/or 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; application administration and remediation; design, develop, document, test and implement programs as required; and perform other related duties as assigned.

• Use District data element dictionary in developing programs to prepare MIS reports as required. (E)
• Design and develop programs to augment Ellucian Banner database(s) utilization and to facilitate District business processes as requested. (E)
• Work with the Oracle and Ellucian 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, Information Technology, or related discipline, and two years' experience in relational database systems programming (preferably Oracle) and UNIX/LINUX. Year-for-year full time experience can be substituted for degree requirement.

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, XML, JSP or ASP or .net.
• Beneficial languages COBOL, UNIX/LINUX shell scripting, Groovy, Grails, and Visual Basic.
• Basic networked computer systems and operation.
• Automated workflow models.
• Oracle and UNIX/LINUX.
• Database program problem identification and problem solving techniques

• Best practices in MIS reporting and data element dictionary.
• Best practices in enterprise reporting and process analysis
• Experience in enterprise systems development for California Community Colleges or Higher Education

• 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/LINUX and Oracle systems, as well as District database applications, including Ellucian Banner, as directed by 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.

• 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.

Application Process
This position requires the following documents to be attached to your online application in order to be considered:

• Application
• Current resume
• Letter of Intent (Cover Letter)
• Copy of Transcripts with degree conferred date

Your application and any required attachments must be submitted by April 24, 2023.

Equal Employment Opportunity and Commitment to Diversity
Antelope Valley College is committed to employing administrators, faculty, and staff members who are dedicated to student success. AVC recognizes that diversity in the academic environment fosters cultural awareness, promotes mutual understanding and respect, and provides suitable role models for all students. AVC is committed to hiring processes that support equal opportunity, diversity, and provide equitable consideration for all candidates as required in federal and state law.

To find out more about AVC, please visit our website at avc.edu

ACCOMMODATIONS

If you have, any questions or concerns/if you require accommodations for the application process in compliance with the Americans with Disabilities Act, please contact the Human Resources Office at (661)722-6311.

Thank you for your interest in employment opportunities with Antelope Valley Community College District.

COMMITMENT TO DIVERSITY AND EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER

Antelope Valley Community College District (AVC) is committed to employing administrators, faculty, and staff members who are dedicated to student success. AVC recognizes that diversity in the academic environment fosters cultural awareness, promotes mutual understanding and respect, and provides suitable role models for all students.

AVC is committed to hiring processes that support equal opportunity, diversity, and provide equitable consideration for all candidates as required in federal and state laws and regulations. To find out more about AVC, please visit our website at avc.edu.

______________________________________________________________________

Annual Security Report is provided by Antelope Valley College for prospective students and employees.