Hi,
Please let me know if you have anyone available for the below mentioned position of Oracle Developer in GIS Environment at Richmond, VA (Face to Face Interview) *Position Title* – Oracle Developer in GIS Environment *Location* – Richmond, VA (Face to Face Interview) *Duration* – 3 Months *Pay Rate* – $55/hour (All Inclusive on C2C) *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 Status Required Present 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 -- Thanks Shivendra iBusiness Solution LLC Phone: 412-894-1929 Email: [email protected]
