12-A-0121-CALL-0001-SAIC_-_Statement_of_Work.pdf

Page 7 of 13 SECHQ1-12-A-0121/0001

SECTION C - DESCRIPTION/SPECIFICATIONS/STATEMENT OF WORK

C.1.0 Scope

The United States Securities and Exchange Commission (SEC) Office of Information Technology (OIT) requires database administration operations and maintenance services for its Microsoft Structured Query Language (SQL) Server, Oracle, Oracle SOA Suite, Oracle Advanced Security Option (ASO), Oracle RMAN, Oracle RAC, and Oracle Data Guard in the Windows, UNIX and Linux environments. The Contractor shall provide consulting support to OIT developers and database administrators, including integration of best practices and standards, for example, from the Capability Maturity Model Integration (CMMI).

C.2.0 Applicable Documents. The Contractor shall comply with the current version of policies and procedures listed in section C.2 of the contractor's BPA award.

C.3.0 Requirements The Contractor shall comply with Section C.3.0.1 thru Section C.3.0.9 of the Contractor’s BPA award.

C.3.1 Real-Time Support. The Contractor shall maintain the necessary functionality Oracle RDMBS, Oracle Data Guard, Oracle RAC, ASO Security. The Contractor shall respond to issues and problems with RMAN and Microsoft SQL Server, as they arise on a real-time basis.

C.3.2 Advise SEC Database Administrators. The Contractor shall provide technical advice to the SEC database administrators (DBAs). The Contractor shall transfer server administration, Failsafe administration, database administration, ASO security, RAC, Data Guard and Oracle and SQL server tool skills to the SEC DBAs.

C.3.3 Oracle Server Administration. The Contractor shall provide administration support for the Oracle ASO, Oracle RMAN, Oracle RAC, and Oracle Grid Control and the Oracle RDMS.

The Contractor shall administer SEC Oracle databases by performing the following subtasks on both the UNIX, Linux and Windows NT platforms:

a. Install, configure, start/stop, upgrade, monitor, manage, and otherwise maintain the Oracle products ASO, RMAN, RAC, Grid, and RDMS.

b. Diagnose problems with Oracle products listed above utilizing Oracles error and master logs and Oracle Enterprise Manager.

c. Create databases using the Oracle DBMS. Set up and manage Oracle Failsafe and RAC.

d. Backup and restore database as defined in Section C.2.5 of the BPA, Database

Administrator Guide

e. Administer the security procedures defined in the Section C of the BPA

f. Advise the SEC about logical database design and develop the physical database design as defined in C.2.4.2 and C.2.4.4.

g. Support the development of applications and the migration of legacy databases into

Oracle by advising developers in logical design, creating database objects, optimizing procedures, writing scripts, and loading, extracting, and converting data.

h. Write scripts, triggers, and stored procedures using Procedural Language/Structured Query Language (PL/SQL).

i. Create and maintain replication tables, perform subscription materialization, define data server functions, establish replication functions, maintain routes, maintain and manage

Page 8 of 13 SECHQ1-12-A-0121/0001 database connections, handle errors and exceptions, recover databases, and reconcile database inconsistencies. See C.2.5 of the BPA for guidance.

C.3.4 Microsoft SQL Server Administrator. The Contractor shall use the Microsoft Enterprise Manager and DBArtisan to administer the Microsoft SQL Server running on the Window NT platform as follows:

a. Use the Microsoft Enterprise Manager to install, configure, start/stop, and upgrade the Microsoft SQL Server.

b. Create and manage databases, files, and transaction logs.

c. Back up databases daily and restore databases, when needed, using SQL Server recovery models.

d. Use SQL Server Agent to manage multistep jobs.

e. Use the Microsoft Enterprise Manager to manage security for SQL Server login, databases, and objects.

f. Use Microsoft Enterprise Manager to set up and manage transactional replication.

g. Advise the SEC about logical database design and develop the physical database design.

h. Support the development of applications and the migration of legacy databases into

Microsoft SQL Server by loading, extracting, and converting data.

SECTION D - PACKAGING AND MARKING

All terms from SECTION D of the Contractor's BPA apply to this Call.

SECTION E - INSPECTION AND ACCEPTANCE

All terms from SECTION E of the Contractor's BPA apply to this Call.

SECTION F - DELIVERIES OR PERFORMANCE

