Programmer Analyst - Oracle PL/SQL Developer

Job Summary:

This position is for a senior-level Programmer Analyst 6 specializing in Oracle database development and data integration within a state agency environment. The role involves designing, developing, and maintaining Oracle database structures and PL/SQL code to support enterprise applications and vendor-hosted solutions. The candidate will work on data modeling, ETL processes, and web services integration while collaborating closely with technical teams to ensure data accuracy, performance, and compliance.

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 and data services.
• Support logical and physical data modeling and database normalization efforts.
• Lead data migration and conversion tasks for implementations, upgrades, and system integrations.
• Develop and consume SOAP/REST web services for data integration between internal and vendor-hosted systems.
• Analyze data and metadata to ensure accuracy, integrity, and compliance with agency standards.
• Collaborate with Data Architects and DBAs on performance tuning, code reviews, and best practices.
• Troubleshoot data issues, determine root causes, and implement corrective actions.
• Participate in planning, estimation, documentation, and technical design sessions for projects and maintenance.

Required Skills & Certifications:

• 8+ years of Oracle PL/SQL development experience including packages, procedures, and functions.
• 8+ years using Oracle development tools such as Toad or SQL Developer.
• Strong experience designing, creating, and maintaining Oracle database objects.
• Proficient in logical and physical data modeling and database normalization.
• 8+ years of experience in data analysis, data quality, and metadata management.
• Experience developing and integrating SOAP and/or REST web services.
• Expertise in database programming for data migration and conversion.
• Bachelor's degree required.
• Clear and concise written and verbal communication skills.

Preferred Skills & Certifications:

• Experience supporting or integrating vendor-hosted or Commercial Off-The-Shelf (COTS) systems.
• Familiarity with agency-specific data standards and compliance requirements.
• Prior experience working in government or public sector environments.

Special Considerations:

• Candidates must be available for in-person interviews and onsite work from day one.
• Hybrid work schedule with mandatory onsite presence two days per week (Tuesdays and Wednesdays).
• No remote-only work option.
• Strongly preferred candidates with local residency; non-local candidates must be willing to relocate at their own expense without delay.
• Submission requirements include valid Right to Represent and adherence to resume length limits (4-5 pages).
• Only one level deep sub-vendor submissions allowed.

Scheduling:

• Full-time position, 40 hours per week.
• Hybrid schedule requiring onsite attendance on Tuesdays and Wednesdays.
• Assignment duration is 1 year with likely extension.