IFB__14-858.pdf

Matthew Rodriquez Secretary for

Environmental Protection

Air Resources Board Mary D. Nichols, Chair

1001 I Street • P.O. Box 2815 Sacramento, California 95812 • www.arb.ca.gov

Edmund G. Brown Jr.

Governor

INVITATION FOR BID

Notice to Prospective Bidders

IFB No. 14-858

April 20, 2016

You are invited to review and respond to this Invitation for Bid (IFB) No. 14-858, entitled, “MySQL & Oracle Database Training.” In submitting your bid, you must comply with the instructions found herein.

This IFB is published online in the California State Contracts Register (CSCR) at https://caleprocure.ca.gov/pages/index.aspx. To ensure receipt of any addenda that may be issued, interested parties are encouraged to register online at: https://caleprocure.ca.gov.

The Air Resources Board (ARB) deadline for receipt of bids is May 9, 2016, no later than 3:00 p.m. Neither late received, nor faxed or emailed bids are acceptable. All late, faxed, and emailed bids will be rejected and returned to the potential bidder. Sealed bids must be received on or before the date and time specified herein at the following location:

Mailing and Street Address:

Contract Services Section Attn: Jennifer Salinas 1001 I Street, 20th Floor Sacramento, CA 95814

You are advised that you are responsible for ensuring that your bid is received by the above listed contact person by the time and date required. Any bid reaching the contact person after the deadline date and time will be returned unopened.

In the opinion of the ARB, this IFB is complete and without need of explanation. However, if you have questions, notice any discrepancies or inconsistencies, or need any clarifying information, the contact person for this IFB is listed below. All questions must be submitted in accordance with the IFB instructions contained herein and sent via email directly to the below listed contact person and not through the Cal eProcure system.

Contact: Jennifer Salinas Phone: (916) 322-0475 Email:jennifer.salinas@arb.ca.gov

We appreciate your interest in this project and hope to receive a bid from you if this is within your area of expertise.

The energy challenge facing California is real. Every Californian needs to take immediate action to reduce energy consumption. For a list of simple ways you can reduce demand and cut your energy costs, see our website: http://www.arb.ca.gov.

California Environmental Protection Agency

Printed on Recycled Paper http://www.arb.ca.gov/ https://caleprocure.ca.gov/pages/index.aspx https://caleprocure.ca.gov/

TABLE OF CONTENTS

SECTION PAGE

I. SCOPE OF WORK

II. BID INSTRUCTIONS AND INFORMATION

A. IFB Key Action Dates B. Submission of Bid C. Bid Submission Withdrawal D. Bidder Responsibilities E. Minimum Qualifications F. General Requirements G. Bid Rejection H. Signature I. Bid Opening and Evaluation J. Disposition of Bids K. Selection and Award L. Standard Conditions of Service M. Socio-Economic and Preference Programs

DRAFT STANDARD AGREEMENT

Standard Agreement (STD 213) Exhibit A – Scope of Work Exhibit B – Budget Detail and Payment Provisions Exhibit B – Attachment 1 Exhibit D – Special Terms and Conditions Exhibit E – Additional Provisions

ATTACHMENTS

1. Required Attachment Checklist

2. Bid/Bidder Certification Sheet

3. Contractor Cost Sheet

4. Bidder References

5. Payee Data Record (STD 204)

6. Contractor Certification Clauses (CCC 307)

7. Bidder Declaration (GSPD-05-105)

8. DVBE Bid Incentive Instructions

11. Minimum Requirements……………………………………………………………………43

IFB No.14-858

I. SCOPE OF WORK

The Air Resources Board (ARB) Emissions Compliance, Automotive Regulations and Sciences Division (ECARS) is responsible for identifying air pollution from mobile sources, and developing procedures and protocols to evaluate, plan, and formulate measures for control of these sources.

To support these tasks, the Laboratory Data Support Branch of ECARS manages all vehicle and engine-related data produced by emissions testing facilities at ARB. Managing data includes acquiring, organizing and storing data for ARB data users and maintaining data systems that support the division’s goals for enforcement, certification, vehicle testing and laboratory support. This includes providing technical support to data users, maintaining current data systems and developing new systems for ECARS and its clients.

Manufacturers of new motor vehicles, engines and aftermarket parts must be certified or exempted by the California Air Resources Board (ARB) for emission compliance before they are legal for sale, use, or registration in California. The New Vehicle and Engine Programs Branch, of ECARS process manufacturers’ certification applications and exemption applications. Staff requires Oracle MySQL training to extract and generate reports for management decisions, and to maintain the databases containing certification related data as new regulations and work needs arise.

The Office of Information Services, in order to conduct these tasks efficiently, must be knowledgeable in the latest database systems, software development, and coding languages as new technologies emerge to support ARB staff. This contract will provide the training necessary to ensure staff remains current in their skill set in order to create new systems and provide the necessary support for those systems already in existence.

The term of this agreement will be for a one (1) year period. ARB is requesting Oracle Databases and MySQL training for an estimated number of twenty-five (25) ARB staff at various times and locations.

Agreement term shall be from June 1, 2016 through May 31, 2017.

More detailed information can be found in Attachment A, Scope of Work (SOW).

ARB’s budget for this project is $50,000. Bids exceeding this amount shall be deemed non responsive and ineligible for award.

