PL/SQL Developer
Description
Hiring: Senior PL/SQL Developer
Experience: 10+ Years
Job Type: W2 Contract
Job Description
We are looking for an experienced Senior PL/SQL Developer with 10+ years of hands-on experience in Oracle database development, PL/SQL programming, query optimization, and database performance tuning. The ideal candidate should have strong expertise in developing complex SQL queries, stored procedures, functions, packages, and triggers.
Key Responsibilities
Design, develop, and maintain complex PL/SQL procedures, functions, packages, and triggers.
Write and optimize complex SQL queries for large-scale databases.
Perform SQL query tuning, performance optimization, and troubleshooting.
Work with Oracle databases, indexing, partitioning, and execution plans.
Develop and maintain database objects to support enterprise applications.
Analyze business requirements and translate them into technical solutions.
Perform data migration, data validation, and database integration activities.
Identify and resolve database performance issues and production defects.
Collaborate with application developers, business analysts, and QA teams.
Participate in code reviews, unit testing, and deployment activities.
Required Skills
10+ years of experience in Oracle PL/SQL development.
Strong expertise in SQL and advanced PL/SQL programming.
Hands-on experience with Stored Procedures, Functions, Packages, Cursors, and Triggers.
Strong knowledge of Oracle Database architecture.
Experience with SQL tuning, query optimization, and performance troubleshooting.
Knowledge of indexing, partitioning, joins, analytical functions, and execution plans.
Experience with database design, data modeling, and normalization.
Proficiency in debugging and resolving complex database issues.
Experience working in Agile/Scrum development environments.
Preferred Skills
Experience with Oracle 12c, 19c, or higher.
Exposure to Unix/Linux shell scripting.
Experience with ETL processes and data integration.
Knowledge of Oracle Forms, Reports, or database utilities is a plus.
Experience with large-scale enterprise applications.
Skills
Sign in to read and join the discussion.