Lead Software Engineer (DB Expert)
BengaluruFull-time5–12 yrsPosted 4 weeks ago
Senior software engineering role at Societe Generale in Bengaluru. Needs 5+ years.
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
- SQL
- Oracle Database
- CI/CD
- Root cause analysis
- Data modelling
- Data privacy