Experience
10 - 15 yrs
Job Location
Mumbai, India
Vacancy
1
Designation
Oracle Database Administrator
Job Type
ONSITE
Job Description
- Position is expected to work on-site at Client Premises in a 24X7 shift. Candidate will have 10+ years of experience with Oracle Database with role as n DBA/Consultant/Data Base Support Engineer. Academic
- Qualifications with BE/BTech and/or MS in Computer Science or equivalent preferred.
- 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).
- 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.