Database - Lead

Job Description

Extensive knowledge in SQL/ PLSQL/Oracle/Oracle Forms/Oracle reports/Ms SQL/Power Builder. Create and optimise packages, procedures, functions, Triggers, Views, cursors to develop application. Experience in create/modifies packages, views, procedures, Triggers, Views, cursors and functions. Create new custom Reports, Forms and modify existing Reports according to the requirement. Involve in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, maintenance and reporting to the client. Experience on Evaluation, Implementation and support with a skillset of Oracle, PL-SQL. Involve in requirement gathering and coordination with users. Hands on in Oracle version 19c and 21c Strong coding knowledge in PLSQL (Bulk Collect, Recursion, Loops (FOR, WHILE DO), Nested blocks, Exception Handling) Strong Coding knowledge in SQL (Analytical functions, View and Materialized Views, Sys tables and Privileges) Good understanding of Performance tuning concepts like Access Paths, Join methods, Partitioning, etc. . Awareness about Oracle data various dictionary and their significance. Complex Queries : Nested queries, inline views, co-related subqueries Awareness about Hierarchical queries Mandatory Competencies Database - Oracle Database - PL SQL Database - SQL Database - MySQL Beh - Communication and collaboration At Iris Software, we offer world-class benefits designed to support the financial, health and well-being needs of our associates to help achieve harmony between their professional and personal growth. From comprehensive health insurance and competitive salaries to flexible work arrangements and ongoing learning opportunities, were committed to providing a supportive and rewarding work environment. Join us and experience the difference of working at a company that values its employees success and happiness.