II. BID INSTRUCTIONS AND INFORMATION

This section contains instructions for the organization and timely submission of your bid. It also contains the bid requirements and other important information crucial for submittal of a responsive and responsible bid. It is the responsibility of the bidder to carefully read and follow all bid requirements within this IFB. Compliance with the IFB instructions is mandatory for your bid to be considered for award. Failure to comply with the IFB instructions will cause your bid to be deemed non-compliant and non-responsive, thus, ineligible for award.

Please read and carefully follow the instructions listed in the following sections. The instructions are separated by category, each with its own requirements and necessary information for submission of a timely and responsive bid. All requirements and specifications in the IFB must be responded to, and all requested data must be supplied for a bid to be considered responsive.

A. IFB Key Action Dates

Below is the tentative time schedule for this IFB. The ARB reserves the right to modify the IFB and/or change the date and time at its sole discretion, prior to the date fixed for submission of bids, by the issuance of an addendum to all parties who received a bid package.

1. ARB reserves the right to modify or cancel in whole or part of its solicitation.

2. Clarifications to bid will be given only in the form of addenda to all bidders.

Time Schedule Date Time

IFB Posted on Cal eProcure April 20, 2016 N/A

Deadline for Submission of Written Questions April 25, 2016 5:00 p.m.

Responses to Questions Posted April 28, 2016 5:00 p.m.

Bid Submission Due / Opening of Bids May 9, 2016 3:00 p.m.

Estimated Agreement Start Date June 1, 2016 N/A

Dates listed above are estimates only and subject to change at ARB’s discretion. The estimated start date shall not be considered as the actual start date of the Agreement. No work shall begin until all required approvals and signatures are obtained.

Written questions must be submitted via electronic mail by the date indicated in Section II.B., IFB Key Action Dates. All written questions received prior to the date indicated for the Written Questions Deadline will be answered in the form of an addendum and posted online at https://caleprocure.ca.gov.

Please note that no verbal information given will be binding upon the State unless such information is issued in writing as an official addendum to all parties/participants.

If you have questions or should need any clarifying information, the contact person for this IFB is:

Jennifer Salinas Phone: (916) 322-0475

Email: jennifer.salinas@arb.ca.gov https://caleprocure.ca.gov/

B. Submission of Bid

1. All bids RECEIVED by ARB must be submitted under sealed cover and sent to ARB by the dates and times shown in the time schedule in Section II.B., IFB Key Action Dates. The sealed envelope must be plainly marked “BID” with “DO NOT OPEN” on the front. The IFB number and title must also be prominent. The Envelope must show your firm name and address as shown in the following example:

Proposer Name (Agency, Firm, Individual) Complete Address

IFB 14-858 BID: DO NOT OPEN

Contract Services Section Attn: Jennifer Salinas, Contract Analyst

1001 I Street, 20th Floor

Bids not submitted under sealed cover may be rejected. A minimum of two (2) copies of the bid packet must be submitted. Bidders may not submit multiple Cost Worksheets. Multiple Cost Worksheets from a bidder will cause the bidder’s offer to be rejected.

2. Entire bid package must be received by the date and time as stated in the time schedule in Section

II.B, IFB Key Action Dates. Entire bid package means all pages, documentation, or other required materials. As a convenience the Required Attachment Checklist, Attachment 1, is provided as a guide to aid the bidder in complying with this IFB. Failure to comply with IFB requirements and instructions may cause your bid to be deemed non-responsive, thus, ineligible for award.

3. Time of delivery is of the essence and must be adhered to. Any bid received after the due date and time as outlined in the time schedule in Section II.B., IFB Key Action Dates will be rejected by ARB as not complying with a mandatory requirement of this IFB. NOTE: Postmark time is NOT acceptable.

4. Mail or deliver bids to the following address:

Attn: Jennifer Salinas, Contract Analyst 1001 I Street, 20th Floor

C. Bid Submission Withdrawal

A bidder may modify a bid after its submission by withdrawing its original bid and resubmitting a new bid prior to the bid submission deadline. Bidder modifications offered in any other manner, oral or written, will not be considered.

D. Bidder Responsibilities

1. Before submitting a response to this solicitation, bidders should review, correct all errors, and confirm compliance with the IFB requirements.

2. Costs incurred for developing bids and in anticipation of award of the agreement are entirely the responsibility of the bidder and shall not be charged to ARB. This includes, but is not limited to:

delivery, drayage, express, parcel post, packing, cartage, insurance, license fees, permits, cost of bonds, any and all travel related expenses incurred in the performance of completing the bid for submittal; or for any other purpose unless expressly included and itemized in the bid solicitation.

3. Prior to submission of bid, bidder shall examine any specifications and instructions or other materials required and included in the bid package to ensure that they meet all the requirements stated in this

IFB.

4. It is the Bidder’s responsibility to promptly notify the ARB Contract Analyst identified in the solicitation, by phone, letter, email, or visit, if the bidder believes that the solicitation is unfairly restrictive, contains errors or conflicting language, or needs clarification. Such notification must be submitted no later than 72 hours prior to bid opening date and time. All such correspondence received after the 72 hour deadline will not be considered and deemed ineligible for review and/or response from ARB.

