Oracle Database Admin L2

etailed Job description with level of experience based on the customer Ask .

• Verify all Instances are running • Look for any new alert log entries • Verify that SNMP is running • Look for Trace files • Session Monitoring • Query or Transaction monitoring • Lock and Latch monitoring • Activity / Redo Log monitoring • Job monitoring and Purging Job history • Replication / Stand by monitoring • Object Monitoring • Verify free space in tablespaces • Verify rollback segments • User / Schema Creation • User Management • Pre-installation Tasks • Installing Oracle Server and Patch Mgmt • Installing & Maintaining DB Tools • Uninstallation

Top 3 Skills needed Oracle Database Administration (DBA), Backup & Recovery (RMAN), Performance Tuning

Location:

Near KR puram railway station,Bangalore Shift: Rotational Minimum 5 years exp

Areas of responsibility           Triaging and resolution of tickets-"Perform initial triage for high priority incident tickets (P2 tickets) which may have an impact across one or more processes and resolve priority incident (P3) tickets within defined SLAs. Create log of incidents and Document observations and related root causes, to support in evaluation of mitigation measures. " Resolution of service Requests-Fulfil software/hardware/network service requests within agreed timeline, ensuring timely completion and adherence to SLAs while maintaining quality and accuracy in request handling. SLA Monitoring-Monitor SLA timelines for entire lifecycle of high priority incident tickets (P2 tickets). Escalate as needed and participate in weekly or monthly service review meetings with clients and internal teams. Change request execution-"Create change requests as per the priority of the incident tickets in adherence with the defined guidelines. Present changes for approval with rollback plans in change approval meetings. Execute approved changes and document post-implementation outcomes." Incident Analysis-"Analyse nature of incidents to support root cause analysis and related service improvement plans. Contribute towards development of mitigation action to reduce repeat incidents, by identifying patterns of issues noted."