Oracle SQL and PL/SQL DeveloperJob Location: Richmond, VAJob Type: Long-Term position requiring onsite 3 days a weekDuration: Possibly 24 monthsParking: Contractor is responsible for their own parkingPrimary Role: Understand, replicate, and document Oracle SQL and PL/SQL code used in VDOT TMSTask 1: Understand and document TMS tasks like generating traffic statistics, traffic factors, and federal reportsTask 1 Specifics: Shadow Senior Oracle Database Architect, observe work, take notes, validate results, and possibly create parallel non-Oracle SQL codeTask 2: Understand, replicate, and document other TMS modules like Payment and Link ManagementTask 2 Specifics: Work closely with Senior Oracle Database Architect and other traffic data professionalsTask 3: Understand data, perform data cleaning and preparation tasks, and conduct limited data analysis and visualizationMain Goal: Ensure documentation is complete, understandable, and up-to-date.