Jobs
>
Richmond

    PL/SQL Developer - Richmond, United States - Crescens

    Crescens
    Crescens Richmond, United States

    14 hours ago

    Default job background
    Description

    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 through VDOT's Parking Management Office or procuring their own parking


    Job Description:
    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.

    Required/Desired Skills

    Prior PL/SQL Development experience

    Data retrieval using SQL

    Technical writing

    Strong written communication skills, especially for technical audiences

    Strong verbal communication skills, especially when addressing technical audience

    Ability to see the big picture and not get bogged down in the details

    Strong organizational skills

    Ability to work independently

    Ability to follow technical guidance from VDOT staff reporting to and working with

    Scripting/coding in a modern language such as Python (pandas, numpy) or R. Working with dataframes.

    Knowledge of relational database design

    Data Engineering skills (cleaning, preparation, validation)

    Data analysis and visualization

    Exposure to or (some) knowledge of transportation data, skills, or/and concepts
  • 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 ...

  • eTek IT Services, Inc.

    PL/SQL Developer

    3 weeks 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 Group

    PL/SQL Developer

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

  • Collabera

    Oracle PL/SQL Developer

    2 weeks ago

    Collabera Richmond, United States

    Home · Search Jobs · Job Description · Oracle PL/SQL Developer · Contract to Hire: Richmond, Virginia, US · Salary: $65.00 Per Hour · Job Code: · End Date: · Days Left: 11 days, 3 hours left · Apply · Position Details: Industry Banking & Finance · Work Location Richmond ...

  • Intellibee

    Pl/SQL Developer

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

  • Saxon Global

    APEX PL/SQL Developer

    4 days ago

    Saxon Global Richmond, United States

    This contractor will perform development activities aimed to implement new requirements and improve the existing application by aiding with the migration from Designer to Apex 19.2, and any other future migrations. · Professional experience working with Web based applications us ...

  • Collabera

    Oracle PL/SQL Developer

    2 weeks ago

    Collabera Richmond, United States

    Home · Search Jobs · Job Description · Oracle PL/SQL Developer · Contract to Hire: Richmond, Virginia, US · Salary: $65.00 Per Hour · Job Code: · End Date: · Days Left: 10 days, 3 hours left · Apply · Position Details: Industry Banking & Finance · Work Location Richmond ...

  • Apollo Technology Solutions LLC

    Oracle PL/SQL Developer

    3 weeks ago

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

  • Crescens

    Oracle PL/SQL Developer

    3 weeks ago

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

  • Intelligence and National Security Alliance

    Oracle PL/SQL Database Developer

    3 weeks ago

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

  • InterSources

    Oracle PL/SQL Database Developer

    3 weeks ago

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

  • V.L.S. Systems, Inc

    Sr PL/SQL Oracle Developer

    3 weeks ago

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

  • InfiCare Technologies

    Sr PL/SQL Oracle Developer

    3 weeks ago

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

  • Saxon Global

    SQL BI Developer

    2 weeks ago

    Saxon Global Richmond, United States

    SQL BI Developer · **Onsite in Richmond, VA Tuesday/Wednesday; Remote Monday, Thursday, Friday** · Scope: · Team is seeking an experienced SQL/BI Developer with strong database, programming, and analytical skills to actively participate in the following scope of work: · Assis ...

  • Target Labs

    sql server developer

    5 days ago

    Target Labs Richmond, United States

    We need candidates who have strong stored procedure and SQL background. · Job Description: · - Strong SQL SERVER developer with good stored procedure , Function, Triggers and SQL skills. · - Responsible for the Analysis, design, development of analytical data constructs/structure ...

  • Resource Informatics Group

    Net/SQL Server Developer

    14 hours ago

    Resource Informatics Group Richmond, United States

    .Net/SQL Server Developer · Richmond, VA - Hybrid - Locals only · C# .NET · SQL Server SQL Stored Procedures and SSIS packages) · Java Script/JQuery · Very good communication skills and documentation skills · .NET Core - 5 + years · Azure/TFS Automation · Power Platform ...

  • HS Solutions Inc

    Senior Oracle Database Developer

    2 days ago

    HS Solutions Inc Richmond, United States

    Job Description: · Looking for two Sr. PL/SQL Oracle Database Developers in Downtown Richmond. Must be willing and able to work onsite two days a week for the first couple of weeks, and then one to two days a week thereafter. Assignment expected to last 12-24 months. · Requiremen ...

  • Equinox Consulting Partners LLC

    Database Developer

    5 days ago

    Equinox Consulting Partners LLC Richmond, United States

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

  • HS Solutions Inc

    Senior Full Stack Java consultant

    4 weeks ago

    HS Solutions Inc Richmond, United States

    Location:- 7700 Midlothian Turnpike, Richmond, VA · Job Description:- · candidate MUST be comfortable working onsite 100% now · We are looking for a Senior Full Stack Java consultant to assist with design, development and support of complex Java/JEE programs. · -A minimum of 5 y ...

  • Commonwealth of Virginia

    CO - P4592 - Business Intelligence/Data Integration Specialist

    1 week ago

    Commonwealth of Virginia Richmond, United States

    Job Duties · The Virginia Department of Environmental Quality is seeking a detail-oriented self-starter to serve as a data analyst/integration specialist to assist the agency in maximizing the value of its data in accomplishing our mission. The primary role for this position will ...