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.2. High Availability & Disaster Recovery Architect 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.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 systemsTreasury systemsRisk & Compliance platformsData Warehouse & Regulatory reportingEnsure 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 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).5. Automation & Operational Excellence Develop 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. .