Oracle PLSQL

Job Description

We are looking for a skilled PL/SQL Developer to design, develop, and maintain database-driven applications using Oracle PL/SQL. The ideal candidate should have strong expertise in writing complex SQL queries, PL/SQL procedures, functions, packages, and performance tuning.

Key Responsibilities

• Design, develop, and maintain Oracle PL/SQL programs such as procedures, functions, packages, triggers, and views
• Write and optimize complex SQL queries to support business requirements
• Perform database performance tuning and query optimization
• Debug and resolve production issues related to database components
• Work closely with application developers, business analysts, and QA teams
• Ensure data integrity, security, and adherence to best practices
• Support deployments, enhancements, and maintenance activities
  
  

Required Skills & Qualifications

• Strong hands-on experience in Oracle PL/SQL development
• Proficiency in writing complex SQL queries, joins, subqueries, and performance tuning
• Experience with Oracle Database (11g/12c/19c)
• Knowledge of indexes, partitions, cursors, collections, and exception handling
• Familiarity with Unix/Linux commands and shell scripting (preferred)
• Experience with version control tools (Git, SVN, etc.)
• Strong problem-solving and analytical skills
  
  

Job Description - Grade Specific

Has more than a year of relevant work experience. Solid understanding of programming concepts, software design and software development principles. Consistently works to direction with minimal supervision, producing accurate and reliable results. Individuals are expected to be able to work on a range of tasks and problems, demonstrating their ability to apply their skills and knowledge. Organises own time to deliver against tasks set by others with a mid term horizon. Works co-operatively with others to achieve team goals and has a direct and positive impact on project performance and make decisions based on their understanding of the situation, not just the rules.

---