Senior Oracle PL/SQL Developer

MasterApp Labs LLC; Lansing (MI); Hybrid; USD 120,000 - 150,000; Part time

Benefits offered by this job

Flexible work from home

Job summary

MasterApp Labs LLC seeks a Senior Oracle PL/SQL Developer in Lansing, MI. This hybrid contract role requires hands-on expertise in Oracle PL/SQL, data modeling, and integration of web services. You will design database objects, optimize PL/SQL code, and lead data migration efforts across systems.

Ideal candidates will have 8+ years of Oracle experience, strong data quality skills, and familiarity with vendor-hosted or COTS solutions. Onsite two days weekly, with flexible work-from-home options.

Qualifications

• 8+ years Oracle PL/SQL development experience.
• 8+ years experience with Oracle objects, PL/SQL packages, procedures, functions.
• 8+ years experience in data modeling, normalization, and data quality.
• Experience developing and integrating web services (SOAP/REST) 8+ years.
• Experience with vendor-hosted or COTS systems.
• Familiarity with ETL processes and data migration tasks.

Responsibilities

• Design, develop, and maintain Oracle database objects.
• Develop and optimize PL/SQL packages, procedures, and functions.
• Support data design, models, and normalization.
• Lead data migration and conversion tasks.
• Develop and consume web services used in data integrations.
• Analyze data for accuracy and compliance with standards.
• Collaborate with Data Architects and DBAs on performance tuning.
• Troubleshoot data issues and implement fixes.
• Participate in planning, estimation, and technical design sessions.

Skills

Oracle PL/SQL development

Data modeling

Database normalization

Data analysis

Data quality

Metadata management

Web services (SOAP/REST)

Data migration

Tools

Toad

SQL Developer

Job description

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.