PL-SQL Developer - Database Performance Tuning (7-10 yrs)

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.