Oracle PL/SQL Programmer

Here Technologies

3 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Senior

Job location

Tech stack

Data analysis

Databases

Data Conversion

Data Integration

Data Migration

Electronic Data Interchange (EDI)

Meta-Data Management

Oracle

Oracle Applications

Performance Tuning

Simple Object Access Protocol (SOAP)

PL-SQL

SQL Databases

Data Streaming

Systems Integration

Web Services

Enterprise Software Applications

Toad (Software)

Data Management

REST

Job description

Support a major system replacement project with a focus on data migration and ongoing maintenance

Design, develop, and maintain Oracle database objects (tables, views, indexes, triggers, constraints)

Develop and optimize PL/SQL packages, procedures, and functions

Perform data modeling (logical and physical) and normalization

Lead data migration and conversion activities for system implementations and integrations

Develop and integrate web services (SOAP/REST) for data exchange with vendor-hosted systems

Ensure data accuracy, integrity, and compliance through analysis and validation

Collaborate with technical teams on performance tuning and best practices

Troubleshoot data-related issues and implement solutions

Participate in technical design, documentation, and project planning activities

Requirements

We are seeking a senior-level Programmer with 8+ years of experience supporting enterprise applications, including Commercial Off-The-Shelf (COTS) solutions, primarily vendor-hosted platforms. The ideal candidate will have strong expertise in Oracle database environments and will play a key role in designing, developing, and maintaining database structures, PL/SQL code, and data integrations.

This role involves working closely with cross-functional teams including Data Architects, DBAs, application support teams, and vendors to ensure secure, efficient, and accurate data flow across systems. The position requires strong technical proficiency, problem-solving skills, and the ability to work independently., 8+ years of Oracle PL/SQL development (packages, procedures, functions)

8+ years using Oracle tools such as Toad or SQL Developer

8+ years designing and maintaining Oracle database objects

8+ years of experience in data modeling and database normalization

Experience working with or integrating COTS/vendor-hosted systems

8+ years of data migration and data conversion experience

Strong background in data analysis, data quality, and metadata management

8+ years developing and integrating SOAP/REST web services

Additional Notes:

Open to candidates willing to relocate at their own expense

Must be able to work onsite from day one as per hybrid schedule