Job Description
Oracle DBA
Exp - 2 to 5years
Np- 15days to Immediate
Database Administration Oracle
Activities:
Database Space Management
Oracle RA Setup, management, troubleshooting andfine tuning
Oracle RAC PT, Management, troubleshooting and fine tuning.
Database management
Database Performance Tuning
Database Backup/readability/restore
NDR DB's health checks
Oracle Data Guard Physical Standby Database Management
Database DR Drill Switchover/Failover
Database Switchover and Switchback planned and unplanned.
Database Data Archival and Fragmentation
Reports and Documentation
Preparing, maintaining and updating SOPs at regular intervals.
Deliverables: Daily Reports & weekly Dashboards of all subsystem and system.
Knowledge on RMAN Backup configuration and support
Knowledge on RAC Cluster DB.
Capacity, performance, change & incident management services. (Oracle & MS SQL, details attached in Annexure-1).
Weekly & Monthly dashboards on devices performance, capacity management to be made available before 5th Working day of the month
Prepare adhoc reports and perform Adhoc activities.
Coordination with Oracle and Microsoft for Service/support request & escalations.
Upgrade Databases from lower to higher version
Patch set Updates pplyon all in-scope Oracle Databases.
New application upgrades support prior to actual Upgrade.
Preparing RCA forS ev-1incidents and problem management techniques.
Install and Configure DB Servers all versions.
VAPT Mitigations Database and DB Server binaries.
Manage Authentication, Access and Database Security (DB Vault, TDE , AVDF,?Redaction)
Determine,?enforce?and?document?database?policies,?procedures?and?standards
Manage?Disaster?recovery?aspects?of?databases.