Shankar Pujari

Experience

1. Oracle Dba

   Ion Exchange India Ltd

   Jan 2017 — Present · Mumbai, IN

   As a Database Administrator, I am Responsible for administration of 13 Oracle databases. • Installation and implementation of the Oracle 10g, 11g, 12c, 19c on Linux, Windows 2003, Windows 2008 Windows 2012 & Windows 2016• Managing databases for their availability & for any problem that may occur. • Implement the automated Hot Backup scripts for the Daily full backup created in Shell. • Up gradation from Oracle 9.2. to Oracle10.2.0.4, 10.2.0.4 to 11.2.0.4.0 & 10.2.0.4 to 12.2.0.1• Maintained standby databases, in both local and remote locations, for fail-over purposes. • Replicated to a disaster recovery site for increased server manageability and availability Refreshing development/test databases from production. • Performing database restoration. • DR standby DATAGUARD implementation for archive log shipping and synchronization • Creating new databases as per client\'s demand. • Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment • Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security. • Create and maintain materialized views. • Implementing and maintaining database security (create and maintain users, roles and assign privileges) • Monitored the production Oracle alert logs for database errors. • Monitored system resource availability and responded to system memory and data issues. • Removing the fragmentation and Reorganization the database structure to improve the database performance. • Replication of Database Using Oracle RMAN Utility Oracle Application Oracle application installation & Configuration on Windows operating system Monitor application related jobs and data replication activities Assist developers with database activities Monitoring & checking alert log.