More than Eighteen years of experience as an Oracle Database Administrator. Worked as an Oracle DBA in Oracle Oracle 8.x, 9.x, Oracle 10G, Oracle 11G, Oracle 12c.
Experience in administration, design, implementation and supporting RAC, RMAN, ASM, Data Guard / Standby Database, OEM, Patching, Cloning.
Full life cycle experience with large Databases including Database Analysis, Design, Installations, Database Creation,Configurations,Implementation and Administration.
Design and implement database backup and recovery procedures using RMAN, Hot & Cold backup and logical backup.
Proficient in Database Administration activities such as Upgrades, Patches, Cloning, performance tuning, script development, and documentation, cloning databases using RMAN, Hot and cold backup.
Worked on transportable tablespaces and successfully implemented ASSM to improve the performance.
Experience in 24*7 Production database support
Experience in administration, Supporting Desktops, Servers, Firewalls, LAN & WAN Network.
Experienced in RAC activities like node addition, node deletion and Grid Infrastructure up gradation
Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges, DB Links), space management of logical structures (i.e. table spaces) and auditing of users.
Experience in Corporate office administration, Vendor management, Hardware purchasing, Negotiation.
Specialized in the areas of Oracle Exadata, RAC, Asm, Dataguard, Golden gate, Backup & Recovery and Performance & Tuning and Oracle cloud
Worked on Amazon cloud as architect
Specialized in migrating database from on premise to cloud
As DBA Profile:-
• Oracle: - Oracle 9i & 10g, 11gR2 – Installation and database creation, administration,
Backup & Recovery
• Oracle RAC (Real Application Cluster) & Exadata: Installation, configuration and administration
of RAC 10 g including O/S & Network settings
• Patching and Up-gradation: - Applying CPU patch, Bug fix patch, Patch set.
• Data Guard: - Physical Standby data guard (Oracle 9i & 10g, 11gR2)
• Cloning: - Cloning by using Host backup , cold backup and RMAN backup.
• Backup & Recovery: - Using RMAN, Export- Import & Data-pump, Flashback
• Tools – TOAD, SQL* Plus, TKPROF, Oracle Enterprise Manager
• MySql: - Installation, creation of database, schema creation etc.
• 24*7 Production and Dev / Test database support.