Programmer Analyst - Data Developer

Oracle PL/SQL: 8+ years of advanced development experience (packages, procedures, functions).

Development Tools: 8+ years of proficiency using Oracle development environments such as Toad or SQL Developer.

Database Design: 8+ years of experience designing, creating, and maintaining Oracle database objects, logical/physical data modeling, and database normalization.

Data Management: 8+ years of expertise in data analysis, data quality assurance, and metadata management.

Integrations & Web Services: 8+ years of experience developing and consuming SOAP and/or REST web services for enterprise system integration.

Data Migration: 8+ years of database programming experience supporting data migration and data conversion initiatives.

COTS Integration: Demonstrated experience supporting or integrating vendor-hosted or Commercial Off-The-Shelf (COTS) software solutions.

Design, develop, and maintain database objects (tables, views, indexes, triggers, and constraints) to support core application and integration requirements.

Develop, optimize, and maintain complex PL/SQL packages, procedures, and functions to power business logic, data services, and ETL processes.

Support enterprise data design and modeling activities, including logical and physical data modeling and strict database normalization.

Lead and execute data migration and data conversion tasks for new software implementations, platform upgrades, and enterprise system integrations.

Develop and consume enterprise web services (SOAP/REST) to facilitate secure data integrations between internal systems and vendor-hosted COTS solutions.

Integrate internal data services seamlessly into third-party vendor platforms while ensuring data integrity.

Analyze data and metadata to ensure accuracy, high integrity, and strict compliance with organizational data standards.

Partner closely with Data Architects and DBAs on SQL performance tuning, database code reviews, and adherence to database engineering best practices.

Troubleshoot complex data issues, identify root causes, and implement rapid corrective solutions.

Participate actively in planning, estimation, documentation, and technical design sessions for both new projects and ongoing maintenance efforts.

Strong problem-solving abilities and the capability to exercise independent judgment in a fast-paced environment.

Clear and concise written and verbal communication skills, with the ability to articulate technical concepts effectively to stakeholders at all levels.

Proven track record of collaborating successfully across cross-functional technology teams.