Oracle Data Developer & PL/SQL Mastery (Hybrid)

First Roles; Dimondale (MI); Hybrid; USD 90,000 - 120,000; Full time

Job summary

First Roles is seeking a Programmer Analyst - Data Developer to join our Lansing area team in a hybrid role. The position emphasizes Oracle PL/SQL development, database design, and data integration across enterprise systems.

The ideal candidate will drive data migration, governance, and quality initiatives, collaborate with DBAs and data architects, and deliver robust data services and integrations using SOAP/REST in a fast-paced environment.

Qualifications

• 8+ years of advanced development experience with Oracle PL/SQL (packages, procedures, functions).
• Proficiency using Oracle development environments such as Toad or SQL Developer.
• Experience designing, creating, and maintaining Oracle database objects, logical/physical data modeling, and normalization.

Responsibilities

• Design, develop, and maintain database objects (tables, views, indexes, triggers, constraints).
• Develop and optimize PL/SQL packages, procedures, and functions powering business logic and ETL processes.
• Support data design and modeling activities, including logical/physical modeling and normalization.

Skills

Oracle PL/SQL

Database design

Data management

Web services

Data migration

COTS integration

Tools

Toad

SQL Developer

Job description

First Roles is seeking a Programmer Analyst - Data Developer to join our Lansing area team in a hybrid role. The position emphasizes Oracle PL/SQL development, database design, and data integration across enterprise systems.

The ideal candidate will drive data migration, governance, and quality initiatives, collaborate with DBAs and data architects, and deliver robust data services and integrations using SOAP/REST in a fast-paced environment.