HomeMy WebLinkAboutRFP - P 858 (2)Citv of Fort Collins
AdministrAve Services
Purchasing Division
REQUEST FOR PROPOSAL
CITY OF FORT COLLINS
Proposal Number P-858
The City of Fort Collins is seeking proposals from qualified vendors for Data Base Management.
Seven (7) CD ROM copies of proposals will be received at the City of Fort Collins' Purchasing
Division, 215 North Mason St., 2nd floor, Fort Collins, Colorado 80524. Proposals will be
received before 2:00 p.m. (our clock), September 13, 2002. If delivered, they are to be delivered
to 215 North Mason Street, 2nd Floor, Fort Collins, Colorado 80524. If mailed, the address is
P.O. Box 580, Fort Collins, 80522-0580.
Questions concerning the scope of the project should be directed to Michelle McDonough,
Project Manager, at 970-221-6369.
Questions regarding proposals submittal or process should be directed to Keith I. Ashby, CPPO,
Buyer, 970-416-2191.
A copy of the Proposal may be obtained as follows:
1. Call the Purchasing Fax -line, 970-416-2033 and follow the verbal instruction to
request document #30858.
2. Download the Proposal/Bid from the Purchasing Webpage,
www.fcqov.com/r)urchasing.
3. Come by Purchasing at 215 North Mason St., 2nd floor, Fort Collins, and request
a copy of the Bid.
Sales Prohibited/Conflict of Interest: No officer, employee, or member of City Council, shall have
a financial interest in the sale to the City of any real or personal property, equipment, material,
supplies or services where such officer or employee exercises directly or indirectly any decision -
making authority concerning such sale or any supervisory authority over the services to be
rendered. This rule also applies to subcontracts with the City. Soliciting or accepting any gift,
gratuity favor, entertainment, kickback or any items of monetary value from any person who has
or is seeking to do business with the City of Fort Collins is prohibited.
Collusive or sham proposals: Any proposal deemed to be collusive or a sham proposal will be
rejected and reported to authorities as such. Your authorized signature of this proposal assures
that such proposal is genuine and is not a collusive or sham proposal.
The City of Fort Collins reserves the right to reject any and all proposals and to waive any
irregularities or informalities.
Sincerely, _
Jos B. O'Neill II, CPPO, FNIGP
Director of Purchasing & Risk Management
215 North Mason Street • 2nd Floor • P.O. Box 580 • Fort Collins, CO 80522-0580 • (970) 221-6775 • FAX (970) 221-6707
REVIEW AND ASSESSMENT
Professional firms will be evaluated on the following criteria. These criteria will be the basis for review of
the written proposals and interview session.
The rating scale shall be from 1 to 5, with 1 being a poor rating, 3 being an average rating, and 5 being an
outstanding rating.
WEIGHTING
QUALIFICATION
STANDARD
FACTOR
2.0
Scope of Proposal
Does the proposal show an understanding of the project
objective, methodology to be used and results that are
desired from the project?
2.0
Assigned Personnel
Do the persons who will be working on the project have
the necessary skills? Are sufficient people of the
requisite skills assigned to the project?
1.0
Availability
Can the work be completed in the necessary time? Can
the target start and completion dates be met? Are other
qualified personnel available to assist in meeting the
project schedule if required? Is the project team
available to attend meetings as required by the Scope of
Work?
1.0
Motivation
Is the firm interested and are they capable of doing
the work in the required time frame?
2.0
Cost and
Do the proposed cost and work hours compare favorably
Work Hours
with the project Manager's estimate? Are the work
hours presented reasonable for the effort required in
each project task or phase?
2.0
Firm Capability
Does the firm have the support capabilities the
assigned personnel require? Has the firm done
previous projects of this type and scope?
Reference evaluation (Top Ranked Firm)
The project Manager will check references using the following criteria. The evaluation rankings will be
labeled Satisfactory/Unsatisfactory.
QUALIFICATION
STANDARD
Overall Performance
Would you hire this Professional again? Did they
show the skills required by this project?
Timetable
Was the original Scope of Work completed within
the specified time? Were interim deadlines met in
a timely manner?
Completeness
Was the Professional responsive to client needs;
did the Professional anticipate problems? Were
problems solved quickly and effectively?
Budget
Was the original Scope of Work completed within
the project budget?
Job Knowledge
a) If a study, did it meet the Scope of Work?
b) If Professional administered a construction
contract, was the project functional upon
completion and did it operate properly? Were
problems corrected quickly and effectively?
Page 11
PROFESSIONAL SERVICES AGREEMENT
THIS AGREEMENT made and entered into the day and year set forth below, by and
between THE CITY OF FORT COLLINS, COLORADO, a Municipal Corporation, hereinafter
referred to as the "City" and , [insert either a corporation, a partnership or an individual,
doing business
WITNESSETH:
hereinafter referred to as "Professional'.
In consideration of the mutual covenants and obligations herein expressed, it is agreed
by and between the parties hereto as follows:
Scope of Services. The Professional agrees to provide services in accordance
with the scope of services attached hereto as Exhibit "A", consisting of () page[s],
and incorporated herein by this reference.
2. The Work Schedule. [Optional] The services to be performed pursuant to this
Agreement shall be performed in accordance with the Work Schedule attached hereto as
Exhibit "B", consisting of ( ) page[s], and incorporated herein by this reference.
3.
Time of Commencement and
Completion of Services.
The services to be
performed
pursuant to this Agreement shall
be initiated within (
) days following
execution of this Agreement. Services shall be completed no later than . Time is of the
essence. Any extensions of the time limit set forth above must be agreed upon in writing by the
parties hereto.
4. Early Termination by City. Notwithstanding the time periods contained herein,
the City may terminate this Agreement at any time without cause by providing written notice of
termination to the Professional. Such notice shall be delivered at least fifteen (15) days prior to
the termination date contained in said notice unless otherwise agreed in writing by the parties.
All notices provided under, this Agreement shall be effective when mailed, postage prepaid and
sent to the following addresses:
Page 12
Professional: City: With Copy to:
In the event of any such early termination by the City, the Professional shall be paid for services
rendered prior to the date of termination, subject only to the satisfactory performance of the
Professional's obligations under this Agreement. Such payment shall be the Professional's sole
right and remedy for such termination.
5. Design, Project Indemnity and Insurance Responsibility. The Professional shall
be responsible for the professional quality, technical accuracy, timely completion and the
coordination of all services rendered by the Professional, including but not limited to designs,
plans, reports, specifications, and drawings and shall, without additional compensation,
promptly remedy and correct any errors, omissions, or other deficiencies. The Professional
shall indemnify, save and hold harmless the City, its officers and employees in accordance with
Colorado law, from all damages whatsoever claimed by third parties against the City; and for the
City's costs and reasonable attorneys fees, arising directly or indirectly out of the Professional's
negligent performance of any of the services furnished under this Agreement. The Professional
shall maintain commercial general liability insurance in the amount of $500,000 combined single
limits, and errors and omissions insurance in the amount of
6. Compensation. [Use this paragraph or Option 1 below.] In consideration of the
services to be performed pursuant to this Agreement, the City agrees to pay Professional a
fixed fee in the amount of ($ ) plus reimbursable direct costs. All such fees and
costs shall not exceed ($ ). Monthly partial payments based upon the
Professional's billings and itemized statements are permissible. The amounts of all such partial
payments shall be based upon the Professional's City -verified progress in completing the
services to be performed pursuant hereto and upon the City's approval of the Professional's
Page 13
actual reimbursable expenses. Final payment shall be made following acceptance of the work
by the City. Upon final payment, all designs, plans, reports, specifications, drawings, and other
services rendered by the Professional shall become the sole property of the City.
6. Compensation. [Option 1] In consideration of the services to be performed
pursuant to this Agreement, the City agrees to pay Professional on a time and reimbursable
direct cost basis according to the following schedule:
Hourly billing rates:
Reimbursable direct costs:
with maximum compensation (for both Professional's time and reimbursable direct costs) not to
exceed ($ ). Monthly partial payments based upon the Professional's billings and
itemized statements of reimbursable direct costs are permissible. The amounts of all such
partial payments shall be based upon the Professional's City -verified progress in completing the
services to be performed pursuant hereto and upon the City's approval of the Professional's
reimbursable direct costs. Final payment shall be made following acceptance of the work by the
City. Upon final payment, all designs, plans, reports, specifications, drawings and other
services rendered by the Professional shall become the sole property of the City.
7. City Representative. The City will designate, prior to commencement of work, its
project representative who shall make, within the scope of his or her authority, all necessary and
proper decisions with reference to the project. All requests for contract interpretations change
orders and other clarification or instruction shall be directed to the City Representative.
8. Project Drawings. [Optional] Upon conclusion of the project and before final
payment, the Professional shall provide the City with reproducible drawings of the project
containing accurate information on the project as constructed. Drawings shall be of archival
quality, prepared on stable mylar base material using a non -fading process to prove for long
storage and high quality reproduction.
Page 14
9. Monthly Report. Commencing thirty (30) days after the date of execution of this
Agreement and every thirty (30) days thereafter, Professional is required to provide the City
Representative with a written report of the status of the work with respect to the Scope of
Services, Work Schedule, and other material information. Failure to provide any required
monthly report may, at the option of the City, suspend the processing of any partial payment
request.
10. Independent Contractor. The services to be performed by Professional are those
of an independent contractor and not of an employee of the City of Fort Collins. The City shall
not be responsible for withholding any portion of Professional's compensation hereunder for the
payment of FICA, Workers' Compensation, other taxes or benefits or for any other purpose.
11. Personal Services. It is understood that the City enters into this Agreement
based on the special abilities of the Professional and that this Agreement shall be considered as
an agreement for personal services. Accordingly, the Professional shall neither assign any
responsibilities nor delegate any duties arising under this Agreement without the prior written
consent of the City.
12. Acceptance Not Waiver. The City's approval of drawings, designs, plans,
specifications, reports, and incidental work or materials furnished hereunder shall not in any way
relieve the Professional of responsibility for the quality or technical accuracy of the work. The
City's approval or acceptance of, or payment for, any of the services shall not be construed to
operate as a waiver of any rights or benefits provided to the City under this Agreement.
13. Default. Each and every term and condition hereof shall be deemed to be a
material element of this Agreement. In the event either party should fail or refuse to perform
according to the terms of this agreement; such party may be declared in default.
14. Remedies. In the event a party has been declared in default, such defaulting
party shall be allowed a period of ten (10) days within which to cure said default. In the event
the default remains uncorrected, the party declaring default may elect to (a) terminate the
Page 15
Agreement and seek damages; (b) treat the Agreement as continuing and require specific
performance; or (c) avail himself of any other remedy at law or equity. If the non -defaulting
party commences legal or equitable actions against the defaulting party, the defaulting party
shall be liable to the non -defaulting party for the non -defaulting party's reasonable attorney fees
and costs incurred because of the default.
15. Binding Effect. This writing, together with the exhibits hereto, constitutes the
entire agreement between the parties and shall be binding upon said parties, their officers,
employees, agents and assigns and shall inure to the benefit of the respective survivors, heirs,
personal representatives; successors and assigns of said parties.
16. Law/Severability. The laws of the State of Colorado shall govern the
construction, interpretation, execution and enforcement of this Agreement. In the event any
provision of this Agreement shall be held invalid or unenforceable by any court of competent
jurisdiction, such holding shall not invalidate or render unenforceable any other provision of this
Agreement.
17. Special Provisions. [Optional] Special provisions or conditions relating to the
services to be performed pursuant to this Agreement are set forth in Exhibit "_", consisting of
( ) page[s], attached hereto and incorporated herein by this reference.
Page 16
THE CITY OF FORT COLLINS, COLORADO
By:
John F. Fischbach
City Manager
By:
James B. O'Neill II, CPPO, FNIGP
Director of Purchasing & Risk Management
DATE:
ATTEST:
Clerk
APPROVED AS TO FORM:
Assistant City Attorney
[Insert Professional's name] or
[Insert Partnership Name] or
[Insert individual's name]
Doing business as _[insert name of business]
0
Title:
CORPORATE PRESIDENT OR VICE PRESIDENT
Date:
ATTEST:
(Corporate Seal)
Corporate Secretary
Page 17
City of Fort Collins
Administrative Services
Purchasing Division
CITY OF FORT COLLINS
ADDENDUM No. 1
RFP P-858
DATA BASE MANAGEMENT TOOL
SPECIFICATIONS AND CONTRACT DOCUMENTS
Description of Bid PROPOSAL P-858 DATA BASE MANAGEMENT TOOL
OPENING DATE: 2:00 p.m. (our clock) September 13, 2002
To all prospective bidders under the specifications and contract documents described above, the
following responses are issued in response to questions from vendors.
If the City of Fort Collins prepayed maintenance cost through 2005 how much would you
discount our maintenance fees?
If this is an option please give price quote for prepaying maintenance through 2005.
Price quotes
Data Base Management Tool
Data Base Management Tool
with discount for prepayed maintenance through 2005.
If you have any questions please contact: Keith I. Ashby, CPPO, Buyer, at (970) 416-2191.
RECEIPT OF THIS ADDENDUM MUST BE ACKNOWLEDGED BY A WRITTEN STATEMENT
ENCLOSED WITH THE BID/QUOTE STATING THAT THIS ADDENDUM HAS BEEN RECEIVED.
215 North Mason Street • 2nd Floor • F.O. Box 580 • Fort Collins, CO 80522-0580 • (970) 221-6775 • FAX (970) 221-6707
Citv of Fort Collins
Administrative Services
Purchasing Division
CITY OF FORT COLLINS
ADDENDUM No. 2
RFP P-858
DATA BASE MANAGEMENT TOOL
SPECIFICATIONS AND CONTRACT DOCUMENTS
Description of Bid PROPOSAL P-858 DATA BASE MANAGEMENT TOOL
OPENING DATE: 2:00 p.m. (our clock) September 13, 2002
To all prospective bidders under the specifications and contract documents described above, the
following responses are issued in response to questions from vendors.
If the City of Fort Collins prepayed maintenance cost through 2005 how much would you
discount our maintenance fees?
If this is an option please give price quote for prepaying maintenance through 2005.
Price quotes
Data Base Management Tool Maintenance cost
Data Base Management Tool Maintenance cost
with discount for pre payment of maintenance cost through 2005.
If you have any questions please contact: Keith I. Ashby, CPPO, Buyer, at (970) 416-2191.
RECEIPT OF THIS ADDENDUM MUST BE ACKNOWLEDGED BY A WRITTEN STATEMENT
ENCLOSED WITH THE BID/QUOTE STATING THAT THIS ADDENDUM HAS BEEN RECEIVED.
215 North Mason Street • 2nd Floor • P.O. Box 580 • Fort Collins, CO 80522-0580 • (970) 221-6775 • FAX (970) 221-6707
SCOPE OF WORK
Database Management Tool
City of Fort Collins Database Environment
Please use the following information for pricing and providing information to the RFP.
• Production Databases
Four Oracle 8.1.6 — 9i databases on separate HP-UX servers
Two Oracle 7.3 databases on separate NT servers
Four Microsoft SQL Server databases on NT, Two databases are on separate NT servers and two share an NT
server.
• Production Hardware
Four HP-UX servers with either one or two CPUs each
Five NT servers with one CPU each
• Test Databases
Three Oracle 8.1.6 databases on one HP-UX server
One Oracle 8.1.7 database on one NT server
One Microsoft SQL Server database on NT
• Test Hardware
One HP-UX server with one CPU
Two NT servers with one CPU each
Company History and References
Please provide a brief company history and a list of 5 references, preferably from the public sector, that use your database
management tool products and support.
For each question, indicate 'Yes/No, which product in your product set performs each function,
and any additional comments.
Y/ Product Response/Comment
N Name(s)
1. Features/Functions
1.1. Monitorina
1.1.1. Can your
1.1.1.2.
Number of transactions per second
1.1.1.3.
Number of transactions committed
1.1.1.4.
Number of queries executed
1.1.1.5.
Number of changes to the redo log
file
1.1.1.6.
Used database file space below a
user -defined threshold
1.1.1.7.
Operating system disks ace free
1.1.1.8.
Operating system disks ace used
1.1.1.9.
Number of active users
1.1.1.10.
Number of inactive users
1.1.1.11.
Caches
1.1.1.12.
SGA for Oracle
1.1.1.13.
Identification of alert loa errors
1.2.
1.2.1. Can your product
1.2.1.1. Delays caused by redo log space
1.2.1.2. Locks blocking other sessions,
indicating tables and users
No Text
Y/ Product Response/Comment
N Name(s)
1.4.1.5. System privilege management
1.4.1.6. Object privilege management
1.4.1.7. Session initialization parameter
1.4.1.8. System initialization parameter
1.4.2. Does your product provide a prioritized list of
issues that needs to be addressed?
1.5. SQL Analysis
1.5.1. Can your product provide recommended
solutions for the following issues?
1.5.1.1. Bad SQL Queries
1.5.1.2. Indexing recommendations based on
1.5.1.3. Inappropriately sized SGA
1.5.2. Can your product move data?
1.5.2.1. Import data into a table
1.5.2.2. Export data from a table
1.5.2.3. Data conversion
1.6. Data Collection
1.6.1. Please provide a list of data collected by
your tool. (Real-time collection, store
historical data, trending, etc.
1.6.2. Can your product capture statistics by
Operating System for users no longer
connected to the database? Scenario: All
OneWorld application users connect to the
database using the same Oracle user id, a
user logs into OneWorld, submits a batch job
to process on the server, then logs out of
How does your product display monitored
information (Graphically, through a report,
1.6.4. Does your product capture historical
.7.1. Does your product integrate with any
chartinq or workflow tools like Visio?
PUSQL Tool
1.8.1. Does your pro
1.8.1.1. Create
1.8.1.2. Create
1.8.1.3. Create
have a tool for
DDL
1.9.1. Can your product schedule and maintain
scripts to perform the following?
1.9.1.1. Database maintenance
1.9.1.2. Database monitoring
1.9.2. Can scripts be created automatic
problem is found? If so, please i
1.9.2.1. In what language are the
written?
1.10. Notification
1.10.1. Can your product send an a-mai
to an issue?
1.10.2. Can your product send a page it
to an issue?
a
response
response
Y/ Product Response/Comment
N Name(s)
Y/ Product Response/Comment
N Name s
1.10.3. How is notification setup?
1.10.4. Does your product integrate with e-mail?
1.10.5. NT
1.10.5.1. Integrate/Utilize Groupwise Client
MAPI ?
1.10.6. Unix
1.10.6.1. Support SMTP and use MIME
encoding?
_..
1.11. Batch Scheduling
1.11.1. Does your product provide batch scheduling
to run scripts to perform monitoring,
maintenance and management?
1.11.2. Does your product interact at the O.S. level
i.e. crontab ?
1.11.3. Is your product able to alter the status of the
database to perform scripts that need
exclusive access?
1.12. Security
1.12.1. Does your product provide a method of
allowing users to view information only
versus allowing other uses to run scripts and
make changes?
2. Architecture/Technology
2.1. Does your tool support the following combinations C-1
of OS and DBMS?
2.1.1. HP-UX - Oracle 9i, Oracle 8i
2.1.2. NT — Oracle 8i, Oracle 7
2.1.3. NT — SQL Server 7, SQL Server 2000
2.1.4. Linux — Oracle 9i
Y/ Product Response/Comment
N Name(s)
2.2. What other platforms do you plan to support in the
future?
2.3. If your company does not have a product that
currently supports SQL Server, is oneplanned?
2.3.1. If so, what is the release date?
2.4. Does your tool utilize TCP/IP as the network
protocol?
2.5. Is your monitor web based?
2.5.1. Does it support client access via Internet
Explorer 5 and above?
2.5.2. What web server is supported?
2.6. Does your product require a separate server?
2.7. Where/how is your repository stored and
maintained?
2.8. What is the frequency of new releases? _
2.9. Are scripts accessible outside of the tool suite in
case the tool is inaccessible or experiencing down
time?
2.10. Does your product work via an agent installed on
the server?
2.10.1. What is the performance hit of this agent? _
2.11. What are the minimum system requirements on
the server and on the client?
3. Support
3.1. Please describe your levels of support and the cost
of each. Include description of your telephone
suaoort and Web su000rt.
4. Cost
4.1. Do you have government discounts?
No Text