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.