Database Engineer - TS/SCI w/Poly

Database Engineer

SCOPE

(U//FOUO) The contractor shall manage the lifecycle of data within customer from the time it is acquired to the time it is removed from customer’s systems. This includes data transformation and extraction activities, the ability to perform data exploitation, storage of data, implementation and maintenance of data access controls, reporting, and the removal of data in accordance with customer’s policies and compliance requirements. The contractor shall support the Sponsor in data ingestion, management, and other areas of data processing and follow specific guidance provided by the Sponsor related to compliance with authorities and oversight policy for data access loading, minimization, retention, and use.

(U//FOUO) Data transformation and extraction includes transforming raw data into a usable format, resolving identities from unstructured and structured text, creating networks for social network analysis, enriching results from disparate data sources, helping mission partners evaluate the use and value of new and current datasets, and identifying new selectors for persons of interest. Additional requirements include a documented SOP that captures, at a minimum, the activity description, business needs addressed and alignment to strategic goals, evaluation of the effort, and technical considerations.

(U//FOUO) The contractor shall provide data services, administration, and management which include the following:

a. Providing data services, data administration, data management, and “Big Data” support in client/server, virtual machine, and cloud infrastructure environment and/or migrations between these environments.

b. Providing database installation, configuration, and upgrading database server software and related products, backup and recovery policies and procedures, database implementation, security, optimization, multi-domain operation, and performance management.

c. Supporting ElasticSearch, DynamoDB, cloud, and other technologies associated with data storage, processing, management, and use.

d. Supporting the migration/transition of database capability into cloud-based technologies and/or creation of interfaces between classic relational databases and key indexes to cloud-based columnar databases and map reduce index capabilities.

Enterprise Compliance Support

(U//FOUO) The contractor shall provide audit support to determine enterprise compliance with all of the customer’s current policies and oversight requirements, which include the following:

a. Providing support for data handling obligations under numerous policy and legal authorities, such as Attorney General Guidelines, partner agency information sharing agreements, and security protocols, and assisting the customer in maintaining compliance with such requirements.

b. Designing, testing, and implementing data oversight and auditing solutions for datasets within IT systems.

c. Monitoring and reporting on the organization’s use of data in accordance with its data access authorities and internal policy, and conducting research and analysis to report on data set usage by dataset, data provider, tool, or compliance requirement in question.

d. Developing/maintaining and implementing automated compliance oversight processes for the organization’s use of and access to new datasets and/or emerging technologies.

e. Conducting technical investigations and audits of IT systems and/or application logs related to data-handling compliance incidents (e.g., late deletions and unauthorized or inappropriate data access) to provide facts regarding access to the data and other issues during the period of non-compliance, and providing investigation results to the appropriate customer personnel in a usable and easily understood format.

f. Providing the customer input to periodic interagency reports, reviewing reports for accuracy regarding access to and use of data, and reviewing/reporting on compliance incidents.

g. Tracking and approving dataset user access requests in accordance with the customer SOPs and policies, and providing recommendations for streamlining and updating access procedures.

h. Formulating methods, documents, and procedures to guide appropriate use of data.

i. Updating existing data-handling compliance training courses and materials, developing new materials to reflect changes to data-handling requirements, providing refresher training to the customer workforce on the data-handling requirements, and implementing required training.

j. Tracking and administering the compliance-related training.

k. Developing and implementing an engagement and communications strategy related to the customer’s compliance requirements.

l. Developing a Compliance Innovation Plan (CDRL 013) and facilitating discussions between the relevant customer stakeholder groups in order to formulate an customer specific implementation plan for data-handling compliance. Updates to the plan shall be submitted every six months beginning six months after Sponsor acceptance of the first plan.

Requirements

(U//FOUO) The contractor shall provide data services, administration, and management which include the following:

a. Providing data services, data administration, data management, and “Big Data” support in client/server, virtual machine, and cloud infrastructure environment and/or migrations between these environments.

b. Providing database installation, configuration, and upgrading database server software and related products, backup and recovery policies and procedures, database implementation, security, optimization, multi-domain operation, and performance management.

c. Supporting ElasticSearch, DynamoDB, cloud, and other technologies associated with data storage, processing, management, and use.

d. Supporting the migration/transition of database capability into cloud-based technologies and/or creation of interfaces between classic relational databases and key indexes to cloud-based columnar databases and map reduce index capabilities.

Benefits

Vacation – 5 weeks of paid vacation per year

· Holidays - Paid holidays published annually by the Office of Personnel Management, excluding Inauguration Day

· 100% paid for Health Benefits* (United Healthcare, Guardian Dental, VSP Vision, MetLife, Life and Disability Insurance and annual $1500 employer HSA contribution on qualified plans)

· 6% 401k Contribution

· Training Reimbursement – Approved training and education expenses will be reimbursed