Job Title : Senior Oracle Data Developer

Position Overview

Work on enterprise application data solutions involving Oracle database development, data integration, and vendor-hosted commercial off-the-shelf (COTS) systems. This senior-level role offers the opportunity to contribute to data architecture implementation, data migration, and integration initiatives while supporting both new projects and ongoing application maintenance.

The Senior Oracle Data Developer will design, develop, and maintain database structures, PL/SQL code, and data integrations that enable secure, efficient, and accurate data flow across assigned systems. The role involves collaboration with Data Architects, Database Administrators, application support teams, and vendors, requiring strong technical proficiency, problem-solving skills, and independent judgment.

What You'll Do / Key Responsibilities

• Design, develop, and maintain Oracle database objects, including tables, views, indexes, triggers, and constraints.
• Develop and optimize PL/SQL packages, procedures, and functions to support business logic, data services, and ETL processes.
• Support logical and physical data modeling activities, including database normalization.
• Lead and execute data migration and data conversion tasks for new implementations, upgrades, and system integrations.
• Develop and consume SOAP and/or 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 applicable agency standards.
• Collaborate with Data Architects and Database Administrators 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 activities.

Required Qualifications

• 8+ years of Oracle PL/SQL development experience, including packages, procedures, and functions.
• 8+ years of experience using Oracle development tools such as Toad or SQL Developer.
• 8+ years of experience designing, creating, and maintaining Oracle database objects.
• 8+ years of experience with 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 web services using SOAP and/or REST.
• 8+ years of experience with database programming for data migration and data conversion.
• Experience supporting or integrating vendor-hosted or COTS systems.