Programmer Analyst I and II (Database Administration)

Class Description

CCBC employs programmers across a wide range of application development and systems support areas. We are currently seeking a Programmer with a particular focus on database administration within our Ellucian Banner and Oracle environments. This role supports database maintenance, Banner administrative processes, SQL and PL/SQL development, and collaboration with database administrators to ensure data integrity, system performance, and reliable enterprise operations. Candidates with experience or interest in database administration or database-driven application support are especially encouraged to apply. Please note that there might be occasional off-hours support required to support the enterprise applications.

The Programmer Analyst I maintains information technology systems including software development life cycles to design, analysis, detail programming, testing, and documentation, understanding business goals and objects, and ensuring projects are delivered in timely manners.

The Programmer/Analyst II serves as a senior technical expert responsible for the advanced support, operation, maintenance, and development of enterprise business applications, including but not limited to the Ellucian Banner ERP system. This role provides strategic and technical leadership in the planning, execution, and evaluation of administrative and academic application initiatives that align with the College’s mission and the strategic vision for information technology. This position requires a high level of autonomy, initiative, and expertise in enterprise application environments, with a strong emphasis on Banner ERP and related administrative systems.

Minimum Requirements

Programmer Analyst I - $78,839-$130,309

• Bachelor’s degree in information technology.
• 8 years of information technology experience in supporting enterprise administrative applications.
• Passing score on programming assessment required job specific languages such as Java, JavaScript, Linux Shell Scripting, TSQL, PL/SQL.
• Placement on the Programmer/Analyst I level requires completion of at least two technical certification identified as appropriate for the Programmer/Analyst I level in the College’s Programmer Certification Matrix and at least one certification identified for the next lower level in the matrix. Certifications must be relevant to the technical and functional responsibilities of the role. Completion of a higher-level certification may be accepted in lieu of a lower-level certification when it aligns with the position’s duties and scope. The College’s Programmer Certification Matrix is subject to change annually.

Programmer Analyst II - $87,514-$144,647

• Bachelor’s degree in information technology.
• 12 years of relevant information technology experience supporting enterprise administrative applications and business process analysis.
• Passing score on programming assessment for required job specific languages such as Java, JavaScript, Linux Shell Scripting, TSQL, PL/SQL.
• Placement on the Programmer/Analyst II level requires completion of at least three technical certification identified as appropriate for the Programmer/Analyst II level in the College’s Programmer Certification Matrix and at least one certification identified for the next two lower levels in the matrix. Certifications must be relevant to the technical and functional responsibilities of the role. Completion of a higher-level certification may be accepted in lieu of a lower-level certification when it aligns with the position’s duties and scope. The College’s Programmer Certification Matrix is subject to change annually.

Mandatory Banner Module Training is required for All New Hires regardless of placement level. All new hires must complete the assigned Banner module curriculum and assessment within six months of their start date. Successful completion is required for continued employment and is a condition of hire.

Promotion and placement within the Programmer career ladder are guided by the most current College’s Programmer Certification Matrix. This matrix outlines recognized certifications and relevant experience benchmarks that support advancement through the Programmer I, Programmer II, Programmer-Analyst I, and Programmer-Analyst II roles. Candidates are encouraged to pursue certifications aligned with their current role and career goals. Certification status will be considered in hiring, promotion, and professional development decisions.

Class Specific Essential Duties

Programmer Analyst I

• Analyze and translate business requirements into technical specifications, ensuring alignment with institutional goals and operational needs.
• Design, develop, and maintain enterprise applications usingprogramming and scripting languages, with a focus on performance, scalability, and maintainability.
• Conduct business process reviews across administrative domains such as admissions, registration, finance, HR, and financial aid, identifying opportunities for automation and optimization.
• Collaborate with stakeholders and cross-functional teams to implement integrated solutions that support enterprise-wide workflows and data integrity.
• Perform debugging, testing, and configuration of applications, ensuring reliability and compliance with institutional standards.
• Produce and maintain technical documentation including process flows, data models, and technical specifications to support ongoing development and knowledge transfer.
• Provide Tier III support for enterprise systems, resolving escalated issues and coordinating with IT support teams to ensure timely resolution.
• Contribute to the development and enforcement of coding standards, best practices, and quality assurance protocols within the development team.

