ADMINISTRATIVE COMMITTEE

 

6.

CONSIDER CONTINUANCE OF CONTRACT WITH ZONE 24X7 FOR WATER DEMAND DATABASE IMPROVEMENTS AND MAINTENANCE

 

Meeting Date:

June 13, 2016

Budgeted: 

Yes

 

From:

David J. Stoldt

Program:

Water Conservation

 

General Manager

Line Item No.:

6-7811.80

 

Prepared By:

Mark A. Dudley

Cost Estimate:

$60,000

 

Administrative Services Division Manager/Chief Financial Officer Review:  Yes

Committee Recommendation:  The Administrative Committee reviewed this item on June 13, 2016 and recommended ________________.

CEQA Compliance:  N/A

 

SUMMARY:  Staff is requesting authorization to expend budgeted funds to continue software programming needs related to the District’s Water Demand Division Database (WDD-DBS).  The WDD-DBS was deployed in October 2009.  Due to the complexity of the integrated database system and changes to District policy, additional programming is necessary to address refinements and conflicts related to the various processes.  Since the October 2009 launch date, WDD-DBS support has been provided by Zone 24x7 (the contractor and designer of the system) and District staff.

 

RECOMMENDATION:  Staff recommends the Board authorize expenditure of budgeted funds in an amount not-to-exceed $60,000 for programming changes to the WDD-DBS to accommodate functionality improvements and database support/maintenance.

 

IMPACT TO STAFF/RESOURCES:  The FY 2016-2017 Water Demand Division Project budget includes $60,000 for this support.    

 

BACKGROUND:  As staff has worked with the system, it has been determined that some of the items originally programmed can be improved to provide better functionality, flexibility, responsiveness and ongoing maintenance of the database.  These functional requirements are based on staff feedback on the original design of the database system.  In addition, implementation of water demand-related ordinances has complicated programming and functionality, as each change potentially affects more than one module in the WDD-DBS.  Additionally, the existing database is in the process of migration to the latest version of Microsoft SQL Server as the current version is under extended support by Microsoft as of July 2015.  These funds will continue the ongoing migration process and regression testing by the software vendor and staff. 

 

EXHIBITS

None

 

U:\staff\Board_Committees\Admin\2016\20160613\06\Item-6.docx