PL/SQL Developer
Ashwanth KumarRemoteMIDPosted 10d ago
PL/SQLSQLDatabase DevelopmentBULK COLLECTFORALLPL/SQL CollectionsCursorsDatabase TriggersQuery OptimizationPerformance Tuning
About the Role
We are looking for a skilled PL/SQL Developer to join our team and work on SQL/PLSQL development, database programming, and performance optimization.
Key Responsibilities
• Develop, maintain, and optimize complex SQL queries and PL/SQL programs
• Work extensively with Advanced PL/SQL, including procedures, functions, and packages
• Implement BULK COLLECT and FORALL for efficient bulk data processing
• Work with PL/SQL collections, including nested tables, VARRAYs, and associative arrays
• Develop and manage explicit and implicit cursors
• Create, maintain, and troubleshoot database triggers
• Handle exceptions and debug PL/SQL code
• Optimize query performance and ensure database efficiency
Requirements
• Strong hands-on experience in SQL and Advanced PL/SQL
• Expertise in BULK COLLECT and FORALL
• Good understanding of PL/SQL collections
• Experience with cursors, triggers, procedures, functions, and packages
• Strong debugging, analytical, and problem-solving skills
• Knowledge of SQL query optimization and performance tuning