Senior Oracle PL/SQL Developer

Ohio City, OH, US • Posted 22 hours ago • Updated 22 hours ago
Contract W2
12 Months
No Travel Required
On-site
$55 - $65/hr
Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

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

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: 9054817
  • Posted 22 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

Remote or Florida

Today

Third Party, Contract

New Jersey

Today

Easy Apply

Full-time

Remote

Today

Full-time

USD 111,155.00 - 150,385.00 per year

Remote

Today

Easy Apply

Full-time

55+

Search all similar jobs