Oracle Dba
Current Roles & Responsibilities:• Verify the Alert logs & last night backup logs for all databases.• Verify logs of analyzation of Tables & Indexes.• Coordinate with application team to deploy new EAR (Enterprise Archive).• Production deployment in UAT databases (UAT refresh).• Schema refreshment of various databases with production data.• Creation of Physical, Logical & Snapshot standby.• Role transition between Primary & standby database. (Switchover-Switchback… Show more Roles & Responsibilities:• Verify the Alert logs & last night backup logs for all databases.• Verify logs of analyzation of Tables & Indexes.• Coordinate with application team to deploy new EAR (Enterprise Archive).• Production deployment in UAT databases (UAT refresh).• Schema refreshment of various databases with production data.• Creation of Physical, Logical & Snapshot standby.• Role transition between Primary & standby database. (Switchover-Switchback, Failover)• Monitoring database performance and analyze AWR & ADDM reports at regular intervals.• Installation of Client in various servers.• Supporting Production & UAT databases.• Working in 24x7 production and application environment of BANCS24 project. And provided on-call and day-to-day support.• Having good hands on experience on HP- data protector and IBM-data protector. Roles & Responsibilities as Jr. Oracle DBA:• Monitoring of the database for CPU, MEMORY, Disk Utilization & I/O Utilization.• Installation & configuration of oracle 11g R2 server & creation of database.• Implementation of Physical Standby database.• Export / Import of Tables, Tablespaces and Databases.• Interacting with On-Site Coordinators.• Managing physical files of the database.• Creation and Maintenance of Table spaces.• Monitored the production Oracle alert logs for database errors and system resource availability.• Generating AWR, ADDM & Statpack reports.• Visit of internet data centre for backup activities. Show less
