Job Description – PL/SQL Developer

Job Title: PL/SQL Developer
Location: Noida, Uttar Pradesh
Salary: ₹10–20 LPA

Job Summary

We are looking for an experienced PL/SQL Developer responsible for designing, developing, optimizing, and maintaining database solutions using Oracle PL/SQL. The ideal candidate should have strong SQL and PL/SQL programming skills, experience in database development, performance tuning, and troubleshooting.

Key Responsibilities

• Develop, maintain, and optimize complex SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Design and implement database solutions based on business requirements.
• Perform query optimization and database performance tuning.
• Develop and maintain database objects, including tables, views, indexes, and sequences.
• Analyze and troubleshoot database-related issues.
• Work with large datasets and ensure data integrity and consistency.
• Develop and maintain ETL processes and data integration solutions.
• Collaborate with application developers, business analysts, and QA teams.
• Participate in code reviews, testing, and deployment activities.
• Prepare technical documentation for database solutions.

Required Skills

• Strong experience in Oracle SQL and PL/SQL.
• Hands-on experience with stored procedures, functions, packages, and triggers.
• Good understanding of Oracle database architecture.
• Experience with query optimization and performance tuning.
• Knowledge of indexing, partitioning, and execution plans.
• Experience with database design, normalization, and data modeling.
• Strong debugging and troubleshooting skills.
• Good understanding of joins, subqueries, analytical functions, and complex SQL queries.

Preferred Skills

• Experience with Oracle Database 11g/12c/19c.
• Knowledge of ETL processes and data warehousing.
• Experience with Unix/Linux shell scripting.
• Familiarity with database migration and production support.
• Exposure to tools such as SQL Developer, TOAD, or PL/SQL Developer.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Strong analytical and problem-solving abilities.
• Good communication and collaboration skills.