Lead Software Engineer (DB Expert)

Design, optimize, and maintain Oracle Database structures including PL/SQL packages, indexing, partitioning, and materialized views aligned with application requirements.

Lead performance tuning through analysis of SQL queries, execution plans, and Oracle monitoring tools; resolve bottlenecks at application-DB interface.

Manage Oracle DB operations including schema changes, deployments, backup/recovery strategies, security features, compliance, troubleshooting, and provide technical leadership on Oracle DB integration with applications.

Strong expertise in Oracle Database 19c and above.

Expert-level skills in PL/SQL development, performance tuning, query optimization, indexing, Oracle RAC, Data Guard, and RMAN.

Experience with Oracle security implementations including roles, privileges, auditing, TDE, data masking, VPD/FGA.

Work Experience Required: Not explicitly mentioned in the JD.

Experienced in complex enterprise Oracle DB environments requiring advanced tuning, security, and high availability implementations.

Capable of collaborating with multi-disciplinary full-stack teams and coaching developers on SQL/PLSQL best practices.

Skilled in leading root cause analysis and driving operational reliability in large-scale database applications.