Oracle PL/SQL Developer

Recmatrix Consulting; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A tech consulting firm in Bengaluru is seeking an experienced Oracle PL/SQL Developer. Responsibilities include designing and maintaining Oracle databases, optimizing SQL queries, and ensuring data integrity. The ideal candidate should have over 3 years of development experience and strong problem-solving skills. This is a full-time position with the expectation of working from the office.

Qualifications

• 3+ years of experience in Oracle PL/SQL development.
• Expertise in SQL and PL/SQL programming.
• Solid understanding of database design and normalization.

Responsibilities

• Design, develop, and maintain Oracle databases.
• Write, optimize, and debug complex SQL queries.
• Ensure data integrity and security.

Skills

Oracle PL/SQL development

SQL programming

Database design concepts

Performance tuning

Problem-solving skills

Education

Bachelor’s degree in computer science or related field

Tools

Oracle 11g

Oracle 12c

Oracle 19c

Job description

Overview

Recruitment Consultant @ Recmatrix | Sales, Recruiting

Job Title: Oracle PL/SQL Developer

Working model: WFO

Experience: 3 to 6 years

Notice Period: Immediate to 30 days

Responsibilities

• Design, develop, and maintain Oracle databases, including tables, views, indexes, and other database objects.
• Write, optimize, and debug complex SQL queries, stored procedures, functions, packages, and triggers.
• Collaborate with business analysts and other developers to translate business requirements into technical specifications and efficient database solutions.
• Perform performance tuning and query optimization to ensure scalability and efficiency of database applications.
• Ensure data integrity and security by implementing robust database constraints and security measures.
• Participate in code reviews, testing, and deployment processes.
• Troubleshoot and resolve database-related issues in a timely manner.
• Create and maintain comprehensive technical documentation for all database solutions.

Required Skills and Qualifications

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 3+ years of experience in Oracle PL/SQL development.
• Expertise in SQL and PL/SQL programming.
• Solid understanding of database design concepts, data modelling, and normalization.
• Experience with performance tuning techniques, including the use of Explain Plan and other optimization tools.
• Proficiency in working with Oracle database versions (e.g., 11g, 12c, 19c).
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration skills.

Good to Have

• Experience with other database technologies (e.g., SQL Server, MySQL, PostgreSQL).
• Knowledge of scripting languages like Unix Shell Scripting.
• Familiarity with ETL processes and data warehousing concepts.
• Experience with Agile development methodologies.

Senioriy level

• Associate

Employment type

• Full-time

Job function

• Information Technology

Industries

• Software Development, IT System Custom Software Development, and Insurance Agencies and Brokerages

Note: The following sections from the original listing appear to be postings or suggestions unrelated to the current role and have been removed to maintain focus on the job description.