ATTACHMENT J.3 LCAT DESCRIPTIONS.pdf

Labor Category and Rates table

Description of Labor Categories are provided below. Note that 3 persons should be identified as Key Personnel:

• Project Manager (PM) – 1 person

• Senior Civil Engineer – 1 person

• Senior Database Engineer – 1 person

Rate table shall include loaded hourly rates for all the 5 years during the contract.

No Labor Category

1 Project Manager (PM) Responsible for administration and management of the Contract, including coordinating time and travel for the contract personnel. Responsible for submission of all task order proposals, progress and required reports, and all other contract and task order deliverables. The PM shall assume the initiative and be the point of technical and administrative contact between the Government and the Contractor and shall be responsible for the successful completion of all work required under this contract. The PM shall have good experience in most task areas and knowledge of all the task areas described in this RFP, and have a minimum of a B.S. degree in Engineering (or equivalent), a Master’s Degree in Engineering or Management (or equivalent), and 15 years of related experience, 5 of which should be in a management role on large research contracts. Excellent organizational and communication skills are required.

2 Senior Civil Engineer Shall be the primary engineering lead for at least one of the main Task Areas as described in this RFP, namely validating and analyzing the LTPP Data and InfoPave, LTBP Data and InfoBridge, and Other Highway Infrastructure Research Data. The Senior Engineer shall have a Master’s Degree in Civil Engineering or equivalent with relevant experience in his/her assigned area(s). Senior Engineer shall have a minimum of 10 years of relevant experience with a Master's Degree in Engineering, or 5 years of relevant experience and a Ph.D.

3 Project Civil Engineer Shall work on at least one of the main Task Areas as described in this RFP, namely LTPP Data and

InfoPave, LTBP Data and InfoBridge, and Other Highway Infrastructure Research Data. Shall have a Bachelor’s Degree in Civil Engineering or equivalent technical experience. Project Engineer shall have a minimum of 8 years of relevant experience with a Bachelor’s Degree or a minimum of 5 years of relevant experience and a Master's Degree in Engineering or higher, or a Ph.D in Civil Engineering.

4 Staff Civil Engineer Shall work on at least one of the main Task Areas as described in this RFP, namely LTPP Data and

InfoPave, LTBP Data and InfoBridge, and Other Highway Infrastructure Research Data. Staff Engineer shall have a Bachelor’s Degree in Civil Engineering or equivalent technical experience. Staff Engineer shall have a minimum of Bachelor’s Degree in Engineering and 1 year of experience or entry level with a Master's Degree in Engineering.

5 Highway Engineering Data Analyst Responsible for developing infrastructure engineering research related datasets, such as the LTPP, LTBP, asphalt and concrete testing laboratory data and providing database support to the datasets QC/QA process. The Highway Engineering Data Analyst shall have a multi-faceted background in a combination of engineering and computational/database fields. Their engineering background is in civil engineering, transportation engineering, or related field. Shall have experience with computational statistics, data analysis, relational database, computational science, or other related fields. Shall have a minimum of 10 years of relevant experience with a Bachelor's Degree in Engineering, or equivalent.

6 Subject Matter Expert (SME) The Subject Matter Expert (SME) provides expert guidance and support for the technical work under this contract in engineering and research. The SME is a nationally recognized authority in the designated areas of expertise outlined in the SOW, offering advanced knowledge and insight to ensure high-quality, informed decision-making and execution throughout the project.

7 Senior Database Engineer Provides technical and database administrative support for the LTPP and LTBP programs, and other relevant infrastructure research databases. The Senior Database Engineer shall have at least 8 years of experience in database design, data warehousing, data modeling, administration, database programming, and data validation and processing. Responsibilities include performance tuning, implementing backup and recovery strategies, automating database deployment and migration, ensuring database security, and supporting compliance with data governance and regulatory standards. Proficiency in commonly used database technologies and tools, including Oracle RDBMS and Microsoft SQL Server, is required, along with familiarity with modern cloud-based database services. The Senior Database Engineer must possess in-depth knowledge of the applicable Task Areas described in the RFP. A minimum of a Bachelor’s Degree in Computer Science, Mathematics, Engineering, or a related technical field, and at least 8 years of relevant experience, is required.

8 Database Engineer Provides technical and database administrative support for the LTPP and LTBP programs, and other relevant infrastructure research databases. The Database Engineer shall be familiar with database programming, administration, modeling, and data processing concepts using Oracle and Microsoft SQL Server databases and supporting tools. Responsibilities include supporting the design, implementation, and maintenance of high-performing, scalable database systems with large data storage requirements;

assisting with database monitoring, data validation, query optimization, backup and recovery procedures, and ensuring data integrity; and participating in the automation of routine administrative tasks. The Database Engineer must have a minimum of a Bachelor’s Degree in Computer Science, Mathematics, Engineering, or a related technical field, and at least 3 years of relevant experience.

9 Senior Software Developer Provides services for the design, development, and implementation of computer software solutions, including web-based, cloud-native, and desktop systems. The Senior Software Developers possess experience designing, developing, and maintaining scalable, enterprise-grade application architectures utilizing .NET technologies and modern software development frameworks. Expertise includes advanced relational database programming and optimization with systems such as Microsoft SQL Server and Oracle® and supporting software. Responsibilities encompass end-to-end DevOps practices, and application deployment using cloud platforms such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform (GCP). Senior Software Developers also provide architectural guidance, technical leadership, code quality oversight, and collaboration with cross-functional teams following Agile or DevSecOps methodologies. Requires a minimum of a Bachelor’s Degree in Computer Science, Software Engineering, or a related technical field, and at least 8 years of relevant software development experience.

10 Software Developer Provides services for the design and development of computer software, including web-based and desktop systems. The Software Developer should have demonstrated experience in developing software applications and a solid understanding of software architecture principles. Must have experience with web and/or desktop application development using .NET technologies and be familiar with relational databases such as Microsoft SQL Server and Oracle®. Experience with basic DevOps tasks, including application deployment and configuration using cloud hosting platforms such as Amazon Web Services (AWS) or Microsoft Azure, is preferred. A minimum of a Bachelor’s Degree in Computer Science (or equivalent technical discipline) and at least 3 years of relevant experience is required.

11 Media Specialist/Editor Assists with outreach and communications activities, including graphic design, layout, and production of brochures, flyers, pamphlets, briefings, posters, displays, video and website layouts. Shall create presentations, including graphics, charts, photos, and clip-art using different graphic software. May also apply writing and editing skills to the development of specifications, training, operating, or maintenance manuals. Shall have experience with Section 508 compliance. Shall have Bachelor's degree in English, Media, or equivalent degree with at least 2 years of experience.

12 Project Support Staff Provides support to the technical and management-level personnel. This includes, but is not limited to, documentation planning and support, project administration, buying goods, event planning and administration, Section 508 compliance, data input, etc. Three years of experience minimum.