Oracle DBA (L3 /L4)
Wipro
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
Wipro in Pune, India, seeks a Senior Oracle DBA with deep experience in Exadata, RAC, Data Guard, and ASM. The role covers Oracle 11g/12c/18c/19c/23ai in on‑prem and cloud contexts (AWS, Azure, OCI).
You will manage performance, backups, patching, and disaster recovery for large-scale production databases. The ideal candidate excels in troubleshooting, automating routine tasks, and delivering high‑availability architectures across multi-cloud environments, with a focus on minimising downtime and
Qualifications
- Extensive experience in Oracle DB administration in enterprise environments.
- Hands-on with Exadata, RAC, ASM, RMAN and GoldenGate.
- Experience across AWS, Azure and OCI cloud platforms.
Responsibilities
- Install, upgrade, maintain, and troubleshoot Oracle databases (11g/12c/18c/19c/23ai).
- Manage single-instance and RAC deployments across prod/non-prod.
- Perform provisioning, migrations, cloning, and capacity planning.
- Monitor health, perform RCA, and ensure high availability and DR.
Skills
Job description
815+ years of Oracle Database Administration experience, with strong hands-on expertise in enterprise, high-availability, mission-critical database environments.
We are seeking an experienced Senior Oracle Database Administrator (DBA) with deep expertise in Oracle Exadata, RAC, Data Guard, ASM, RMAN, GoldenGate, Performance Tuning, Backup & Recovery, Patching and Database Cloning.
The candidate should also have hands-on experience managing Oracle database workloads across AWS, Microsoft Azure, and Oracle Cloud Infrastructure (OCI). The role requires strong troubleshooting capabilities, performance optimization skills, high-availability and disaster-recovery expertise, automation mindset, and experience supporting large-scale production database environments.
- Install, configure, upgrade, maintain, and troubleshoot Oracle Database 11g/12c/18c/19c/23ai environments.
- Manage both single-instance and RAC databases across production and non-production environments.
- Perform database provisioning, refreshes, migrations, upgrades, and cloning.
- Manage tablespaces, datafiles, redo logs, archive logs, control files, undo, temporary tablespaces, and database storage.
- Perform proactive database health checks, capacity planning, and availability monitoring.
- Troubleshoot complex production incidents and perform detailed Root Cause Analysis (RCA).
- Strong hands-on administration and troubleshooting experience with Oracle Exadata Database Machine.
- Experience supporting Exadata database nodes, storage cells, ASM, RAC, and high-availability configurations.
- Monitor and troubleshoot Exadata performance using AWR, ASH, ADDM, SQL Monitor, cell metrics and Exadata-specific statistics.
- Understand Exadata technologies including:
- Smart Scan
- Storage Indexes
- Smart Flash Cache
- I/O Resource Management
- Cell Offload Processing
- Hybrid Columnar Compression
- Experience with Exadata patching and maintenance activities.
- Install, configure, administer, and troubleshoot Oracle RAC and Grid Infrastructure.
- Troubleshoot RAC node eviction, CRS failures, interconnect issues, voting disk/OCR issues, and cluster resource failures.
- Manage services, listeners, SCAN listeners, VIPs, and RAC database services.
- Perform RAC rolling maintenance and patching with minimum business disruption.
- Install, configure, and administer Oracle Automatic Storage Management (ASM).
- Manage ASM disk groups, failure groups, rebalance operations, disk additions/removals, and storage capacity.
- Troubleshoot ASM, multipathing, storage latency, and database I/O issues.
- Design, configure, monitor, and troubleshoot RMAN backup and recovery strategies.
- Strong experience with:
- Full and incremental backups
- Archive log backups
- Control file and SPFILE recovery
- Database restore and recovery
- Point-in-Time Recovery
- Tablespace recovery
- Block Media Recovery
- Disaster recovery scenarios
- Perform regular recovery validation and ensure compliance with defined RPO/RTO requirements.
- Design, configure, maintain, and troubleshoot Oracle Data Guard / Active Data Guard.
- Manage physical standby databases and Data Guard Broker.
- Perform and troubleshoot switchover and failover operations.
- Monitor redo transport and apply lag.
- Troubleshoot archive gaps, redo transport failures, standby synchronization, and recovery issues.
- Experience with disaster recovery testing and DR drills.
- Install, configure, administer, and troubleshoot Oracle GoldenGate replication.
- Configure and manage:
- Extract
- Data Pump
- Replicat
- Integrated Extract
- Integrated Replicat
- Trail files
- Checkpoints
- Troubleshoot replication lag, abends, missing transactions, mapping issues, and data inconsistencies.
- Experience with zero/minimal-downtime database migrations using GoldenGate is highly desirable.
- Strong expertise in Oracle database and SQL performance tuning.
- Analyze AWR, ASH, ADDM, SQL Monitor, execution plans, wait events and system statistics.
- Troubleshoot:
- High CPU utilization
- I/O bottlenecks
- Memory pressure
- Blocking/locking
- RAC contention
- SQL performance degradation
- Database hangs
- Connection storms
- Tune SQL statements, optimizer statistics, indexing strategies, SGA/PGA parameters, and database configuration.
- Perform Oracle Database and Grid Infrastructure patching.
- Experience with RU/RUR/one-off patches and OPatch/OPatchAuto.
- Perform pre-patch validation, rollback planning, post-patch validation, and troubleshooting.
- Experience performing Oracle database upgrades and migrations with minimal downtime.
- Perform database cloning and environment refresh using:
- RMAN Duplicate
- Backup-based cloning
- Active Duplicate
- Data Pump
- Snapshot/Storage-based techniques
- Experience with large production-to-non-production database refreshes.
- Implement appropriate security and masking processes where production data is copied to lower environments.
Hands-on experience managing Oracle databases on Amazon Web Services (AWS), preferably:
- Amazon RDS for Oracle
- Oracle on EC2
- EBS storage
- S3
- AWS Backup
- CloudWatch
- IAM
- Multi-AZ/DR architecture
- Database migration using AWS DMS
Ability to troubleshoot database performance, storage, connectivity, backup, recovery, and availability issues in AWS environments.
Experience managing Oracle database workloads hosted on Microsoft Azure, including:
- Oracle databases on Azure Virtual Machines
- Azure Storage
- Managed Disks
- Azure Backup
- Azure Monitor
- Networking/NSG
- Availability Zones/Sets
- Oracle Database@Azure exposure is desirable.
Strong Oracle database administration experience in OCI, preferably:
- Base Database Service
- Exadata Database Service
- Exadata Cloud@Customer
- Autonomous Database exposure
- OCI Compute
- Block/Object Storage
- OCI IAM
- VCN/networking
- OCI Monitoring
- Backup and Recovery
- Data Guard/DR configurations
Experience performing on-premises-to-cloud and cloud-to-cloud Oracle database migrations is highly desirable.
- Strong scripting knowledge in:
- Shell/Bash
- SQL/PLSQL
- Python
- Experience automating database health checks, backup validation, monitoring, patching, provisioning, and operational activities.
- Exposure to Ansible, Terraform, OCI CLI, AWS CLI, or Azure CLI is desirable.
- Exposure to AI/agentic automation for database operations is an added advantage.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
