JCL Database Developer

Position: JCL Database Developer

Location: VA (Remote)

Duration: Long term

Description:

One (1) Database Analyst/Programmer III with a bachelor’s degree in an information technology-related

field with a minimum of ten (10) years of experience as a developer (a master’s degree with at least three (3) years of experience is preferred). This individual must be able to design, implement and maintain complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. He/she

must demonstrate proficiency using programs, such as SAS, SQL, R, and Python. He/she must demonstrate the ability to maintain database dictionaries, monitor standards and procedures, and integrate 4 systems through database design. He/she must be competent to work at the highest level of all phases of database management.

SCOPE

Description of Work: PDHS will compare the health records of a cohort of MWDs that deployed to Southwest Asia, including those that deployed to OEF/OIF/OND, to the health records of a cohort of MWDs that did not deploy to that region. In collaboration with APHC, PDHS will receive the health and deployment records of all (approximately 3,000) deceased MWDs from the Department of Defense's Military Working Dogs Veterinary Service (DODMWDVS). The DODMWDVS will provide information from the MWD records, to include, but not limited to, clinical encounters, demographics, military service information, laboratory and pathology results, and the Permanent Change of Station/Temporary Duty (PCS/TDY) information for each MWD selected. These records may exist in both electronic and hardcopy, paper form. The Contractor will produce scanned PDFs of all paper records.

The Contractor will then abstract specific data from the military working dog records; these data will be: 1) missing data on current dogs in the database and, potentially, 2) data on deceased dogs that are not currently represented in the database. Monthly samples of abstracted data and their corresponding electronic files will be provided to the PDHS/APHC for review of accuracy and validation. APHC will provide the database that will be populated with the DODMWDVS records data. The Contractor will add abstracted data from the records to the database. The Contractor will also perform updates to the coding of the database to improve functionality and usability as appropriate. The Contractor shall provide the personnel and management necessary to support the transfer of data from the DODMWDVS to APHC via PDHS (who has an active research protocol with DODMWDVS), and subsequent abstraction and management through the use of a Microsoft Access database. APHC will provide equipment, a workstation, and onsite support for both members of the contract team. PDHS will oversee all aspects of the contract and will receive an export of the final database upon completion of the services