Core DBA

Performance Engineering & Optimization (Core Focus) Lead advanced performance tuning using:AWR/ASH analysisSQL tracingExecution plan deep analysisWait-event methodologySQL Monitor & Real-Time ADDMDiagnose systemic issues (I/O bottlenecks, latch contention, memory pressure, CPU saturation). Optimize:Indexing strategiesPartitioning strategiesQuery rewritesPL/SQL optimizationConnection pooling patternsEstablish performance baselines for OLTP-heavy core banking workloads. High Availability & Disaster RecoveryArchitect and manage:Oracle RAC (multi-node clustering)Data Guard / Active Data GuardDR drills & failover simulationsOwn 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, 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 systemsTreasury systemsRisk & Compliance platformsData Warehouse & Regulatory reportingEnsure compliance with RBI/central bank guidelines and audit standards. Support high transaction throughput environments (large OLTP systems). Security & ComplianceImplement database hardening and security best practices:Role-based access controlPrivilege minimizationDatabase Vault (if applicable)Transparent Data Encryption (TDE)Data masking for non-prod environmentsSupport audit requirements and regulatory inspections. Ensure encryption at rest and in transit (SSL/TLS, wallet management). Automation & Operational ExcellenceDevelop automation using:Shell / PythonAnsibleInfrastructure-as-Code principlesStandardize 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 RACData Guard / Active Data GuardRMANAWR/ASH performance diagnosticsPartitioning & Advanced CompressionOEMStrong 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 DatabaseHands-on experience with multicloud - OCI, Azure, AWS, GCPAbility to execute DBA tasks such as Upgrade, migration. Experience with Golden Gate replicationsExperience with SQL Server AGExperience with Weblogic upgrade Technical Skills (Expanded) Oracle 12c/19c/21c /26Ai architectureASM & storage managementExadata (Smart Scan, Storage Indexes, HCC)GoldenGate (replication & migration scenarios)Database upgrades & migration strategiesEdition-Based Redefinition (EBR)SQL Plan Management (SPM)Real Application Testing (RAT)Resource ManagerConnection pooling (WebLogic, application integration)Linux performance diagnostics (vmstat, iostat, top, sar)Network latency analysisCloud 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. Performance Engineering & Optimization (Core Focus) Lead advanced performance tuning using:AWR/ASH analysisSQL tracingExecution plan deep analysisWait-event methodologySQL Monitor & Real-Time ADDMDiagnose systemic issues (I/O bottlenecks, latch contention, memory pressure, CPU saturation). Optimize:Indexing strategiesPartitioning strategiesQuery rewritesPL/SQL optimizationConnection pooling patternsEstablish performance baselines for OLTP-heavy core banking workloads. High Availability & Disaster RecoveryArchitect and manage:Oracle RAC (multi-node clustering)Data Guard / Active Data GuardDR drills & failover simulationsOwn 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, 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 sy