PL/SQL Developer

The Value Maximizer; New Jersey; On-site; USD 90,000 - 120,000; Full time

Job summary

A data solutions company is seeking an experienced PL/SQL Developer based in New Jersey. In this role, you will design and optimize PL/SQL procedures, manage database jobs, and collaborate with teams to ensure performance and stability. Candidates should have strong expertise in Oracle databases, Unix scripting, and SQL tuning. The ideal candidate is familiar with CI/CD pipelines and has experience troubleshooting PL/SQL scripts. This position offers a dynamic work environment focused on critical data processing workflows.

Qualifications

• Strong hands-on expertise in Oracle PL/SQL and database development.
• Proficiency in SQL performance tuning and query optimization.
• Experience using Unix/Linux shell scripting for job automation.
• Familiarity with CI/CD pipelines and version control for automated deployments.
• Solid understanding of data migration, exception handling, and database performance best practices.
• Experience in troubleshooting and debugging SQL and PL/SQL scripts.

Responsibilities

• Design, develop, and optimize PL/SQL procedures and packages.
• Work with Unix shell scripts for automation and job scheduling.
• Collaborate with teams to troubleshoot production issues.
• Collaborate with business, QA, and DevOps teams to support releases and troubleshoot production issues.
• Participate in code reviews and ensure adherence to development and deployment best practices.

Skills

Experience in Oracle PL/SQL

SQL performance tuning

Unix/Linux shell scripting

Database development tools (Toad, SQL Workbench, DBeaver)

CI/CD and version control

Troubleshooting SQL/PLSQL

Oracle Forms (nice to have)

Perl scripting & AWS Glue (ETL)

Tools

Toad

SQL Workbench

DBeaver

Version control (Git/SVN)

Job description

We are looking for a PL/SQL Developer with strong experience in Oracle databases, Unix scripting, and SQL performance tuning to support critical data processing and integration workflows for the wealth management client. The role involves developing and optimizing PL/SQL procedures, managing database jobs, and collaborating across teams to ensure operational stability and performance.

Key Responsibilities

• Design, develop, and optimize PL/SQL procedures, triggers, and packages within Oracle databases
• Work with Unix shell scripts for automation, data transfers, and job scheduling
• Configure and manage DBMS Scheduler for scheduling and monitoring PL/SQL jobs
• Collaborate with business, QA, and DevOps teams to support releases and troubleshoot production issues
• Participate in code reviews and ensure adherence to development and deployment best practices

Must have skills

• Strong hands-on expertise in Oracle PL/SQL and database development
• Proficiency in SQL performance tuning and query optimization
• Experience using Toad, SQL Workbench, and DBeaver for database development and analysis
• Familiarity with CI/CD pipelines and version control for automated deployment workflows
• Experience working with Unix/Linux shell scripting for job automation and data processing
• Solid understanding of data migration, exception handling, and database performance best practices
• Experience in troubleshooting and debugging SQL and PL/SQL scripts. Nice to have:
• Exposure to Oracle Forms for legacy system support
• Knowledge of Perl scripting and AWS Glue for ETL automation and data integration