Consultant Technical Lead - Oracle Performance Tuning

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 –

• Cloud Database Administrator (Exadata Cloud Specialist)
  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.
• Key Responsibilities
  1. Exadata Cloud Architecture & Deployment
• Architect, deploy, and manage Exadata Cloud Service (ExaCS) and Exadata Cloud@Customer (ExaCC) environments.
  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)
• Install, configure, patch, and upgrade Oracle Database on Exadata (12c/19c/21c).
  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
• Conduct in-depth performance diagnostics using:
• AWR, ASH, ADDM
  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
• Automate Exadata provisioning, patching, monitoring, and operational workflows using:
• Terraform (OCI)
  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)
• Design and manage High Availability (HA) and DR architectures using:
• RAC on Exadata
  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
• Implement strong security controls:
• IAM policies and network segmentation
  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
• Resolve performance degradations, kernel issues, storage anomalies, and RAC cluster instabilities.
  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
• Collaborate with cloud engineering, infrastructure, application, and security teams.
  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
• 8–12+ years Oracle DBA experience with 4+ years on Exadata (Cloud or on-premise).
  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 Exadata Database Machine Specialist
  Oracle Cloud Infrastructure Architect Associate/Professional
  Oracle OCP/OCM for 12c/19c
  Autonomous Database Specialist
• 
  Education

• 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.