Design, develop, and maintain Oracle databases using PL/SQL including stored procedures, functions, packages, triggers.
Write and optimize complex SQL queries, ensuring high performance in OLTP/batch systems.
Perform query tuning with tools like SQL Trace, Explain Plan, AWR, ADDM.
Develop database objects: packages, views, materialized views, ref cursors, dynamic SQL, bulk DML/collects.
Collaborate with developers, DBAs, data architects guide on schema design and data integration.
Ensure data security, backup & recovery strategies, version control, and regulatory compliance +8app.joinrise.co+8thejob.dev+8 +2apna.co+2 +1 .
Participate in code reviews and troubleshoot DB-related issues apna.co .
If senior/lead level: mentor junior team members, assist in peer reviews, manage low-level designs and risk mitigation

PLsql Developer

Job Description