*Oracle Developer w/GIS - In person interview- **Direct Client*
*Immediate Interview and Start ASAP!!!*



*Please send resume to **s...@cncconsulting.com <s...@cncconsulting.com>*

Job Title: Oracle Developer w/GIS

Location: Lansing, MI

Duration: 12 Months

Direct Client Position

Client: State of MI

In person interview



MDOT is in need of an Oracle Database Developer. They are currently working
with Oracle 11g. This position requires a concentration in database design,
data transformation, writing geospatial queries, physical database
modifications, writing stored procedures and other duties related duties.



Responsibilities in this role include, but are not limited to, developing
conceptual, logical and physical data models (using data modeling software)
including the facilitation of modeling sessions. They will be writing
complex SQL statements including spatial queries using Oracle’s
SDO_Geometry data type. They will be using Data Definition Language (DDL)
and Data Manipulation Language (DML) to physically change the database. The
resource will be performing the function of extract-transform-load (ETL)
using automated tools and will be using Oracle system utilities and DBMS
packages to minimally generate dynamic SQL. The resource will also be
writing database stored procedures and functions using PL/SQL.



Establishes physical data base parameters. Codes data base descriptions and
specifies identifiers of data base to data base management system or
directs others in coding data base descriptions. Specifies user access
level for each segment of one or more data items, such as insert, replace,
retrieve, or delete data. Specifies which users can access data bases and
what data can be accessed by user. Tests and corrects errors, and refines
changes to data base. Enters code to create production data base. Selects
and enters codes of utility program to monitor data base performance, such
as distribution of records and amount of available memory.  Directs
programmers and analysts to make changes to data base management system.
Reviews and corrects programs. Answers user questions. Confers with
coworkers to determine impact of data base changes on other systems and
staff cost for making changes to data base. Modifies data base programs to
increase processing performance, referred to as performance tuning. Workers
typically specialize in one or more types of data base management systems.
May train users.



Developing conceptual, logical and physical data models (using data
modeling software) including the facilitation of modeling sessions
Required7Years

Oracle 11g Required2Years

Experience writing SQL statements Required5Years

Experience with Data Definition Language (DDL) and Data Manipulation
Language (DML) to physically change the database Required7Years

Experience performing Extract-Transform-Load (ETL) using an automated tool
Required7Years

Experience using Oracle system utilities and DBMS packages to minimally
generate dynamic SQL Required5Years

Experience writing stored procedures and functions using PL/SQL
Required3Years



Desired Skills.

Experience writing spatial queries using Oracle’s SDO_Geometry data type
Desired

Experience with Oracle Spatial Network and/or Topology Model Desired

Experience with Geographic Information Systems (GIS) & geodatabases Desired

Experience with Business Objects Desired

Data Administration and Governance experience Desired

Object-Relational mapping experience Desired

Experience with TOAD software Desired

Dimensional database design experience Desired

IBM Datastage experience Desired

Experience using Safe FME for data conversion Desired

Experience with ESRI ArcGIS Desired

Experience with at least 2 other projects with changing/fluid requirements;
state government experience a plus Highly desired





*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 
"Peoplesoft Security Administrator" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to peoplesoft-security-administrator+unsubscr...@googlegroups.com.
To post to this group, send email to 
peoplesoft-security-administrator@googlegroups.com.
Visit this group at 
https://groups.google.com/group/peoplesoft-security-administrator.
For more options, visit https://groups.google.com/d/optout.

Reply via email to