Oracle PL / SQL Developer

We are looking for an experienced Oracle PL/SQL Developer with strong hands-on expertise in Oracle database development, SQL, PL/SQL programming, query optimization, and performance tuning. The candidate will be responsible for developing and maintaining database components, troubleshooting production issues, and working closely with application and business teams.

Responsibilities:

• Design, develop, and maintain PL/SQL procedures, functions, packages, triggers, views, and cursors.
• Write and optimize complex SQL queries involving joins, subqueries, analytical functions, and aggregations.
• Perform SQL/PLSQL performance tuning and query optimization.
• Analyze execution plans and improve database performance through indexing and query optimization.
• Design and maintain database objects, including tables, indexes, constraints, sequences, and partitions.
• Perform database development, enhancement, debugging, and troubleshooting.
• Support data migration, ETL, data cleansing, and data integration activities.
• Investigate and resolve production issues and perform root-cause analysis.
• Work closely with application developers, DBAs, QA, business analysts, and other stakeholders.
• Participate in code reviews, testing, deployment, and technical documentation.
• Follow Agile/Scrum development practices and coding standards.

Requirements:

• Strong hands-on experience in Oracle SQL and PL/SQL.
• Stored Procedures, Functions, Packages, and Triggers.
• Experience in complex SQL queries, query optimization and performance tuning, database design and data modeling, joins, cursors, collections, exception handling, tables, indexes, constraints, views, debugging, and production support.