Helping California's local education agencies efficiently and effectively
use electronic data

Database Programmer/Analyst

Salary & Benefits

$#,### – $#,### per month. Maximum entry level is $#,### per month. Holiday, sick leave and vacation benefits are provided. Prepaid medical, dental, vision, and counseling plans provided for employee and family. Prepaid life insurance policy provided for the employee. Employees of this office are not covered by Social Security, but do have mandatory retirement coverage with Public Employees Retirement System (PERS). This position is located in Sacramento, CA.

Responsibilities

Under direction of the CSIS Information Systems Administrator, plan and execute tasks supporting the operation and use of database and data warehouse structures and systems supporting the California School Information Services (CSIS) program staff, local education agencies and the California Department of Education.
As a CSIS technical staff member, the CSIS Database Programmer/Analyst (DBP/A) may lead technical and procedural efforts that establish, document and carry out detailed services to CSIS Program participants.
Determine data manipulation needs within the CSIS architecture and building of data storage and retrieval routines necessary to the development, implementation and operation of systems in a client-server, multi-tier architecture;
work as a technical team member contributing to a wide variety of tasks including systems analysis for database needs, design of both logical and physical data structures;
development and maintenance including use of Data Definition Language (DDL);
development and support of database update and retrieval modules based upon Structured Query Language (SQL);
implement and maintain procedures for the efficient and effective deployment and use of data access, retrieval and storage routines including use of Remote Procedure Calls (RPCs);
coordinate and participate in training of CSIS Program staff and staffs of other agencies as directed;
provide timely and accurate reporting of CSIS technical issues to the CSIS Information Systems Administrator, and as directed to key stakeholders and other entities;
serve as a cooperative and contributing member of the CSIS Program Office team;
complete other duties as assigned.

Qualifications

Knowledge of:
Knowledge of the use of DBMS products and tool sets;
thorough knowledge of one or more relational or multidimensional database management systems such as Oracle, SQL Server, Informix or Sybase, plus demonstrated knowledge of microcomputer database tools such as Access, FoxPro, 4th Dimension or similar product;
capabilities, capacities and limitations of databases and or computer hardware and software systems;
advanced principles, practices and computer systems development methodologies;
and client support issues and concepts.
Ability to:
Proven ability to effectively work on concurrent tasks and with multiple entities;
work with formal organizational structures as well as with flexible teams;
build and manage constructive inter-personal relationships;
excellent written and verbal communication skills.
Experience:
A minimum of two years combined experience in designing for, development of, implementing and using relational or multidimensional database management systems (DBMS) is necessary.
Experience with high-end servers and mini or mainframe with large-scale implementations is preferred;
experience using microcomputer platforms is acceptable;
demonstrated progress in job assignments for this period is expected.
Desirable experience includes:  Four or more years experience in large scale, enterprise database and data warehouse applications;
four or more years experience in client-server and/or server based applications;
two or more years working with school and/or student based information systems;
two or more years working in local area and wide area network (LAN/WAN) environments;
some experience using advanced CASE or other data and systems design tools.
Education:
Graduation from an accredited two-year college or university with a major in computer science, information technologies, or a related field.
Work experience resulting in an equivalent knowledge base may be substituted for the major requirement.

Application Deadlines

Filing Deadline: Month xx, 201x
Oral Interview: Week of Month xx – Month xx, 201x
All candidates must file an application, supplemental application, resume, and proof of education with the California School Information Services Program, 770 L St. Suite 1120, Sacramento, CA 95814, (916) 325-9200 on or before Month xx, 201x, by 5:00 p.m. College transcripts or other proof of education is required with application.
This position is located in Sacramento.
Each candidate’s application papers will be thoroughly evaluated and ranked by a screening committee appointed by the Kern County Superintendent of Schools Office. Candidates achieving a rating of 70% or better will qualify to continue in the eligibility screening process with an interview scheduled the week of Month xx, 201x. Interviews will be held at the California School Information Services Office, 770 L St. Suite 1120, Sacramento, CA 95814.

Conditions of Employment

Some positions may require proof of privately owned automobile insurance and possess a valid California Motor Vehicle operator’s license. Fingerprint clearance by the Federal Bureau of Investigation and the California Department of Justice is a condition of appointment after all other required job conditions have been met. This position is overtime exempt and has a probationary period of one year.