Oracle PL/SQL Analyst
Job Posting for Oracle PL/SQL Analyst at Kapital Data Corp
Job Details
Title: Oracle PL/SQL Analyst (Hybrid)
Duration: 24 Months
Location: Richmond, VA
**Please submit candidates who already live in Richmond, VA
**Long-Term position requires onsite 3 days a week
**Assignment to be extended beyond 6/30, possibly 24 months
About the role:
Task 1: Understand, replicate results, and produce technical documentation for the procedures and processes that the Senior Oracle Database Architect/Engineer employs for various foundational tasks 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)
Task 2: The candidate will perform the same tasks (understand, replicate results, produce technical documentation) for other modules of the client's TMS (Traffic Management System), the most important ones being Payment, and Link Management. For this task, the candidate 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: the candidate 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 | Required / Desired |
| Prior PL/SQL Development experience | Required |
| Data retrieval using SQL | Required |
| Technical writing | Required |
| Strong written communication skills, especially for technical audiences | Required |
| Strong verbal communication skills, especially when addressing technical audiences | Required |
| Ability to see the big picture and not get bogged down in the details | Required |
| Strong organizational skills | Required |
| Ability to work independently | Required |
| Ability to follow technical guidance from VDOT staff reporting to and working with | Required |
| Scripting/coding in a modern language such as Python (pandas, numpy) or R. Working with data frames. | Highly desired |
| Knowledge of relational database design. | Highly desired |
| Data Engineering skills (cleaning, preparation, validation) | Highly desired |
| Data analysis and visualization | Highly desired |
| Exposure to or (some) knowledge of transportation data, skills, or/and concepts | Desired |
Sign up to receive alerts about other jobs that are on the Oracle PL/SQL Analyst career path.
Click the checkbox next to the jobs that you are interested in.
Sign up to receive alerts about other jobs with skills like those required for the Oracle PL/SQL Analyst.
Click the checkbox next to the jobs that you are interested in.
-
Brand Management Skill
-
Income Estimation: $59,288 - $79,191
-
Income Estimation: $64,867 - $82,481
-
-
Branding Skill
-
Income Estimation: $58,192 - $76,453
-
Income Estimation: $62,649 - $86,924
-
Job openings at Kapital Data Corp
Washington, DC
Full Time
Colorado, CO
Full Time
Richmond, VA
Full Time
Richmond, VA
Full Time
Not the job you're looking for? Here are some other Oracle PL/SQL Analyst jobs in the Richmond, VA area that may be a better fit.
We don't have any other Oracle PL/SQL Analyst jobs in the Richmond, VA area right now.
Oracle Solutions of VA, Chesterfield, VA
Oracle Integration Cloud (OIC)
Kapital Data Corp, Richmond, VA