Responsibilities2. Performance Tuning & Optimization3. Application–DB Integration4. Oracle Database Operations & Reliability5. Security, Compliance & Data Governance6. Troubleshooting & Root Cause Analysis7. Technical Leadership & Collaboration

• 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 productive 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.
• Identify and resolve performance bottlenecks at the application–DB interface.
• Work with full‑stack teams to validate and optimize ORM mappings, JDBC/ODP.NET usage, and application query patterns.
• Ensure adherence to Oracle DB best practices in application code.




• Provide guidance on transaction management, concurrency control, and cursor handling.
• Manage schema changes, DB deployments, versioning, and rollbacks using tools such as Liquibase/Flyway (if applicable).
• Monitor database health using Oracle Enterprise Manager (OEM), AWR, ASH, ADDM.
• Ensure strong backup, recovery, high availability (RAC/Data Guard), and DR strategies.
• Implement and manage Oracle security features: roles, privileges, auditing, TDE, data masking, VPD/FGA.
• Ensure compliance with internal and external regulatory frameworks (e.g., GDPR, PCI‑DSS).
• Maintain data quality and validation standards for the application domain.
• Lead resolution of Oracle‑related incidents, including performance degradations, deadlocks, and data inconsistencies.
• Perform RCA for outages and propose preventive measures.
• Work with SRE/DevOps teams to automate Oracle health checks and alerting

📌 Lead Software Engineer (Bengaluru)
🏢 Societe Generale Global Solution Centre
📍 Bengaluru