Senior Oracle PL/SQL Developer – Data Integration & COTS

Novalink Solutions LLC • Lansing, MI

2d

About The Position

This is a senior-level Application Data Developer role supporting enterprise applications in an Oracle database environment. The developer will be a core member of a technology team supporting agency applications and data services. The role designs, develops, and maintains database structures, PL/SQL code, and data integrations to enable secure, efficient, and accurate data flow across assigned systems. It includes project and maintenance work, with technical leadership on data modeling, ETL development, and integration of agency-specific data into vendor-hosted solutions.

The developer collaborates with Data Architects, Database Administrators, application support staff, and vendors to create, test, deploy, and optimize data structures and processes. The position requires technical proficiency, problem-solving ability, independent judgment, and clear, concise written and verbal communication. It may report to a project lead, project manager, or manager.

Requirements

• 8+ years of Oracle PL/SQL development, including packages, procedures, and functions.
• 8+ years using Oracle development tools such as Toad or SQL Developer.
• 8+ years designing, creating, and maintaining Oracle database objects.
• 8+ years with logical and physical data modeling and database normalization.
• 8+ years in data analysis, data quality, and metadata management.
• 8+ years developing and integrating web services (SOAP and/or REST).
• 8+ years of database programming for data migration and conversion.
• Experience supporting or integrating vendor-hosted or COTS systems.
• Bachelor's degree.
• Clear and concise written and verbal communication skills.

Responsibilities

• Design, develop, and maintain database objects, including tables, views, indexes, triggers, and constraints, for application and integration requirements.
• Develop and optimize PL/SQL packages, procedures, and functions supporting 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 conversion tasks for implementations, upgrades, and system integrations.
• Develop and consume SOAP and 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 projects and maintenance efforts.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior