Jobs
>
Richmond

    Pl/Sql Developer - Richmond, VA, United States - Cyber Resource Provider LLC

    Cyber Resource Provider LLC
    Cyber Resource Provider LLC Richmond, VA, United States

    2 weeks ago

    Default job background
    Technology / Internet
    Description

    Role: VDOT System Analyst

    Job Id : 734662

    Positions : 1

    Location: RICHMOND, VA 23219

    Work mode: Hybrid

    Interview: Web Cam Interview Only

    DUE : 05/07

    Experience : 8+

    Client : -VDOT (Virginia Department of Transportation)

    Client State: Virginia

    *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 VDOT's 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.

    Pl/Sql Developer

  • Intellibee

    Pl/SQL Developer

    2 weeks ago


    Intellibee Richmond, United States

    **Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA · Understanding, replication, and technical documentation of Oracle SQL and PL/SQL code used in the VDOT TMS (Traffic Monitoring System). Traffic data analysis. · - generating traffic statis ...

  • LanceSoft, Inc.

    PL/SQL Developer

    1 week ago


    LanceSoft, Inc. Richmond, United States

    PL/SQL Developer · Looking for local Virginia PL/SQL resource · Experienced PL/SQL developer with skills in Oracle coding with 10 years · Must also have ability to do data analysis, develop requirements and data models. · Must have background in application backend support, Oracl ...

  • V-Soft Consulting Group

    PL/SQL Developer

    1 week ago


    V-Soft Consulting Group Richmond, United States

    PL/SQL Developer · Primary Location: Richmond, Virginia · V-Soft Consulting is currently hiring for a PL/SQL Developer for our premier client in Richmond, Virginia. · Education and Experience " Prior PL/SQL Development experience: 3 Years. · Data retrieval using SQL: 2 Years ...

  • Crescens

    PL/SQL Developer

    1 week ago


    Crescens Richmond, United States

    Title: PL/SQL Developer · Location: Richmond VA · Duration: 6+ Months · Type: Contract · Note:Local Richmond, VA candidates only · Long-Term position requires onsite 3 days a week at 1401 East Broad Street, Richmond VA · Contractor will be responsible for purchasing parking th ...

  • Serigor Inc

    PL SQL Developer

    2 weeks ago


    Serigor Inc Richmond, United States

    Job Title: · PL SQL Developer (Remote) · Location: · Richmond, VA · Duration: · 12+ Months · Job Description: · Seeking PL/SQL resource with object oriented concept to develop and incorporate business processes to produce various reports, data extractions, interfaces, schedul ...

  • eTek IT Services, Inc.

    PL/SQL Developer

    2 days ago


    eTek IT Services, Inc. Richmond, United States

    PL/SQL Developer · VA/hybrid · C2H Role · 7+ years of hands-on PL/SQL experience, and proven understanding of Relational Databases (Oracle Exadata 12c) · 5+ years hands-on experience in Python/Java, including the ability to code in more than one programming language. · Experien ...

  • V-Soft Consulting

    PL/SQL Developer

    1 week ago


    V-Soft Consulting Richmond, United States Contract

    PL/SQL Developer · Primary Location: Richmond, Virginia · V-Soft Consulting is currently hiring for a PL/SQL Developer for our premier client in Richmond, Virginia. · Education and Experience »Prior PL/SQL Development experience: 3 Years. · Data retrieval using SQL: 2 Years. · Te ...

  • GSK Solutions

    PL/SQL Developer

    2 weeks ago


    GSK Solutions Richmond, United States

    Job Description · Job DescriptionJob Title: PL/SQL Developer (Hybrid) · Location: Richmond, VA · Duration: 12+ Months · Job Type: Corp-Corp / 1099 / Contract W2 · Rate: $50/hr. on C2C · Interview Type: Webcam · Client: State of Virginia · Job Description: · Understanding, repli ...


  • Crescens Richmond, United States

    Job Title: Oracle PL/SQL Developer · Location: Richmond VA (Hybrid) · Duration: 12 +Months · Type: Contract · Notes: · *Local Richmond candidates or candidates willing to relocate to Richmond due to onsite work requirement · *Web Cam and ONSITE interviews · *Candidates ...


  • MSys Inc Richmond, United States

    Job summary: · Title: · Junior PL/SQL Developer · Location: · Richmond, VA, United States · Length and terms: · Long term - W2 or C2C · Position created on 05/04/2024 04:19 am · Job description: · ** Long term* Hybrid · **Please submit candidates who already live in Richmond, VA ...


  • Apollo Technology Solutions LLC Richmond, United States

    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 develope ...


  • Stellar Professionals Richmond, United States

    Job Description · Job DescriptionORACLE PLSQL DEVELOPER · Client is looking for a local candidate in Richmond, OH · Applicant must have 10 years of experience with the following: · Experience working with Oracle PL/SQL and SQL Server Database Development. · Written and oral co ...


  • HexaQuEST Global, Inc. Richmond, United States

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


  • InfiCare Technologies Richmond, United States

    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 applic ...


  • IPS Technology Services Richmond, United States

    Job Description · Job DescriptionJob title: Oracle PL/SQL Database Developer in Richmond, VA (HYBRID · On-site/Remote: On-site · Locals required: yes · must have · Oracle PL/SQL and SQL Server Database Developement 10+ years of experience · existing PL/SQL code to convert initia ...


  • V.L.S. Systems, Inc Richmond, United States

    Role: Sr PL/SQL Oracle Developer · Location: Hybrid | Richmond, VA · Duration: 12 Months · Interview: 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 int ...


  • InterSources Richmond, United States

    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 Orac ...


  • Intelligence and National Security Alliance Richmond, United States

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


  • IPS Technology Services Richmond, United States

    Job Description · Job DescriptionResponsibilities Required Skills: · *Experience working with Oracle PL/SQL and SQL Server Database Development. · *Background in data integration between business systems · *Write and maintain/extend existing PL/SQL code to convert initial data se ...

  • EDI Staffing

    SQL Developer

    2 weeks ago


    EDI Staffing Richmond, United States

    Looking for a candidate who is capable of writing complex SQL Code with expertise in writing stored procedures with expertise and experience working with T-SQL on a Microsoft SQL Server environment vs an oracle / postgres · Minimum of 5 years of SQL Development working with T-SQ ...