Oracle DBA

Job Description

Role & responsibilities User management and maintenance of all database users like granting a subset of privileges as per clients 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. Monitoring the uptime of all production & staging databases including and SMS databases 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 in 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. Providing out of hours cover as agreed with the Team Leader 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 Preferred candidate profile B. Tech / BE 5+ years of relevant experience Proven ability to plan and execute workload in a pressurized & dynamic environment. ITIL Certified or a strong working knowledge of ITIL Incident, Problem and Change Management disciplines.