HomeMy WebLinkAboutBATKY HOWELL - CONTRACT - RFP - P927 UNIX AIX DATABASE TRAININGSERVICES AGREEMENT
WORK ORDER TYPE
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 Batky-Howell, LLC, hereinafter referred to as "Service Provider".
WITNESSETH:
In consideration of the mutual covenants and obligations herein expressed, it is agreed by
and between the parties hereto as follows:
1. Services to be Performed.
a. This Agreement shall constitute the basic agreement between the parties for services
for UNIX/AIX Operating Systems, Crystal Reports and Oracle Database Administration Training for
the Combined Regional Information Systems Project (CRISP) as described in the Training
Requirements attached hereto as Exhibit "A", consisting of seven (7) pages, and incorporated
herein by this reference. The conditions set forth herein shall apply to all services performed by
the Service Provider on behalf of the City and particularly described in Work Orders agreed upon
in writing by the parties from time to time. Such Work Orders, a sample of which is attached hereto
as Exhibit "B", consisting of one (1) page, and incorporated herein by this reference, shall include
a description of the services to be performed, the location and time for performance, the amount
of payment, any materials to be supplied by the City and any other special circumstances relating
to the performance of services. No Work Order shall exceed $15,000. The only services
authorized under this agreement are those which are performed after receipt of such Work Order,
except in emergency circumstances where oral work requests may be issued. Oral requests for
emergency actions will be confirmed by issuance of a written Work Order within two (2) working
days.
WOSA 10/97
Advanced UNIX Tools w/AIX Emphasis
Audience: Users, programmers, and system administrators who wish to develop more advanced
skills in UNIX.
Prerequisites: Fundamentals of UNIX.
In this course, users should develop more advanced skills in using UNIX tools. Users should
increase their productivity in UNIX by learning how to create powerful korn shell scripts for
processing text, managing files, and performing other complex tasks.
Time allocated for this curriculum is not to exceed 4 days in length.
Following outline points are considered minimum curriculum to be completed in time allotted:
• ex and vi Options
• A Buffers
• Shell Interaction - Extending vi
• A Macros
• Regular Expressions
• Shell Programming
• Korn Shell Features
• Introduction to sed
• Introduction to awk
• Awk Patterns
• Overview of Perl
WOSA 10/97
UNIX System Administration w/AIX Emphasis
Audience: UNIX administrators and anyone involved with the UNIX System V, Release 4
operating system.
Prerequisites: Fundamentals of UNIX, and some system administration experience
recommended.
Users should learn and practice essential administration tasks. Generic system administration
concepts as well as those related to the AIX OS should be covered.
Time allocated for this curriculum is not to exceed 4 days in length.
Following outline points are considered minimum curriculum to be completed in time allotted:
• Overview of System Administration
• User Administration
• File System Basics
• Advanced File System Concepts
• Disk Management
• Backups
• UNIX Processes
• System Startup and Shutdown
• UNIX System Security
• Performance Monitoring and Tuning
• IP Addressing
• Configuring TCP/IP
• The LP Print Service
• Network Utilities
• Kernel Reconfiguration
• Overview of NIS
WOSA 10/97
Oracle for Application Developers
Audience: Programmers involved in developing database applications using Oracle.
Prerequisites: Experience in a structured programming language such as Perl, C, Cobol or
Java.
This course should build a solid foundation for the new Oracle user. Topics covered should
allow students to become effective Oracle application developers. Users should learn how to
create, retrieve and manipulate data in a relational database using the Structured Query
Language (SQL). Users should be able to used PL/SQL to write triggers and stored procedures
and packages. Course should end with embedded SQL coverage, utilizing the C programming
language for examples.
Time allocated for this curriculum is not to exceed 5 days in length.
Following outline points are considered minimum curriculum to be completed in time allotted:
• Relational Database Concepts
• Analysis and Design
• Relational Database Management Systems
• SQL Queries: The SELECT Statement
• SQL Functions
• Data Manipulation
• Data Definition and Control Statements
• Views and Other Schema Objects
• SQL Queries - Joins
• Advanced Query Techniques
• Triggers
• PL/SQL Syntax and Logic
• Stored Procedures
• Records and Collections
• Exception Handling
• Cursors
• Using Packages
• Creating Packages
• Stored Functions
• Embedded SQL
• Connecting and Selecting
• Transactions and Error Handling
WOSA 10/97
Oracle8i Database Administration
Audience: Non-Oracle8i database administrators, application developers, and system
administrators.
Prerequisites: Oracle for Application Developers. Previous working experience with Oracle is
recommended. A solid understanding of SQL and PL/SQL is required. A base understanding of
the operating system used for class (UNIX or NT) is needed as well.
This course should teach users the fundamental skills required to manage Oracle databases.
Users should learn database administration skills by designing, setting up, configuring, and
managing their own Oracle8i server. By the end of the class, each user should have gone
through the main tasks necessary to manage Oracle8i databases. New Oracle8i features such
as the Oracle8i JVM, locally managed table spaces, partitioned tables, global and local indexes,
index -organized tables, function -based indexes, object -relational features, the large pool and the
Java pool should be covered.
Time allocated for this curriculum is not to exceed 5 days in length.
Following outline points are considered minimum curriculum to be completed in time allotted:
• Oracle Memory Structures and Processes
• Understanding the Oracle8i Server Architecture
• Server Processes and Executing SQL
• Using the Data Dictionary
• Starting and Shutting Down an Oracle Server
• Creating an Oracle Instance and Database
• Managing Table spaces and Data Files
• Managing Tables
• Oracle8i Indexing
• Managing Constraints
• Managing Rollback and Temporary Segments
• Administration of Control and Redo Log Files
• Managing Users and Profiles
• Security Administration
• Advanced Security Features
• Introduction to Partitioning
• Managing Partitioned Objects
• Database Triggers
• Advanced Cost -Based Optimizer Features
• Oracle Utilities and Managing Data
• Oracle8i's JVM Architecture (EJE)
WOSA 10/97
EXHIBIT "B"
WORK ORDER FORM
PURSUANT TO AN AGREEMENT BETWEEN
THE CITY OF FORT COLLINS
AND
DATED:
Work Order Number:
Purchase Order Number:
Project Title:
Commencement Date:
Completion Date:
Maximum Fee: (time and reimbursable direct costs):
Project Description:
Scope of Services:
Acceptance _
User
Service Provider agrees to perform the services
identified above and on the attached forms in
accordance with the terms and conditions
contained herein and in the Services Agreement
between the parties. In the event of a conflict
between or ambiguity in the terms of the Services
Agreement and this work order (including the
attached forms) the Services Agreement shall
control.
Service Provider
By:
Date:
WOSA 10/97
The attached forms consisting of U pages
are hereby accepted and incorporated herein by
this reference, and Notice to Proceed is hereby
given.
City of Fort Collins
By:
Date:
WOSA 10/97
EXHIBIT "C"
Pricing Schedule
Service Provider's bid for all courses listed in the RFP will be based on a simple formula
(depending on class size), starting at $1,700 per day for up to 5 students. The 6`h 71h and 81h
students will cost an additional $100 each per day, but the 9` and 10`h students will not attract
any extra charge.
For example, using the "Fundamentals of Unix" class as guide, the 4-day class for 5 students
would cost $6,800, 7 students would cost $7,600, and 8-10 students would cost $8,000.
Since training classes will be held along the front range of Colorado at location provided by
CRISP in Fort Collins, there will be no travel charges for any Service Provider instructors.
Classes canceled or rescheduled inside fifteen (15) days of the start date may be invoiced at
50% of the class price plus expenses incurred.
WOSA 10/97
EXHIBIT "D"
INSURANCE REQUIREMENTS
1. The Service Provider will provide, from insurance companies acceptable to the City, the
insurance coverage designated hereinafter and pay all costs. Before commencing work
under this bid, the Service Provider shall furnish the City with certificates of insurance
showing the type, amount, class of operations covered, effective dates and date of
expiration of policies, and containing substantially the following statement:
"The insurance evidenced by this Certificate will not be cancelled or materially altered,
except after ten (10) days written notice has been received by the City of Fort Collins."
In case of the breach of any provision of the Insurance Requirements, the City, at its option,
may take out and maintain, at the expense of the Service Provider, such insurance as the
City may deem proper and may deduct the cost of such insurance from any monies which
may be due or become due the Service Provider under this Agreement. The City, its
officers, agents and employees shall be named as additional insureds on the Service
Provider's general liability and automobile liability insurance policies for any claims arising
out of work performed under this Agreement.
2. Insurance coverages shall be as follows:
A. Workers' Compensation & Employer's Liability. The Service Provider shall maintain
during the life of this Agreement for all of the Service Provider's employees engaged
in work performed under this agreement:
1. Workers' Compensation insurance with statutory limits as required by
Colorado law.
2. Employer's Liability insurance with limits of $100,000 per accident, $500,000
disease aggregate, and $100,000 disease each employee.
B. Commercial General & Vehicle Liability. The Service Provider shall maintain during
the life of this Agreement such commercial general liability and automobile liability
insurance as will provide coverage for damage claims of personal injury, including
accidental death, as well as for claims for property damage, which may arise directly
or indirectly from the performance of work under this Agreement. Coverage for
property damage shall be on a "broad form" basis. The amount of insurance for
each coverage, Commercial General and Vehicle, shall not be less than $500,000
combined single limits for bodily injury and property damage.
In the event any work is performed by a subcontractor, the Service Provider shall be responsible
for any liability directly or indirectly arising out of the work performed under this Agreement by a
subcontractor, which liability is not covered by the subcontractor's insurance.
WOSA 10/97
WOSA 10/97
b. The City may, at any time during the term of a particular Work Order and without
invalidating the Agreement, make changes within the general scope of the particular services
assigned and the Service Provider agrees to perform such changed services.
2. Changes in the Work. The City reserves the right to independently bid any services
rather than issuing work to the Service Provider pursuant to this Agreement. Nothing within this
Agreement shall obligate the City to have any particular service performed by the Service Provider.
3. Time of Commencement and Completion of Services. The services to be performed
pursuant to this Agreement shall be initiated as specified by each written Work Order or oral
emergency service request. Oral emergency service requests will be acted upon without waiting
for a written Work Order. Time is of the essence.
4. Contract Period. This Agreement shall commence upon the date of execution
shown on the signature page of this Agreement and shall continue in full force and effect for one
(1) year, unless sooner terminated as herein provided. In addition, at the option of the City, the
Agreement may be extended for an additional period of one (1) year at the rates provided with
written notice to the professional mailed no later than 90 days prior to contract end.
5. Delay. If either party is prevented in whole or in part from performing its obligations
by unforeseeable causes beyond its reasonable control and without is fault or negligence, then the
party so prevented shall be excused from whatever performance is prevented by such cause. To
the extent that the performance is actually prevented, the Service Provider must provide written
notice to the City of such condition within fifteen (15) days from the onset of such condition.
6. Early Termination by City/Notices. 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 Service Provider. Such notice shall be mailed at least fifteen (15) days prior
to the termination date contained in said notice unless otherwise agreed in writing by the parties.
WOSA 10/97
All notices provided under this Agreement shall be effective when mailed, postage prepaid and sent
to the following address:
WOSA 10/97
10. Independent Contractor. It is agreed that in the performance of any services
hereunder, the Service Provider is an independent contractor responsible to the City only as to the
results to be obtained in the particular work assignment and to the extend that the work shall be
done in accordance with the terms, plans and specifications furnished by the City.
11. Personal Services. It is understood that the City enters into the Agreement based
on the special abilities of the Service Provider and that this Agreement shall be considered as an
agreement for personal services. Accordingly, the Service Provider shall neither assign any
responsibilities nor delegate any duties arising under the Agreement without the prior written
consent of the city.
12. Acceptance Not Waiver. 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 under the Agreement or
of any cause of action arising out of the performance of this Agreement.
13. Warranty.
(a) Service Provider warrants that all work performed hereunder shall be
performed with the highest degree of competence and care in accordance
with accepted standards for work of a similar nature.
(b) Unless otherwise provided in the Agreement, all materials and equipment
incorporated into any work shall be new and, where not specified, of the
most suitable grade of their respective kinds for their intended use, and all
workmanship shall be acceptable to City.
(c) Service Provider warrants all equipment, materials, labor and other work,
provided under this Agreement, except City -furnished materials, equipment
and labor, against defects and nonconformances in design, materials and
workmanship/workwomanship for a period beginning with the start of the
work and ending ninety (90) days from completion of the class and after final
acceptance under the Agreement, regardless whether the same were
furnished or performed by Service Provider or by any of its subcontractors
of any tier. Upon receipt of written notice from City of any such defect or
nonconformances, the affected item or part thereof shall be redesigned,
repaired or replaced by Service Provider in a manner and at a time
acceptable to City.
WOSA 10/97
shall provide and maintain insurance coverage naming the City as an additional insured under this
Agreement of the type and with the limits specified within Exhibit "D", consisting of one (1) page,
attached hereto and incorporated herein by this reference. The Service Provider before
commencing services hereunder, shall deliver to the City's Director of Purchasing and Risk
Management, PO Box 580, Fort Collins, Colorado 80522 one copy of a certificate evidencing the
insurance coverage required from an insurance company acceptable to the city.
18. Entire Agreement. This Agreement, along with all Exhibits and other documents
incorporated herein, shall constitute the entire Agreement of the parties. Covenants or
representations not contained in this Agreement shall not be binding on the parties.
19. Law/Severability. This Agreement shall be governed in all respect by the laws of the
State of Colorado. 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.
CITY OF FORT COLLINS, COLORADO
a mu ' ' al corporation
Jame B. "Neillll,PPO
Direc Purchasing and Risk Management
Batky-Howell, LLC
13.47A
PRINT NAME
go-
TftLE
WOSA 10/97
Date: y, -5"- � 00q
ATTEST: (Corporate Sea[)
BY: 2 /70 gyve // L
PRINT NAME
/ ggc1e(°` co - cco
TITL
WOSA 10/97
EXHIBIT "A"
Training Requirements
For
Combined Regional Information Systems Project
Ft Collins/Larimer County, CO
The Combined Regional Information Systems Project (CRISP) has a need to train System
Administrators and other support staff in the use and implementation of Crystal Reports,
UNIX/AIX Operating Systems and Oracle Database Administration.
• All training is to be accomplished in a computer lab environment provided by CRISP in Ft
Collins. Computer lab is set up for up to 10 students with network/internet connectivity.
• It is intended that there will be 6 training sessions to complete all subject curriculums
listed with time off between sessions of 1 to 2 weeks. Training would begin
approximately April, 2004 and be completed no later than September, 2004. Training
dates to be defined by CRISP.
• Class length is expected to be not less than 2 days or more than 5 days, dependant
upon curriculum (see attached outlines). Precise length of class to be determined by
agreement of training contractor and CRISP according to final curriculum (see tailoring
on next line)
• Training contractor must be willing to tailor curriculum for each class to meet specific
needs of CRISP.
• Training hours will be from 8:00 AM to 5:00 PM., Monday through Friday (as defined by
course length).
• Class size will vary between 4 and 10 students, dependant upon the curriculum.
• Training contractor will provide training staff and all training materials.
• Proposers should respond with qualifications to perform this training, costs and
availability.
WOSA 10/97
Basic Crystal Reports
Audience: New Crystal Report users
This workshop should be designed for beginning users with little or no exposure to Crystal
Reports. The intent of the course should be to familiarize the students with the Crystal Reports
environment. The workshop should provide the basic steps for creating, modifying, saving and
viewing reports to more flexible tasks such as basic formulas and the powerful automated
features.
Time allocated for this curriculum is not to exceed 2 days in length.
Following outline points are considered minimum curriculum to be completed in time allotted:
• Creating a Simple Report
• Formatting Features
• Selecting Specific Records from the Database
• Grouping and Sorting Data for Summary Purposes
• Combining Multiple Tables
• Creating and Using Formulas
• Conditional Formatting
• Creating Summary Reports and Charts
• Exporting Report Results Within Your Organization
• Setting Default and Report Options
• Using the Report Wizards
• Mapping
• Creating an ODBC Data Source to Attach to a Database
WOSA 10/97
UNIX Fundamentals w/AIX Emphasis
Audience: End -users and programmers who are new to the UNIX environment.
This course should provide a comprehensive introduction to the full range of UNIX user
commands and utilities. Users should develop shell programming and vi editing skills.
Performance monitoring of a UNIX system should also be covered.
Time allocated for this curriculum is not to exceed 4 days in length.
Following outline points are considered minimum curriculum to be completed in time allotted:
• Getting Started
• The File System - Files
• The File System - Directories
• Editing With vi
• Personal Utilities
• Text Handling Utilities
• File System Security
• File System Management Utilities
• Communication Utilities
• Using the Shell
• Filename Generation
• Introduction to Shell Programming
• UNIX Processes
• Shell Programming Concepts
• Flow Control
• Variables
• Special Variables
• More Flow Control
• Appendix: Korn shell features
WOSA 10/97