PL/SQL Developer

4 weeks ago

Richmond, United States Logix Shapers Full time
Job DescriptionJob Description

PL/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:

  • 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 (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: moumita@logixshaper.com

  • Oracle PL/SQL Developer

    2 weeks ago

    Richmond, United States Apollo Technology Solutions LLC Full time

    Job Title: Oracle PL/SQL Developer Location: Richmond VA Duration: 1 Months (possibly 24 months)*** Candidates must be willing and able to work onsite 2 days/week for the fi rstcouple of weeks, and 1-2 days/week there after ***Job Description: Experienced PL/SQL developer with skills in Oracle coding Must also have ability to do data analysis, develop...

  • Oracle PL/SQL Developer

    2 weeks ago

    Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 19 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...

  • Oracle PL/SQL Developer

    1 week ago

    Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 17 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...

  • Oracle PL/SQL Developer

    6 days ago

    Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 14 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...

  • Oracle PL/SQL Developer

    5 days ago

    Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 13 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...

  • Oracle PL/SQL Developer

    3 days ago

    Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 11 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...

  • Oracle PL/SQL Developer

    2 days ago

    Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 10 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...

  • Oracle PL/SQL Developer

    1 day ago

    Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 9 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...

  • Oracle PL/SQL Developer

    16 hours ago

    Richmond, United States Collabera Full time

    Description Home Search Jobs Job Description Oracle PL/SQL Developer Contract to Hire: Richmond, Virginia, US Salary: $65.00 Per Hour Job Code: 349164 End Date: 2024-06-07 Days Left: 8 days, 3 hours left Apply Position Details: Industry Banking & Finance Work Location Richmond, VA/ Plano, TX/Charlotte, NC (Hybrid) Job Title Oracle PL/SQL Developer...

  • Sr PL/SQL Oracle Developer

    2 weeks ago

    Richmond, United States InfiCare Technologies Full time

    Position: Sr PL/SQL Oracle Developer Location: Richmond, VA (Hybrid Onsite) Mode: Contract (WX) *Experienced PL/SQL developer with skills in Oracle coding *Must also have ability to do data analysis, develop requirements and data models. *Must have background in application backend support, Oracle PL/SQL and MS SQL server development. *Must have background...

  • Sr PL/SQL Oracle Developer

    2 weeks ago

    Richmond, United States V.L.S. Systems, Inc Full time

    Role: Sr PL/SQL Oracle DeveloperLocation: Hybrid | Richmond, VADuration: 12 MonthsInterview: Phone/Skype+F2F Sr Oracle Database Developer*Local Richmond candidates or candidates willing to relocate to Richmond due to onsite work requirement*Web Cam and ONSITE interviews *Candidates must be willing and able to work onsite 2 days/week for the first couple of...

  • Oracle PL/SQL Database Developer

    5 days ago

    Richmond, United States Intelligence and National Security Alliance Full time

    Responsibilities Our client is looking for an Oracle Database Developer in Richmond, VA. If interested, please submit your resume ASAP indicating (1) current location (2) desired hourly rate, W2 or 1099? (3) Your email address. Required Skills: *Experience working with Oracle PL/SQL and SQL Server Database Development. *Background in data integration between...

  • Oracle PL/SQL Developer

    2 weeks ago

    Richmond, United States HexaQuEST Global, Inc. Full time

    Job Description: Responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. As part of the PTS/R technology team providing services to internal clients the duties and responsibilities include but are not limited to:...

  • Oracle PL/SQL Developer

    3 weeks ago

    Richmond, United States HexaQuEST Global, Inc. Full time

    Job Description: Responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. As part of the PTS/R technology team providing services to internal clients the duties and responsibilities include but are not limited to:...

  • Oracle PL/SQL Developer

    2 weeks ago

    Richmond, United States HexaQuEST Global Full time

    Job Description: Responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. As part of the PTS/R technology team providing services to internal clients the duties and responsibilities include but are not limited...

  • Oracle APEX Developer

    2 weeks ago

    Richmond, United States Crescens Full time

    Job Title: Oracle Apex Developer Location: Richmond, VA (Remote) Duration: 9+ months Contract *Although this is a remote position, the agency and hiring manager prefer local Richmond, VA candidates *please do not submit candidates who have been submitted to previous VDH Oracle APEX reqs Virginia Vital Events and Screening Tracking System (VVESTS) is a 24x7...

  • Oracle APEX Developer

    4 weeks ago

    Richmond, United States Crescens Full time

    Job Title: Oracle Apex Developer Location: Richmond, VA (Remote) Duration: 9+ months Contract *Although this is a remote position, the agency and hiring manager prefer local Richmond, VA candidates *please do not submit candidates who have been submitted to previous VDH Oracle APEX reqs Virginia Vital Events and Screening Tracking System (VVESTS) is a 24x7...

  • Sr.Oracle Database Developer

    6 days ago

    Richmond, United States Intelligence and National Security Alliance Full time

    Equinox Consulting Partners LLC is seeking an experienced Senior PL/SQL Developer with strong Oracle coding skills to join our team in Richmond, VA. The ideal candidate will have expertise in PL/SQL development, data analysis, requirements development, and data modeling. Additionally, experience in application backend support, building interfaces between...

  • Sr.Oracle Database Developer

    3 weeks ago

    Richmond, United States Equinox Consulting Partners LLC Full time

    Equinox Consulting Partners LLC is seeking an experienced Senior PL/SQL Developer with strong Oracle coding skills to join our team in Richmond, VA. The ideal candidate will have expertise in PL/SQL development, data analysis, requirements development, and data modeling. Additionally, experience in application backend support, building interfaces between...

  • Sr.Oracle Database Developer

    3 weeks ago

    Richmond, United States Equinox Consulting Partners LLC Full time

    Equinox Consulting Partners LLC is seeking an experienced Senior PL/SQL Developer with strong Oracle coding skills to join our team in Richmond, VA. The ideal candidate will have expertise in PL/SQL development, data analysis, requirements development, and data modeling. Additionally, experience in application backend support, building interfaces between...