5. Bidder must complete and submit Cost Sheet, Attachment 3. Submission of this attachment is mandatory. Failure to fully complete and return attachment with your bid will cause your bid to be rejected and deemed non-responsive.

6. References must be provided using Bidder References Form, Attachment 4. Submission of this attachment is mandatory. Failure to fully complete and return this attachment with your bid may cause your bid to be rejected and deemed non-responsive.

7. Bidder must complete and submit to ARB, the Payee Data Record (STD 204), Attachment 5, to determine if the selected bidder is subject to State income tax withholding, pursuant to California Revenue and Taxation Code, Section 18662. This form can be found on the Internet at www.osp.dgs.ca.gov under the “forms” link. Contract payment cannot be made unless a completed STD 204 has been returned to ARB.

8. Bidder is responsible for reviewing, reading, understanding, and complying in full with the State’s

General Terms and Conditions along with the Contractor Certification Clauses (CCC) at:

http://www.dgs.ca.gov/ols/Resources/StandardContractLanguage.aspx. The Bidder must sign and return CCCs, Attachment 6.

9. The Bidder must be an individual or firm licensed to do business in California and shall obtain at his/her expense all license(s) and permit(s) required by law for accomplishing any work required in connection with this Agreement.

10. The Bidder must own and operate a legitimate business. If required by law, the Bidder must be registered in the State of California to operate said business in the State and be in good standing with the Secretary of State prior to date of contract award. Evidence of registration shall be submitted with this bid.

http://www.dgs.ca.gov/ols/Resources/StandardContractLanguage.aspx

11. In the event that any license(s) and/or permit(s) expire at any time during the term of this Agreement, bidder agrees to provide agency a copy of the renewed license(s) and/or permit(s) within 30 days following the expiration date. In the event the bidder fails to keep in effect at all times all required license(s) and permit(s), ARB may, in addition to any other remedies it may have, terminate this Agreement upon occurrence of such event.

E. Minimum Qualifications

The Bidder must provide a detailed response, outlining information as to how the Bidder meets each of the minimum qualifications. Bids that do not meet the minimum qualifications will be determined non-responsive and ineligible for award. Bidder must complete and submit Minimum Qualifications Checklist, Attachment 9.

1. Must have a Bachelors or equivalent degree in computer science or related technical field.

2. Must have a minimum of three (3) years of experience teaching Oracle courses to subject matters in a formal setting (i.e., classroom or live virtual class room).

3. Must have at least three (3) years of combined experience with Oracle Databases 11g and 12c.

4. Must have at least two (2) years of work experience with Microsoft Office Suite of Tools (Project, Excel, Word, PowerPoint, Visio, SharePoint).

F. General Requirements

1. Must be certified in Oracle Database.

2. Must be certified in MySQL.

3. Must have excellent verbal and written communication skills.

4. Must have a strong ability to communicate highly technical information in easy to understand non-technical language.

5. Must have a highly technical and good understanding of Oracle products.

6. Must have extensive knowledge of PL/SQL and Oracle database administration.

G. Bid Rejection

1. Bids must be submitted for the performance of all the services described herein. Any deviation from the work specifications will not be considered and will cause a bid to be rejected.

2. Bids must be completed in all respects as required by the IFB. A bid will be rejected if it is conditional or incomplete, or if it contains any alterations of forms or other irregularities of any kind. The State may reject any or all bids and may waive any immaterial deviation in a bid. The State's waiver of immaterial defect shall in no way modify the IFB document or excuse the Bidder from full compliance with all requirements, if awarded the Agreement. A bid must be rejected if any such defect or irregularity constitutes a material deviation from the IFB requirements.

2. ARB reserves the right to reject any or all bids for any reason. The agency is not required to award an agreement. Each bid will be checked in detail to determine its compliance to the IFB requirements. If a bid fails to meet any IFB requirements, ARB will determine if the deviation is material; a material deviation will cause rejection of the bid. A non-material deviation (errors in mathematical computation, spelling, etc.) will be examined to determine when the deviation is acceptable. If accepted, the bid will be processed as if no deviation had occurred.

4. Bids that contain false or misleading statements, or which provide references, which do not support an attribute or condition claimed by the Bidder, will be rejected. If, in the opinion of the State, such information was intended to mislead the State in its evaluation of the bid, and the attribute, condition, or capability is a requirement of this IFB, it will be the basis for rejection of the bid.

5. Bids received past the date and time specified in the table in Section II.B., IFB Key Action Dates, will be deemed non-responsive and rejected. Under no circumstances will any bids be accepted past the date and time stated in the table. All such bids received past the date and time will not be accepted.

H. Signature

1. An individual who is authorized to bind the bidding firm contractually shall sign the Bid/Bidder Certification Sheet, Attachment 2. The signature must indicate the title or position that the individual holds in the firm. An unsigned bid may be rejected.

2. All documents requiring a signature must bear an original signature of a person authorized to bind the bidding firm and must be duly authorized to sign the Agreement if awarded the bid.

I. Bid Opening and Evaluation

1. The bids will be publicly opened and read promptly at the time and place indicated in the IFB, as stated in the table in Section II.B., IFB Key Action Dates.

2. A vendor’s bid must constitute an irrevocable offer for a period of at least ninety (90) days following the scheduled date for contract award and execution.

3. ARB will put each bid through an administrative evaluation process pursuant to the published requirements to determine the Bidder’s responsiveness to the IFB.

