Agenda

Return

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

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
cc:	EHSD Human Resources Otilia Parra Fina Prak

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,

BY:	, Deputy

RECOMMENDATION(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, 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.