Direct Client: Oracle PL/SQL Developer @ Lansing, MI – Hybrid – Locals Preferred

KSN Technologies. • Lansing, MI

1d • Hybrid

About The Position

This senior-level Application Data Developer role supports enterprise applications and data services in an Oracle database environment. The developer designs, develops, and maintains database structures, PL/SQL code, and data integrations to enable secure, efficient, and accurate data flow across assigned systems. The role supports both project and maintenance work and provides technical leadership for data-related activities, including data modeling, ETL development, and integrating 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 written and verbal communication. It may report to a project lead, project manager, or manager.

This is a one-year contract based in Lansing, Michigan, with a hybrid schedule requiring onsite work from day one on Tuesdays and Wednesdays. Local candidates are strongly preferred; non-local candidates must be willing to relocate at their own expense without delay and follow the hybrid schedule. Candidates must be able to work without visa sponsorship and attend an in-person interview; there may be two interview 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 in logical and physical data modeling and database normalization.
• At least 8 years in data analysis, data quality, and metadata management.
• At least 8 years developing and integrating SOAP and/or REST web services.
• At least 8 years of database programming for data migration and conversion.
• Experience supporting or integrating vendor-hosted or COTS systems.
• Clear and concise written and verbal communication skills.
• Ability to work without visa sponsorship.
• Availability to attend an in-person interview.
• For non-local candidates: willingness to relocate at personal expense without delay and comply with the hybrid schedule.

Nice To Haves

• Local to the Lansing, Michigan area.

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 conversion tasks for new 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.
• Collaborate 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.

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed