Consultant Technical Lead - Oracle Performance Tuning
at Societe Generale
Posted a day ago
No clicks
- Compensation
- Not specified
- City
- Bengaluru
- Country
- India
Currency: Not specified
Consultant Technical Lead focusing on Oracle performance tuning and Exadata cloud architectures for SG's IT division. You will architect, administer, and optimize large Oracle databases on Exadata Cloud Service and Exadata Cloud@Customer, performing advanced diagnostics and SQL tuning. You will lead cloud modernization initiatives, automate provisioning and monitoring, and design HA/DR and security controls. The role requires 8–12+ years of Oracle DBA experience with Exadata and offers a hybrid work arrangement in Bangalore, India.
Department \/ Project Overview<\/strong> \u2013 GTS\/PAS\/DRE Team provides 24 * 7 production database support to all the MKT\/GDI & Retail Banking customers across SG group. Project includes incidents, requests & changes management on all the Retail applications hosted on multiple technologies including Oracle, MSSQL, Informix, DB2, Teradata & Open Source RDBMS (PostgreSQL, MongoDB & MYSQL). The project is responsible for the complete life cycle management of databases including Migrations, Upgrades etc. Additionally the project supports all the maintenance operations, performance analysis & troubleshooting, patching & DRP exercises.<\/p> Key Responsibilities \u2013<\/strong><\/p> Bachelor\u2019s or Master's degree in Computer Science, Engineering, IT, or related field.<\/p><\/li><\/ul>Profile required Years of Experience \u201315+<\/b>\u00a0years and above<\/p> Qualification \/ Certification \u2013 <\/b>Engineering graduate \/ MCA \/ Computer Science Graduate or PG. Any relevant RDBMS certification is an added advantage.<\/p> GTS\/PAS\/DRE Team provides 24 * 7 production database support to all the MKT\/GDI & Retail Banking customers across SG group. Project includes incidents, requests & changes management on all the Retail applications hosted on multiple technologies including Oracle, MSSQL, Informix, DB2, Teradata & Open Source RDBMS (PostgreSQL, MongoDB & MYSQL). The project is responsible for the complete life cycle management of databases including Migrations, Upgrades etc. Additionally the project supports all the maintenance operations, performance analysis & troubleshooting, patching & DRP exercises.<\/p> \u00a0<\/b><\/p>Why join us We are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status\u201d.<\/p>Business insight At Soci\u00e9t\u00e9 G\u00e9n\u00e9rale, we are convinced that people are drivers of change, and that the world of tomorrow will be shaped by all their initiatives, from the smallest to the most ambitious.<\/p> Whether you\u2019re joining us for a period of months, years or your entire career, together we can have a positive impact on the future. Creating, daring, innovating and taking action are part of our DNA.<\/p> If you too want to be directly involved, grow in a stimulating and caring environment, feel useful on a daily basis and develop or strengthen your expertise, you will feel right at home with us!<\/p> Still hesitating?<\/p> You should know that our employees can dedicate several days per year to solidarity actions during their working hours, including sponsoring people struggling with their orientation or professional integration, participating in the financial education of young apprentices and sharing their skills with charities. There are many ways to get involved.<\/p>","identifier":{"@type":"PropertyValue","name":"Recruitment Societe Generale","value":"26000298"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Bangalore","addressCountry":"India"}}} window.dataLayer = window.dataLayer || []; var aData = { customVarPage1: "Consultant Technical Lead - Oracle Performance Tuning", customVarPage2: "Bangalore", customVarPage3: "Permanent contract", customVarPage4: "26000298", customVarPage5: "SG Global Solution Centre", customVarPage6: "IT (Information Technology)", customVarPage7: "2026/02/21" } window.dataLayer.push(aData); Department / Project Overview – GTS/PAS/DRE Team provides 24 * 7 production database support to all the MKT/GDI & Retail Banking customers across SG group. Project includes incidents, requests & changes management on all the Retail applications hosted on multiple technologies including Oracle, MSSQL, Informix, DB2, Teradata & Open Source RDBMS (PostgreSQL, MongoDB & MYSQL). The project is responsible for the complete life cycle management of databases including Migrations, Upgrades etc. Additionally the project supports all the maintenance operations, performance analysis & troubleshooting, patching & DRP exercises. Key Responsibilities – Bachelor’s or Master's degree in Computer Science, Engineering, IT, or related field. Years of Experience –15+ years and above Qualification / Certification – Engineering graduate / MCA / Computer Science Graduate or PG. Any relevant RDBMS certification is an added advantage. GTS/PAS/DRE Team provides 24 * 7 production database support to all the MKT/GDI & Retail Banking customers across SG group. Project includes incidents, requests & changes management on all the Retail applications hosted on multiple technologies including Oracle, MSSQL, Informix, DB2, Teradata & Open Source RDBMS (PostgreSQL, MongoDB & MYSQL). The project is responsible for the complete life cycle management of databases including Migrations, Upgrades etc. Additionally the project supports all the maintenance operations, performance analysis & troubleshooting, patching & DRP exercises. We are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status”. At Société Générale, we are convinced that people are drivers of change, and that the world of tomorrow will be shaped by all their initiatives, from the smallest to the most ambitious. Whether you’re joining us for a period of months, years or your entire career, together we can have a positive impact on the future. Creating, daring, innovating and taking action are part of our DNA. If you too want to be directly involved, grow in a stimulating and caring environment, feel useful on a daily basis and develop or strengthen your expertise, you will feel right at home with us! Still hesitating? You should know that our employees can dedicate several days per year to solidarity actions during their working hours, including sponsoring people struggling with their orientation or professional integration, participating in the financial education of young apprentices and sharing their skills with charities. There are many ways to get involved.
Role Overview
The Expert Oracle Exadata Cloud DBA is responsible for architecting, administering, and optimizing large\u2011scale Oracle databases running on Oracle Exadata Cloud Service (ExaCS) and Exadata Cloud@Customer (ExaCC) platforms. This role requires advanced expertise in Exadata internals, cloud deployment patterns, performance tuning, automation, and high\u2011availability engineering.
The expert will lead Exadata cloud modernization initiatives, ensure top\u2011tier performance for mission\u2011critical workloads, and drive cloud architectural decisions across the enterprise.<\/li>
1. Exadata Cloud Architecture & Deployment<\/li>
Configure compute nodes, cell servers, storage servers, and networking for optimal performance.
Plan and implement capacity, resource allocation, storage tiering, and cluster scaling.
Lead migrations from on\u2011prem Exadata or non-Exadata platforms to Exadata Cloud.<\/li>
2. Advanced Oracle Database Administration (Exadata-Focused)<\/li>
Administer Oracle RAC, ASM, ACFS, and Exadata-specific features (Smart Scan, Smart Flash Cache, Storage Indexes).
Manage Cloud tooling: OCI Console, dbaascli, exadbscli, and cloud automation scripts.
Implement robust backup, recovery, and DR using RMAN, OCI Backup, and Data Guard.<\/li>
3. Exadata Performance Engineering & Optimization<\/li>
Exadata Metrics, CellCLI, DCLI
OEM, OCI Monitoring<\/li>
Optimize Smart Scan usage, Hybrid Columnar Compression (HCC), and I\/O Resource Management (IORM).
Tune SQL\/PLSQL workloads and optimize application interaction with Exadata hardware.<\/li>
4. Cloud Automation, DevOps & Infrastructure as Code<\/li>
Ansible
Python or Shell<\/li>
Build CI\/CD pipelines for database changes.
Integrate Exadata alerts and metrics with Prometheus, Grafana, OCI Monitoring, or OEM.<\/li>
5. High Availability & Disaster Recovery (Exadata-Focused)<\/li>
Active Data Guard
GoldenGate for real-time replication<\/li>
Implement cross-region DR with ExaCS or ExaCC.
Lead DR drills, failover\/failback testing, and infrastructure resilience validation.<\/li>
6. Exadata Cloud Security & Compliance<\/li>
TDE and Key Management (OCI Vault\/KMS)
Database auditing and isolation<\/li>
Enforce compliance with enterprise policies and regulatory standards (GDPR, PCI-DSS, SOX).<\/li>
7. Troubleshooting & Operational Excellence<\/li>
Perform root cause analysis for critical incidents and implement long-term solutions.
Provide 24x7 on-call support for production Exadata Cloud environments.<\/li>
8. Stakeholder Collaboration & Technical Leadership<\/li>
Act as the subject matter expert (SME) for Exadata Cloud strategy and governance.
Mentor junior DBAs and guide engineering teams on best practices.<\/li>
Required Skills & Qualifications
Technical Skills<\/li>
Expertise in Exadata Cloud Service, Exadata Cloud@Customer, Exadata X-series hardware.
Strong knowledge of RAC, ASM, ACFS, Data Guard, RMAN, GoldenGate.
Hands-on with CellCLI, DCLI, Exachk, and Exadata patching cycles.
Strong SQL\/PLSQL tuning and workload optimization abilities.
Proficiency in Linux OS internals, networking, and shell scripting.
Experience with Terraform, Ansible, DevOps tooling (Git, Jenkins).
Familiarity with OCI networking, IAM, VCN, Vault, and Monitoring.<\/li>
Preferred Certifications<\/li>
Oracle Cloud Infrastructure Architect Associate\/Professional
Oracle OCP\/OCM for 12c\/19c
Autonomous Database Specialist<\/li>
Education<\/li> Consultant Technical Lead - Oracle Performance Tuning
Responsibilities
Role Overview
The Expert Oracle Exadata Cloud DBA is responsible for architecting, administering, and optimizing large‑scale Oracle databases running on Oracle Exadata Cloud Service (ExaCS) and Exadata Cloud@Customer (ExaCC) platforms. This role requires advanced expertise in Exadata internals, cloud deployment patterns, performance tuning, automation, and high‑availability engineering.
The expert will lead Exadata cloud modernization initiatives, ensure top‑tier performance for mission‑critical workloads, and drive cloud architectural decisions across the enterprise.
1. Exadata Cloud Architecture & Deployment
Configure compute nodes, cell servers, storage servers, and networking for optimal performance.
Plan and implement capacity, resource allocation, storage tiering, and cluster scaling.
Lead migrations from on‑prem Exadata or non-Exadata platforms to Exadata Cloud.
2. Advanced Oracle Database Administration (Exadata-Focused)
Administer Oracle RAC, ASM, ACFS, and Exadata-specific features (Smart Scan, Smart Flash Cache, Storage Indexes).
Manage Cloud tooling: OCI Console, dbaascli, exadbscli, and cloud automation scripts.
Implement robust backup, recovery, and DR using RMAN, OCI Backup, and Data Guard.
3. Exadata Performance Engineering & Optimization
Exadata Metrics, CellCLI, DCLI
OEM, OCI Monitoring
Optimize Smart Scan usage, Hybrid Columnar Compression (HCC), and I/O Resource Management (IORM).
Tune SQL/PLSQL workloads and optimize application interaction with Exadata hardware.
4. Cloud Automation, DevOps & Infrastructure as Code
Ansible
Python or Shell
Build CI/CD pipelines for database changes.
Integrate Exadata alerts and metrics with Prometheus, Grafana, OCI Monitoring, or OEM.
5. High Availability & Disaster Recovery (Exadata-Focused)
Active Data Guard
GoldenGate for real-time replication
Implement cross-region DR with ExaCS or ExaCC.
Lead DR drills, failover/failback testing, and infrastructure resilience validation.
6. Exadata Cloud Security & Compliance
TDE and Key Management (OCI Vault/KMS)
Database auditing and isolation
Enforce compliance with enterprise policies and regulatory standards (GDPR, PCI-DSS, SOX).
7. Troubleshooting & Operational Excellence
Perform root cause analysis for critical incidents and implement long-term solutions.
Provide 24x7 on-call support for production Exadata Cloud environments.
8. Stakeholder Collaboration & Technical Leadership
Act as the subject matter expert (SME) for Exadata Cloud strategy and governance.
Mentor junior DBAs and guide engineering teams on best practices.
Required Skills & Qualifications
Technical Skills
Expertise in Exadata Cloud Service, Exadata Cloud@Customer, Exadata X-series hardware.
Strong knowledge of RAC, ASM, ACFS, Data Guard, RMAN, GoldenGate.
Hands-on with CellCLI, DCLI, Exachk, and Exadata patching cycles.
Strong SQL/PLSQL tuning and workload optimization abilities.
Proficiency in Linux OS internals, networking, and shell scripting.
Experience with Terraform, Ansible, DevOps tooling (Git, Jenkins).
Familiarity with OCI networking, IAM, VCN, Vault, and Monitoring.
Preferred Certifications
Oracle Cloud Infrastructure Architect Associate/Professional
Oracle OCP/OCM for 12c/19c
Autonomous Database Specialist
Education Profile required
Why join us
Business insight
Diversity and Inclusion
