Oracle Database Administrator

Hiring candidates for the role of Oracle DBA

location. Bangalore

Experience. 3 to 4 years

Skills. RAC RMAN

Database Space Management

o Oracle RAC – Setup, management, troubleshooting and fine tuning

o Oracle RAC PT, Management, troubleshooting and fine tuning.

o Database management

o Database Performance Tuning

o Database Backup/readability/ restore

o NDR DB’s health checks

o Oracle Data Guard – Physical Standby Database Management

o Database DR Drill Switchover/Failover

o Database Switchover and Switchback planned and unplanned.

o Database Data Archival and Fragmentation

o Reports and Documentation

o Preparing, maintaining and updating SOPs at regular intervals.

o Deliverables: Daily Reports weekly Dashboards of all subsystem and system.

o Knowledge on RMAN Backup configuration and support

o Knowledge on RAC Cluster DB.

o Capacity, performance, change incident management services. (Oracle MS SQL, details attached in Annexure-1).

o Weekly Monthly dashboards on devices performance, capacity management to be made available before 5th Working day of the month

o Prepare adhoc reports and perform Adhoc activities.

o Coordination with Oracle and Microsoft for Service/support request escalations.

o Upgrade Databases from lower to higher version

o Patch set Updates apply on all in-scope Oracle Databases.

o New application upgrades support prior to actual Upgrade.

o Preparing RCA for Sev-1 incidents and problem management techniques.

o Install and Configure DB Servers all versions.

o VAPT Mitigations Database and DB Server binaries.

o Manage Authentication, Access and Database Security (DB Vault, TDE , AVDF, Redaction)

o Determine, enforce and document database policies, procedures and standards

o Manage Disaster recovery aspects o Read more