*Oracle PL/SQL Developer* *Location: Richmond, VA*
*Duration: 3 Months* *Rate: DOE* * * ***local candidates strongly preferred*** ***personal interviews required*** * * · *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 Required / Desired Amount of Experience* *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 and have a great day,* * * *Kavita Singh* *Sr. Technical Recruiter*** *|*Saras America Incorporated | 38345 W.10 Mile Road, Suite 300, Farmington Hills MI 48335 | 248.489.8484 x 957 | Fax: 248.489.8585 *kavi...@sarasamerica.com* ||www.sarasamerica.com Certified Minority-Owned Enterprise -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To post to this group, send email to oracle...@googlegroups.com. To unsubscribe from this group, send email to oracled2k+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracled2k?hl=en.