Error! Reference source not found.Error! Reference source not found.Error! Reference source not found.Error! Reference source not found.

clutteredreverandΔιαχείριση Δεδομένων

31 Οκτ 2013 (πριν από 3 χρόνια και 9 μήνες)

108 εμφανίσεις

State of California


Department of Public Health

Request for Offer

IT Services for WIC MIS DB2/DBA M&O



Attachment 2


Cost Data Sheet



Complete the following identifying the associated costs for the proposed contract staff.


CMAS Classification

Hourly
Rate



Hours per Month



Monthly
Rate



Duration



Total

_____________________

(CMAS Classification)

$_________

x

* 167 hours

=

$_________

x

24 Months

=

$_________________

GRAND TOTAL =

$_________________


* Contractor staff may be required to work additional hours each month (up to 5%) above the 167 hours projected per month.

Refer to Sections
Error! Reference source not found.

-

Error! Reference source not found.

and
Error! Reference source
not found.

-

Error! Reference source not found.

for details.







State of California


Department of Public Health

Request for Offer

IT Services for WIC MIS DB2/DBA M&O


Attachment 3


Mandatory Qualifications


Experience

Years of
Experience

Name of Project(s) and
the relevant experience
on the project(s).

List dates of each
engagement.

Reference
Information: Name,
E
-
Mail Address,

Phone Number

1.

Mandatory:

Proposed Candidate
must possess an IBM Database Administrator certification




2.

Mandatory:

Minimum 3 years

of experience as senior database administrator in a centralized
mainframe environment dedicated to supporting and maintaining critical z/OS enterprise
OLTP and reporting databases. This experience must include data content analysis,
performance monitoring
, online real
-
time transaction processing, defining and implementing
backup and recovery processes, defining and implementing database security strategies,
administering DB2 on a z/OS environment used by CICS, MVS batch and .NET web
applications.




2a

M
andatory:
1 Year of the experience listed in #2 must be in a DB2 z/OS v 9 or greater
environment.




3.

Mandatory:

Must have minimum 3 years of experience
performing functions to tune DB2
databases for batch and real
-
time applications.




4.

Mandatory:

Must have minimum 3 years of experience working with MQTs and partitioned
tables.




5.

Mandatory:

Must have minimum 2

years of experience writing advanced SQL queries and
supporting query tools such as QMF for Workstation and query explain tools.




6.

Mandatory:

Minimum
1 year experience in a database administration supporting DB2 UDB
on AIX. This includes maintaining and supporting databases/instances and tables, federated
database configuration and support between AIX and z/OS DB2 databases, troubl
eshooting,
performance monitoring, log reviews, and archiving. All experience must include support of a
database similar in size to the ISIS AIX reporting database.




7.

Mandatory
: Minimum 1

year experience performing database administration support usin
g
DB2 Connect.




8.

Mandatory
:
2 years’ experience performing in a lead position dedicated to mentoring/training
staff on database administration, tools, operations and support.




State of California


Department of Public Health

Request for Offer

IT Services for WIC MIS DB2/DBA M&O


9.

Mandatory:

1 year experience developing and implementing stored procedures using IBM’s
Data Studio




10.

Mandatory:

1 year experience working with JCL, Sync Sort and Batch DB2 utilities.







State of California


Department of Public Health

Request for Offer

IT Services for WIC MIS DB2/DBA M&O


Attachment 3A


Desirable Qualifications


Experience

Years of
Experience

Name of
Project(s) and
the relevant
experience on
the project(s).

List dates of
each
engagement.

Reference
Information: Name,
E
-
Mail Address,

Phone Number

Experience

1.

Desirable
: Experience working with, or as part of a project or program
associated
with the federal and state agencies and departments.




2.

Desirable:

Knowl edge/ex per i enc e wor k i ng wi t h Feder al and St at e WI C pr ogr am.




3.

Desirable:

Experience using the following utilities and toolsets:

MVS




IBM DB2 Administration tools

(e.g. DB2 Admin Tool, Object Compare, DB2
Automation Tool, HP Unload, Automation Tool, Cloning Tool, DB2 Table
Editor, SQL Performance Analyzer, Query Monitor and DB2 Recovery
Expert).



Omegamon Xe Performance Expert for DB2



BMC Log Master



Data Propagator

PC




QMF for Workstation



TOAD for DB2

IBM Data Studio







State of California

Department of Public Healt h


Request for Offer
IT Services for
WIC MIS DB2/DBA M&
O


Attachment 4


Customer Experience Reference Form

(Responding Offeror)



The responding contractor must complete a form for each customer reference. A minimum of three (3) references is required.

Details regarding completing and
submitting this form are found in Section 2.2.5 Part 5


Response to Attachment 4, 4A, 5,
5A


Vendor Reference Form.

Contractor’s Name







Company/Organization (prov iding ref erence)







Contact







Telephone Number

(



)







Fax Number

(



)






Email







Address







City







State




Zip







Project Name







Project Description (limit 500 characters)









