Programmer Analyst - Data Developer

Database Design & PL/SQL Development

• 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.

Integration, COTS & Data Migration

• 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.

Data Governance, Performance & Support

• 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.

• 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., * 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.