F.1 Period of Performance. The period of performance shall be for the base year is November 16, 2013 through November 15, 2014. There are three (3) options years.

F.1.1 At the end of the base year, if exercised, the first option will begin. If all options are exercised, the period of performance will not exceed a total of five (5) years and six (6) months, not including any extension under FAR 52.217-9, Option To Extend The Term of the Contract. If exercised, the period of performance for each successive option will begin the day after expiration of the previous period. Exercise of any option requires a contract modification signed by the SEC Contracting Officer.

F.2. Deliverables and Schedule. The Contractor shall provide the deliverables in electronic format using the appropriate product from the Microsoft Office suite (for example, Microsoft Word or Excel) or compatible software. All deliverables shall be delivered to the COR unless otherwise noted. The COR will have 5 days to review all deliverables.

Section Deliverable Schedule C.3.0.4.4.1 Status reports -

Draft Monthly, 10 business days of the following month - SEE BPA

C.3.0.4.4.1 Status reports – Final

Monthly, 5 business days after the COR returns the draft

Page 9 of 13 SECHQ1-12-A-0121/0001

C.3.2 Draft special reports As requested by the COR C.3.2 Final special reports 10 business days after the COR returns the draft report with comments.

F.3 Place of Delivery. The deliverables to be furnished under this contract shall be delivered to the following addresses:

U.S. Securities and Exchange Commission Station Place - Headquarters 100 F Street NE Washington, D.C. 20549 Attn: Joyce C Hankins, COR

F.4 Place of Performance. Work on this contract will be performed at SEC Headquarters in Washington, DC. In addition, work may be off-site on approval of the COR and case-by-case basis.

U.S. Securities and Exchange Commission Station Place - Headquarters 100 F Street NE Washington, D.C. 20549

F.5 Work Hours. Due to security considerations, all Contractor personnel assigned to this award and working in Federal workspace must begin their work hours no earlier than 6:30 AM and must leave no later than 7:00 PM, Monday - Friday, excluding Government holidays and shut downs. There will be times when support is required during outside of the normal hours of performance and weekends for system maintenance, disaster recovery testing, production application deployments and system outage. Exceptions may be made on a case-by-case basis and must be pre-approved by the Government COR.

SECTION G - CONTRACT ADMINISTRATIVE DATA

G.1 Appointment of Contracting Officer’s Representative (COR)

a. The Contracting Officer shall appoint, in writing, a Contracting Officer's Representative (COR) for this award. The COR has no authority regarding the terms and conditions of the contract. The Contractor shall be provided a copy of the appointment letter identifying the tasks for which the COR is responsible. The COR may not re-delegate his or her authority.

b. The COR will act as the liaison to coordinate activities between the Contractor and Contracting Officer, as required, in the performance of the work under this contract.

c. Only the Contracting Officer has the authority to change the terms and conditions of this contract. The COR may not agree to or issue a change to the contract terms and conditions. In the event the Contractor effects changes to the contract at the direction of any person other than the Contracting Officer, the changes will be considered to have been made without any authority and no adjustments will be made to the contract.

d. The COR for this award is Joyce Hankins, hankinsjc@sec.gov, 202-551-8139.

mailto:hankinsjc@sec.gov

Page 10 of 13 SECHQ1-12-A-0121/0001

G.2 Submission of Invoices (Apr 2012) The Securities and Exchange Commission accepts only electronic/e-mail invoices.

Invoices shall be submitted for the Fixed Price CLINs in twelve (12) equal increments on the monthly basis. The Labor Hour CLINs shall only be invoiced for actual labor charges.

Contractors should submit invoices in accordance with the SEC Prompt Payment Provision of the contract. Contractors are cautioned against submitting an invoice prior to goods and services being received/accepted. Invoices submitted prematurely may be rejected.

Electronic/e-mail Invoice Instructions:

Invoices must be in PDF Format and may not exceed 10MB Subject Line: Company name and the invoice number e-mail Message:

Company logo or letterhead Company name and payment address Company point of contact (POC) for the invoice with phone and e-mail Invoice Number SEC Contract or Order number

SEC COR

For supplies: contract line item number, item description, quantity delivered, and unit and extended price, per Section B CLIN structure

For services: contract line item number, item description, period of performance and associated costs, per Section B, contract line item, CLIN, structure

Shipping and handling charges, if applicable

Clearly mark duplicates of previous invoice submissions with "DUPLICATE"

Clearly mark the final invoice with "FINAL INVOICE"

Attach the invoice and any supporting documents in a secure tamper-proof or tamper-resistant format compatible with Adobe Acrobat.

Electronic signatures are acceptable in scanned documents. Each page of a document must be clearly marked with information identifying it with the company, the contract, the invoice, and any other information required by the contract.

E-mail invoices to the following address: 9-AMC-AMZ-SEC-Invoices@faa.gov

G.3 Payment Information. Payments will be made within 30 days after receipt of a valid invoice.

G.4 BPA CALL Options

(a) Award of an initial BPA call will not obligate the Government to exercise contractual Option CLINs. Prior to exercising any option and at least once per year, the Government will make a written determination whether (i) The schedule contract, upon which the BPA was established, is still in effect; (ii) The BPA still represents the best mailto:9-AMC-AMZ-SEC-Invoices@faa.gov

Page 11 of 13 SECHQ1-12-A-0121/0001 value (see 8.404(d)); and (iii) Estimated quantities/amounts have been exceeded and additional price reductions can be obtained.

(b) The SEC shall not pay any charges for Option CLINs that are not exercised.

SECTION H - SPECIAL CONTRACT REQUIREMENTS

H.1 Type of Award. The award type for this BPA Call is Firm Fixed Price (FFP) CLINs and a Labor-Hour (LH) CLINs.

H.9 Contractor Personnel

H.9.1 Contractor Responsibilities/Standards of Conduct. The Contractor shall furnish all managerial, supervisory, and personnel to successfully, effectively, and efficiently accomplish under this call.

Contractor personnel are employees of the Contractor and under its administrative control and supervision. The Contractor shall select, supervise and exercise control and direction over its employees under this contract. The SEC will not exercise any supervision over the Contractor’s employees. The Contractor is accountable to the SEC for the actions of Contractor’s personnel.

The Contractor’s employees, when on-site at SEC facilities under this contract, shall only engage in duties specified in Section C, and not in other business, or political, charitable or other duties.

The Contractor shall not recruit on SEC premises or otherwise act to disrupt official SEC business.

The Contractor shall be responsible for maintaining satisfactory standards of employee competency, conduct, appearance, and integrity, and shall be responsible for taking such disciplinary action with respect to its employees as may be necessary. Contractor employees are expected to adhere to standards of conduct that reflect credit on themselves, their employer, the SEC and the Federal Government.

The SEC reserves the right to review all resumes of all personnel assigned to this contract and the results of the background investigations conducted by the Contractor. The SEC has the right to require the removal of any Contractor personnel assigned to this contract, at any time, for any reason.

H.9.2 Key Personnel- Contractor shall designate specific key personnel who are essential to the successful performance of BPA call. Key personnel shall be available for full-time assignment as necessary to efficiently manage the work of the call and shall be available on the effective date of the call..

H.9.2.2 Contractor Substitution Of Key Personnel- Following award, and throughout the life of Orders under this BPA, the Contractor shall permit no substitution of key personnel without the written consent of the Contracting Officer, unless such substitutions are necessitated by an individual’s sudden illness, death or termination of employment. In the event that substitution of personnel is desired, the Contractor shall notify the Contracting Officer in writing at least thirty (30) calendar days before any key personnel substitution is made, if possible. The Contractor shall submit a justification in sufficient detail to permit evaluation of the impact on Order performance, with the resume of the proposed replacement personnel. The Contractor shall obtain the Contracting Officer’s written approval prior to any changes in the contract participation of the personnel named as key personnel. Proposed substitute personnel shall have experience and education at least substantially equal to those of the personnel being replaced.

https://www.acquisition.gov/far/current/html/Subpart%208_4.html#wp1089505

Page 12 of 13 SECHQ1-12-A-0121/0001

Requests for substitutions shall provide a detailed explanation of the circumstances necessitating such changes, a resume for each proposed substitute, and any other information as requested by the Contracting Officer. The Contracting Officer will evaluate such requests and promptly notify the Contractor of approval or disapproval thereof.

H.9.3 Background Check for Contractor Personnel H.9.3.1 Pre-Employment Check -Contractor shall be subject to a complete pre-employment check, which will be completed by the SEC. The pre-employment check shall include a background investigation of each proposed employee under this BPA to determine suitability for employment on the basis of qualifications for the job. The Contractor shall submit U.S. Office of Personnel Management (OPM) Standard Form 85P for each prospective employee. OPM Standard Form 85P is available at http://www.opm.gov/forms. The Government reserves the right of final approval for prospective employees. The pre-employment check shall include, but not be limited to the checks identified below. The Contractor shall make its best efforts to provide employees that pass the SEC’s security screening. Failure of employee(s) to pass the security screening is not a justifiable cause for schedule slippages. The SEC is currently revising its security processes and there may be a change to this process by time of award.

H.9.3.2 Criminal History Check- SEC may contact local law enforcement authorities and the Federal Bureau of Investigation (FBI) to determine the criminal history of each prospective contract employee.

H.9.3.3 Credit History Check- Credit history shall evidence the Contract employee to be responsible with credit obligations. A Contract employee receiving an unfavorable credit rating must be approved by the COR prior to acceptance to this Contract. In the event of an unsatisfactory credit rating, the Contractor shall submit an explanation of the circumstances and the employee shall not be assigned to Orders under the BPA prior to Contracting Officer approval.

H.9.3.4 Background Checks- Due to the sensitive nature of this work, the SEC may conduct background checks of proposed key personnel in addition to reference checks. It shall be the responsibility of the Contractor throughout the life of this BPA to inform the SEC of any changes in its key personnel so that the appropriate background and reference checks may be conducted.

The Contractor also agrees to include the substance of this clause in any of its subcontracts.

The Contractor shall conduct a background investigation regarding the criminal record and credit history of all employees who will be assigned to work on Orders under the BPA. The Contractor shall not assign to work on Orders under the BPA and shall immediately remove from work on Orders under the BPA any employee who has been convicted within the past ten years of fraud or any other felony.

The Contractor shall certify to the SEC that a background investigation has been conducted on each employee who is assigned to work on Orders under the BPA. The Contractor shall conduct follow-up background investigations every twelve months on each employee assigned work under the BPA, unless the SEC directs otherwise.

H.10 Organizational Conflicts Of Interest (OCOI) The Contractor warrants that, to the best of the Contractor’s knowledge and belief, there are no relevant facts or circumstances which could give rise to an Organizational Conflict of Interest (OCOI), as defined in FAR Subpart 9.5. The Contractor warrants that, to the best of the Contractor’s knowledge and belief, there are no relevant facts or circumstances which could give rise to an Organizational Conflict of Interest (OCOI), based on current or pending litigation in http://www.opm.gov/forms

Page 13 of 13 SECHQ1-12-A-0121/0001 which the SEC is a party. The Contractor further warrants that it has disclosed all such relevant information to the Contracting Officer.

The Contractor agrees that if it discovers an actual, apparent, or potential OCOI after award, the Contractor shall make a full disclosure, in writing, to the Contracting Officer. This disclosure shall include a description of actions which the Contractor has taken or proposes to take, after consultation with the Contracting Officer, to avoid, mitigate, or neutralize the actual, apparent or potential conflict.

If the SEC discovers an actual or potential conflict after award, it may terminate this contract for convenience, in whole or in part. If the OCOI is discovered prior to award and the SEC concludes, in its sole discretion, that the OCOI cannot be mitigated, no award will be made. If the Contractor did not disclose relevant information or misrepresented relevant information to the Contracting Officer, the SEC may terminate the contract for default, debar the Contractor from SEC contracting, or pursue other remedies as may be permitted by law or by this contract.

In protecting the SEC’s integrity, the Contracting Officer is vested with the broadest possible discretion as to determining whether an OCOI exists and what remedy is appropriate. For this contracting action, all that is required in finding such a conflict is some evidence that facts exist which could be alleged to constitute an actual or apparent conflict of interest. Accordingly, it is in each Contractor’s best interest to fully inform the Contracting Officer as early as possible to allow the Contracting Officer the maximum opportunity to find ways to mitigate or resolve such potential conflicts of interest.

All other terms from SECTION H of the contractor's BPA apply to this BPA CALL.

SECTION I - TASK ORDER CLAUSES

All terms from SECTION I of the contractor's BPA apply to this order.

SECTION J – LIST OF ATTACHMENTS, EXHIBITS AND OTHER DOCUMENTS

Attachment 1:Non-Disclosure Agreement (Company NDA) Attachment 2: Non-Disclosure Agreement (Contract Employee NDA)

H.10 Organizational Conflicts Of Interest (OCOI)