Walk-in || Oracle PLSQL Programmer

Role & responsibilities

• Develop, enhance, and maintain Oracle SQL queries, PL/SQL procedures, functions, packages, and triggers.
• Work on L3 development and production support, including debugging, performance tuning, troubleshooting, and root cause analysis.
• Optimize SQL queries for large datasets involving millions of rows to improve application performance.
• Implement bulk processing using BULK COLLECT, FORALL, and collections for high-volume data processing.
• Work with cursors, REF CURSORs, and dynamic SQL for complex business requirements.
• Design and maintain database objects such as tables, views, indexes, constraints, and partitions.
• Collaborate with Development, QA, and Business teams for requirement gathering, issue triaging, and defect resolution.
• Implement effective error handling, exception handling, logging, and debugging mechanisms.
• Support data migration, transformation, and integration activities.
• Work with tools such as Git, JIRA, Jenkins, and AutoSys or equivalent tools for version control, CI/CD, and job scheduling.
• Follow Agile/Scrum methodologies and participate in relevant ceremonies.

Required Skills & Experience

• 36 years of hands-on experience in Oracle SQL and PL/SQL development.
• Strong knowledge of SQL optimization techniques, including indexes, hints, execution plans, and statistics.
• Hands-on experience with PL/SQL programming constructs such as procedures, packages, functions, triggers, and cursors.
• Experience in performance tuning, debugging, and production incident support.
• Strong understanding of SDLC and Agile practices.
• Experience working with large datasets in OLTP/OLAP environments.
• Good understanding of database design and normalization.
• Strong problem-solving and analytical skills.
• Exposure to XML and JSON handling in Oracle is an added advantage.
• Good communication and collaboration skills for working with cross-functional teams.

Nice-to-Have Skills

• Knowledge of Oracle advanced features such as Materialized Views, Partitioning, and Parallel Query.
• Hands-on experience with Oracle XML DB and JSON functions.
• Exposure to AWS RDS / Cloud Databases.
• Experience with unit testing frameworks such as utPLSQL.