01Overview
- Oracle 12c/19c/21c /26Ai architecture
- OEM 24AI new feature knowledge
- 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)
BE/BTech and/or MS in Computer Science or equivalent preferred.
10+ years of enterprise Oracle database experience with 3+ years of preferred hands-on banking/financial services.
Expert-level experience in:
- Oracle RAC
- Data Guard / Active Data Guard
- RMAN
- AWR/ASH performance diagnostics
- Partitioning & Advanced Compression
- OEM
Strong experience in large OLTP workloads (high TPS environments).
Experience handling multi-terabyte databases.
Robust scripting/automation experience (Shell, Python, Ansible).
1. 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.
2. 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.
3. Banking Domain Alignment
- Leads client situations in .
