HomeMy WebLinkAboutMINUTES - 09152015 - C.29RECOMMENDATION(S):
ADOPT Position Adjustment Resolution No. 21715 to add one (1) Database Administrator (LWSA) (represented)
full time position at Salary Plan and Grade ZB5 1834 ($6841-$8316) Information Technology Division of the
Administrative Bureau of Employment and Human Services Department.
FISCAL IMPACT:
Upon approval of this position, will have an annual cost of $148,439. This position will be funded 45% Federal
revenue, 45% State revenue, and 10% County cost. The annual pension cost is $51,954.
BACKGROUND:
The Employment and Human Services Department requests to add one permanent full time Database Administrator
in the Information Technology Division of the Administrative Bureau of Employment and Human Services
Department. The Information Technology Division currently has one Database Administrator who oversees a very
complex database of over a thousand tables in the CalWIN Information System (CIS), running on Oracle. The
Database Administrator manages this CIS database,
APPROVE OTHER
RECOMMENDATION OF CNTY ADMINISTRATOR RECOMMENDATION OF BOARD COMMITTEE
Action of Board On: 09/15/2015 APPROVED AS RECOMMENDED OTHER
Clerks Notes:
VOTE OF SUPERVISORS
AYE:John Gioia, District I
Supervisor
Candace Andersen, District II
Supervisor
Karen Mitchoff, District IV
Supervisor
ABSENT:Mary N. Piepho, District III
Supervisor
Federal D. Glover, District V
Supervisor
Contact: Holly Trieu (925) 313-1560
I hereby certify that this is a true and correct copy of an action taken and entered on the minutes of the
Board of Supervisors on the date shown.
ATTESTED: September 15, 2015
David Twa, County Administrator and Clerk of the Board of Supervisors
By: , Deputy
cc: EHSD, Human Resources, Otilia Parra, Fina Prak
C. 29
To:Board of Supervisors
From:Kathy Gallagher, Employment & Human Services Director
Date:September 15, 2015
Contra
Costa
County
Subject:Add one (1) Database Administrator full time position Information Technology Division at EHSD
BACKGROUND: (CONT'D)
the various interfaces to the state, the daily, weekly, and monthly table update processes, and the batch processes
that generate supporting tables for these reports. Additionally, EHSD has partnered with Santa Clara to implement
a Business Intelligence Dashboard, based on an Oracle database. The dashboard and associated reporting will
provide critical support to both Workforce Services and Children and Family Services daily operations. This
dramatically increases the importance and complexity of the tasks. The position also develops and modifies
databases that require knowledge of Microsoft SQL Databases, assists programming staff in managing the SQL
databases that EHSD’s internal applications use, participates in systems analysis, design, and implementation,
monitors database performance, establishes procedures for database operations, and responds to system problems
that may affect the database. Oracle Database support is requiring more effort and becoming more complex as
noted above. Additionally, with the implementation of the Santa Clara Business Intelligence Dashboard, the
criticality to day-to-day operations is becoming paramount. The additional Database Administrator will perform
all of these duties as well as on-going backup for the current Database Administrator.
CONSEQUENCE OF NEGATIVE ACTION:
If this position is not added, the department will continue to have one single Database Administrator to oversee
the CalWin complex database; failures in other database programs will leave the department without a back-up.
CHILDREN'S IMPACT STATEMENT:
The Santa Clara Business Intelligence Dashboard will also provide CWS/CMS Data. This tool will assist Children
and Family Services on tracking timeliness of assistance and other important factors.
ATTACHMENTS
P-300 #21715