Lead Software Engineer (DB Expert)

About the role

Oracle Database Architecture & Application Design Design and maintain PL/SQL packages, schema structures, indexing strategies , and data models aligned with application requirements. Work with application architects to translate functional flows into efficient DB structures. Recommend and enforce best practices around data modeling, partitioning, materialized views , and storage design.

What you'll do

• Design and maintain PL/SQL packages, schema structures, indexing strategies , and data models aligned with application requirements
• Work with application architects to translate functional flows into efficient DB structures
• Recommend and enforce best practices around data modeling, partitioning, materialized views , and storage design
• Conduct deep‑dive analysis of SQL queries, execution plans, AWR/ASH reports , and Oracle Performance Hub
• Optimize complex PL/SQL code, triggers, functions, and stored procedures

What you need

• 5–12 yrs of experience
• SQL
• Oracle Database
• CI/CD
• Root cause analysis
• Data modelling
• Data privacy
• Any graduate