Jobs
>
Richmond

    PL/SQL Developer - Richmond, United States - GSK Solutions

    GSK Solutions
    GSK Solutions Richmond, United States

    1 month ago

    Default job background
    Description

    Job Description

    Job Description

    Job 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, 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 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)

    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 Matrix

    Skill

    Required /Desired

    Amount

    of Experience

    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

    Recruiter Details:

    Recruiter Name: Lokesh at gsksolutions dot com

    Contact Number: Eight three two- Nine nine zero - Two four two six

    About GSK Solutions Inc:

    GSK Solutions Inc is a leading information technology (IT) Services Company that specializes in providing complete consulting solutions and staff augmentation to its clients. We provide on-time, on-budget, and quality service to our clients and consistently meet their expectations. We are known for our superior execution on a sustained basis.

    GSK has been in the business of providing both commercial and custom product development services, including, Information Security, Software Development, Consulting and IT Audit. GSK implements highly critical and time-sensitive projects for their Fortune 500 clients located across the country.

  • V-Soft Consulting

    PL/SQL Developer

    2 weeks 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

    4 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

    3 days 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

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

  • 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

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

  • Saxon Global

    APEX PL/SQL Developer

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

  • HexaQuEST Global, Inc.

    Oracle PL/SQL Developer

    1 hour ago

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

  • Crescens

    Oracle PL/SQL Developer

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

  • 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

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

  • Intelligence and National Security Alliance

    Oracle PL/SQL Database Developer

    4 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

    4 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

    4 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

    4 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

    3 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

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

    3 days 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

    5 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

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