JOBSEARCHER

PL/SQL Developer

Title: Programmer Analyst 6 - Data Developer
Location: 425 W Ottawa St Lansing, MI 48933
Interview Process:
  • There may be two rounds of interviews. Interviews will be held in person. Candidates MUST be available for an in-person interview.
  • Assignment duration: 1 year with extension likely
  • Hybrid Work Schedule: Resource will be working a hybrid schedule - Tuesdays and Wednesdays
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)
  • Use of Oracle development tools such as Toad or SQL Developer
  • Designing, creating, and maintaining Oracle database objects
  • Logical and physical data modeling; database normalization
  • Data analysis, data quality, and metadata management
  • Developing and integrating web services (SOAP and/or REST)
  • Database programming for data migration and data conversion
  • Experience supporting or integrating vendor hosted or COTS systems