Hello,
Greeting’s This is Prasad from Softtrans Inc., We have an urgent position open for *Senior Oracle PL/SQL Developer* position at *VA*. Reply to pras...@softtrans.net or prasadg.softtr...@gmail.com * * *Title: Senior Oracle PL/SQL Developer* *Location: Richmond, VA* *Duration: 3+ months* *Rate: Max $40/hr CTC or 1099 all inclusive* *In-person interview required after phone screen* Sr Consultant 1 - PL SQL Developer *Complete Description: * 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 ***local candidates strongly preferred **personal interviews required* * Required / Desired Skills* [image: https://vms.peopleclick.com/images/shim.gif] *Skill* *[image: https://vms.peopleclick.com/images/white.gif]* *Required / Desired* *[image: https://vms.peopleclick.com/images/white.gif]* *Amount of Experience* Oracle SQL Development/Tuning [image: https://vms.peopleclick.com/images/white.gif] Required [image: https://vms.peopleclick.com/images/white.gif] 5 Years Oracle PL/SQL Development 9i, 10g [image: https://vms.peopleclick.com/images/white.gif] Required [image: https://vms.peopleclick.com/images/white.gif] 5 Years Data Modeling [image: https://vms.peopleclick.com/images/white.gif] Required [image: https://vms.peopleclick.com/images/white.gif] 1 Years Complex Schema Analysis [image: https://vms.peopleclick.com/images/white.gif] Highly desired [image: https://vms.peopleclick.com/images/white.gif] 2 Years Oracle 10g/11g [image: https://vms.peopleclick.com/images/white.gif] Highly desired [image: https://vms.peopleclick.com/images/white.gif] 2 Years Oracle Spatial [image: https://vms.peopleclick.com/images/white.gif] Highly desired [image: https://vms.peopleclick.com/images/white.gif] 2 Years Oracle SQL Developer or Toad [image: https://vms.peopleclick.com/images/white.gif] Highly desired [image: https://vms.peopleclick.com/images/white.gif] 2 Years Unix [image: https://vms.peopleclick.com/images/white.gif] Desired [image: https://vms.peopleclick.com/images/white.gif] 2 Years ETL [image: https://vms.peopleclick.com/images/white.gif] Desired [image: https://vms.peopleclick.com/images/white.gif] 1 Years -- Best Regards Sai Prasad Software Transformations Inc. 3245, Main Street Suite 235 326,FRISCO, TX 75034 Tel: (732) 218-7554 Fax: Fax: (732)909-2223 Email: pras...@softtrans.net | prasadg.softtr...@gmail.com gTalk:prasadg.softtr...@gmail.com <gtalk%3aprasadg.softtr...@gmail.com> | YIM: prasad548 http:/www.softtrans.net -- You received this message because you are subscribed to the Google Groups "Oracle Users" group. To post to this group, send email to oracle-us...@googlegroups.com. To unsubscribe from this group, send email to oracle-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracle-users?hl=en.