Talent.com
This job offer is not available in your country.
PL-SQL Developer - Oracle RAC

PL-SQL Developer - Oracle RAC

TalproBangalore
30+ days ago
Job description

Job Description

We have the most urgent requirement on the subject skill :

Job description :

PLSQL Developer :

  • We are seeking an experienced Senior Oracle Database Developer with a minimum of 5 years of expertise in all phases of the Software Development Life Cycle (SDLC).
  • The ideal candidate should have extensive experience in SQL and PL / SQL programming, encompassing packages, stored procedures, functions, triggers, indexes, and exception handling.
  • Proficiency in creating database objects like tables, views, sequences, synonyms, and indexes using Oracle tools such as SQLPlus, SQL Developer, and Toad is essential.
  • The candidate should possess a strong working knowledge of loading data using SQLLoader and PL / SQL with different file formats.
  • Moreover, the candidate should have a proven track record of trouble-shooting, query optimization, and performance tuning using explain plans.
  • Experience with advanced Oracle features, including Ref-Cursors, PL / SQL Tables, Materialized Views, Dynamic SQL, and Oracle RAC, is highly desirable.
  • The Senior Oracle Database Developer will be responsible for writing scheduler jobs and handling issue resolution in the event of any failures.
  • The candidate should have the ability to analyze application requirements and provide recommended designs, as well as support code migration from development to staging environments.
  • Strong skills in writing complex SQL queries and PL / SQL procedures to extract data from various source tables are required.
  • The candidate should be capable of working independently and collaboratively, delivering high-quality results under pressure and tight deadlines.

Requirements :

Software Development Life Cycle (SDLC) :

  • Participate in all phases of the SDLC, including requirement gathering, analysis, application design, development, testing, implementation, and maintenance.

    • SQL and PL / SQL Programming :

  • Demonstrate extensive expertise in SQL and PL / SQL programming, encompassing packages, stored procedures, functions, triggers, indexes, and exception handling.
  • Create and manage database objects such as tables, views, sequences, synonyms, and indexes using Oracle tools like SQL-Plus, SQL Developer, and Toad.

    • Data Loading and File Formats :

  • Apply a strong working knowledge of loading data using SQL-Loader and PL / SQL with different file formats.

    • Troubleshooting and Performance Tuning :

  • Utilize extensive experience in trouble-shooting, query optimization, and performance tuning, using explain plans to optimize query execution.

    • Advanced Oracle Features :

  • Utilize Ref-Cursors, PL / SQL Tables, Materialized Views, Dynamic SQL, and Oracle RAC for efficient data processing and system performance.

    • Scheduler Jobs :

  • Write and maintain scheduler jobs, and troubleshoot issues in case of job failures.

    • Application Design and Support :

  • Analyze application requirements, provide recommended designs, and support code migration from development to staging environments.

    • Complex SQL Queries and PL / SQL Procedures :

  • Develop complex SQL queries and PL / SQL procedures to extract data from various source tables.

    • Team Collaboration :

  • Work independently and collaboratively with team members to deliver high-quality results under pressure and tight deadlines.

    • Requirements :

  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  • Minimum 5 years of relevant experience in all phases of the SDLC.
  • Extensive experience in SQL and PL / SQL programming, including packages, stored procedures, functions, triggers, indexes, and exception handling.
  • Proficiency in creating database objects using Oracle tools such as SQL-Plus, SQL Developer, and Toad.
  • Strong working knowledge of loading data using SQL-Loader and PL / SQL with different file formats.
  • Proven track record in trouble-shooting, query optimization, and performance tuning using explain plans.
  • Experience with advanced Oracle features like Ref-Cursors, PL / SQL Tables, Materialized Views, Dynamic SQL, and Oracle RAC is highly desirable.
  • Ability to write and maintain scheduler jobs and handle any issue resolution related to job failures.
  • Strong analytical and problem-solving skills.
  • Ability to analyze application requirements and provide recommended designs.
  • Proficiency in writing complex SQL queries and PL / SQL procedures to extract data from various source tables.
  • Excellent ability to work independently and as part of a team, delivering high-quality results under pressure and tight deadlines

    • (ref : hirist.tech)

    Create a job alert for this search

    Oracle Developer • Bangalore