N0018919R3034_USFF_DBA_PWS.docx

Performance Work Statement US Fleet Forces Database Administrator

1.0 INTRODUCTION

United States Fleet Forces Command (USFFC) Communications and Information Systems provide SharePoint Portal hosting services and support to USFFHQ staff and global customers for information sharing and collaboration. In order to maintain and ensure that services are adequately provided USFF requires contractor support in the administration, configuration, management of SharePoint Portals, and to provide customer support and user training.

2.0 TASKS

In the performance of support services, the contractor shall be required to perform tasks and sub-tasks listed in this section and its sub-sections. Information provided in this section is strictly a summary of the applicable functions and should not be construed as all-inclusive. Due to the rapid changes in technology and business dynamics within USFF, the Contractor must be abreast with the latest technologies and trends, and able to adapt or implement to support requirements.

USFF uses Microsoft SQL Servers Enterprise to support several SharePoint and Custom Applications. Microsoft Data Base Administrator support is required to perform and execute the duties and responsibilities outlined below on all Microsoft SQL Servers used by USFF.

· Manage and maintain all required security level/posture of all MS SQL Servers. MS SQL

· Servers must be Information Assurance (IA) compliant to the latest policies and standards (i.e. STIG, IAVA, etc.)

· Document and generate report on all changes applied to MS SQL Servers.

· Provide assistance in the processing and submission of Certification and Accreditation (C&A) for MS SQL Servers.

· Provide recommendation on industry best practices in the use of MS SQL Server and upcoming trends in database design, implementation and sustainment.

· Manage and maintain all MS SQL services to ensure that they are always at peak performance (greater than 99.99%).

· Improve slow performing database(s) and/or code(s) to attain their peak performance throughout the life cycle of the database.

· Must ensure that all Transact-SQL code are bug free and executes effectively and efficiently.

· Manage and maintain all database backup and recovery. There must not be any loss of any data (in part or in whole).

· Develop and maintain Analysis Services (such as DAX, OLAP/MOLAP), SQL Reporting Services, Data Transformation Services packages, Business Intelligence, Availability Groups, Clustering, and SQL Agent jobs. These items must be responsive and optimized to execute close to 99.99% efficiency.

· Provide effective and quality training and/or assistance to data analysts, coders/programmers (including pre-production code reviews), data modelers, managers, and users.

· Perform auditing, base lining/enhancing/optimizing/tuning (especially index tuning and custom statistics), monitoring and troubleshooting.

· Plan configuration changes, future workloads, and future system resources that are aligned to government mission and goals.

· Report to government lead about system conditions, failures and future needs.

· In case of malfunctions, immediately report to government lead all issues and provide appropriate resolution or mitigation.

· Develop POAM for all projects and tasks.

· Attend meetings either physical or virtual.

3.0 DEFENSE SECURITY SERVICE-APPROVED FACILITY CLEARANCE

Contractor must have SECRET facility clearance at time of proposal submission. Contractor shall be able to provide Subject Matter Expert (SME) support with clearances up to and including General Service (GENSER)/SECRET level. The contractor shall abide by all USFF, DON, and DOD instructions, rules, procedures, and standards of conduct. The contractor’s request for visit authorization shall be submitted in accordance with DOD 5220.22M (Industrial Security Manual for Safeguarding Classified Material) no later than one (1) week prior to arrival. Active secret clearances are required for all positions. All contractor personnel shall be eligible for secret clearances for all positions as required. It is the contractor’s responsibility to obtain the requisite clearance levels for all contractor personnel prior to the start of work. In the event that contractor personnel cannot obtain a secret clearance, prior to the required start date, the contractor shall notify the COR. A DD-254 shall be provided for the contractor to complete and utilize for security purposes. A copy of the completed form shall be emailed to the COR and USFF security officer. All contractor personnel shall be eligible for a Secret security clearance for NIPRNET and/or SIPRNET information access to perform management of USFF N1D tasks. All classified SIPRNET work in performance of this contact will take place at USFFC. Any contractor personnel proposed to work on this effort shall be eligible to immediately begin performance at the time of contract award.

3.1 MISSION REQUIREMENT SPECIFIC CLASSIFICATION GUIDANCE

· In accordance with DODM 5200.45, "Instruction for Developing Security Classification Guides," the following derivative classification applies:

· A specific capability or unit linked to being allocated to an Operation is unclassified.

· The numbers of a specific capability allocated to an Operation is Secret.

· A specific capability or unit allocated to the Operation and linked to specific response times, dates of deployment, or dates of employment is Secret. An exception is made in accordance with Chairman of the Joint Chiefs of Staff (CJCS) Instruction 3130.06, "Global Force Management Allocations Policies and

