Core Database Administrator

NTT DATA BUSINESS SOLUTIONS; Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

NTT DATA BUSINESS SOLUTIONS Bengaluru is seeking a senior Performance Engineer to lead enterprise Oracle database optimization across OLTP workloads and core banking environments. You will diagnose bottlenecks, implement tuning strategies, and drive automation for repeatable improvements.

Responsibilities include advanced diagnostics with AWR/ASH, RMAN backups, OEM monitoring, and multi-cloud integration (OCI, Azure, AWS, GCP).

Qualifications

• 10+ years of enterprise Oracle database experience with 3+ years in banking/financial services.
• Expert-level experience in Oracle RAC, RMAN, AWR/ASH diagnostics, Partitioning Advanced Compression, OEM.
• Strong experience in large OLTP workloads and multi-terabyte databases.
• Scripting/automation skills (Shell, Python, Ansible) and cloud exposure (OCI preferred).
• Hands-on with upgrades/migrations and GoldenGate replications; familiarity with WebLogic.

Responsibilities

• Lead advanced performance tuning using AWR/ASH analysis, SQL tracing, execution plan deep analysis, wait-event methodology, and Real-Time ADDM.
• Diagnose systemic issues (I/O bottlenecks, latch contention, memory pressure, CPU saturation).
• Optimize indexing, partitioning, query rewrites, PL/SQL, and connection pooling patterns.
• Establish performance baselines for OLTP-heavy core banking workloads.
• Architect and manage Oracle RAC, Data Guard, DR drills, and RBI/compliance alignment.
• Collaborate with cross-functional stakeholders and support crises with RCA reports.

Skills

Oracle DBA expertise

AWR/ASH diagnostics

Scripting (Shell, Python)

Ansible

Pre-Sales for Oracle / MS-SQL

Multicloud exposure

WebLogic

OLTP performance optimization

Education

Oracle OCP / OCM certification

Tools

OEM

RMAN

SQL Monitor

GoldenGate

Exadata

Job description

Performance Engineering Optimization (Core Focus)

Lead advanced performance tuning using:

• AWR/ASH analysis
• SQL tracing
• Execution plan deep analysis
• Wait-event methodology
• SQL Monitor Real-Time ADDM

Diagnose systemic issues (I/O bottlenecks, latch contention, memory pressure, CPU saturation).

Optimize:

• Indexing strategies
• Partitioning strategies
• Query rewrites
• PL/SQL optimization
• Connection pooling patterns

Establish performance baselines for OLTP-heavy core banking workloads.

High Availability Disaster Recovery

• Architect and manage:
  • Oracle RAC (multi-node clustering)
  • Data Guard / Active Data Guard
  • DR drills failover simulations
• Own RPO/RTO alignment with banking regulatory requirements.
• Design backup recovery frameworks (RMAN, incremental merge, backup validation).
• Ensure DR readiness with periodic validation and audit documentation.

Banking Domain Alignment

Leads client situations in crisis management, good executive communication and cross-functional leadership to Leadership Competencies, e.g. Lead crisis resolution for Sev1/Sev2 database incidents and delivers executive-ready RCA reports.

Aligns with cross-functional stakeholders (IT, business, audit) in large banking teams

Communicate complex database risk and strategy to C-suite executives and regulatory auditors.

• Support mission-critical systems such as:
  • Core Banking (CBS)
  • UPI / Payments / Switch systems
  • Treasury systems
  • Risk Compliance platforms
  • Data Warehouse Regulatory reporting
• Ensure compliance with RBI/central bank guidelines and audit standards.
• Support high transaction throughput environments (large OLTP systems).

Security Compliance

• Implement database hardening and security best practices:
  • Role-based access control
  • Privilege minimization
  • Database Vault (if applicable)
  • Transparent Data Encryption (TDE)
  • Data masking for non-prod environments
• Support audit requirements and regulatory inspections.
• Ensure encryption at rest and in transit (SSL/TLS, wallet management).

Automation Operational Excellence

• Develop automation using:
• Shell / Python
• Ansible
• Infrastructure-as-Code principles
• Standardize patching, upgrade, and rollback frameworks.
• Enhance observability via OEM / custom monitoring.
• Improve MTTD/MTTR via structured incident response and RCA processes.

Required Experience

• 10+ years of enterprise Oracle database experience with 3+ years of preferred hands‑on banking/financial services.
• Expert‑level experience in:
  • Oracle RAC
  • RMAN
  • AWR/ASH performance diagnostics
  • Partitioning Advanced Compression
  • OEM
• Strong experience in large OLTP workloads (high TPS environments).
• Experience handling multi‑terabyte databases.
• Strong scripting/automation experience (Shell, Python, Ansible).
• Experience in Pre‑Sales for Oracle, MS‑SQL, Open source Database
• Hands‑on experience with multicloud - OCI, Azure, AWS, GCP
• Ability to execute DBA tasks such as Upgrade, migration.
• Experience with Golden Gate replications
• Experience with SQL Server AG
• Experience with Weblogic upgrade

Technical Skills (Expanded)

• Oracle 12c/19c/21c /26Ai architecture
• ASM storage management
• Exadata (Smart Scan, Storage Indexes, HCC)
• GoldenGate (replication migration scenarios)
• Database upgrades migration strategies
• Edition-Based Redefinition (EBR)
• SQL Plan Management (SPM)
• Real Application Testing (RAT)
• Resource Manager
• Connection pooling (WebLogic, application integration)
• Linux performance diagnostics (vmstat, iostat, top, sar)
• Network latency analysis
• Cloud exposure (OCI preferred)

Preferred Qualifications

• Oracle OCP / OCM certification.
• Experience with Exadata or engineered systems.
• Exposure to cloud-native database architectures.
• Experience in regulatory audits within banking sector.