*please send resumes to pra...@mncl.net* *Need ASAP...Thanks a lot*
*Oracle Developer: * *Location:* Richmond, VA *Duration:* 3+ Months *Rate: *Open *Specific Duties and Responsibilities * Need Oracle PL/SQL developer ideally with experience with SPATIAL data such as with GIS applications. *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 ** Local candidates strongly preferred ** Personal interviews required - Oracle SQL Development/Tuning - Oracle PL/SQL Development 9i, 10g - Data Modeling - Complex Schema Analysis - Oracle 10g/11g - Oracle Spatial - Oracle SQL Developer or Toad - Unix - ETL * * * Regards, Prasad MNCL, Inc. Technical Recruiter 9810 E. 42nd Street, Suite 223, Tulsa, OK 74146 Contact:877-999-6625 Ext:212 918-398-9548(Dir) E Mail: pra...@mncl.net URL: http://www.mncl.net. * * * * * -- You received this message because you are subscribed to the Google Groups "IT provider" group. To post to this group, send email to it-provi...@googlegroups.com. To unsubscribe from this group, send email to it-provider+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/it-provider?hl=en.