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.

• 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.

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

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

• 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.