J. Disposition of Bids

Upon bid opening, all original documents submitted in response to this IFB will become the property of the State of California and ARB, and will be regarded as public records under the California Public Records Act (Government Code Section 6250 et seq.).

K. Selection and Award

1. Award, if made, will be to the lowest responsive, responsible bidder.

2. Whenever an agreement is awarded under a procedure which provides for competitive bidding, but the agreement is not to be awarded to the low bidder, the low bidder shall be notified by facsimile transmission, overnight courier, or personal delivery five (5) working days prior to the award of the agreement.

3. Bidders may protest the proposed award(s) by filing a notice of protest with the ARB and the DGS, Office of Legal Services. The Agreement(s) shall not be awarded until either the protest has been withdrawn or the State has decided the matter.

4. Protest notices should contain full contact information, including a fax number, and must be filed with:

Attention: Manager 1001 I Street, 20th Floor Sacramento, CA 95814 Phone Number: (916) 445-4845 Fax Number: (916) 327-2940

Department of General Services Office of Legal Services Attention: Protest Coordinator 707 Third Street, 7th Floor, Suite 7-330 West Sacramento, CA 95605 Phone Number: (916) 376-5080 Fax Number: (916) 376-5088

5. Within five (5) calendar days after filing the protest notice, the protesting Bidder shall file with DGS, Office of Legal Services and the Air Resources Board a detailed written statement specifying the grounds for the protest.

6. Proposed contractor will receive a fully executed Agreement with all necessary terms and conditions and exhibits/attachments. Proposed contractor should carefully read the entire Agreement and be sure to sign Agreement and all required documents.

7. Such award, if made, will be made within sixty (60) days after opening of bids, if not sooner. The

Agreement shall be signed by Bidder and returned within ten (10) working days of receipt. If lowest responsive, responsible bidder refuses or fails to execute the Agreement, ARB may award the agreement to the next lowest responsive, responsible bidder.

The Agreement shall not be awarded until either the protest has been withdrawn or the State has decided the matter.

L. Standard Conditions of Service

1. Services shall be available on the express date set by ARB and the Contractor, after all approvals have been obtained and the Agreement is fully executed. Should the Contractor fail to commence work at the agreed upon time, the awarding agency, upon five (5) days written notice to the Contractor, reserves the right to terminate the Agreement. In addition, the Contractor shall be liable to the State for the difference between contractor's bid price and the actual cost of performing work by the second lowest bidder or by another contractor.

2. All performance under the Agreement shall be completed on or before the termination date of the

Agreement.

3. The State does not accept alternate contract language from a prospective contractor. A bid with such language will be considered a counter proposal and will be rejected. The State’s General Terms and Conditions (GTC) and Contractor Certification Clauses (CCC) are not negotiable. The GTC and CCCs are included in the sample Agreement attached to this package and may also be viewed at the Internet site: www.dgs.ca.gov/ols under Standard Contract Language.

4. The State does not negotiate rates and/or costs listed on any bid submitted.

5. No oral understanding or agreement shall be binding on either party. Any changes or alterations to the Agreement must be in writing and approved by both parties and/or Department of General Services’ Office of Legal Services, if required.

http://www.dgs.ca.gov/ols

M. Socio-Economic and Preference Programs

1. Disabled Veteran Business Enterprise (DVBE) Incentive (Optional)

a. This solicitation does not require a minimum amount of Disabled Veteran Business Enterprises (DVBE) participation. However, you are strongly encouraged to either become certified, if eligible, or to subcontract a portion of the work to a certified DVBE.

If a prime bidder is a certified DVBE or commits to subcontracting with DVBE(s), it may be eligible to receive an incentive provided that the DVBE provides a commercially useful function as defined in California Code of Regulations, Title 2, Section 1896.61(l). For evaluation purposes only, the State shall apply an incentive to bids that propose California certified DVBE participation as identified on the Bidder Declaration (GSPD-05-105), Attachment 7, and confirmed by the State.

The incentive amount in the table below varies in conjunction with the percentage of DVBE participation in accordance with “California Disabled Veteran Business Enterprise (DVBE) Bid Incentive Instructions,” Attachment 8.

Confirmed DVBE Participation of: DVBE Incentive:

5% or Over 5% 4% to 4.99% inclusive 4% 3% to 3.99% inclusive 3% 2% to 2.99% inclusive 2% 1% to 1.99% inclusive 1%

2. Small Business or Microbusiness Preference (Optional)

a. If Bidder is claiming the 5% certified Small Business or micro business preference, or is committing to subcontract 25% or more of their net bid price to one of more Certified Small Businesses or microbusinesses, complete Bidder Declaration (GSPD-05-105), Attachment 7, and attach a copy of the certification.

Additional References: http://www.pd.dgs.ca.gov

Questions regarding the certification approval process or the Small Business program should be directed to the Department of General Services, Procurement Division at (800) 559-5529 or

(916) 375-4940. For the 24-Hour Recording & Mail Request call (916) 322-5060.

Small business or micro business bidders or proposers using the non-small business preference shall be granted a preference consisting of 5% of the bid price of the lowest responsive, responsible bidder that is not a small business.

http://www.pd.dgs.ca.gov/

STATE OF CALIFORNIA

