Senior Oracle DB Developer – ETL, GIS & Data Modeling

Stem Xpert; Lansing (MI); On-site; USD 80,000 - 100,000; Full time

Job summary

A government agency is seeking an Oracle Database Developer to manage complex data transformation projects and lead a team. Key responsibilities include developing physical database architectures and writing sophisticated SQL queries. Candidates must be experienced in Oracle 11g, ETL processes, and have strong PL/SQL skills, with a minimum of 7 years in data modeling and related fields. This role offers a 10+ month duration with potential for extension.

Qualifications

• 7+ years developing conceptual, logical and physical data models.
• 2+ years working with Oracle 11g.
• 5+ years writing SQL statements.
• 7+ years using DDL and DML.
• 7+ years ETL experience with an automated tool.
• 3+ years writing stored procedures in PL/SQL.

Responsibilities

• Lead a team in complex data conversion of legacy systems.
• Write complex SQL statements including spatial queries.
• Perform ETL using automated tools.
• Establish physical database parameters and performance tuning.
• Train users on database management.

Skills

Developing conceptual, logical and physical data models

Oracle 11g

Experience writing SQL statements

Experience performing Extract-Transform-Load (ETL)

Experience using Oracle system utilities and DBMS packages

Experience writing stored procedures and functions using PL/SQL

Tools

Oracle PL SQL Tools

Talend Software

TOAD software

IBM Datastage

Safe FME

ESRI ArcGIS

Job description

A government agency is seeking an Oracle Database Developer to manage complex data transformation projects and lead a team. Key responsibilities include developing physical database architectures and writing sophisticated SQL queries. Candidates must be experienced in Oracle 11g, ETL processes, and have strong PL/SQL skills, with a minimum of 7 years in data modeling and related fields. This role offers a 10+ month duration with potential for extension.