Database Administrator Job in For a Client of TeamLease Digital at Bangalore

Database Creation for Production and environments. Provided 24x7 support for Oracle11g/12c and 19c production databases in LINUX environments. Managed standby database (DataGuard-ADG) for all production database. Managing and Handling about 30+Huge Oracle databases. Working on maintaining and monitoring Database Activities like monitoring sessions & table space utilization,alertlogs,redologs,archivelogsandlisteners,diskspace,utilizationofCPUandmemory. User Account management Creating Users, Disabling users, Roles and Responsibility management. Used EXPORT/IMPORT/DATA PUMP to do table/schema level refresh. Resolving performance related incident reported by users. Invoking BCP of database by performing database SWITCHOVER /FAILOVER between standby databases. Performance Tuning of Degrading SQL and providing Advisor/Manual recommendation to developers. Back up and recovery procedures including logical backup (Export/Import), Physical backup (cold/hot). Handling internal tracks and based on user request