PL-SQL Developer - Database Performance Tuning

Position : PL-SQL developer Location : Pune, Hyderabad Duration : C2H Exp : 8 Year Mandatory skills : PL SQL stored procedure, packages, functions, & triggers , cursors ,joins, subqueries. Job Description : - Strong communication and stakeholder management skills. - Hands on development using Oracle Materialized views , Partitioning , DB links etc - Experience in tuning Oracle queries in large databases. - Experience in performance tuning using AWR , ASH reports etc. - Hands on experience in analyzing TKPROF report - Knowledge on RLS(Row Level Securities) , multi schema approach or Oracle In Memory is an add on - Should have a good knowledge in Advanced PL/SQL - Must have strong PL SQL stored procedure, packages, functions, & triggers , cursors ,joins, subqueries, Oracle Batches . - Strong experience in PL/SQL development, including the creation and maintenance of stored procedures, packages, functions, and triggers. - In-depth understanding of joins, subqueries, and cursors for complex query optimization. - Proficient with Oracle Batches for batch processing and data handling. - Experience with Materialized Views for caching large result sets to improve query performance. - Knowledge of Partitioning strategies for large datasets and performance improvements. - Familiarity with Oracle SQL tuning techniques, including indexing strategies and query optimization. - Excellent problem-solving skills and ability to work with minimal supervision. - Ability to understand and apply database design and data integrity principles. - Good communication skills to interact with cross-functional teams and clients. (ref:hirist.tech)

Location: in, IN

Posted Date: 2/22/2025