Roles and Responsibilities :

- User management and maintenance of all database users like granting a subset of privileges as per client's policy.

- Resolving User-related queries in Production and Test Databases.

- As per client request creating new users and assigning profiles in production databases.

- Monthly purging activity to gain database level space improvement.

- Archival activity for performance improvement.

- Performance monitoring, Database installation and configuration.

- Schedule RMAN backup and monitor RMAN status of all production databases.

- Database timely patching / bug-patching on requirement.

- Monitoring the up time of all production & staging databases.

- Good analytical, trouble-shooting skills in technical fault isolation and rectification.

- Monitoring Database and listener status for Production and DR side.

- Monitoring of alert logs, identifying errors and Initiate approval for necessary action.

- Monitoring Disk utilization for Production and DR Database.

- Monitoring Table space Size at database level.

- Monitoring for DC and DR sync status and check status archival apply status.

- Monitoring number of active sessions in database.

- Monitoring CPU utilization and I/O wait on Production database.

- Interface proactively with other Infrastructure support teams such as UNIX, Windows, Network, Storage, Monitoring etc.

- Document issues and associated resolutions to problems.

- Prepare documentation and presentation of progress reports to customers.