Hi,
Please let me know if you have consultants available for below req!!! Role : Oracle PL/SQL developer ideally with experience with SPATIAL data such as with GIS applications. Start Date: 3/15/2010 Duration: 3+ months (to 6/30/2010 then renewable) Location: Richmond, VA **local candidates strongly preferred **personal interviews required Rate : Open Complete Description: VDOT Senior Consultant 1 - PL SQL Developer Experienced PL/SQL Oracle Database Developer to convert and validate mainframe/legacy system data in a Spatial/GIS environment. Will write and maintain/extend existing PLSQL code to convert initial data sets, system enhancements, reports production, and improved transaction editing. Complete Description: . Develop database packages, procedures, functions, and queries to load and maintain Roadway Network System and supported systems. Emphasis on system interoperability, associating road edge vectors with tables defining route/street paths and intersections, and production-quality periodic load/import and problem diagnosis. . Generate edit lists where manual route associations are required. . Archive changes to a historical database. . Archive changes for synchronization with external databases. . Changes in route and street paths will cause cascading changes to events associated with route/street paths. Procedures will be developed to migrate these changes or notify business users based on type of edit and business rules. . Develop procedures to populate and update a separate de-normalized database for reporting purposes from the transaction database. Requirements: . Expert skills developing complex PLSQL Oracle database packages, procedures, functions and triggers (Min 3 yrs experience). . Expert skills with Oracle 9i, 10g development . Experience with advanced PL/SQL commands, especially Analytic functions . Experience with designing transactional and reporting databases . Experience with linking DOT NET Web Service requests and updates to database procedures . Experience with ETL tools and methodologies . Some experience with using XML for Web Applications . Some experience with Crystal Reports reporting tools . Some experience using ESRI ArcSDE and/or Oracle Spatial preferred, but not required Skill Req'd / Des'd Amount of Exp Oracle SQL Development/Tuning Required 5 Years Oracle PL/SQL Development 9i, 10g Required 5 Years Data Modeling Required 1 Years Complex Schema Analysis Highly desired 2 Years Oracle 10g/11g Highly desired 2 Years Oracle Spatial Highly desired 2 Years Oracle SQL Developer or Toad Highly desired 2 Years Unix Desired 2 Years ETL Desired 1 Years Thank you for your time and have a great day! Sandeep V Technical Recruiter Aim Computer Consulting <mailto:[email protected]> [email protected] [email protected] <http://www.aim-cc.com/> www.aim-cc.com cid:[email protected] Note: If your consultant's resume matches with our requirement, My BDM will contact you soon. Thanks for your efforts. Note: This is not an unsolicited mail. If you are not interested in receiving our e-mails then please click "Remove" -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
<<image001.jpg>>
