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, positive 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

📌 Core Database Administrator (Bengaluru)
🏢 NTT DATA Business Solutions
📍 Bengaluru