• 10+ years of development experience using PL/SQL
• Very good knowledge of SQL (aggregation functions, Joins and various built-in SQL functions and data types).
• Experience in a high volume, highly scalable transaction processing environment.
• Sound knowledge of advanced SQL, which includes analytical SQL, hierarchical SQL, dynamic SQLs and regular expressions.
• Sound knowledge of advanced PL/SQL, PL/SQL collections, external subroutines, web-interface, n/w interface, file handling functions.
• Sound knowledge for SQL performance tuning, analyzing SQL joins execution plan, indexing, partitioning and optimizer hints.
• Sound knowledge of PL/SQL performance tuning, AWR, ASH analysis, database statistics gathering.