PL/SQL Developer

PL/SQL Developer

Experience: 5+ Years

Location: Remote

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:

5+ years experience as an Oracle PL/SQL Developer.

Strong proficiency in PL/SQL development in Oracle environments.

Proven expertise in writing complex stored procedures, functions, packages, and triggers.

Deep understanding of query optimization, execution plans, and Oracle indexing strategies.

Hands-on experience with performance tuning tools (e.g., Oracle AWR, ADDM, SQL Trace,

TKPROF).

Experience working with large datasets, data migration, and ETL logic.

Proficient in Oracle database concepts (12c, 19c, or later). Ability to analyze bottlenecks and propose robust solutions.

Strong analytical and problem-solving skills.

Nice to Have:

Experience in Agile/Scrum teams.

Forward-thinking, proactive approach to emerging Oracle technologies.

Strong collaboration skills, working cross-functionally with developers, architects, and DBAs.