Oracle PL​/SQL Developer

Key Responsibilities
1) Technical Leadership & Architecture

• Lead the design and development of Oracle database solutions using PL/SQL, SQL, packages, procedures, functions, triggers, cursors, and collections.
• Define and enforce database design standards, coding guidelines, naming conventions, and best practices.
• Drive database architecture decisions for scalability, security, performance, resiliency, and maintainability.
• Review and approve solution designs, PL/SQL code, data models, and technical documentation.
• Mentor developers on PL/SQL performance, query optimization, indexing strategy, and coding craftsmanship.

• Modernize legacy database logic by refactoring monolithic PL/SQL into modular, reusable components.
• Design/implement data access patterns, APIs/contracts as needed (DB layer), and robust error handling.
• Support initiatives involving data platform upgrades, schema redesign, re-partitioning, and storage optimization.
• Work closely with architects and product teams to translate business requirements into efficient data models and database services.

• Diagnose and resolve performance issues using execution plans, AWR/ASH reports, SQL Trace/TKPROF, and optimizer statistics.
• Optimize SQL queries, join strategies, index design (B-Tree, bitmap), partitioning, and materialized views.
• Improve batch performance via bulk collect/forall, pipelined functions, parallel execution, and advanced PL/SQL tuning techniques.

• Lead and coordinate L2/L3 production support for Oracle database components, including incident analysis and root‑cause resolution.
• Implement proactive monitoring and performance baselining, and participate in on‑call/critical support rotations as required.
• Ensure stability through release governance, rollback strategies, and robust deployment readiness checks.

• Ensure adherence to enterprise security standards including least privilege, role‑based access control, auditing, and secure coding.
• Implement measures for data protection, encryption (where applicable), masking, and compliance requirements.
• Ensure the database layer follows secure development lifecycle practices.

• Plan and track delivery across sprints/releases; manage dependencies and risks; ensure predictable outcomes.
• Lead cross‑functional collaboration with QA, Dev Ops, application teams, business stakeholders, and vendors.
• Provide regular status updates and ensure alignment on scope, timelines, and quality targets.