Oracle PLSQL Developer

Key Responsibilities

• Develop and maintain Oracle database objects including Tables, Views, Constraints, Sequences, and Synonyms
• Design and implement complex database objects such as Stored Procedures, Functions, Packages, and Collections
• Develop and manage PL/SQL programming including Triggers, Cursors, user-defined Exceptions, Pragma, Autonomous Transactions, Bulk Collect, FORALL, Hints, Explain Plan, and SYS_REFCURSOR
• Optimize SQL queries and perform database performance tuning
• Apply exception handling mechanisms with correct scope and visibility
• Participate in Agile/Scrum development methodology and sprint activities
• Communicate with clients for scoping, effort estimation, and status reporting
• Work with client-server applications using Oracle 10g/11g/12c, SQL Plus, TOAD, and SQL Loader
• Basic knowledge of UNIX commands and Oracle database administration