*Please respond to [email protected] <[email protected]>* Oracle PL/SQL Developer
Location: Lansing, MI Duration: 12+ months Required skills include database design & enhancements, Oracle geodatabase, spatial data editting & query (ORACLE w/ ArcSDE), lead worker & facilitation, writing stored procedures (PL/SQL), advanced SQL & tuning including spatial queries, data transformations and metadata management. The resource will report to the Asset Management IT Manager. This position * prefers a Bachelor's Degree in Computer Science, Information Systems, or other related field, or equivalent * work experience and requires 7 to 10 years of IT work experience. * Requires prior management, supervisory, or team leader experience. * The resource needs strong Oracle PL/SQL work experience writing packages, stored procedures and functions, writing and tuning advanced SQL statements including geospatial queries, and experience with ESRI products accessing and/or editing an Oracle geodatabase. * The resource should also have relational database design experience, perform data transformations & analysis and ensure data quality through development and testing. * The need will exist to lead database development projects and train new SOM staff on database fundamentals. The candidate must meet the basic qualifications of 10 or more years of generic IT experience and a Bachelor's Degree as defined for a Technical Consultant. In addition, this position requires a concentration in database design, data transformation, writing Oracle geospatial queries, database and spatial data modifications, accessing Oracle from ESRI products, writing stored procedures and other duties relating to data management. Each senior candidate will score between 1 and the maximum possible for each category. Points will be determined from review of the experience section NOT from the "Summary" area of a resume. * 10 years writing ORACLE DDL, DML, packages, stored procedures (PL/SQL) and functions * 4 years in the query and/or editing of geospatial data in an ORACLE database using the ESRI product, ArcSDE. (ArcExplorer, ArcIMS) * 8 years developing conceptual, logical and physical data models (using data modeling software) for an RDBMS * 8 years accepting data files in multiple formats, transforming the data to meet business needs and loading it into an ORACLE database * years as a technical team leader for projects involving extensive database work and data manipulation * Possess ORACLE DBA Certification Additional skills that are considered highly desirable (but not required): Oracle Spatial Network and/or Topology Model experience ESRI ARC*GIS 10 desktop/server Business Objects - Universe Definition This position prefers a Bachelor's Degree in Computer Science, Information Systems, or other related field. *Thanks and Regards* *Lisa,* TechnoTalent 707 Alexander Rd. 208, Princeton, NJ 08540 [email protected] <[email protected]> T:732-230-4500 www.technotalent.com -- You received this message because you are subscribed to the Google Groups "US_IT_ Jobs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/chandrakants. For more options, visit https://groups.google.com/groups/opt_out.