STANDARD AGREEMENT

STD 213 (Rev 6/03)

REGISTRATION NUMBER

PURCHASING AUTHORITY NUMBER AGREEMENT NUMBER

ARB-3900

1. This Agreement is entered into between the State Agency and Contractor named below:

STATE AGENCY’S NAME

Air Resources Board (ARB)

CONTRACTOR’S NAME

2. The term of this

Agreement is

3. The maximum amount of this Agreement is:

4. The parties agree to comply with the terms and conditions of the following attachments which are by this reference made a part of the Agreement:

Exhibit A – Scope of Work 2 pages

Exhibit B – Budget Detail & Payment Provisions 1 page

Exhibit C* – General Provisions - GSPD-401IT (9/5/14) Online

Items shown with an asterisk (*), are hereby incorporated by reference and made part of this Agreement as if attached hereto.

These documents can be viewed at http://www.documents.dgs.ca.gov/pd/poliproc/GSPD401IT14_0905.pdf

IN WITNESS WHEREOF, this Agreement has been executed by the parties hereto.

CONTRACTOR

CALIFORNIA

Department of General Services Use Only CONTRACTOR’S NAME (If other than an individual, state whether a corporation, partnership, etc.)

BY (Authorized Signature) DATE SIGNED

PRINTED NAME AND TITLE OF PERSON SIGNING

ADDRESS

STATE OF CALIFORNIA

AGENCY NAME

AIR RESOURCES BOARD

BY (Authorized Signature) DATE SIGNED

PRINTED NAME AND TITLE OF PERSON SIGNING

Exempt per

IT Services Purchasing Authority No.

ARB-3900

Pam Biggins, Chief, Budgets, Contracts and Grants Branch

ADDRESS

1001 I Street, 20th Floor, Sacramento, CA 95814

STANDARD AGREEMENT

FOR I.T. GOODS/SERVICES ONLY

EXHIBIT A

SCOPE OF WORK

A. Background and Purpose The Air Resources Board (ARB) Emissions Compliance, Automotive Regulations and Sciences Division (ECARS) is responsible for identifying air pollution from mobile sources, and developing procedures and protocols to evaluate, plan, and formulate measures for control of these sources.

To support these tasks, the Laboratory Data Support Branch of ECARS manages all vehicle and engine-related data produced by emissions testing facilities at ARB. Managing data includes acquiring, organizing and storing data for ARB data users and maintaining data systems that support the division’s goals for enforcement, certification, vehicle testing and laboratory support.

This includes providing technical support to data users, maintaining current data systems and developing new systems for ECARS and its clients.

Manufacturers of new motor vehicles, engines and aftermarket parts must be certified or exempted by the California Air Resources Board (ARB) for emission compliance before they are legal for sale, use, or registration in California. The New Vehicle and Engine Programs Branch, of ECARS process manufacturers’ certification applications and exemption applications. Staff requires MySQL training to extract and generate reports for management decisions, and to maintain the databases containing certification related data as new regulations and work needs arise.

The Office of Information Services, in order to conduct these tasks efficiently, must be knowledgeable in the latest database systems, software development, and coding languages as new technologies emerge to support ARB staff. This contract will provide the training necessary to ensure staff remains current in their skill set in order to create new systems and provide the necessary support for those systems already in existence.

B. Service Delivery

1. Contractor will provide instruction on Oracle Databases and MySQL courses as indicated in the Scope of Work. The training shall include examples and labs with hands on practice. The Contractor shall include a syllabus of each course.

2. Contractor shall provide all requested training to commence within thirty (30) days of the executed Agreement. Actual dates for training shall be arranged by ARB Training Unit (ARB/TU) and Contractor during the term of the Agreement.

3. All services will be provided during the hours of 8:00 a.m. to 5:00 p.m., Monday through Friday, excluding State of California holidays, as per the California Department of Human Resources.

4. The services shall be performed at the Contractor’s facilities located in (Contractor’s office location – TBD). Contractor’s facilities must be located within the Greater Sacramento and Los Angeles areas.

5. The Contractor must be able to provide both in-class training at the Contractor’s facility AND live virtual class training. Students will get to select their preferred method of training when they sign-up through ARB/TU.

C. Contractor Tasks and Responsibilities

Task 1 – Oracle Database and MySQL training

Contractor will provide training for Oracle Databases and MySQL, training will include the following:

1. Contractor shall ensure that course materials presented will cover all information necessary for staff to successfully take and pass MySQL certification exams consistent with the course subject(s).

2. Class size should be limited to twenty-five (25) students.

3. Within ten (10) days of course completion, Contractor shall provide a certificate of completion to ARB staff.

4. All courses, whether live virtual class or in person, that are cancelled by the Contractor due to technology issues, weather, or other unforeseen delays, shall be rescheduled with ARB/TU within thirty (30) days without penalty or additional charge to the State.

5. Contractor shall not charge ARB for live virtual class courses that cannot be broadcast to ARB staff due to technical difficulties, weather, or other unforeseen delays.

6. Contractor shall provide to ARB/TU all technical computer specifications required for web-based training, in order to ensure viewing and instructor interaction, at least two weeks prior to course date.

7. Contractor shall allow ARB staff substitution for all courses, at any time, without penalty or additional charge to ARB.