· Procedures," which directs that Force Tracking Numbers (FTNs) and EJMAPS numbers be added to deployment orders in order to identify personnel inbound to support requirements.

· A specific capability or unit link to a specific Operation is Secret.

· An execution order and the supporting deployments/redeployments are treated as two separate events. When a linkage is made between the two events, the highest level of classification applies. When a linkage is required during deployment/redeployment to obtain diplomatic overflight and air traffic clearances, information may be declassified as required.

· Additional guidance regarding classification of and allowed declassification of movement and location information is provided in CJCS M3130.03, "Adaptive Planning and Execution (APEX) Planning Formats and Guidance."

3.2 ADDITIONAL SECURITY CLASSIFICATION GUIDANCE

In addition to the above mission requirement classification guidance, the contractor shall comply with any additional applicable security classification guidance contained in the National Industrial Security Program Operating Manual (DOD 5220.22-M), DOD Information Security Program: Protection of classified information (DODM 5200.01 V1-V4), DON Information Security Program (SECNAV M-5510.36) and local USFF security policies. The contractor shall not release any Government information e.g. classified, controlled unclassified/For Official Use Only (FOUO) information without the express permission of the Government representative or COR.

4.0 QUALIFICATIONS

· Bachelor’s degree in Computer Science or associate’s degree in Computer Science with additional 2 years of experience as Microsoft SQL Server DBA.

· Minimum 8 years of experience as DBA in Microsoft SQL Server.

· Minimum 8 years of in depth knowledge and experience in database theory and design.

· Minimum 8 years of in depth experience in planning, implementing, administering and programming Microsoft SQL Server.

· Minimum 4 years of in depth knowledge and experience of Windows O/S, distributed computing architecture (client-server), networking, storage area network (SAN), and Virtualization (Hyper-V and VMware).

