PL/SQL Developer

InstantServe LLC; Lansing (MI); On-site; USD 120,000 - 170,000; Full time

Job summary

InstantServe LLC in the United States is seeking a PL/SQL Developer with 8+ years of Oracle database experience to design, develop, and maintain database structures, PL/SQL code, and robust data integrations.

You will collaborate with Data Architects, DBAs, and vendors to integrate agency data with vendor-hosted COTS solutions, perform data modeling, migrations, and ensure data integrity and performance. Strong expertise in APIs (REST/SOAP) and experience with data migration scripts is required.

Qualifications

• Advanced Oracle and PL/SQL development skills.
• Strong data modeling and database normalization experience.
• Experience with REST/SOAP APIs and data migration scripts.
• Proven track record integrating vendor-hosted/COTS systems.

Responsibilities

• Design, build, and maintain Oracle database objects and PL/SQL packages, procedures, and functions.
• Develop and consume REST/SOAP web services for secure data flows between internal apps and COTS systems.
• Lead data modeling (logical/physical), normalization, and migration/conversion efforts for new implementations and upgrades.
• Collaborate with DBAs on query tuning, code reviews, metadata analysis, and data integrity.

Skills

Oracle & PL/SQL

Data modeling

Database normalization

APIs & data migration

COTS integration

Tools

Toad

Oracle SQL Developer

Job description

We are seeking a PL/SQL Developer with 8+ years of experience in Oracle database environments to support enterprise applications. In this role, you will design, develop, and maintain database structures, PL/SQL code, and robust data integrations. You will serve as a core technical member collaborating with Data Architects, DBAs, and vendors to integrate agency-specific data with vendor-hosted Commercial Off-The-Shelf (COTS) solutions.

Key Responsibilities

• Database & Code Development: Design, build, and maintain Oracle database objects (tables, views, indexes, triggers) and write high-performing PL/SQL packages, procedures, and functions.
• Integrations & Web Services: Develop and consume REST/SOAP web services to enable secure data flows between internal applications and vendor-hosted COTS systems.
• Data Modeling & Migration: Lead data modeling (logical/physical), normalization, and data migration/conversion efforts for new implementations and system upgrades.
• Performance & Quality: Collaborate with DBAs on query tuning and code reviews; analyze metadata and enforce data integrity and agency standards.
• Troubleshooting & Support: Perform root-cause analysis on complex data issues, implement solutions, and actively contribute to technical design, estimation, and project planning.

Key Requirements (8+ Years)

• Oracle & PL/SQL: Advanced expertise in PL/SQL development and database object design.
• Database Tools: Daily proficiency with tools such as Toad or Oracle SQL Developer.
• Data Architecture: Strong background in logical/physical data modeling and database normalization.
• APIs & Migration: Hands-on experience with REST/SOAP integrations and complex data migration scripts.
• COTS Systems: Proven track record supporting or integrating vendor-hosted/COTS enterprise applications.