PL/SQL Developer

Job Title: Programmer / Oracle PL/SQL Developer

Location: Lansing, MI (Hybrid)

Work Schedule:

Onsite: Tuesdays & Wednesdays (Mandatory)

Remote: Mondays, Thursdays & Fridays

Duration: Initial 12 Months Contract (Extension Possible)

Interview Mode: 60-Minute Virtual Interview via MS Teams (Video Required)

Job Summary:

We are seeking a senior-level Programmer with 8+ years of experience supporting enterprise applications, Oracle database environments, and COTS/vendor-hosted systems. The selected candidate will work on critical agency projects, including legacy system replacement, data migration, integrations, and ongoing application/database support.

Key Responsibilities:

Design, develop, and maintain Oracle database objects such as tables, views, indexes, triggers, and constraints

Develop and optimize PL/SQL packages, procedures, and functions

Perform data migration, data conversion, and ETL-related activities

Support logical/physical data modeling and database normalization

Develop and consume SOAP/REST web services for integrations

Analyze data quality, metadata, and ensure data integrity

Troubleshoot database/data issues and implement solutions

Collaborate with DBAs, Architects, project teams, and vendors

Participate in technical design, planning, documentation, and estimation sessions

Required Skills:

8+ years of Oracle PL/SQL development experience

8+ years with Toad and/or SQL Developer

8+ years creating and maintaining Oracle DB objects

8+ years of data modeling experience

Strong experience with vendor-hosted/COTS systems

8+ years in data migration and data conversion

8+ years in data analysis, metadata, and data quality management

8+ years developing SOAP/REST web services

Important Notes:

Local candidates preferred; non-local candidates must relocate at their own expense without delay

Candidate must be able to work onsite from Day 1