Data Developer (Oracle / COTS Solutions)

PSR Associates • Lansing, MI

2d • Hybrid

About The Position

PSR Associates is seeking a senior-level Application Data Developer to support enterprise applications and data services in an Oracle database environment. The role designs, develops, and maintains database structures, PL/SQL code, and data integrations to support secure, efficient, and accurate data flow across assigned systems. It contributes to project and maintenance work and provides technical leadership for 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 strong technical proficiency, problem-solving ability, and independent judgment. The work schedule is hybrid, with onsite work required Tuesdays and Wednesdays in Lansing, Michigan. The position may report to a project lead, project manager, or manager.

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 experience.
• At least 8 years of data analysis, data quality, and metadata management experience.
• 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, for 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 conversion tasks for implementations, upgrades, and system integrations.
• Develop and consume SOAP and REST web services for 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 maintenance work.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed