Source description
About the role
- 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 .
More at Path Infotech