PL / SQL Developer

Job Title : PL / SQL Developer

Experience : 5+ Years

Location : Remote

Time Zone : 1 pm – 10 pm

Secondary Tech Stack :

Job Summary : 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.

Key Responsibilities :

• Develop and maintain complex PL / SQL packages, procedures, triggers, and functions for mission-critical applications.
• Analyze and optimize SQL queries and database performance for high-volume environments.
• Perform SQL query tuning, execution plan analysis, and index optimization.
• Leverage Oracle tools (AWR, ADDM, SQL Trace, TKPROF) for in-depth performance diagnostics and tuning.
• Participate in planning and executing Oracle database upgrades (e.g., 12c / 19c to 23c).
• Collaborate with application developers and DBAs to improve application performance and scalability.
• Work closely with DBAs to ensure zero / minimal downtime during migrations and upgrades.
• Participate in code reviews and enforce best practices for database development.
• Troubleshoot and resolve performance-related issues in production and non-production environments.
• Assist in database schema design and contribute to data architecture discussions.
• Document technical designs, processes, and implementation details.

Required Skills :

Nice to Have :

Key Points :