PL/SQL Developer

SRM Technologies; Hyderabad; On-site; INR 900,000 - 1,300,000; Full time

Job summary

SRM Technologies in Hyderabad, India, seeks an experienced PL/SQL Developer to design, optimize, and maintain PL/SQL components for high-performance database systems. You will develop procedures, functions, packages, and views, and ensure scalable data processing with clean coding standards.

You will work with loops, cursors, temporary tables, and partitioning techniques to improve performance, perform query optimization, and troubleshoot issues, collaborating with cross-functional teams to

Qualifications

• Strong proficiency in PL/SQL programming (procedures, functions, packages, views).
• Loops, cursors, and temporary tables for data processing.
• Indexing and query optimization techniques.
• Performance tuning with execution plans and optimizer hints.
• Partitioning and modular code design.
• Debugging and problem-solving skills.
• Understanding of database architecture and data modeling concepts.

Responsibilities

• Design, develop, and maintain PL/SQL procedures, functions, packages, and views.
• Write efficient and optimized SQL queries for large datasets.
• Perform query performance tuning using execution plans, indexing strategies, and optimizer hints.
• Work with loops, cursors, and temporary tables for complex data processing.
• Implement partitioning strategies to improve performance.
• Debug and troubleshoot database issues, ensuring proper exception handling.
• Collaborate with cross-functional teams to understand requirements and deliver scalable solutions.
• Adhere to coding standards and best practices in modular development.

Skills

PL/SQL

Loops & Cursors

Query Optimization

Partitioning

Debugging

Data Modeling

Communication

Job description

Job Summary:

We are looking for an experienced PL/SQLDeveloper with strong expertise in database programming and performanceoptimization. The ideal candidate will be responsible for developing,maintaining, and optimizing PL/SQL components while ensuring high performanceand reliability of database systems.

Key Responsibilities:

• Design, develop, and maintain PL/SQL procedures, functions,packages, and views
  
• Write efficient and optimized SQL queries for large datasets
  
• Perform query performance tuning using execution plans,indexing strategies, and optimizer hints
  
• Work with loops, cursors, and temporary tables for complex dataprocessing
  
• Implement partitioning strategies to improve performance andmanage large tables
  
• Debug and troubleshoot database issues, ensuring properexception handling
  
• Collaborate with cross-functional teams to understandrequirements and deliver scalable solutions
  
• Ensure adherence to coding standards and best practices inmodular development
  

Required Skills:

• Strong proficiency in PL/SQL programming (procedures,functions, packages, views)
  
• Hands-on experience with loops, cursors, and temporary tables
  
• Solid understanding of indexing and query optimizationtechniques
  
• Expertise in performance tuning, execution plans, and optimizerhints
  
• Experience with table partitioning and modular code design
  
• Strong debugging and problem-solving skills
  
• Good understanding of database architecture and data modelingconcepts
  

Preferred Qualifications:

• Experience working with development or from product
  
• Experience working in Agile environments
  
• Exposure to large-scale enterprise applications
  
• Strong communication and collaboration skills