Core DBA

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. 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 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). 4. 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). 5. 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 • 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. • 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.