Senior Oracle PL/SQL Developer

MasterApp Labs•Lansing, MI

1d•$53 - $58•Hybrid

About The Position

The Senior Oracle PL/SQL Developer designs, develops, and maintains Oracle database objects and PL/SQL code to support application, integration, business logic, data services, and ETL requirements. The role supports data modeling, migration, conversion, data quality, and web service integrations involving internal systems and vendor-hosted COTS solutions. The developer collaborates with Data Architects and DBAs on performance tuning, code reviews, and database best practices, while troubleshooting data issues and participating in technical planning and documentation. This is a contract position in Lansing, Michigan. The work arrangement is hybrid, with onsite work required two days per week on Tuesdays and Wednesdays. Onsite work begins on day one. Interviews are in person and may consist of two rounds.

Requirements

At least 8 years of Oracle PL/SQL development, including packages, procedures, and functions.
At least 8 years using Oracle development tools such as Toad or SQL Developer.
At least 8 years designing, creating, and maintaining Oracle database objects.
At least 8 years of logical and physical data modeling and database normalization.
At least 8 years of data analysis, data quality, and metadata management.
At least 8 years developing and integrating web services using SOAP and/or REST.
At least 8 years of database programming for data migration and data conversion.
Experience supporting or integrating vendor-hosted or COTS systems.

Responsibilities

Design, develop, and maintain database objects, including tables, views, indexes, triggers, and constraints, to support application and integration requirements.
Develop and optimize PL/SQL packages, procedures, and functions for business logic, data services, and ETL processes.
Support data design and modeling, including logical and physical data models and normalization.
Lead and execute data migration and data conversion 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 agency standards.
Work with Data Architects and DBAs 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.