Senior PL/SQL Developer (Oracle)

About the role

An experienced PL/SQL Developer with 6+ years of hands-on expertise in Oracle SQL, PL/SQL development and database performance tuning is sought. The role suits someone who enjoys solving complex database challenges, optimizing high-volume systems and delivering scalable, high-performance solutions.

Key responsibilities

• Develop and maintain Oracle database objects such as procedures, packages, functions, views and triggers.
• Write, test, troubleshoot and optimize complex SQL and PL/SQL code.
• Analyze execution plans and improve performance through query tuning, indexing and optimization.
• Troubleshoot slow-running queries and production database issues.
• Optimize joins, indexes, statistics, partitioning and overall database performance.
• Support database deployments, releases and production environments.
• Collaborate with application development teams on database integration requirements.
• Maintain technical documentation and use TFS for source control and release management.

Required profile

• 6+ years of Oracle SQL and PL/SQL development experience.
• Proven experience in SQL performance tuning, execution-plan analysis, indexing and query optimization.
• Experience working with large-scale production databases.

Required skills

• Strong expertise in Oracle Database, SQL and PL/SQL; stored procedures, packages, functions, triggers, cursors and exception handling.
• Understanding of the Oracle Optimizer, statistics, joins, partitioning and data modeling.
• Hands-on experience with Toad for Oracle, DataGrip and TFS.
• Nice to have: Microsoft SQL Server and T-SQL, Azure services, Azure DevOps, cloud database concepts and Oracle/Azure certifications.