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 current 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.

📌 Tech Mahindra - Oracle GoldenGate Administrator (India)
🏢 Tech Mahindra
📍 India