ITB# : 071I2200009
Oracle DBA with data modeling, DDL/DML, ETL, PL/SQL, Oracle Spatial Network and/or Topology Model experience
Location: Lansing, MI
Duratin: 1-3 years
Positions: 1
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. Points will be determined from review of the experience section NOT from the “Summary of Skills” area of a resume or application.
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/SQL
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
No comments:
Post a Comment