Oracle PL/SQL Developer

3 days ago

India NSKH Tech Full time

Job Description

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

- Minimum 5+ years of experience in Oracle PL/SQL development.
- Advanced knowledge of PL/SQL programming including packages, procedures, functions, and triggers.
- Strong background in SQL performance tuning, execution plan analysis, and Oracle indexing strategies.
- Hands-on experience with Oracle performance tools like AWR, ADDM, SQL Trace, and TKPROF.
- Experience in data migration, handling large volumes of data, and ETL logic design.
- Familiarity with Oracle versions 12c, 19c, or later.
- Deep understanding of Oracle database architecture, memory structures, and optimizer behavior.
- Strong analytical and problem-solving skills.
- Effective communication and collaboration abilities.

Nice To Have

- Experience working in Agile/Scrum teams.
- Exposure to emerging Oracle database technologies (e.g., 23c).
- Familiarity with DevOps tools or CI/CD pipeline integration with database environments.
- Prior experience working in cross-functional technical teams.

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

  • PL/SQL Developer-Core Banking

    2 weeks ago

    India Oracle Full time

    Job DescriptionIntermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices. Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer specifications.Career...

  • [Apply in 3 Minutes] PL/SQL Developer-Core Banking

    2 weeks ago

    India Oracle Full time

    Job Description Intermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices. Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer...

  • PL/SQL Developer

    2 weeks ago

    india Tata Consultancy Services Full time

    Greetings from TATA CONSULTANCY SERVICES!TCS is hiring for PL/SQL Developer Location: - Chennai/Bangalore Experience Range: - 4-10 yrsExperienced in the Development and support of Java Web Applications and services as specified by our business Partners Exposure to powerhouse or any other 4GL language, core Java is an added advantage Be the go-to expert for...

  • PL/SQL Developer

    3 weeks ago

    India Trantor Full time

    Job Opportunity: PL/SQL Developer (4–6 years experience) Are you a skilled PL/SQL Developer with 4–6 years of expertise in Oracle database development? Join our team to showcase your proficiency in writing and optimizing PL/SQL code. If you have exposure to Oracle Integration Cloud (OIC) and Visual Builder Cloud Service (VBCS), this role is perfect for...

  • PL/SQL Developer

    2 weeks ago

    India Tata Consultancy Services Full time

    Greetings from TATA CONSULTANCY SERVICESTCS is hiring for PL/SQL DeveloperLocation: - Chennai/BangaloreExperience Range: - 4-10 yrsExperienced in the Development and support of Java Web Applications and services as specified by our business Partners Exposure to powerhouse or any other 4GL language, core Java is an added advantage Be the go-to expert for...

  • Pl/SQL

    2 weeks ago

    India Heptarc Technology Solution Full time

    JD Extensive experience of Oracle SQL and PL/SQL (ideally Oracle 12c) and above Highly proficient in RDBMS concepts and Oracle PL/SQL Experience with complex SQL (Dynamic, Stored Procedures and Triggers) Expertise with writing and optimizing stored procedures and SQL query performance. Exposure to debugging and troubleshooting is an added advantage. End to...

  • PL/SQL Developer

    1 day ago

    india Tata Consultancy Services Full time

    Greetings from TATA CONSULTANCY SERVICES! Skill: PLSQL Years of Experience: 4 - 10 years Location: Chennai/ BangaloreJob Description: - Experienced in the Development and support of Java Web Applications and services as specified by our business partners. Exposure to powerhouse or any other 4GL language, core Java is an added advantage. Be the go-to expert...

  • Oracle Pl/SQL Support

    4 days ago

    India Bloom Consulting Services Full time

    **Oracle Pl/SQL Support ( Job ID : 000001375 )**: NA Experience **3 - 5 years** Offered Salary Notice Period **Not Disclosed** - Oracle and Pl-Sql - Good communication skills - Open for rotational shift. 24*7 support - Open to take responsibility

  • 15h Left PL/SQL Developer

    3 weeks ago

    India Trantor Full time

    Job Opportunity: PL/SQL Developer (4–6 years experience)Are you a skilled PL/SQL Developer with 4–6 years of expertise in Oracle database development? Join our team to showcase your proficiency in writing and optimizing PL/SQL code. If you have exposure to Oracle Integration Cloud (OIC) and Visual Builder Cloud Service (VBCS), this role is perfect for...

  • PL/SQL Developer

    1 week ago

    Hyderabad, India Data Unveil Full time

    Job Description Position Title: PL/SQL Developer Experience - 2 Years to 5 Years Location: Hyderabad, Telangana. Hire Type: Full Time Start Date: Immediate Responsibilities & Skills - Minimum 2+ years experience in SQL development. - Translate complex business requirements into technical requirements for development. - Collaborate with internal teams...