105 Burgeon IT Services Jobs
PL-SQL Developer - Database Performance Tuning (7-10 yrs)
Burgeon IT Services
posted 18d ago
Flexible timing
Key skills for the job
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.
Functional Areas: Software/Testing/Networking
Read full job description