Location - Dadar - Mumbai (WORK FROM OFFICE AS PER BANKING CALENDAR )
Must-have Skills (Mandatory Skills)
- Strong hands-on Oracle DBA production experience with Oracle 12c/19c/21c.
- Oracle-to-Oracle database migration experience mandatory, including planning, execution, validation and cutover.
- Expertise in RMAN, Data Pump (EXPDP/IMPDP) and database migration/backup strategies.
- Strong experience with Oracle RAC, ASM and high-availability architecture.
- Hands-on Oracle Data Guard, including switchover, failover, DR setup and DR testing.
- Strong SQL/PLSQL and performance tuning skills — AWR, ASH, execution plans, indexing and query optimization.
- Expertise in backup, restore and point-in-time recovery, including backup/restore testing.
- Strong database monitoring and production troubleshooting — performance, blocking, deadlocks, space and connectivity issues.
- Experience with DC/DR operations, database failover/failback and disaster recovery procedures.
- Strong scripting/automation and migration documentation skills, including Shell/SQL, migration runbooks, cutover and rollback plans.
Positive to have skills
- Experience with Oracle GoldenGate for replication and near-zero-downtime migrations.
- Hands-on experience with Oracle Enterprise Manager (OEM) and advanced database monitoring.
- Experience with Oracle Exadata / OCI / AWS cloud database environments.
- Knowledge of Oracle RAC One Node, partitioning, TDE and advanced security.
Experience Range
10+ years
Top 3 Responsibilities:
1. Manage Oracle to Oracle Migration including Scripting
2. Database Monitoring and Support
3. Database query optimisation