Loading...
HomeMy WebLinkAboutRFP - P927 UNIX AIX DATABASE TRAININGAdministrative Services Purchasing Division REQUEST FOR PROPOSAL City of Fort Collins CITY OF FORT COLLINS Proposal Number P927 UNIX, AIX Operating Systems and Oracle Database Administration Training The City of Fort Collins is seeking proposals from qualified professional training firms. Written proposals, six (6) 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 3:00 p.m. (our clock), February 26, 2004. Proposal No. P-927. If delivered, they are to be sent to 215 North Mason Street, 2Id 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 Project Manager, Larry Vail (970) 416-2706. Questions regarding proposals submittal or process should be directed to David M. Carey, Buyer, C. P. M. (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 #30927. 2. Download the Proposal/Bid from the Purchasing Webpage, www.fcqov.com/purchasing. 3. Come by Purchasing at 215 North Mason St., 2"d 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 overthe 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, r� A m O'Neill I�PPO, FNIGP for 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 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? SA 10/01 10 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 , hereinafter referred to as "Service Provider". W ITNESSETH: In consideration of the mutual covenants and obligations herein expressed, it is agreed by and between the parties hereto as follows: 1. Scope of Services. The Service Provider 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 execution of this Agreement. Services shall be completed no laterthan ( ) days following Time is of the essence. Any extensions of the time limit set forth above must be agreed upon in a writing signed by the parties. 4. Contract Period. [Option 11 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 ninety (90) days prior to contract end. SA 10/01 11 4. Contract Period. [Option 2] This Agreement shall commence 200_, and shall continue in full force and effect until , 200_, unless sooner terminated as herein provided. In addition, at the option of the City, the Agreement may be extended for additional one year periods not to exceed _ (_) additional one year periods. Pricing changes shall be negotiated by and agreed to by both parties and may not exceed the Denver - Boulder CPI-U as published by the Colorado State Planning and Budget Office. Written notice of renewal shall be provided to the Service Provider and mailed no later than ninety (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 its 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. [Early Termination clause here as an option. 6. Early Termination by City/Notice. 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 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: City: Service Provider: SA 10/01 12 In the event of early termination by the City, the Service Provider shall be paid for services rendered to the date of termination, subject only to the satisfactory performance of the Service Provider's obligations under this Agreement. Such payment shall be the Service Provider's sole right and remedy for such termination. 7. Contract Sum. The City shall pay the Service provider for the performance of this Contract, subject to additions and deletions provided herein, the sum of Dollars ($ ) [Option Cost Breakdown is attached Exhibit "C"] 8. City Representative. The City will designate, prior to commencement of the work, its representative who shall make, within the scope of his or her authority, all necessary and proper decisions with reference to the services provided under this agreement. All requests concerning this agreement shall be directed to the City Representative. 9. Independent Service provider. The services to be performed by Service Provider are those of an independent service provider and not of an employee of the City of Fort Collins. The City shall not be responsible for withholding any portion of Service Provider's compensation hereunder for the payment of FICA, Workmen's Compensation or other taxes or benefits or for any other purpose. 10. 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. 11. 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 or benefits provided to the City under this Agreement or cause of action arising out of performance of this Agreement. SA 10/01 13 12. 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 twelve (12) months from 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. 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 thereof. 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 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 SA 10/01 14 representatives, successors and assigns of said parties. 16. Indemnity/Insurance. a. The Service Provider agrees to indemnify and save harmless the City, its officers, agents and employees against and from any and all actions, suits, claims, demands or liability of any character whatsoever brought or asserted for injuries to or death of any person or persons, or damages to property arising out of, result from or occurring in connection with the performance of any service hereunder. b. The Service Provider shall take all necessary precautions in performing the work hereunder to prevent injury to persons and property. c. Without limiting any of the Service Provider's obligations hereunder, the Service Provider 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—, consisting of (_) pages[s], 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, P. O. Box 580 Fort Collins, Colorado 80522 one copy of a certificate evidencing the insurance coverage required from an insurance company acceptable to the City. 17. 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. 18. 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. SA 10/01 15 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 March, 2004 and be completed no later than June, 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. 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 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 Advanced UNIX Tools WAIX 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 • vi Buffers • Shell Interaction - Extending vi • vi Macros • Regular Expressions • Shell Programming • Korn Shell Features • Introduction to sed • Introduction to awk • Awk Patterns • Overview of Perl 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 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 PUSQL 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 • PUSQL 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 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) 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 Work Hours favorably 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?