Core DBA

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 r