•Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.

•Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.

•Expertise in PL/SQL, SQL, and UNIX Shell Scripting (Implemented UNIX Scripts using CRON JOB for Day-to-Day activities and Windows Task Scheduler).

•Extensively worked on setting up auditing in many databases we supported

•Installed ASM environment and migrated databases from NON-ASM to ASM.

•Monitored different databases and application

•Drive end to end availability, performance monitoring, and capacity planning for PostgreSQL, using different tools.

•Rebuilding the indexes at regular intervals for better performance.

•Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

•Configure logical replication to replicate real time data.

•Designing and testing database installation, implementation, and recovery scenarios.

•Determining test to use and collecting appropriate data according to established guidelines.

•Participating in analysis, development, and implementation of unique database recovery plans in response to client-impacting outages.

•Performing database software installations and upgrades and implementing backup/recovery strategies.

•Reviewing and approving application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.

•Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.

•Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.

•Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, and Indexes on the tables.

•Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

•Loading data from flat files to database using SQL*Loader, External Tables.

•Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

•Involved in the installation, configuration, and extended support to Oracle 11g, 12c two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

•Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

•Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

•Experienced in cloning the databases using HOT and COLD backups.

•Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.

•On call Production & Development database support and administration.

•Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

•Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

•Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

•Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

•Performed Database upgrade from Oracle 10g (11.2.0.5) and to Oracle 12c (12.1.0.2) RAC database.

•Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

•Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

•Migration of Oracle databases from windows to Linux.

•Performed SQL tuning and assist developers with coding PL/SQL.

•Provided support to Application Database Administrators in designing the database.

•Management of schemas, objects partitioning the tables & indexes.

•Automation of data load using shell scripting and SQL*Loader

Contact this candidate