Benefits:
401(k) matching
Dental insurance
Health insurance
Vision insurance
Job Title: Senior Oracle PL/SQL Developer
Location: Lansing, MI, (Hybrid)-Onsite from day 1, two days a week. Tuesdays and Wednesdays are required onsite
Position Type: Contract
Interview Mode: In-person-(There may be two rounds of interviews.)
Key Responsibilities
Design, develop, and maintain database objects (tables, views, indexes, triggers, constraints) to support application and integration requirements.
Develop and optimize PL/SQL packages, procedures, and functions to support business logic, data services, and ETL processes.
Support data design and modeling activities, including logical and physical data models and normalization.
Lead and execute data migration and data conversion tasks for new implementations, upgrades, and system integrations.
Develop and consume web services (SOAP/REST) used in data integrations between internal systems and vendor hosted COTS solutions.
Analyze data and metadata to ensure accuracy, integrity, and compliance with agency standards.
Work closely 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 both new projects and ongoing maintenance efforts.
Required Skills and Experience
Oracle PL/SQL development (packages, procedures, functions) 8+ years
Use of Oracle development tools such as Toad or SQL Developer 8+ years
Designing, creating, and maintaining Oracle database objects 8+ years
Logical and physical data modeling; database normalization 8+ years
Data analysis, data quality, and metadata management 8+ years
Developing and integrating web services (SOAP and/or REST) 8+ years
Database programming for data migration and data conversion 8+ years
Experience supporting or integrating vendor hosted or COTS systems
Flexible work from home options available.