Attachment 003 - ORACLE DB TUNING - Performance Work Statement -final 15 NOV2024.pdf

Global Combat Support System‐Army (GCSS‐Army) 1821 B Ave, Building 4229

Fort Gregg-Adams, VA 23801

ORACLE Database Tuning Services Performance Work Statement (PWS)

18 October 2024 Final – 15 Nov 2024

1.0 Background

GCSS-Army has existing ORACLE Databases set up with licenses previously purchase via NASA SEWP.

2.0 Scope

Requirement is for Technical Support Services from an Oracle Advanced Customer Services (ACS) Senior Advanced Support Engineer for SAP Oracle Database Tuning Services. Services from the Oracle SAP Center of Excellence can only be obtained through Oracle ACS (via an authorized reseller). The Oracle SAP Center of Excellence has developed its own tools and methodologies for analyzing/recommending database optimization to get the best performance out of an SAP system running on the Oracle Relational Database Management System (RDBMS).

3.0 Objective

The objective is to have an SAP/Oracle Tuning Expert provide tuning analysis and recommendations for the GCSS-Army Database. The service provider will provide the expected level of work, possess the required technical expertise, and have the ability to perform the work in the time period required.

4.0 Description of Services

Oracle’s ACS technical services are required to provide analysis and database tuning recommendations.

Task Area 1: Oracle ACS Engineering Services – Database Tuning

During this period of performance (PoP) being requested, the Senior Oracle Advance Support Engineer will continue to provide analysis and tuning recommendations four times a year for the base period as follows:

a. Assist with performing specialized production tasks and enabling operational optimization for complex Oracle environments. Specific services may include assistance with one or more of the following activities:

SAP Oracle database tuning and optimization

1) Technical and Performance advice and guidance based on analysis on database metrics.

2) Suggestions for improving SQL performance based on database metrics analyzed.

The goal is to maximize performance of existing SAP Oracle databases as GCSS-Army is ramping up for new users.

5.0 Security

ORACLE representative performing services on this contract will have a favorable background investigation completed by Oracle.

CAC is not required.

a. OPSEC 1: AT Level I Training.

This provision/contract text is for contractor employees with an area of performance within an Army controlled installation, facility or area. All contractor employees, to include subcontractor employees, requiring access Army installations, facilities and controlled access areas shall complete AT Level I awareness training within 5 calendar days after contract start date or effective date of incorporation of this requirement into the contract, whichever is applicable. The contractor shall submit certificates of completion for each affected contractor employee and subcontractor employee, to the COR or to the contracting officer, if a COR is not assigned, within two (2) calendar days after completion of training by all employees and subcontractor personnel. AT level I awareness training is available at the following website:

https://atlevel1.dtic.mil/at .

b. OPSEC 2: Access and General Protection/Security Policy and Procedures.

This standard language text is for contractor employees with an area of performance within an Army controlled installation, facility or area. Contractor and all associated sub-contractors employees shall comply with applicable installation, facility and area commander installation/facility access and local security policies and procedures (provided by government representative). The contractor shall also provide all information required for background checks to meet installation access requirements to be accomplished by installation Provost Marshal Office, Director of Emergency Services or Security Office.

Contractor workforce must comply with all personal identity verification requirements as directed by DOD, HQDA and/or local policy. In addition to the changes otherwise authorized by the changes clause of this contract, should the Force Protection Condition (FPCON) at any individual facility or installation change, the Government may require changes in contractor security matters or processes.

c. OPSEC 2b: For contractors that do not require CAC but require access to a DoD facility or installation. Contractor and all associated sub-contractors employees shall comply with adjudication standards and procedures using the National Crime Information Center Interstate Identification Index (NCIC-III) and Terrorist Screening Database (TSDB) (Army Directive 2014-05/AR 190-13), applicable installation, facility and area commander installation/facility access and local security policies and procedures (provided by government representative), or, at OCONUS locations, in accordance with status of forces agreements and other theater regulations.

d. OPSEC 4: iWATCH Training.

This standard language is for contractor employees with an area of performance within an Army controlled installation, facility or area. The contractor and all associated sub-contractors shall brief all employees on the local iWATCH program (training standards provided by the requiring activity ATO). This local developed training will be used to inform employees of the types of behavior to watch for and instruct employees to report suspicious activity to the COR. This training shall be completed within 5 calendar days of contract award and within 5 calendar days of new employees commencing performance with the results reported to the COR NLT 7 calendar days after contract award.

6.0 Deliverables/Reports

a. Reports shall summarize the status of services performed and identify findings, problems, issues, recommendations, etc. Delivery of all reports will be electronically to the Contracting Officer Representative (COR) no later than (NLT) two weeks after each visit. Final reports are due NLT five (5) days after the final day of the contract PoP.

b. The contractor shall report all contractor labor hours (including subcontractor labor hours) required for performance of services provided under this contract for the Department of the Army via a secure data collection site. The contractor is required to completely fill in all required data fields using the following web address: http://www.ecmra.mil/, and then click on "Department of the Army CMRA" or the icon of the DoD organization that is receiving or benefitting from the contracted services.

7.0 Place of Performance

The place of performance for work covered under this PWS is ARMY NEC-R-RSA DATA Center, Building 3339, Snooper Road, Redstone Arsenal, AL, 35898. Contractor personnel must follow base access and facility entrance requirements, and present picture identification prior to access. Oracle ACS Senior Advanced Support Engineers must coordinate access to Redstone Arsenal base in advance of the scheduled PoP. Oracle ACS employees and their sub-contractors must carry a picture ID at all times when working in the facilities. With mutual agreement, some work may be performed remotely.

8.0 Period of Performance

The period of performance for this PWS is for a 12-month base period with two (2) one year option periods.

9.0 Labor Categories/Hours

Database Tuning: One (1) Oracle ACS Senior Advanced Support Engineer - - four (4) visits per year, one-to-two weeks in duration.

http://www.ecmra.mil/