Updated: Mar 23, 2020

Location: UC Irvine Campus


Job Type:

Department: SOM-DECISION SUPPORT SERVICES

Recruitment Number: 6963
Reports To:
Working Title: Web Programmer
Cost Center: IR6080
Bargaining Unit: 99
FLSA: Exempt
Job Code: 007300
Job Location: Various
Percent of Time: 100%
Work Schedule: 8-5, M-F
Appointment: Career

Position Summary:

Under the general direction of Director, SOM Decision Support Services (DSS), and as an integral part of the Decision Support Staff technical team, Applications Programmer 3 is responsible for developing, implementing, and maintaining complex home grown systems. As part of the DSS, this position will play a significant role in the enhancement/modification of existing and future DSS Web Applications, maintenance of database programs integrated with DSS home grown systems. The incumbent is expected to work with SOM Associated Dean/CAO/CFO, Dean's Office Directors, Financial Managers and Analysts, as well as the other departmental CAOs and Personnel, providing technical and non-technical assistance on all DSS systems and their local environment.

Compensation Range:

Monthly: $5,091.67 - $7,754.17

Department Website:

http://www.som.uci.edu/

Required:

At least 2 years web programming experience using in VB.Net technology and Visual Studio.
At least 4 to 5 years of relevant work experience with a BA/BS; or at least 2 to 3 years of relevant work experience with MA/MS; or equivalent work experience.
Strong knowledge of and experience with web programming in ASP.Net, VB.NET, HTML, XML, CSS, JavaScript, Bootstrap, and jQuery.
Strong knowledge of and experience with source control technology, Subversion, or Git.
Demonstrated skill to analyze current system modules in order to redesign functional modules with more modern software tools and programming languages.
Demonstrated skill and experience in SDLC, software development planning, systems design, project management, user training, operational training, system maintenance and recovery.
At least 2 years database programming experience in MS SQL, Oracle, DB2, or any SQL coding.
Experience and knowledge of SQL programming; stored procedures, functions, triggers, views, indexes, and tuning.
Experience in data extraction and query tools, conversion of data to/from multiple formats, import techniques and file formats (Excel, Access, SQL, CSV) for moving data from one platform to another.
Significant knowledge of data modeling, table design, and RDMS.
Knowledge of multidimensional reporting/analysis tools such as Tableau, Cognos, and Business Intelligence.
Experience in help desk or production support environment, with large scales of web and database programming projects.
Demonstrated in the environment to handle multi-tasking in both production supports and scheduled projects, and must have good skills of time and project management.
Demonstrated skill to work as an independent, self-motivated productive member of a team, and a good team player.
Demonstrated skill to contribute both technical and non-technical discussions and to recommend solutions to technical problems.
Knowledge of DBA functions, such as SQL database backup/restore, query tuning, scheduled jobs, and monitor, is plus.
Working experience with Tableau and MS Reporting Services, is plus.
Experience in supporting Finance, Accounting, or HR team is plus.
Intermediate knowledge of secure software development.
Advanced skills associated with software design, modification, implementation and deployment, including object-oriented programming concepts.
Demonstrated ability to understand functional needs and how systems can support those needs. Demonstrated ability to develop conversion and system implementation plans.
Demonstrated software repository skills. Demonstrated testing and test planning skills.
Thorough experience with common programming tools. Demonstrated ability to follow software specifications.
Demonstrated effective communication and interpersonal skills.
Self-motivated and works independently and as part of a team. Able
Demonstrated broad problem solving skills.

Preferred:

Knowledge of UCI data warehouse and business systems, or any higher education data is plus.
Knowledge of School of Medicine business functions and systems supporting those functions (accounting, payroll, research, students, physician billing) is plus.
Demonstrated ability to interface with management on a regular basis.
Demonstrated ability to contribute technical narrative to grant proposals.
Thorough experience with identification and use of code libraries and open-source forums.
Experience with planning for deployment and creation of feedback mechanisms.
Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.

Final candidate subject to background check. As a federal contractor, UC Irvine is required to use E-Verify to confirm the work status of individuals assigned to perform substantial work under certain federal contracts/subcontracts.

The University of California, Irvine is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy.

Below are general guidelines on the position's physical, mental, and environmental working conditions. In accordance with applicable state and federal law, UCI provides reasonable accommodations for applicants with disabilities upon request. For more information, please contact Human Resources at (949) 824-0500.