Programmer Analyst II

• Leading complex programming and systems integration efforts across enterprise platforms.
• Conducting in-depth business analysis to identify, design, and implement solutions that improve operational efficiency and data integrity.
• Diagnosing and resolving advanced technical issues, ensuring system reliability and performance.
• Collaborating with stakeholders and cross-functional teams to define requirements, develop project plans, and deliver high-impact solutions.
• Mentoring staff and contributing to the development of best practices, standards, and documentation.
• Evaluating emerging technologies and recommending enhancements to existing systems and processes.
• Perform advanced coding, debugging, testing, configuration, and analysis to develop or modify application programs.
• Conduct detailed analysis of functional and technical requirements to create specifications.
• Utilize programming, scripting, or database languages to produce efficient code.
• Provide Tier III support for implementing, enhancing, integrating, and maintaining applications.
• Produce and maintain technical documentation including process flows, data models, and technical specifications to support ongoing development and knowledge transfer.

Essential Job Duties are intended to be examples of duties and are not intended to be all inclusive. There will be other duties as assigned.

Position Specific Essential Duties

Programmer Analyst I

• Develop, test and maintainapplication code using SQL, PL/SQL, Java, and HTML, ensuring performance, scalability, and maintainability across enterprise systems.
• Lead data validation and testing efforts, working with users to verify accuracy and reliability of implementations and enhancements to administrative applications.
• Troubleshoot and resolve software issues to ensure system stability and user satisfaction.
• Collaborate with business units to analyze workflows and design application interfaces that meet faculty, student, and administrative needs.
• Design and generate reports within the Ellucian Banner ERP system, supporting institutional decision-making and operational efficiency.
• Provide Tier III support for enterprise applications and coordinating with IT support teams to resolve issues.
• Mentor programmers by offering guidance on technical challenges and promoting adherence to development standards and best practices.
• Document technical processes, application configurations, and business workflows to support knowledge sharing, compliance, and future maintenance
• Conduct business process reviews to identify opportunities for system enhancements, automation, and workflow optimization.
• Design and manage scheduled jobs using job scheduler software to automate routine operations and ensure timely execution of critical processes.
• Support and maintain Banner ERP module processes and reports, ensuring accuracy, reliability, and performance across administrative functions.

Programmer Analyst II

• Maintain and optimize codebase, updating, repairing, testing and refining existing code using SQL, PL/SQL, Java, HTML, and other relevant technologies.
• Document technical workflows, producing and maintaining comprehensive documentation including process flows, data flow diagrams, and system specifications.
• Perform rigorous testing, conducting unit testing and validation of applications to ensure accuracy, reliability, and performance.
• Lead and support data verification and quality assurance, assisting users in verifying data and testing programs to ensure successful implementation and enhancement of application systems.
• Troubleshoot and debug applications, identifying and resolving advanced software issues through advanced debugging and troubleshooting techniques.
• Lead complex projects, providing expert support to programmers and analysts on challenging projects and leading the implementation of complex application interfaces.
• Deliver ERP reporting solutions, designing and executing reports within the Ellucian Banner ERP system to meet faculty, student, and administrative needs.
• Provide Tier III technical support, serving as a senior resource for escalated issues and coordinating with the Help Desk and Support Center to ensure resolution.
• Mentor Programmer Analysts and Programmers by offering guidance on technical challenges and promoting adherence to development standards and best practices.
• Document technical processes, application configurations, and business workflows to support knowledge sharing, compliance, and future maintenance.
• Collaborate with business units to analyze workflows and design application interfaces that meet faculty, student, and administrative needs.

Essential Job Duties are intended to be examples of duties and are not intended to be all inclusive. There will be other duties as assigned