ADMINISTRATIVE COMMITTEE

 

12.

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

 

Meeting Date:

June 12, 2017

Budgeted: 

Yes

 

From:

David J. Stoldt

Program:

Water Conservation

 

General Manager

Line Item No.:

26-05-781161

 

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 12, 2017 and recommended _______________.

CEQA Compliance:  This action does not constitute a project as defined by the California Environmental Quality Act Guidelines section 15378.

 

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 rules, 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 2017-2018 Water Demand Division Project budget includes $60,000 for this support.  Approval of this item will be contingent upon adoption of the FY 2017-2018 budget by the District Board.    

 

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                                                                                      file:///U:\staff\Board_Committees\Admin\2017\20170612\12\Item-12.docx