Role: APPLICATION DATABASE ADMINISTRATOR-RDBMS . Responsibilities:• Database Events, Incident & Service Request Management for SLA Compliance.• Managed Database Availability, Events, Issues, Incidents & Health Checks.• All the UAT DB converted into Archive log mode & automated alerts for space/issue.• All RMAN Error Fixes for production & non - production servers.• DB configured for online RMAN backup & managed as well.• Co-ordination with Application team for data archival. • Actively participated on online testing switch over / switch back.• Every Half Yearly DR Drill Testing conducted in testing zone for all the application to recover application/DB in DR Site.• All the production File system, Arch file system Space, Sessions, lock issues are Monitored/Managed.• Critical DB's DDL's are captured and reviewed with respective team for Security purpose.•Server Monitoring viz. CPU utilization, Memory utilization, File system growth, Tablespace.• DB Ugradation• Table Defragmentation• Table,schema,database refreshes.• Creating sql_profiles for the sqls which are picking the wrong plan.

Role: Specialist – Oracle DBA. Database Monitoring Database Refresh / Cloning. Table Partition Maintenance Managing Database objects Database Availability & Monitoring. Creating Oracle databases  Making database backups and performing recovery.Tools :Oracle 11g,12c ,Toad 9.0.1,SQL Plus10.2.0.1 , Grid control, sql Developer, Toad & Red Hat Enterprise Linux Server release 5

Roles & Responsibilities:• Monitoring on Remedy ticketing tool.• Schema management and tablespace management.• Creating users and assigning appropriate roles and privileges to users depends on requirement. • Perform refresh like refresh, table refresh using data pump utility.• Index rebuilds.• Materialized view refresh.• Gathering tables statistics, Schema statistics.• Killing unnecessary sessions.• Script execution as part of change management.• Resolving db_link related issues.• Resolving listener issues.• DB down and up for server patching.• Cronjob set up.• Monitoring RMAN backups.

Responsibilities:• Monitoring databases through OEM.• Handled production RAC databases of size up to 4 TB in 24/7 environment.• Check Alert Log file and trace files for errors and made necessary actions to rectify them.• Monitor and managed the Tablespaces and Datafiles growth.• Analyzed Tables & Schemas, collecting system statistics, rebuilding indexes.• Enrolled new user and maintain security, Role and system privileges.• Responsible for taking backup and recovery using logical backup (datapump) and online backup (Hot backup and RMAN backup).• Kill unwanted user sessions or processes.• Monitor locks and various sessions using OEM.• Monitor database performance, generating AWR and ADDM report.• Job scheduling by crontab.• Generate SQL query plan for tuning by explain plan.• Schema and table refresh using data pump.• Database shut down and starts up.• Archive logs deletion.

Roles & Responsibilities:• Schema management and tablespace management.• Creating users and assigning appropriate roles and privileges to users depends on requirement. • Perform refresh like refresh, table refresh using data pump utility.• Index rebuilds.• Gathering tables statistics, Schema statistics.• Killing unnecessary sessions.• Script execution as part of change management.• Resolving db_link related issues.• Resolving listener issues.• DB down and up for server patching.• Cronjob set up.• Monitoring RMAN backups.