Oracle PL/SQL Developer

Matlen Silver; Jersey City (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading tech solutions provider in New Jersey is seeking a Senior Oracle SQL/PLSQL Developer to convert and modernize existing Mainframe SAS processes. This role involves analyzing legacy workflows and designing corresponding Oracle solutions, requiring strong expertise in SQL/PLSQL and knowledge of SAS. The ideal candidate will work collaboratively with the team, ensuring quality delivery and automation using Python as needed. Familiarity with JIRA in an Agile environment is preferred. Join us to make a meaningful impact with your skills.

Qualifications

• Strong expertise in Oracle SQL and PLSQL development.
• Experience with Mainframe SAS.
• Working proficiency with Python for automation.
• Experience with Java-based applications integration.
• Familiarity with Agile working methodologies.
• Proven teamwork and communication skills.

Responsibilities

• Convert and migrate legacy Mainframe SAS processes to Oracle SQL/PLSQL.
• Analyze Mainframe SAS workflows for Oracle execution.
• Collaborate with technology manager for reporting and planning.
• Ensure performance and reliability of Oracle solutions.
• Use Python for data processing and automation.
• Support team in a collaborative environment.

Skills

Oracle SQL

PLSQL

Mainframe SAS

Python

JIRA

Tools

JIRA

Java

Job description

Overview

The Senior Oracle SQL/PLSQL Developer will be responsible for converting and modernizing existing Mainframe SAS-based processes into optimized Oracle SQL/PLSQL solutions. This role involves analyzing legacy SAS workflows, designing corresponding Oracle data-processing logic, and ensuring efficient, accurate migration of complex business processes to the Oracle platform.

In addition, the developer will support the creation and enhancement of a Java-based user interface to facilitate ongoing process maintenance. The position requires close collaboration with the technology manager for status reporting and project updates, while maintaining minimal direct client interaction.

The ideal candidate possesses strong expertise in Oracle SQL/PLSQL, knowledge of SAS or COBOL on the mainframe, and working knowledge of Python for automation or data handling. Familiarity with JIRA for task tracking and Agile workflows is preferred. The developer is expected to demonstrate strong ownership, deliver high quality work within agreed timelines, collaborate effectively with team members, and provide support to the broader team as needed.

Key Responsibilities

• Convert and migrate legacy Mainframe SAS processes to Oracle SQL/PLSQL.
• Analyze existing Mainframe SAS workflows and redesign logic for Oracle-based execution.
• Collaborate with the technology manager for reporting, planning, and delivery oversight.
• Ensure accuracy, performance, and reliability of Oracle-based solutions.
• Utilize Python as needed for automation, data processing, or migration tasks.
• Use JIRA for work management within an Agile or hybrid environment.
• Support team members and contribute to a collaborative, delivery-focused environment.

Required Skills & Attributes

• Strong expertise in Oracle SQL and PLSQL development.
• Experience with Mainframe SAS.
• Working proficiency with Python.
• Experience supporting or integrating with Java-based applications.
• Familiarity with JIRA or similar workflow tools.
• Self motivated with the ability to work independently.
• Proven team player with strong communication and problem solving skills.
• Consistent, on-time delivery of high quality technical outcomes.
• Willingness to assist teammates and contribute to overall project success.