*Database Administrator w/Oracle Geometry Data - Direct Client **Immediate Interview and Start ASAP!!!*
*Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Job title: Database Administrator w/Oracle Geometry DataLocation: Lansing, MIDuration: 12 MonthsDirect Client PositionThe database that supports the Transportation Management System (TMS), is a large database holding information relative to Safety, Congestion, Pavement, Public Transportation, and Bridge management as well as other strategic functions for MDOT. The system and corresponding database were built during the 1990’s as a federally mandated development effort. Federal funds are received to enhance the database and it continues to grow in content to meet the needs of MDOT. In 2008, an effort was started to build a common repository for location-enabling assets owned by MDOT. This provided for the building of geospatial data and encourages the sharing of spatial and non-spatial data across all system development efforts. This requires some specialty skills beyond that of a standard Data Architect. The size of the database and ongoing enhancement activity due requires three staff members to support the needs of our customer, MDOT. The candidate must meet the basic qualifications of 8 or more years of generic IT experience as defined for a Sr Database Administrator. In addition, this position requires a concentration in database design, data transformation, writing geospatial queries, physical database modifications, writing stored procedures and other duties relating to Data Administration. Each senior candidate will score between 1 and the maximum possible for each category. a. More than 7 years experience developing conceptual, logical and physical data models (using data modeling software) including the facilitation of modeling sessions b. 5 years experience writing complex SQL statements including spatial queries using Oracle’s SDO_Geometry data type. c. More than 7 years experience with Data Definition Language (DDL) and Data Manipulation Language (DML) to physically change the database d. 5 years experience performing the function of extract-transform-load (ETL) using an automated tool e. 5 years experience using Oracle system utilities and DBMS packages to minimally generate dynamic SQL f. 3 years experience writing database stored procedures and functions using PL/SQLExperience Preferred Additional skills that are considered highly desirable (but not required) and may be used to supplement close scoring and assist in making a final selection are: Oracle Spatial Network and/or Topology Model Geographic Information Systems (GIS) & geodatabases Business Objects – Universe Definition Data Administration and Governance Object-Relational mapping TOAD software Dimensional database design Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * *Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com <s...@cncconsulting.com>* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.