Professional Summary
Seasoned IT professional with expertise in Database Administration, providing various DBA roles across LINUX, Solaris, UNIX, and Windows platforms various RDBMS software versions such as ORACLE (10g, 11g, 12c/18c) PostgreSQL(9x, 10x, 11x, 12x) and Microsoft SQL Server 2012-2016.I have hands on experience on Oracle's Multitenant Architecture(12c), PostgreSQL cluster and SQL Server Management Studio, performing Installations, configurations, and maintenance of the technologies such as Golden Gate on heterogeneous and homogenous platforms for real-time replication and Data Guard for disaster recovery. Proficient in Migrations, Backup and Recovery Strategies, Upgrades and Patching, Performance Tuning, Scripting. I am a great team player, with great written and oral communication skills, enthusiastic about learning new technologies. SKILL SUMMARY Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. Created indexes to facilitate easy user interface implementation and tuning. Experience in 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities. Adept at installation of OEM Database Control, OEM grid control and Deploying Agents. Performed RMAN backups (Full, Incremental and Cumulative) and complete recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard. Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Extensively worked on Import/Export and Data Pump Import/Export tools. In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security. Database security using Oracle Security Features (roles, privileges), auditing, Transparent data encryption, DBMS CRYPTO,