8. Contractor shall provide ARB/TU with proof of attendance, as indicated by training class sign-in sheet; within ten (10) days of course completion.

9. Contractor shall provide one (1) hard copy set of all training materials to each registered student, for all offsite training. The training materials shall become the property of each student.

10. Contractor shall notify all registered students by e-mail regarding cancellations with a cc: to

ARB/TU at trainprog@arb.ca.gov as soon as possible, and not provide less than 24 hours’ notice.

11. Contractor will give priority access to open spots at future training classes if the Contractor cancels a training class.

Task 2 – Oracle Training Courses

Contractor will provide various Oracle training courses listed below:

1. Oracle Database: SQL Fundamentals:

Understanding single-row functions to customize output, retrieving data using the SQL SELECT statement, restricting and sorting data, using conversion functions and conditional expressions, reporting aggregated data using the group functions, displaying data from multiple tables, using subqueries to solve queries.

mailto:trainprog@arb.ca.gov

2. Oracle Database: Advanced PL/SQL Programming & Tuning:

Exploiting and managing cursor sharing and bind variables to maximize embedded SQL execution performance, obtain the performance benefits that come from employing SQL and PL/SQL result caching, using dynamic SQL to extend the functionality and flexibility of database programs, identifying SQL injection attack vulnerabilities within an application and applying countermeasures to address security risks and protect against hacking.

3. Oracle Database: Administration Workshop I:

Learn to Install and configure the Oracle Database, create and administer user accounts in the Oracle Database, create objects such as table spaces, tables, indexes, materialized views, monitor, troubleshoot, and maintain the Oracle Database, configure Oracle Net services for the Oracle Database.

4. Oracle Database: Administration Workshop II:

Back up and recover a database with RMAN, use flashback technology to view past states of data, use an appropriate and flexible memory configuration for the database, troubleshoot poorly performing SQL, use compression to optimize database storage and duplicate databases.

5. Oracle Database: Performance Tuning DBA:

Learn the right techniques to achieve best performance from the Oracle Database, avoid common myths and pitfalls that slow down the database, diagnose problems when they arise and employ tricks to prevent them, explore various aspects that affect performance, from application design to system tuning.

6. Oracle : PL/SQL Introduction:

Understand the environment and context in which PL/SQL operates, consider the advantages and benefits of PL/SQL within a database environment, declare program variables and complex data types, develop logic within PL/SQL program blocks, fetch data from the database into program variables, return program output to users, handle program exceptions, use explicit and implicit database cursors, maintain and implement triggers.

7. MySQL Developer Techniques with Advanced Stored Procedures:

Develop stored procedures and sample codes. Create a procedure statement, understand stored procedure variables, parameters, return multiple values, and execute a block of SQL code based on conditions.

8. MySQL for Developers with Developer Techniques Accelerated:

Configure and Optimize MySQL, create and manage triggers, create user defined variables, prepared statements and stored routines, create views utilizing SELECT statements to produce virtual tables of specific data, debug MySQL applications, manage the structural characteristics of employee databases and database tables, perform bulk data import and export operations.

9. Fundamentals of Relational Databases using MySQL:

MySQL is a relational database management system, and ships with no graphical user interface tools to administer MySQL databases or manage data contained within the databases. This course shall cover MySQL features. Explain the basics of relational databases and main considerations to design an effective database. Explain MySQL storage engines, database transactions, and metadata. The class shall include command line tools, and MySQL "front-ends" desktop software (Workbench) and web applications to create and manage MySQL databases, build database structures, back-up and restore data, inspect status, and work with data records including different methods to export and import data. Query data and join data from multiple tables, perform nested subqueries, and use built-in MySQL functions.

10. Getting data from MySQL database:

This MySQL training course shall provide students the knowledge to create reports from a MySQL database using SQL queries. This class shall cover how to do conditional SQL processing (IF, IFNULL, NULLIF, Case); use the ROLLUP, ROLLUP with IFNULL, GROUP, and GROUP CONCAT functions; use SQL character, numeric, and date functions, LIMIT clause, SHOW and DESCRIBE statements; Building a Result Set from several sources. Advanced Select with calculated fields, Aggregate Functions, and Grouping, Built-in data manipulation Functions, Subqueries, Joins, Unions. Create views to reuse SELECT statements, and methods to save and export query results.

D. ARB Responsibilities

1. ARB/TU shall ensure employees have the proper equipment to view live virtual class courses, and interact with instructors.

2. ARB will be invoiced for the full amount of training for any request for cancellations received less than fifteen (15) calendar days prior to the start of training.

E. Registration

1. Only ARB/TU is authorized to register, substitute, or cancel ARB staff for training under this Agreement. ARB/TU will notify Contractor via email of ARB/TU staff authorized to register, substitute, or cancel ARB staff for training, upon execution of this Agreement.

2. ARB/TU shall schedule all training courses, via email, with the Contractor, at least fifteen (15) business days in advance.

3. ARB/TU shall provide Contractor with full name, telephone number, and email address for each registered student.

4. Contractor shall email confirmation of registration to each registered student, with a cc: to ARB/TU at trainprog@arb.ca.gov.

5. The cost for all education handouts and other training materials are included in the price of the course.

6. The postage cost for mailing education materials will be included in the price of the course.

7. All training materials for the live virtual class training shall be emailed by the Contractor to each registered student.

