Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailPL/SQL Developer (734662)
Location Richmond VA 23219
Work Arrangement Hybrid
Duration: 12 Months
**Contractor will be responsible for purchasing parking through Parking Management Office or procuring their own parking
Understanding replication and technical documentation of Oracle SQL and PL/SQL code used in the (Traffic Monitoring System). Traffic data analysis.
Task 1: The contracted System Analyst candidate (Contractor) will understand replicate results and produce technical documentation for the procedures and processes that the Senior Oracle Database Architect/Engineer employs for various foundationaltasks of the TMS (Traffic Management System). Examples of these tasks are:
Some initial and possibly incomplete or outdated in some places documentation for the above processes already exists and will be shared with the Contractor. To fully understand the processes used for the tasks above the Contractor will shadow the Senior Oracle Database Architect/Engineer observe his work and take notes. The Contractor will be tasked with making sure that documentation is complete easy to understand and uptodate by working with both the Senior Database Architect/Engineer and the and users of these data sets such as Data Scientists and Architect/Engineers and Data Analysts. For replication the Contractor will run the Oracle scripts used to produce the above measures in a test environment and validate their results against the results from the production environment produced by the Senior Oracle Database Architect/Engineer. The Contractor will need to understand document and replicate the general procedures as well as the special/edge cases where a casebycase decision or human decision may be needed. The possibility of creating parallel nonOracle SQL code that connects to the Oracle database processes the data outside Oracle and writes it back to the Oracle database is preferable and will be offered to the Contractor.
Task 2: The Contractor will perform the same tasks (understand replicate results produce technical documentation) for other modules of the (Traffic Management System) the most important ones being Payment and Link Management. For this task the Contractor will work with the Senior Oracle Database Architect/Engineer and the Traffic Data Analysts Traffic Monitoring Systems Engineers and Engineering Techs who use these modules.
Task 3: For the successful completion of the above two tasks the Contractor will need at the minimum to understand the data perform some data cleaning and preparation tasks and conduct at least some limited data analysis and visualization.
Require/Desire Skills
Prior PL/SQL Development experience Required 3 Years
Data retrieval using SQL Required 2 Years
Technical writing Required 4 Years
Strong written communication skills especially for technical audiences Required 4 Years
Strong verbal communication skills especially when addressing technical audiences Required 4 Years
Ability to see the big picture and not get bogged down in the details Required 3 Years
Strong organizational skills Required 3 Years
Ability to work independently Required 3 Years
Ability to follow technical guidance from staff reporting to and working with Required 2 Years
Scripting/coding in a modern language such as Python (pandas numpy) or R. Working with dataframes. Highly desired 2 Years
Knowledge of relational database design. Highly desired 1 Years
Data Engineering skills (cleaning preparation validation) Highly desired 1 Years
Data analysis and visualization Highly desired 1 Years
Exposure to or (some) knowledge of transportation data skills or/and concepts Desired 1 Years
Please reach out to me at:
Full Time