Job Description

We are looking for a Senior Team Lead with deep expertise in Oracle PL/SQL and Oracle Database (8+ years ) to lead enterprise-scale application development, modernization, and support programs. This role requires strong technical leadership, hands-on database architecture experience, and the ability to drive delivery excellence across cross-functional teams. The ideal candidate combines technical depth, people leadership, and stakeholder management to deliver high-quality, scalable, secure, and high-performing database solutions in complex enterprise environments.

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.

2) Database Development & Modernization

• 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.

3) Performance Tuning & Optimization

• 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.

4) Production Support & Reliability

• 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.

5) Security, Compliance & Data Governance

• 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.

6) Delivery Leadership & Stakeholder Management

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

Job Tags

Similar Jobs