Senior PL/SQL Developer (Oracle)
We are seeking an experienced PL/SQL Developer with 6+ years of hands-on expertise in Oracle SQL, PL/SQL development, and database performance tuning. This role is ideal for a developer who enjoys solving complex database challenges, optimizing high-volume systems, and delivering scalable, high-performance solutions.
Key Responsibilities
- Develop and maintain Oracle database objects including Procedures, Packages, Functions, Views, and Triggers.
- Write, test, troubleshoot, and optimize complex SQL and PL/SQL code.
- Analyze execution plans and improve database 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 Qualifications
- 6+ years of Oracle SQL and PL/SQL development experience.
- Strong expertise in Oracle Database, SQL, and PL/SQL programming.
- Advanced knowledge of Stored Procedures, Packages, Functions, Triggers, Cursors, and Exception Handling.
- Proven experience in SQL performance tuning, execution-plan analysis, indexing, and query optimization.
- Strong understanding of Oracle Optimizer, statistics, joins, partitioning, and data modeling.
- Experience working with large-scale production databases.
- Hands-on experience with Toad for Oracle, DataGrip, and TFS.
Nice to Have
- Experience with Microsoft SQL Server and T-SQL.
- Familiarity with Azure Services, Azure DevOps, and cloud database concepts.
- Oracle and/or Azure certifications.
