Oracle Developer

Title: Oracle Developer

Location: Lansing, MI (Local candidates preferred. Non-local candidates must relocate at their own expense from acceptance and be onsite from day 1)

Duration: 12-18 months (Mid Term) - Hybrid

Employment Mode: Full Time

What You'll Do / Key Responsibilities

• Design, develop, and maintain Oracle database objects, including tables, views, indexes, triggers, and constraints.
• Develop and optimize PL/SQL packages, procedures, and functions to support business logic, data services, and ETL processes.
• Support logical and physical data modeling activities, including database normalization.
• Lead and execute data migration and data conversion tasks for new implementations, upgrades, and system integrations.
• Develop and consume SOAP and/or REST web services for data integrations between internal systems and vendor-hosted COTS solutions.
• Analyze data and metadata to ensure accuracy, integrity, and compliance with applicable agency standards.
• Collaborate with Data Architects and Database Administrators on performance tuning, code reviews, and database best practices.
• Troubleshoot data issues, identify root causes, and implement corrective solutions.
• Participate in planning, estimation, documentation, and technical design sessions for new projects and ongoing maintenance activities.

Required Qualifications

• 8+ years of Oracle PL/SQL development experience, including packages, procedures, and functions.
• 8+ years of experience using Oracle development tools such as Toad or SQL Developer.
• 8+ years of experience designing, creating, and maintaining Oracle database objects.
• 8+ years of experience with logical and physical data modeling and database normalization.
• 8+ years of experience in data analysis, data quality, and metadata management.
• 8+ years of experience developing and integrating web services using SOAP and/or REST.
• 8+ years of experience with database programming for data migration and data conversion.

Experience supporting or integrating vendor-hosted or COTS systems.