Senior Oracle PL/SQL Developer

Jersey City, NJ, US • Posted 3 hours ago • Updated 3 hours ago
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • ADDM
  • Apache Subversion
  • Data Migration
  • Oracle Data Guard
  • Oracle Application Express
  • Data Validation
  • Extract, Transform, Load
  • Oracle
  • Computer Science
  • IT Management
  • Mentorship
  • Production Support
  • Linux
  • Informatica
  • Oracle Data Integrator
  • PL/SQL
  • Oracle GoldenGate
  • Cloud Computing
  • Communication
  • Performance Tuning
  • Collaboration
  • Root Cause Analysis
  • Analytical Skill
  • Database
  • Quality Assurance
  • SQL Trace
  • SQL
  • Technical Drafting
  • Scripting
  • RAC
  • Profit And Loss
  • Unix

Summary

Senior Oracle PL/SQL Developer

Experience: 11+ Years

Job Overview:
We are looking for a highly experienced Senior Oracle PL/SQL Developer with 11+ years of experience in Oracle database development, PL/SQL programming, performance tuning, and production support. The candidate should have strong experience working with complex enterprise applications and large-volume data.

Key Responsibilities

  • Develop and maintain complex PL/SQL Procedures, Functions, Packages, Triggers, Cursors, and Views.
  • Write and optimize complex SQL queries using joins, subqueries, CTEs, and analytical functions.
  • Perform SQL/PLSQL performance tuning using Explain Plan, AWR, ADDM, ASH, and SQL Trace.
  • Design database objects including tables, indexes, constraints, sequences, and materialized views.
  • Troubleshoot production issues and perform root-cause analysis.
  • Develop Unix/Linux shell scripts for database and batch processes.
  • Support ETL, data migration, data validation, and reconciliation activities.
  • Collaborate with application developers, DBAs, QA, business teams, and architects.
  • Participate in code reviews, technical design, deployments, and production support.
  • Mentor junior developers and provide technical leadership.

Required Skills

  • Oracle Database 11g/12c/19c
  • Advanced SQL & PL/SQL
  • Stored Procedures, Functions, Packages, Triggers, Cursors
  • BULK COLLECT, FORALL, Dynamic SQL
  • SQL/PLSQL Performance Tuning
  • AWR, ADDM, ASH, Explain Plan
  • Unix/Linux Shell Scripting
  • Database Design & Data Modeling
  • ETL/Data Migration
  • Git/SVN, Jira
  • Strong troubleshooting and communication skills

Preferred: Oracle APEX, ORDS, RAC, Data Guard, GoldenGate, Informatica/ODI, and cloud database experience.

Education: Bachelor''''s/Master''''s degree in Computer Science, IT, Engineering, or a related field.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10477291
  • Position Id: 9063163
  • Posted 3 hours ago
Contact the job poster
RC

Rahul Chourasia

Recruiter @ Raas Infotek LLC
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Jersey City, New Jersey

Today

Contract

USD55 - USD65

New York, New York

Today

Full-time

USD 140,828.00 - 166,223.00 per year

Jersey City, New Jersey

Today

Contract

USD55 - USD65

Parsippany-Troy Hills, New Jersey

Today

Easy Apply

Full-time

Depends on Experience

Search all similar jobs