Confirmed on the employer's own hiring board on Nov 10, 2026. First seen by Alion on Nov 10, 2026. Tech Mahindra scores A on the Alion truth index.
Job Description
Skill Set :
Oracle Database Administration
Total Experience :
4.00 to 10.00 Years
No of Openings :
1
Job Post Date :
06/11/2026
Job Expiry Date :
31/12/2026
Domain :
IT
Location :
NEW DELHI [India]
Job Reference No :
4117135
Job Summary
DBA Key Responsibilities
Position is expected to work on site at Client Premises in a 24X7 shift. Candidate will have 5+ years of experience with Oracle Database with role as n DBA/Consultant/Data Base Support Engineer.
1. 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
- 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
5. Automation & Operational Excellence
- Develop automation using:
- Shell / Python / Ansible
- 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
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

