Human Resources, University of California, Berkeley

·Home·

About Us/
Contact

·Compensation·

·HRMS·

Compensation and Classification

Programmer/Analyst Job Family
Technical Leveling Factors

(Note: Please print using landscape format)

Programmer/Analyst Jobs
System Administrator Programmer/Analyst Jobs
Database Oriented Programmer/Analyst Jobs
Job Description Template

PROGRAMMER/ANALYST JOBS

LEVEL	IMPACT AND SCOPE	INDEPENDENCE AND DECISION MAKING	WORKING RELATIONSHIPS	KNOWLEDGE AND SKILLS
PA II	Completion of specific programs or projects. Work quality affects the achievement of sub-unit goals and objectives.	Receives direct supervision, and work is checked for adherence to established standards. Prioritizes work, and selects methods which typically conform to generally established standards. May have primary responsibility for small projects or systems.	Contacts are primarily within work groups as a member of a project team or with professional colleagues across the campus in order to identify and resolve problems. Trains users on implementation and operation of specific systems and databases.	Broad knowledge in area of expertise with an understanding and basic ability to design, develop, and implement systems for moderately complex applications or to maintain simpler systems and assist in the management and integration of more complex systems.
PA III	Guides successful completion of major programs. Work quality affects the attainment of major unit objectives.	Works relatively independently and in consultation with manager and high level technical experts to define systems design requirements, and to develop and implement complex systems. Negotiates scope and approach to be employed with users. Work is only periodically reviewed on results achieved and general methods.	Works closely with users to establish system specifications and resolve problems. May be principal support person for major systems. Interacts with other PA’s within unit and across campus. Trains users on implementation and operation of systems. May interact with vendors to resolve system problems an understand new technology.	Broad and in-depth knowledge and technical expertise in one or more areas of expertise; recognized as a resource in a specialty area, competent to independently resolve complex problems and systems administration/networking issues using advanced principles.
PA IV	Develops or implements advanced technical ideas and guides their development. Work quality affects the achievement of critical objectives in multiple units.	Conceives, plans and implements original approaches to solve complex problems of diverse scope. Prepares publications and presentations on technical concepts for campus-wide and/or industry groups. Identifies, evaluates, and recommends appropriate new technologies for unit/campus.	Frequent interaction with users of project teams to establish system specifications and resolve problems. Principal contact for complex systems. Interacts with vendors to resolve system problems. Trains users and high level system professionals in implementation and operation of the most complex systems.	Broad authority and in-depth knowledge in area of expertise. High level technical contributor in own field; recognized as a resource within unit/campus. Acts as internal and external consultant to others in one or more areas of expertise. Competent to work at the highest level of all phases in profession.

SYSTEM ADMINISTRATOR PROGRAMMER/ANALYST JOBS
(Factors in addition to Programmer/Analyst Job Factors)

LEVEL	RESPONSIBILITIES
PA II	Respond to trouble reports Contact vendors to report trouble Install, maintain, upgrade software Install, maintain, upgrade hardware Add new users (when process is straight-forward/uncomplicated) Simple set up of network services (mail, Backups: change tapes, do dumps, etc. on relatively simple systems User needs relatively simple: small groups, undergraduates, clerical
PA III	Resolves problems with vendors Authority to allocate resources (computers, disk, etc.) Design backup system Sets up complex security system Designs hardware configuration Writes operating system code to add new computers to network Sets up complex mail service Sets up and maintains high-level network services (mail ,file servers, NFS, etc.) Specifies software and hardware requirements User needs more complex: faculty, graduate students, other technical users Customizes operating system to meet organizational needs
PA IV	Designs large, complex backup system Design/implements/maintains security system Designs large/complex hardware configuration Makes decisions about software and hardware requirements Oversees large, complex system (many servers interacting, etc.) Address highly technical user needs: high-level technical, scientific knowledge required (FE: MatLab)

DATABASE ORIENTED PROGRAMMER/ANALYST JOBS
(Factors in addition to Programmer/Analyst Job Factors)

LEVEL	CLIENT SERVED	DATABASE CHARACTERISTICS	RESPONSIBILITIES	PLATFORM CHARACTERISTICS
PA II	typically within the business unit/department	typically small and less complex databases typically do not see online update capabilities	enters data into database or general data loading help train users no design responsibility no database management responsibility report generation	database resides on PC and accessed by limited client base
PA III	client base extents to the control unit and may occasionally be campus-wide	smaller databases or large but less complex (e.g., limited number of tables) ones many users with online transaction capabilities	write scripts for data loading designs and writes backup procedures install and maintain database (operational responsibility) design activity restricted to smaller to moderate sized database systems typically manages database modify tables and interfaces	PC based with multiple users or UNIX based with limited user.
PA IV	client base typically involves the entire university and may extent beyond	typically, large and highly complex (numerous tables) many users with online transaction capabilities	design database and schema for the loading of data if no design, understands and administers highly complex database or warehouse does performance tuning of system; detailed knowledge of database internal working typically manages database modify tables and interfaces	UNIX (or similar operating system) based