Oracle PL / SQL Developer

Job Title : PL / SQL Developer – Oracle Performance Tuning

Experience Required : 5+ Years

Location : [Remote

Employment Type : [Contract

Job Overview

We are seeking a highly skilled and experienced PL / SQL Developer with a strong command of Oracle Database and deep expertise in performance tuning and query optimization . The ideal candidate will have proven experience developing complex PL / SQL code and working closely with application and DBA teams to enhance and maintain system performance in high-volume production environments.

Key Responsibilities

• Design, develop, and maintain PL / SQL packages, procedures, triggers, and functions for enterprise-grade systems.
• Analyze, optimize, and tune SQL queries and stored procedures to enhance performance.
• Perform execution plan analysis, index tuning, and other diagnostics using tools such as AWR, ADDM, SQL Trace, and TKPROF.
• Work with application developers and DBAs to resolve database performance issues across environments.
• Assist in Oracle upgrades (e.g., 12c / 19c to 23c), ensuring minimal disruption and performance loss.
• Participate in code reviews, share best practices, and contribute to quality and standards enforcement.
• Support data migration, ETL logic, and large-volume dataset handling.
• Collaborate cross-functionally with architecture, DevOps, and infrastructure teams.
• Document all development, optimization techniques, and performance tuning recommendations.
• Provide support in schema design and data architecture planning.

Required Skills & Qualifications

Nice To Have

Skills : oracle indexing strategies,sql trace,oracle database architecture,oracle performance tools (awr, addm, sql trace, tkprof),addm,pl / sql programming,memory structures,oracle database,awr,etl logic design,sql performance tuning,oracle,tuning,collaboration skills,optimizer behavior,data,communication skills,etl logic,sql optimization,sql,execution plan analysis,pl / sql,tkprof,analytical skills,performance tuning,index tuning,data migration,database,problem-solving skills

Skills Required

Oracle Database, Performance Tuning, Sql Trace, Tkprof, Addm, Pl Sql Programming, Awr