PLEASE SUBMIT ONLY RESUMES, WITH CONTACT INFORMATION, CURRENT LOCATION, AND RATE CONFIRMATION TO AVOID FURTHER DELAY IN SUBMISSION.
JOB TITLE : PL SQL Developer DURATION : 03 Months LOCATION : Richmond VA * The client will do a stringent background check if you get selected. Job 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 Skills: Oracle SQL Development/Tuning 5 Years Oracle PL/SQL Development 9i, 10g 5 Years Data Modeling 1 Years Complex Schema Analysis 2 Years Oracle 10g/11g 2 Years Oracle Spatial 2 Years Oracle SQL Developer or Toad 2 Years Unix 2 Years ETL 1 Years Sareen Bhaskaran Resource Manager Prosoft Cyberworld Group 630-371-0530 ext 145 [email protected] YAHOO IM: sareen_prosoftcyberworld PLEASE MARK A CC TO [email protected] CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -- You received this message because you are subscribed to the Google Groups "Open Source J2EE frameworks" 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/open-source-j2ee-frameworks?hl=en.