mailto:trainprog@arb.ca.gov

F. Deliverable Acceptance Criteria and Other Reporting Requirements

It shall be ARB’s sole determination as to whether a deliverable has been successfully completed and acceptable to ARB. There must be a signed acceptance document for each deliverable before invoices can be processed for payment. Submit Deliverables based on the following guidelines:

1. Document Format: Unless otherwise stated in this contract, all deliverables will be provided in electronic form using Adobe Acrobat PDF format (or version compatible) as appropriate to the deliverable. This applies to word processing documents, spreadsheets, diagrams, presentations, and administrative databases.

2. Attendance Report: Proof of attendance, as indicated by training class sign-in sheet, including the date and time of training, and name of course.

G. Conflict of Interest

1. The Contractor must ensure that no conflicts of interest exist between the services required under this Agreement and services provided by the Contractor to other clients or the Contractor’s other business operations.

2. The Contractor must not have any financial interests in the outcome of any services it provides as a service provider under this contract except for fees for service under this contract.

3. The Contractor must have in place formal policies and procedures to identify and mitigate conflicts of interest and ensure that the Contractor’s organization, management and employees avoid financial interests and activities that potentially create conflicts of interest.

4. The Contractor must ensure that its employees and subcontractors meet and comply with the requirements described above.

Notwithstanding the foregoing, ARB reserves the right to determine, at its sole discretion, whether information received from any source indicates the existence of an actual or potential conflict of interest. If ARB determines that a conflict of interest exists, or that there is an unavoidable appearance of a conflict of interest, that cannot be resolved to the satisfaction of ARB, such determination shall be grounds for termination of the Agreement immediately.

H. CONTRACT REPRESENTATIVES

The Project Managers during the term of this Agreement shall be:

Agency: ARB Contractor:

Division: Section:

Attention: Attention:

Address:

Address:

Phone: Phone:

Email:

Direct all inquiries to the Project Managers.

The parties may change their Contract Representative(s) upon providing ten (10) days written notice to the other party’s Contract Representative(s). The notifying party shall provide complete contact information for the replacement Contract Representative(s) to include the information provided above.

EXHIBIT B

BUDGET DETAIL AND PAYMENT PROVISIONS

A. Invoicing and Payment

1. Invoices will be submitted to ARB within the first fifteen (15) calendar days following completion of course. Each invoice shall contain a breakdown summary including the Course Name, Course Description, Course Rate and the total amount due for the billing period. A signed certification by an authorized Contractor owner/representative on company letterhead must be submitted with the invoice attesting to the accuracy of the data in the invoice.

2. Final billing for services must be received by ARB within ninety (90) days following the end of the contract.

3. For services satisfactorily rendered, and upon receipt and approval of the invoice(s) for each completed task and deliverable, the State agrees to compensate the Contractor in accordance with the detailed budget and rates specified in the attached Exhibit B, Attachment 1 – Contractor’s Cost Sheet.

4. Contractor shall submit one (1) original and one (1) copy of each invoice. Invoices must include the Agreement Number and must be submitted not more frequently than monthly in arrears to:

Air Resources Board Accounting Section

P.O. Box 1436 Sacramento, California 95812

B. Budget Contingency Clause

1. It is mutually agreed that if the Budget Act of the current year and/or any subsequent years covered under this Agreement does not appropriate sufficient funds for the program, this Agreement shall be of no further force and effect. In this event, the State shall have no liability to pay any funds whatsoever to Contractor or to furnish any other considerations under this Agreement and Contractor shall not be obligated to perform any provisions of this Agreement.

2. If funding for any fiscal year is reduced or deleted by the Budget Act for purposes of this program, the State shall have the option to either cancel this Agreement with no liability occurring to the State, or offer an agreement amendment to Contractor to reflect the reduced amount.

C. Prompt Payment Clause

Payment will be made in accordance with, and within the time specified in, Government Code Chapter 4.5, commencing with Section 927.

D. Travel

No travel shall be covered by this contract.

EXHIBIT B, ATTACHMENT 1

CONTRACTOR COST SHEET

Rates listed in Attachment 3, Contractor Cost Sheet, will be included in the final Agreement.

EXHIBIT D

SPECIAL TERMS AND CONDITIONS

A. Excise Tax

The State of California is exempt from federal excise taxes, and no payment will be made for any taxes levied on employees’ wages. The State will pay for any applicable State of California, local sales, or use taxes on the services rendered or equipment or parts supplied pursuant to this Agreement. California may pay any applicable sales and use tax imposed by another state.

B. Settlement of Disputes

1. In the event of a dispute, Contractor shall file a “Notice of Dispute” with ARB within ten (10) days of discovery of the problem. Within ten (10) days, the ARB shall meet with the Contractor and Project Manager for purposes of resolving the dispute.

2. Any dispute concerning a question of fact arising under the terms of this Agreement which is not disposed of within a reasonable period of time by Contractor and State employees normally responsible for the administration of this Agreement shall be brought to the attention of the Executive Officer or designated representative of each organization for resolution. The decision of the State Executive Officer or designated representative shall be final.

3. In the event of a dispute, the language contained within this Agreement shall prevail over any other language.

4. The existence of a dispute not fully resolved shall not delay Contractor to continue with the responsibilities under this Agreement which is not affected by the dispute.

