Oracle Database Administrator

Oracle Database Administrator: L2 Location : Jodhpur(Rajasthan)

1. Should manage creation/alteration of Database, changes to database schema, creation/alteration of user and its roles and privileges

2. Periodically perform configuration checks and fine tune the databases with respect to performance and proactive identification of potential problems

3. Should be responsible for management and maintenance of Database Security, Backup and Recovery policies and procedures

4. Should create SOP’s for various day to activities/incidents

5. Should be responsible of designing and reviewing database reports on periodic basis as per requirement

6. Should have knowledge of Active Data Guard with management and maintenance of standby databases at DR.

7. Should participate in database upgrade, patch upgrade as and when required

8. Should interact with Oracle Corporation for technical support.

9. Patch Management and Version Control

10. Should upload / create/alter users and assigning roles and privileges

11. Should able to perform export/import, database creation, basic troubleshooting

12. Should administer and create all database objects and users on the request of developer of the application team.

13. Should create basic Oracle database daily/monthly/quarterly reports on periodic basis as per requirement and distribute the same to respective stakeholders

14. Should follow processes for change control, problems, incidents, service calls and manage the incident/tickets at provided tool

15. Should be responsible to maintain optimum utilization of all the equipment’s w.r.t. database operations and keeping close watch on optimum performance of database

16. Should monitor Database, OS, Network, Database processes, Database objects on regular basis an implement necessary measures to rectify the issues.