Home

PL/SQL Developer @ Richmond ,VA -only locals at Richmond, Virginia, USA
Email: [email protected]
Hello
,

Hope you doing great.

Please go through the JD and
send resumes to [email protected]

PL/SQL Developer

1401 E Broad St Richmond VA 23219-Need locals

Web Cam Interview Only

Hybrid

**Please submit candidates who already live in Richmond, VA

**Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA

**Assignment to be extended beyond 6/30, possibly 24 months

**Contractor will be responsible for purchasing parking through VDOTs Parking Management Office or procuring their own parking

Understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the VDOT TMS (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:

generating traffic statistics such as AADTs (Average Annual Daily Traffic), MADW (Monthly Average Day of Week Traffic), DVMT (Daily Vehicle Miles Traveled)

generating different traffic factors (seasonal, growth, day of week, hourly, K-factor, directional, classification, etc.) that are used to estimate the above statistics when/where not enough data is available

generating mandated federal reports such as HPMS submittals (Highway Performance Monitoring System)

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 up-to-date 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 case-by-case decision or human decision may be needed. The possibility of creating parallel non-Oracle 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 VDOT TMS (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.

Skill

Years Used

Last Used

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 VDOT 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

Question 2

Please list candidate's email address.

Question 3

In what city/state does your candidate PERMANENTLY reside

Question 4

Does your candidate agree to work onsite 3+ days per week, as determined by mgr This is REQUIRED.

Question 5

How soon after an offer can your candidate start

S. LEELA

MADHURI

US IT RECRUITER

Tel:
703-831-8282 Ext.
2518

Email: [email protected]

linkedin.com/in/leela-madhuri-10ab66258

--

Keywords: rlang information technology golang procedural language Virginia
PL/SQL Developer @ Richmond ,VA -only locals
[email protected]
[email protected]
View all
Thu May 02 01:24:00 UTC 2024

To remove this job post send "job_kill 1359684" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 3

Location: ,