C. Potential Subcontractors

Nothing contained in this Agreement or otherwise, shall create any contractual relation between the State and any subcontractors, and no subcontract shall relieve the Contractor of his responsibilities and obligations hereunder. The Contractor agrees to be responsible to the State for the acts and omissions of its subcontractors and of persons either directly or indirectly employed by any of them as it is for the acts and omissions of persons directly employed by the Contractor. The Contractor’s obligation to pay its subcontractors is an independent obligation from the State’s obligation to make payments to the Contractor. As a result, the State shall have no obligation to pay or to enforce the payment of any moneys to any subcontractor.

D. Stop Work Order

State reserves the right to issue an order to stop work in the event that a dispute should arise, or in the event that State gives Contractor a notice that the Agreement will be terminated. The stop work order will be in effect until the dispute has been resolved or the Agreement has been terminated.

E. Termination

1. In addition to the rights under Exhibit C of the Standard Agreement, State reserves the right to terminate this Agreement at its sole discretion at any time upon thirty (30) days prior written notice to Contractor.

2. In the case of early termination, Contractor shall submit one (1) original and one (1) copy of the invoice covering services to termination date, following the invoice requirements of this Agreement. A copy and description of any data collected up to termination date shall also be provided to State.

3. Upon receipt of the invoice, progress report, and data, a final payment will be made to Contractor. This payment shall be for all State-approved costs that in the opinion of State are justified, and shall include labor, and materials purchased or utilized (including all non-cancellable commitments) to termination date, and pro rata indirect costs as specified in the proposal budget.

F. Amendments

1. No amendment or variation of the terms of this Agreement shall be valid unless made in writing, signed by the parties, and approved as required. No oral understanding or agreement not incorporated in this Agreement is binding on any of the parties.

2. ARB reserves the right to amend this Agreement through a formal written amendment, signed by the parties, for additional time and/or funding.

G. Insurance Requirements

1. Commercial General Liability

Contractor must furnish to the State a certificate of insurance to remain in effect at all times during the term of this Agreement. Contractor shall maintain general liability on an occurrence form with limits not less than $1,000,000 per occurrence for bodily injury and property damage liability combined with a $2,000,000 annual policy aggregate. The policy must include coverage for liabilities arising out of premises operations, independent contractors, products, completed operations, personal & advertising injury, and liability assumed under an insured contract. This insurance shall apply separately to each insured against whom claim is made or suit is brought subject to the Contractor’s limit of liability. The policy must include:

California Environmental Protection Agency/Air Resources Board, State of California, its officers, agents, and employees are included as additional insured, but only with respect to work performed under this Agreement.

This endorsement must be supplied under a form acceptable to the Office of Risk and Insurance Management.

In the case of Contractor’s utilization of subcontractors to complete the contracted scope of work, Contractors shall include all subcontractors as insured under Contractor’s insurance or supply evidence of insurance to the State equal to policies, coverage and limits required of Contractor.

2. Automobile Liability

Contractor must furnish to the State a certificate of insurance to remain in effect at all times during the term of this Agreement. Contractor shall maintain motor vehicle liability with limits not less than $1,000,000 combined single limit per accident. Such insurance shall cover liability arising out of a motor vehicle including owned, hired and non-owned motor vehicles.

The policy must include:

California Environmental Protection Agency/Air Resources Board, State of California, its officers, agents, and employees are included as additional insured, but only with respect to work performed under this Agreement.

3. Workers’ Compensation and Employers’ Liability

Contractor must furnish to the State a certificate of insurance to remain in effect at all times during the term of this Agreement. Contractor shall maintain statutory workers’ compensation and employers’ liability for all its employees who will be engaged in the performance of the Agreement. Employers’ liability limits of $1,000,000 are required. The policy must include:

When work is performed on State owned or controlled property the Workers’ Compensation policy shall contain a waiver of subrogation in favor of the State. The waiver of subrogation endorsement shall be provided.

4. General Provisions Applying to all Policies

a. Coverage Term: Coverage needs to be in force for the complete term of the Agreement. If insurance expires during the term of the Agreement, a new certificate must be received by the State at least ten (10) days prior to the expiration of this insurance. Any new insurance must still comply with the original terms of the Agreement.

b. Policy Cancellation or Termination and Notice of Non-Renewal: Contractor shall provide to the State within five (5) business days following receipt by Contractor a copy of any cancellation or non-renewal of insurance required by this Agreement. In the event Contractor fails to keep in effect at all times the specified insurance coverage, the State may, in addition to any other remedies it may have, terminate this Agreement upon the occurrence of such event, subject to the provisions of this Agreement.

c. Deductible: Contractor is responsible for any deductible or self-insured retention contained within their insurance program.

d. Primary Clause: Any required insurance contained in the Agreement shall be primary, and not excess or contributory to any other insurance carried by the State.

e. Insurance Carrier Required Rating: All insurance companies must carry a rating acceptable to the Office of Risk and Insurance Management. If the Contractor is self-insured for a portion or all of its insurance, review of financial information including a letter of credit may be required.

f. Endorsements: Any required endorsement must be physically attached to all requested certificates of insurance and not substituted by referring to such coverage on the certificate of insurance.

g. Inadequate Insurance: Inadequate or lack of insurance does not negate the…