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, valuable 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.

📌 Core DBA (India)
🏢 NTT
📍 India