27 Aug
|
NTT America
|
Bengaluru
27 Aug
NTT America
Bengaluru
**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. + Solid 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 (Bengaluru)
🏢 NTT America
📍 Bengaluru