We are looking for an experienced PL SQL Developer with expertise in Oracle Database development who specializes in performance tuning and optimization of complex queries and stored procedures The ideal candidate should have strong experience in designing developing and maintaining PL SQL code and should be able to work closely with application and DBA teams to ensure optimal database performance Experience 7 Years Location Remote Salary Range 10-12LPA Key Responsibility PL SQL Developer Develop and maintain complex PL SQL packages procedures triggers and functions for mission-critical applications o Analyze and optimize SQL queries and database performance for high-volume environments o Perform SQL query tuning execution plan analysis and index optimization o Leverage Oracle tools AWR ADDM SQL Trace TKPROF for in-depth performance diagnostics and tuning o Participate in planning and executing Oracle database upgrades e g 12c 19c to 23c o Collaborate with application developers and DBAs to improve application performance and scalability o Work closely with DBAs to ensure zero minimal downtime during migrations and upgrades o Participate in code reviews and enforce best practices for database development o Troubleshoot and resolve performance-related issues in production and non-production environments o Assist in database schema design and contribute to data architecture discussions o Document technical designs processes and implementation details Required Skills o 5 years experience as an Oracle PL SQL Developer o Strong proficiency in PL SQL development in Oracle environments o Proven expertise in writing complex stored procedures functions packages and triggers o Deep understanding of query optimization execution plans and Oracle indexing strategies o Hands-on experience with performance tuning tools e g Oracle AWR ADDM SQL Trace TKPROF o Experience working with large datasets data migration and ETL logic o Proficient in Oracle database concepts 12c 19c or later o Ability to analyze bottlenecks and propose robust solutions o Strong analytical and problem-solving skills Nice to Have o Experience in Agile Scrum teams o Forward-thinking proactive approach to emerging Oracle technologies o Robust collaboration skills working cross-functionally with developers architects and DBAs Job Type Full-time Pay 800 000 00 - 1 000 000 00 per year Work Location In person