Oracle PL/SQL Developer

Company: IT Services Organization

Key Skills: PLSQL, PL SQL, SQL, Oracle, PL/SQL, Stored Procedures, Triggers, Procedure

Roles and Responsibilities:

• Design, develop, test, and maintain robust PL/SQL code for various applications.
• Create and manage Oracle Packages, Procedures, Functions, Triggers, and Cursors.
• Collaborate with business analysts and cross-functional teams to gather and understand technical requirements.
• Optimize SQL queries and PL/SQL blocks for performance and scalability.
• Conduct code reviews, enforce coding standards, and mentor junior developers.
• Troubleshoot and resolve issues related to database logic, performance, and data integrity.
• Prepare and maintain technical documentation, including design specs and user guides.

Skills Required:

• Must-Have:
• Proficient in Oracle PL/SQL, PL SQL, and SQL
• Experience working with Oracle RDBMS
• Hands-on experience in writing complex queries, procedures, functions, packages, and views
• Strong debugging and problem-solving skills
• Good understanding of relational database design and data modeling
• Nice-to-Have:
• Experience in creating and managing Stored Procedures, Triggers, Cursors
• Familiarity with performance tuning and query optimization techniques
• Knowledge of version control systems (e.g., Git)
• Exposure to Agile methodologies

Education: Bachelor's degree in Computer Science, Information Technology, or a related field