Data Developer (Oracle / COTS Solutions)

Company Description

StarTekk’s adoption of Digital Transformation is to accelerate organizational growth, increase efficiencies and help Star Workforce achieve focused business goals. The Employee will help our organization to identify and bridge the gap that exists in the business by analyzing the data, scale and support digital transformation initiatives.

Job Description

We are seeking a Senior-Level Application Data Developer with 8+ years of experience supporting enterprise applications in an Oracle database environment. The ideal candidate will have strong expertise in Oracle PL/SQL development, database design, data modeling, data migration, and web services integration.

The candidate will work as a core member of a technology team supporting agency applications and data services. This role involves designing, developing, and maintaining database structures, PL/SQL code, and data integrations to ensure secure, efficient, and accurate data flow across enterprise systems.

The Data Developer will collaborate with Data Architects, Database Administrators (DBAs), application support teams, and vendors to develop, test, deploy, and optimize database solutions. Experience integrating vendor-hosted and Commercial Off-The-Shelf (COTS) applications is highly desirable.

Key Responsibilities

• Design, develop, and maintain Oracle database objects, including tables, views, indexes, triggers, and constraints.
• Develop, maintain, and optimize PL/SQL packages, procedures, and functions for business logic, data services, and ETL processes.
• Support logical and physical data modeling, database design, and normalization.
• Lead and execute data migration and data conversion activities for new implementations, upgrades, and system integrations.
• Develop and integrate SOAP and REST web services for data exchange between internal systems and vendor-hosted COTS solutions.
• Analyze data and metadata to ensure accuracy, integrity, quality, and compliance with agency standards.
• Collaborate with Data Architects and DBAs on performance tuning, code reviews, and database best practices.
• Troubleshoot database and data integration issues, identify root causes, and implement corrective actions.
• Participate in technical design sessions, project planning, effort estimation, documentation, and ongoing application maintenance.

Qualifications

• 8+ years of experience in Oracle PL/SQL development, including packages, procedures, and functions.
• 8+ years of experience using Oracle development tools such as Toad or Oracle SQL Developer.
• 8+ years of experience designing, creating, and maintaining Oracle database objects.
• 8+ years of experience in logical and physical data modeling and database normalization.
• 8+ years of experience in data analysis, data quality, and metadata management.
• 8+ years of experience developing and integrating SOAP and/or REST web services.
• 8+ years of experience in database programming for data migration and data conversion.
• Experience supporting or integrating vendor-hosted applications and COTS solutions.
• Strong analytical, troubleshooting, problem-solving, and technical documentation skills.
• Ability to work independently and collaborate effectively with cross-functional technical teams.

Additional Information

• Work Arrangement: Hybrid; local candidates are strongly preferred.
• Relocation: Non-local candidates must be willing to relocate at their own expense, without delays after acceptance, and be available to work onsite from day one according to the hybrid schedule.
• Location Preference: Candidates local to Lansing, Michigan, are strongly preferred.