Location - Dadar - Mumbai (WORK FROM OFFICE AS PER BANKING CALENDAR )
Must-have Skills (Mandatory Skills)
Robust 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.
Solid 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:
Manage Oracle to Oracle Migration including Scripting
Database Monitoring and Support
Database query optimisation