Nikhil Patil

Oracle Database Administrator @Clover Infotech

Mumbai, IN

Managed and monitored databases in Production, Development, UAT, Integration, QA, and Standby environments.• Created and managed Oracle databases (12c and 19c).• Handled and monitored Oracle SRs.•Monitoring Database Using OEM 13c• Experience in database/schema/table refreshes using expop/impap, exp/imp, RMAN.• Performed DR tests for databases using Flashback and Data Guard.• Performed switchover activities.• DB cloning, including backup and restoration processes for both Oracle and PostgreSQL environments.• Applied Oracle patches.• Upgraded databases from 10g, 11g to 12c and 19c.• Experience in performance tuning, including long-running jobs handling and locking sessions.• Used Flashback to recover dropped tables.• Created and managed database storage structures (tablespaces, datafiles) and objects like tables, indexes.• Handled DML/DDL changes with script executions.• Generated AWR, ASH, ADDM, and Stackpack reports.• Managed user security by providing grants, roles, and profiles.• Monitored and fixed Oracle errors.• Managed PostgreSQL database activities including backups, restorations, upgrades, and point-in-time recovery.• Implemented Oracle to PostgreSQL real-time replication using advanced tools, ensuring seamless data migration and synchronization across platforms.• Managed PostgreSQL DR (Disaster Recovery) replication setup and maintenance, ensuring high availability

R. C. Patel Institute of Technology, Shirpur

Bachelor of Technology - BTech, Civil Engineering