29 Sep
|
Tech Mahindra
|
Nagpur
29 Sep
Tech Mahindra
Nagpur
Role Description The role holder will be responsible for providing L1 /L2 Database administration support. Qualification & Experience - B. Tech / BE/MCA - 4-7 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. Skills Required Technical skills - Strong Knowledge in Database administration processes and concepts. - Knowledge of configuring and setting up maintenance activities for DB. - Ability to direct and guide team to resolve crisis situations within prescribed SLAs Analytical skills - Good analytical, trouble-shooting skills in the area of technical fault isolation and rectification. Process skills - Ability to resolve service requests. Strong attention to detail and the ability to follow processes. Other skills - Documentation and reporting skills. Should be a quick learner and have good communication and interpersonal skill. Should be willing to work in a 24*7 environment and a good team player. - 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. - Monitoring the uptime of all production & staging databases including sbi.co.in ,MAB 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
📌 Senior Oracle Database Administrator (Nagpur)
🏢 Tech Mahindra
📍 Nagpur