Database Specialist-Geotechnical Focus

Job Description

This is a full-time advanced level position involving technical work with a highway materials testing application. This position maintains portions of the MAC (Materials Acceptance and Certification) system and performs advanced database functions. The position requires a highly motivated and organized employee to create customized entries while ensuring the system is consistent across materials and technical areas. Strong computer skills and experience in Microsoft programs such as Visual Studio, SQL Server Management Studio, Access, and Excel are required. Prior experience working with relational database management system (RDBMS), along with proficiency in visual basic, Structured Query Language (SQL), SQL Server Reporting Services (SSRS), and business Intelligence tools and concepts are preferred. This position will be working with the Materials Program Performance Section. It is an in-office position with no option for remote work.

Role and Responsibilities

Specific duties for the Database Information Section include the following :

• Develops and maintains MAC Specifications for the Geotechnical Materials Program
• Creates, revises and maintains Geotechnical Materials Program test definitions including targets and limits, and other sampling and testing requirements
• Data processing using appropriate software, storage, and analysis; and prepares detailed engineering reports on findings
• Works to ensure the test definitions, comparison definitions, evaluation checklists and inspection checklists are up to date while ensuring the system is consistent
• Assists the Quality Systems unit with database and reporting development and maintenance
• Assists the Database Information Team in data compilation and analysis.
• Troubleshoots issues with data, uploads, and application programming
• Assists with FDOT Service Desk tickets pertaining to MAC
• Assesses MAC access requests and ensures they are processed by the appropriate District Application Coordinator
• Assists with programming enhancements to MAC in compliance with the Office of Information Technology’s application development standards
• Assists with State Materials Office SharePoint development and maintenance including Power Apps

Qualifications and Education Requirements

High school diploma, or equivalent.

Strong computer skills and experience in Microsoft programs such as Visual Studio, SQL Server Management Studio, Access, and Excel are required. Prior experience working with relational database management system (RDBMS), along with proficiency in visual basic, Structured Query Language (SQL), SQL Server Reporting Services (SSRS), and business Intelligence tools and concepts are preferred.

Preferred Skills

Demonstrates strong communication, technical writing, and interpersonal skills

Demonstrates experience in data entry and quality review

Additional Notes

40 hours / week

Schedule : Monday-Friday, 8 : 00 AM- 5 : 00 PM