General Information
| Payroll Title | PROGR ANL 3 | Title Code | 007275 | Grade/Step | 10 | Working Title | Oracle PLSQL Developer |
|---|---|---|---|---|---|---|---|
| Department Name | Student Information Systems De | Supervisor | Livaudais, Mary F | Department Head | Livaudais, Mary F |
Special Requirements and Conditions
| Critical Position |
| Travel |
| Travel Outside of Normal Business Hours |
Level of Supervision Received
| General Supervision |
Items Used
Position Purpose
| Under the general direction of Computing and Communications Director of Academic Information Systems, the purpose of this position is to design, program, troubleshoot, maintain, update, and document complex software applications in Oracle/UNIX environments. Development is in support of Student Information Systems, specifically Student Business Services, Admissions, Enrollment Management, and Financial Aid. Specific duties include (but are not limited to) analysis and design of new systems, integration of third-party applications, writing code, testing and debugging programs, engaging in database design/tuning, utilizing Oracle internet application server, PL/SQL and Java in program source code, as well as HTML, XML, Javascript and other web technologies. Also included is interaction with users and analysts to determine client needs, writing documentation as needed, and providing technical expertise and insight to other programming staff as required. Assignments typically require advanced, current knowledge of hardware, software, systems analysis techniques, and/or specialized knowledge in higher education business and student administrative functions or disciplines. All software applications produced must be of the highest production quality (e.g., available 24x7 with minimal scheduled downtime). The potential user base includes virtually all campus constituents (administrative and academic) as well as users at the University of California, Office of the President. |
Essential Functions
| Essential Function | % Time |
|---|---|
| Software Application Development in a Cooperative, Team Environment. | 80 |
| Software Application Development in a Cooperative, Team Environment: 80 1. Develop, implement, maintain, and support sophisticated web applications that automate campus business processes. Development may include business processes from Student Business Services, Student Records, Admissions, Financial Aid, Summer Sessions, Housing etc. Primary technologies include UNIX, SQL, PL/SQL, Oracle Internet Application Server, Java, HTML, Javascript, and other emerging multimedia and web programming technologies. 2. Develop, implement, maintain, and support sophisticated IBM mainframe and Oracle PL/SQL. These software applications include automated online and batch transaction processing systems, and On-Line Analytical Processing (OLAP) tools. SQL, ODBC access methods, and third-party tools to enhance program functionality. 3. Research system impact of requests for modifications and enhancements, identifying and documenting all existing programs and processes affected. 4. Prepare support documentation, for processes, programs and jobs. 5. Engage in database design and tuning to support software application development. Responsibilities involve the design and creation of database queries and objects (tables, views, indexes, users, roles, stored procedures, etc.) and performance monitoring and tuning. Database technologies include Oracle, SQL, PL/SQL, ODBC. 6. Explore and utilize other languages and technologies to develop software that enhances and complements our various applications. |
|
| Interact With End Users, Analysts, and Other Programmers to Determine Client Needs, Install Custom Applications, and Train End Users. | 15 |
| Interact With End Users, Analysts, and Other Programmers to Determine Client Needs, Install Custom Applications, and Train End Users. 15 1. Participate in meetings to determine project priorities, end user needs, project time frames, and project directions. 2. Interact with other programmers and technical leadership to determine most effective technologies to deploy given customer requirements. 3. Consider and advocate creative solutions (both technical and non-technical) to end user business needs, training requirements, and software installation/update requirements. |
|
| Provide Other Programming, Technical, and Non-Technical Support in a Team-Oriented, Client/Server Development Environment. | 5 |
| Provide Other Programming, Technical, and Non-Technical Support in a Team-Oriented, Client/Server Development Environment. 5 1. Interact with other programmers and vendors to determine optimal development strategies, techniques, and tools. Share knowledge and expertise as needed throughout the organization. Address technical issues, problems, and concerns that do not directly result from software applications (e.g. operating system and network issues). |
|
Minimum Requirements
| Minimum Requirement | Display Ranking |
|---|---|
| 1 | |
| Bachelor's degree in Computer Science or related field or an equivalent combination of education and experience |
|
| 2 | |
| Experience with Oracle PL/SQL, UNIX |
|
| 3 | |
| Demonstrated programming and troubleshooting skills. |
|
| 4 | |
| Must possess excellent oral and written communications skills, with the ability to communicate processes, procedures and specifications verbally and in writing, to a diverse audience, technical, non-technical and executive. |
|
| 5 | |
| Ability to utilize a wide variety of software development tools to independently complete custom software applications. |
|
| 6 | |
| Knowledge of current computing, network, operating system, and software development trends. Proven, demonstrated ability to work independently and deploy sophisticated software systems to hundreds of users in a highly distributed environment. Excellent interpersonal and communication skills, time management abilities, and organizational skills. Ability to be flexible, cooperative and collaborative in a fast-paced, dynamic, and technical work environment. | |
Preferred Qualifications
| Preferred Qualification | Display Ranking |
|---|---|
| 1 | |
|
In-depth experience with environments such as RDBMS, SQL, Oracle PL/SQL, HTML, Javascript, Cobol, PowerBuilder, Microsoft Windows operating systems, and database design, programming, and tuning techniques. |
|
| 2 | |
| Extensive, demonstrated programming/troubleshooting skills. | |
| 3 | |
|
Experience with business functional analysis relating to automation of business processes in a higher education environment. |
|
| 4 | |
| Experience with business analytics software, preferably Cognos. | |
| 5 | |
| Experience with application development for higher education, in particular Banner Student Information System. | |
| Posted Position Purpose |
|---|
| Under the general direction of Computing and Communications Director of Academic Information Systems, the purpose of this position is to design, program, troubleshoot, maintain, update, and document complex software applications in Oracle/UNIX environments. Development is in support of Student Information Systems, specifically Student Business Services, Admissions, Enrollment Management, and Financial Aid. Specific duties include (but are not limited to) analysis and design of new systems, integration of third-party applications, writing code, testing and debugging programs, engaging in database design/tuning, utilizing Oracle internet application server, PL/SQL and Java in program source code, as well as HTML, XML, Javascript and other web technologies. Also included is interaction with users and analysts to determine client needs, writing documentation as needed, and providing technical expertise and insight to other programming staff as required. Assignments typically require advanced, current knowledge of hardware, software, systems analysis techniques, and/or specialized knowledge in higher education business and student administrative functions or disciplines. All software applications produced must be of the highest production quality (e.g., available 24x7 with minimal scheduled downtime). The potential user base includes virtually all campus constituents (administrative and academic) as well as users at the University of California, Office of the President. |
| Posted Minimum Requirements |
| Bachelor's degree in Computer Science or related field or an equivalent combination of education and experience. Experience with Oracle PL/SQL, UNIX Demonstrated programming and troubleshooting skills. Must possess excellent oral and written communications skills, with the ability to communicate processes, procedures and specifications verbally and in writing, to a diverse audience, technical, non-technical and executive. Ability to utilize a wide variety of software development tools to independently complete custom software applications. Knowledge of current computing, network, operating system, and software development trends. Proven, demonstrated ability to work independently and deploy sophisticated software systems to hundreds of users in a highly distributed environment. Excellent interpersonal and communication skills, time management abilities, and organizational skills. Ability to be flexible, cooperative and collaborative in a fast-paced, dynamic, and technical work environment. |
| Posted Preferred Qualifications |
| In-depth experience with environments such as RDBMS, SQL, Oracle PL/SQL, HTML, Javascript, Cobol, PowerBuilder, Microsoft Windows operating systems, and database design, programming, and tuning techniques. Extensive, demonstrated programming/troubleshooting skills. Experience with business functional analysis relating to automation of business processes in a higher education environment. Experience with business analytics software, preferably Cognos. Experience with application development for higher education, in particular Banner Student Information System. |