· Experience in Microsoft .NET programming (C# or VB.NET).

· Minimum six years of in depth knowledge and experience in Transact SQL and PowerShell.

· Microsoft Certified Solutions Expert: Data Platform or Microsoft Certified Solutions Expert: Data Management and Analytics.

· CompTIA Security Plus.

· All certification must be current versions. All certifications must stay current and up to date throughout the life of the contract.

· Contractor must have SECRET SECURITY CLEARANCE at time of proposal submission.

NOTE: This position is considered to be a key position. Individuals not meeting all of the requirements listed above shall not be acceptable.

5.0 DELIVERABLES

The Contractor shall provide all the deliverables as directed and listed in the Deliverable Matrix outlined in the Quality Assurance Surveillance Plan (QASP).

6.0 SUBSTITUTION

A requirement of this contract is to maintain stability of personnel proposed in order to provide quality services. The contractor agrees to assign only those personnel who are necessary to fulfill the requirements of the effort. The contractor agrees to assign to any effort only personnel who meet or exceed the applicable labor category descriptions. No substitution or addition of personnel shall be made except in accordance with the following.

1. If contractor personnel, for any reason, become unavailable to perform under the contract for a continuous period exceeding ten (10) working days, or are expected to devote substantially less effort to the work than indicated in the proposal, the contractor shall provide a substitution to such personnel, in accordance with the below sub-sections.

2. All proposed substitutions shall be submitted, in writing, to the Contracting Officer and COR at least ten (10) working days prior to any contractor personnel becoming unavailable for work. Each request shall provide a detailed explanation of the circumstances necessitating the proposed substitution, a complete résumé for the proposed substitute, information regarding the full financial impact of the change, and any other information required by the Contracting Officer and COR to approve or disapprove the proposed substitution. All proposed substitutes (no matter when they are proposed during the performance period) shall have qualifications that meet section 4.0 Qualifications.

3. Contractor shall provide resumes to include certification, work experience and education to ensure that candidates meet the requirements as outline in this PWS. All certifications must be current with proof attached to the resume.

4. The Contracting Officer with the COR and/or Technical Representative(s) shall evaluate requests for substitution of personnel and promptly notify the contractor, in writing, of whether the request is approved or disapproved. Upon approval of proposed substitution, personnel shall be on site within ten (10) working days to commence work. Under no circumstances shall support not to be provided greater than ten working days without Contracting Officer or COR approval.

5. If the Contracting Officer determines that suitable and timely replacement of personnel who have been reassigned, terminated or have otherwise become unavailable to perform under the contract is not reasonably forthcoming or that the resultant reduction of productive effort would impair the successful completion of the contract, the contract may be terminated by the Contracting Officer for default or for the convenience of the Government, as appropriate. Alternatively, at the Contracting Officer’s discretion, if the Contracting Officer finds the contractor to be at fault for the condition, he may equitably adjust (downward) the contract price to compensate the Government for any delay, loss or damage as a result of the contractor’s action.

7.0 GOVERNMENT FURNISHED EQUIPMENT (GFE)

The Government will furnish equipment or facilities, needed by contractor personnel, to accomplish objectives and tasks identified in this performance work statement (PWS). Equipment: Office Cubicle with storage space, Desktop/Laptop Computer as required, printer, facsimile machine, copy machine, telephone, and office supplies, etc. on a temporary and not-to-interfere basis with existing services. All provided databases will remain property of the U.S. Navy. The contractor shall not retain any government furnished equipment or materials.

8.0 MATERIALS

All materials required to perform duties will be provided by the Government to include workspace, phone, and NIPR/SIPR computers.

9.0 ADDITIONAL TRAINING REQUIREMENTS

The Contractor is responsible for its employees (and subcontractors) supporting this contract completing and staying up-to-date on all training required by USFF and supported activities for individuals working on Government installations. Some examples of required training and their requisite course numbers/references are listed below. The required training is subject to change throughout the life of this contract; however, the Contractor should assume at least a total of eight (8) hours for all required training courses annually per Contractor/Subcontract employee. The Contractor shall provide documentation (copies of training certificates) to the COR confirming that Contractor employees have completed the required training within five (5) days of the specific training due date.

DOD-IC-IAA-V12.0

SECNAVINST 5239.3B, para. 7(a)(4)

E2.11; E3.18.6

COMUSFLTFORCOMINST 3432.1, para. 8a(7)

10.0 PLACE OF PERFORMANCE

Contractor support shall be performed at USFF located on the Naval Support Activity (NSA), Norfolk, Virginia

11.0 RECOGNIZED FEDERAL HOLIDAYS:

Below are the traditional Federal holidays in which Government facilities will be closed. With the exception of responsibilities, such as 24-hour operations to support training events/exercises and real world events, where prior approval has been granted by the COR to perform on-site at the Government installation, Contractor shall follow their corporate policy for work on recognized Federal holidays where on-site performance cannot be conducted:

12.0 ENTERPRISE CONTRACTOR MANPOWER REPORTING APPLICATION (ECRMA)

The contractor shall report contractor labor hours (including subcontractor labor hours) required for performance of services provided under this contract for the Center for Security Forces via a secure data collection site. Contracted services excluded from reporting are based on Product Service Codes (PSCs). The excluded PSCs are:

(1) W, Lease/Rental of Equipment;

(2) X, Lease/Rental of Facilities;

(3) Y, Construction of Structures and Facilities;

(4) D, Automatic Data Processing and Telecommunications, IT and Telecom- Telecommunications Transmission (D304) and Internet (D322) ONLY;

(5) S, Utilities ONLY;

(6) V, Freight and Shipping ONLY.

The contractor is required to completely fill in all required data fields using the following web address https://ecmra.mil.

Reporting inputs will be for the labor executed during the period of performance during each Government fiscal year (FY), which runs October 1 through September 30. While inputs may be reported any time during the FY, all data shall be reported no later than October 31 of each calendar year. Contractors may direct questions to the help desk, linked at https://ecmra.mil.

13.0 CONTRACTOR UNCLASSIFIED ACCESS TO FEDERALLY CONTROLLED FACILITIES, SENSITIVE INFORMATION, INFORMATION TECHNOLOGY (IT) SYSTEMS OR PROTECTED HEALTH INFORMATION (JAN 2017) Homeland Security Presidential Directive (HSPD)-12, requires government agencies to develop and implement Federal security standards for Federal employees and contractors. The Deputy Secretary of Defense Directive-Type Memorandum (DTM) 08-006 – “DoD Implementation of Homeland Security Presidential Directive – 12 (HSPD-12)” dated November 26, 2008 (or its subsequent DoD instruction) directs implementation of HSPD-12. This clause is in accordance with HSPD-12 and its implementing directives.

APPLICABILITY

This clause applies to contractor employees requiring physical access to any area of a federally controlled base, facility or activity and/or requiring access to a DoN or DoD computer/network/system to perform certain unclassified sensitive duties. This clause also applies to contractor employees who access Privacy Act and Protected Health Information, provide support associated with fiduciary duties, or perform duties that have been identified as National Security Position, as advised by the command security manager. It is the responsibility of the responsible security officer of the command/facility where the work is performed to ensure compliance.

Each contractor employee providing services at a Navy Command under this contract is required to obtain a Department of Defense Common Access Card (DoD CAC). Additionally, depending on the level of computer/network access, the contract employee will require a successful investigation as detailed below.

ACCESS TO FEDERAL FACILITIES

Per HSPD-12 and implementing guidance, all contractor employees working at a federally controlled base, facility or activity under this clause will require a DoD CAC. When access to a base, facility or activity is required contractor employees shall in-process with the Command’s Security Manager upon arrival to the Command and shall out-process prior to their departure at the completion of the individual’s performance under the contract.

ACCESS TO DOD IT SYSTEMS

In accordance with SECNAV M-5510.30, contractor employees who require access to DoN or DoD networks are categorized as IT-I, IT-II, or IT-III. The IT-II level, defined in detail in SECNAV M-5510.30, includes positions which require access to information protected under the Privacy Act, to include Protected Health Information (PHI). All contractor employees under this contract who require access to Privacy Act protected information are therefore categorized no lower than IT-II. IT Levels are determined by the requiring activity’s Command Information Assurance Manager.

Contractor employees requiring privileged or IT-I level access, (when specified by the terms of the contract) require a Single Scope Background Investigation (SSBI) or T5 or T5R equivalent investigation, which is a higher level investigation than the National Agency Check with Law and Credit (NACLC)/T3/T3R described below. Due to the privileged system access, an investigation suitable for High Risk national security positions is required. Individuals who have access to system control, monitoring, or administration functions (e.g. system administrator, database administrator) require training and certification to Information Assurance Technical Level 1, and must be trained and certified on the Operating System or Computing Environment they are required to maintain.

Access to sensitive IT systems is contingent upon a favorably adjudicated background investigation. When access to IT systems is required for performance of the contractor employee’s duties, such employees shall in-process with the Navy Command’s Security Manager and Information Assurance Manager upon arrival to the Navy command and shall out-process prior to their departure at the completion of the individual’s performance under the contract. Completion and approval of a System Authorization Access Request Navy (SAAR-N) form is required for all individuals accessing Navy Information Technology resources.

The decision to authorize access to a government IT system/network is inherently governmental. The contractor supervisor is not authorized to sign the SAAR-N; therefore, the government employee with knowledge of the system/network access required or the COR shall sign the SAAR-N as the “supervisor”.

The SAAR-N shall be forwarded to the Command’s Security Manager at least 30 days prior to the individual’s start date. Failure to provide the required documentation at least 30 days prior to the individual’s start date may result in delaying the individual’s start date.

When required to maintain access to required IT systems or networks, the contractor shall ensure that all employees requiring access complete annual Information Assurance (IA) training, and maintain a current requisite background investigation. The Contractor’s Security Representative shall contact the Command Security Manager for guidance when reinvestigations are required.

INTERIM ACCESS

The Command's Security Manager may authorize issuance of a DoD CAC and interim access to a DoN or DoD unclassified computer/network upon a favorable review of the investigative questionnaire and advance favorable fingerprint results. When the results of the investigation are received and a favorable determination is not made, the contractor employee working on the contract under interim access will be denied access to the computer network and this denial will not relieve the contractor of his/her responsibility to perform.

DENIAL OR TERMINATION OF ACCESS

The potential consequences of any requirement under this clause including denial or termination of physical or system access in no way relieves the contractor from the requirement to execute performance under the contract within the timeframes specified in the contract. Contractors shall plan ahead in processing their employees and subcontractor employees. The contractor shall insert this clause in all subcontracts when the subcontractor is permitted to have unclassified access to a federally controlled facility, federally-controlled information system/network and/or to government information, meaning information not authorized for public release.

CONTRACTOR’S SECURITY REPRESENTATIVE

The contractor shall designate an employee to serve as the Contractor’s Security Representative. Within three work days after contract award, the contractor shall provide to the requiring activity’s Security Manager and the Contracting Officer, in writing, the name, title, address and phone number for the Contractor’s Security Representative. The Contractor’s Security Representative shall be the primary point of contact on any security matter. The Contractor’s Security Representative shall not be replaced or removed without prior notice to the Contracting Officer and Command Security Manager.

BACKGROUND INVESTIGATION REQUIREMENTS AND SECURITY APPROVAL PROCESS FOR CONTRACTORS ASSIGNED TO NATIONAL SECURITY POSITIONS OR PERFORMING SENSITIVE DUTIES Navy security policy requires that all positions be given a sensitivity value based on level of risk factors to ensure appropriate protective measures are applied.

Contractor employees under this contract are recognized as Non-Critical Sensitive [ADP/IT-II] positions when the contract scope of work require physical access to a federally controlled base, facility or activity and/or requiring access to a DoD computer/network, to perform unclassified sensitive duties. This designation is also applied to contractor employees who access Privacy Act and Protected Health Information (PHI), provide support associated with fiduciary duties, or perform duties that have been identified as National Security Positions. At a minimum, each contractor employee must be a US citizen and have a favorably completed NACLC or T3 or T3R equivalent investigation to obtain a favorable determination for assignment to a non-critical sensitive or IT-II position. The investigation consists of a standard NAC and a FBI fingerprint check plus law enforcement checks and credit check. Each contractor employee filling a non-critical sensitive or IT-II position is required to complete:

· SF-86 Questionnaire for National Security Positions (or equivalent OPM investigative product)

· Two FD-258 Applicant Fingerprint Cards (or an electronic fingerprint submission)

· Original Signed Release Statements

Failure to provide the required documentation at least 30 days prior to the individual’s start date shall result in delaying the individual’s start date. Background investigations shall be reinitiated as required to ensure investigations remain current (not older than 10 years) throughout the contract performance period. The Contractor’s Security Representative shall contact the Command Security Manager for guidance when reinvestigations are required. Regardless of their duties or IT access requirements ALL contractor employees shall in-process with the Command’s Security Manager upon arrival to the command and shall out-process prior to their departure at the completion of the individual’s performance under the contract. Employees requiring IT access shall also check-in and check-out with the Navy Command’s Information Assurance Manager. Completion and approval of a System Authorization Access Request Navy (SAAR-N) form is required for all individuals accessing Navy Information Technology resources. The SAAR-N shall be forwarded to the Navy Command’s Security Manager at least 30 days prior to the individual’s start date. Failure to provide the required documentation at least 30 days prior to the individual’s start date shall result in delaying the individual’s start date.

The contractor shall ensure that each contract employee requiring access to IT systems or networks complete annual Information Assurance (IA) training, and maintain a current requisite background investigation. Contractor employees shall accurately complete the required investigative forms prior to submission to the Command Security Manager. The Command’s Security Manager will review the submitted documentation for completeness prior to submitting it to the Office of Personnel Management (OPM); Potential suitability or security issues identified may render the contractor employee ineligible for the assignment. An unfavorable determination is final (subject to SF-86 appeal procedures) and such a determination does not relieve the contractor from meeting any contractual obligation under the contract. The Command’s Security Manager will forward the required forms to OPM for processing. Once the investigation is complete, the results will be forwarded by OPM to the DoD Central Adjudication Facility (CAF) for a determination.

If the contractor employee already possesses a current favorably adjudicated investigation, the contractor shall submit a Visit Authorization Request (VAR) via the Joint Personnel Adjudication System (JPAS) or a hard copy VAR directly from the contractor’s Security Representative. Although the contractor will take JPAS “Owning” role over the contractor employee, the Navy Command will take JPAS "Servicing" role over the contractor employee during the hiring process and for the duration of assignment under that contract. The contractor shall include the IT Position Category per SECNAV M-5510.30 for each employee designated on a VAR. The VAR requires annual renewal for the duration of the employee’s performance under the contract.

BACKGROUND INVESTIGATION REQUIREMENTS AND SECURITY APPROVAL PROCESS FOR CONTRACTORS ASSIGNED TO OR PERFORMING NON-SENSITIVE DUTIES Contractor employee whose work is unclassified and non-sensitive (e.g., performing certain duties such as lawn maintenance, vendor services, etc. ...) and who require physical access to publicly accessible areas to perform those duties shall meet the following minimum requirements:

· Must be either a US citizen or a US permanent resident with a minimum of 3 years of legal residency in the United States (as required by The Deputy Secretary of Defense DTM 08-006 or its subsequent DoD instruction) and

· Must have a favorably completed National Agency Check with Written Inquiries (NACI) or T1 investigation equivalent including a FBI fingerprint check prior to installation access.

· To be considered for a favorable trustworthiness determination, the Contractor’s Security Representative must submit for all employees each of the following:

· SF-85 Questionnaire for Non-Sensitive Positions

· Two FD-258 Applicant Fingerprint Cards (or an electronic fingerprint submission)

· Original Signed Release Statements

The contractor shall ensure each individual employee has a current favorably completed National Agency Check with Written Inquiries (NACI) or T1 equivalent investigation, or ensure successful FBI fingerprint results have been gained and investigation has been processed with OPM. Failure to provide the required documentation at least 30 days prior to the individual’s start date may result in delaying the individual’s start date.

* Consult with your Command Security Manager and Information Assurance Manager for local policy when IT-III (non-sensitive) access is required for non-US citizens outside the United States.

10 | Page