Back to search

Oracle PL/SQL Developer

We are looking for an experienced Oracle PL/SQL Developer with strong expertise in database development, query optimization, and performance tuning.

  • Whippany, New Jersey, United States +1 more
  • On-site
  • Posted Nov 9, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise SoftwareDeveloper Tools & Infrastructure

Locations (2)

  • Whippany, New Jersey, United States
  • Iselin, New Jersey, United States

Responsibilities

  • Design, develop, and maintain Oracle PL/SQL procedures, functions, packages, and triggers.
  • Perform SQL query optimization and database performance tuning.
  • Analyze and troubleshoot slow-running SQL queries.
  • Work on execution plans, indexing strategies, and SQL performance improvements.
  • Identify database bottlenecks and improve application performance.
  • Optimize complex joins, subqueries, and analytical queries.
  • Collaborate with application developers, DBAs, and business teams.
  • Perform database troubleshooting and production support.

Requirements

Nice to have: Oracle 12c, Oracle 19c, large-scale databases, database optimization techniques, enterprise environments

Skills

Oracle DatabasePL/SQLSQL developmentOracle Performance TuningExplain PlanSQL TraceTKPROFAWR reportsindexingpartitioningquery optimizationstored proceduresfunctionspackagestriggersOracle DatabasePL/SQLSQL

More jobs nearby

Full description

Job Description – Oracle PL/SQL Developer (Performance Tuning) Location: Whippany, NJ Position: Oracle PL/SQL Developer Experience: 8+ Years (Preferred) Job Summary We are looking for an experienced Oracle PL/SQL Developer with strong expertise in database development, query optimization, and performance tuning. The ideal candidate should have hands-on experience in developing complex SQL queries, stored procedures, functions, packages, and optimizing database performance. Key Responsibilities Design, develop, and maintain Oracle PL/SQL procedures, functions, packages, and triggers. Perform SQL query optimization and database performance tuning. Analyze and troubleshoot slow-running SQL queries. Work on execution plans, indexing strategies, and SQL performance improvements. Identify database bottlenecks and improve application performance. Optimize complex joins, subqueries, and analytical queries. Collaborate with application developers, DBAs, and business teams. Perform database troubleshooting and production support. Required Skills Strong experience with Oracle Database and PL/SQL. Expertise in SQL and PL/SQL development. Hands-on experience in Oracle Performance Tuning. Strong knowledge of Explain Plan, SQL Trace, TKPROF, and AWR reports. Experience with indexing, partitioning, and query optimization. Knowledge of stored procedures, functions, packages, and triggers. Strong analytical and problem-solving skills. Preferred Skills Oracle 12c/19c. Experience with large-scale databases. Knowledge of database optimization techniques. Experience working in enterprise environments. Work Location: Whippany, NJ

Oracle PL/SQL Developer at Han IT Staffing | Referso Jobs