Contractor’s Inv olv ement







Project Start Date (mm/dd/y y y y )







Project End Date (mm/dd/y y y y )








Project Dollar Amount

$







Briefly describe the work completed for this customer. The description of the work must be detailed and comprehensive
enough to permit the State to assess the similarity of this work to the work anticipated in the award of the Purchase Order
resulting fro
m this procurement.
(limit 5,000 characters) (you may use a separate page)









State of California

Department of Public Healt h


Request for Offer
IT Services for
WIC MIS DB2/DBA M&
O


Attachment 4A


Customer Experience Reference Form

(Proposed Contract Staff)



The proposed contract staff must complete a form for each customer reference. A minimum of three (3) references is
required.

Details regarding completing and submitting this form are found in Section 2.2.5 Part 5


oesponse to Attachment 4I 4AI 5I
5A



ndor oeference corm.

Contractor’s Name







Company/Organization (prov iding ref erence)







Contact







Telephone Number

(



)







Fax Number

(



)






Email







Address







City







State




Zip







Project Name







Project Description (limit 500 characters)









Contractor’s Inv olv ement







Project Start Date (mm/dd/y y y y )







Project End Date (mm/dd/y y y y )








Project Dollar Amount

$







Briefly describe the work completed for this customer. The description of the work must be detailed and comprehensive
enough to permit the State to assess the similarity of this work to the work anticipated in the award of the Purchase Order
resulting fro
m this procurement.
(limit 5,000 characters) (you may use a separate page)









State of California

Department of Public Healt h


Request for Offer
IT Services for
WIC MIS DB2/DBA M&
O


Attachment 5


Customer Experience Reference
Rating
Form

(Proposed Offeror)


To Responding Contractor:
This form must be completed for three (3) customer references identified on Attachment 4,
Customer
Experience Reference Form
,

and included in your response package. Do not
submit

more than three (3) completed Reference Rating
Forms.

Name of
Company/Organization (Responding Contractor)






To Customer Reference:

Pl ease compl ete,
si gn and date thi s form. Return i t to the Company/Organi zati on from whom you
recei ved i t. Your responses wi l l be consi dered i n our overal l assessment of thi s Responding Contractor for a Cal i forni a Depa
rtment of
Publ i c Heal th
Purchase Order procurement
.

Company/Organizat ion (Cust omer)







Address







St at e




Zip







Name of Person
Complet ing Ref erence Response







Telephone Number

(



)






Email







Project Name






Project St art Dat e (mm/dd/y y y y )







Project End Dat e (mm/dd/y y y y )








Project Dollar Amount

$







Brief Project Descript ion (limit 500 charact ers)

and y our rat ing of t he work perf ormance.



















Signat ure of Person Complet ing Ref erence Response

Dat e (mm/dd/y y y y )













State of California

Department of Public Healt h


Request for Offer
IT Services for
WIC MIS DB2/DBA M&
O


Attachment 5A


Reference Rating Form

(Proposed Contract Staff)


To Proposed Contract Staff:
This form must be completed for three (3) customer references identified on Attachment 4A,
Customer
Experience Reference Form
. Do not submit more than three (3) completed Reference Rating Forms.

Name of Company/Organization (Responding Contractor)






To Customer Reference:

Pl ease compl ete
,
sign and date this form. Return it to the Company/Organization from whom you
received it. Your responses will be considered in our overall assessment
of this Responding Contractor for a California Department of
Public Health Purchase Order procurement.

Company/Organization (Customer)







Address







State




Zip







Name of Person
Completing Ref erence Response







Telephone Number

(



)






Email







Project Name






Project Start Date (mm/dd/yyyy)







Project End Date (mm/dd/yyyy)








Project Dollar Amount

$







Brief Project Description (limit 500 characters)































Signature of Person Completing Ref erence Response

Date (mm/dd/yyyy)







State of California

Department of Public Healt h


Request for Offer
IT Services for
WIC MIS DB2/DBA M&
O


Attachment 6


Confidentiality Statement




As an authorized representative and/or corporate officer of the company named below, I warrant my company and its
employees will not disclose any
documents, diagrams, information and information storage media made available to us
by the State and marked confidential for the purpose of responding to this RFO or in conjunction with any contract arising
there from. I warrant that only those employees w
ho are authorized and required to use such materials will have access
to them.


I further warrant that all materials provided by the State will be returned promptly after use and that all copies or
derivations of the materials will be physically and/or ele
ctronically destroyed. I will include with the returned materials, a
letter attesting to the complete return of materials, and documenting the destruction of copies and derivations. Failure to
so comply will subject this company to liability, both crimin
al and civil, including all damages to the State and third parties.
I authorize the State to inspect and verify the above.


I warrant that if my company is awarded the Purchase Order, it will not enter into any agreements or discussions with a
third party

concerning such materials prior to receiving written confirmation from the State that such third party has an
agreement with the State similar in nature to this one.


Signature of Representative

Date (mm/dd/yyyy)







Typed Name of Representative







Typed Name of Company