6 years of experience as an Oracle Database Administrator supporting production mission critical databases. • Installation and configuration of Oracle database /10g/11g/12c in Linux and Windows environment.
• Creation of Database through DBCA and Manually.
• Managing Database securities (like Creating Users, Roles and grant/revoke privileges to/from users/roles).
• Hands-on experience with most of the Oracle 9i and 10g features like Undo Management, locally Managed table spaces, multiple block size table spaces, partitioned tables and auto segment space management
• Designed and implemented various high availability solutions like Data Guard, Data Pump, ASM, RMAN, Oracle Flashback, and Log Miner. • Database Cloning (Hot Cloning, Cold Cloning and Rman Cloning).
• Expertise in Backup and Recovery, Scheduling backups using RMAN, Non-RMAN and Logical DB Backup (Using Data Pump, Import/Export Utility) for Object level, Schema level and full database.
• Worked with development team, provided needed support and consultation to development team..
• Configuring and managing oracle database backups like logical, hot/cold and RMAN backup as per the requirement of application owner.
• Experience with Data Guard, Creation of Physical Standby database and resolving the physical standby database gap.
• Experience on DR over drills.
• Configured auto failover setup in Dataguard.
• Provided 24*7 Production support, application release support and on call.
• Knowledge On SAP HANA DB, HPDP, TSM&AVAMAR TOOLS.
• Experience in working of Mysql & Ms sql server Databases.
• Patching done on Oracle weblogic.