Oracle Database Administrator

Location

Mumbai

Type

Full-time

Department

Technical

Job description

Write data structure, queries, store procedures, PL SQL commands and various important documents for databases. Evaluate hardware and software requirements based on specific requests. Enroll user and give privileges to users. Control access and permissions to the database users. He shall be responsible for data analysis and provide best query execution plan and resolve the performance issues by proper indexing, data retrieval and storage mechanisms. Manage database parameters and monitor performance of the database. Maintain data format and standards. Implement Backup Policies for disaster management. So that in case of any type of error such as hardware/software failure, data corruption, virus etc. Recover database in case of disaster and make it available to users quickly. Optimizing database for its better performance, provide database resource management features that can help controlling resource allocation. Vendor may use any tool for effective database management as well as early alerts. Download, Install, and configure patches as and when required. Maintain multiple production database systems or create testing and development database system similar to production database systems, roll out existing installation to other hosts. Create and develop strong disaster management policy as per requirement of SLA. Periodic Performance Tuning and proactive database tasks and maintain proper documentation for future usage.

Responsibilities:
  • Write data structure, queries, store procedures, PL SQL commands and various important documents for databases.
  • Evaluate hardware and software requirements based on specific requests.
  • Control access and permissions to the database users.
  • He shall be responsible for data analysis and provide best query execution plan and resolve the performance issues by proper indexing, data retrieval and storage mechanisms.
  • Manage database parameters and monitor performance of the database.
  • Maintain data format and standards. Implement Backup Policies for disaster management. So that in case of any type of error such as hardware/software failure, data corruption, virus etc. Recover database in case of disaster and make it available to users quickly.
  • Optimizing database for its better performance, provide database resource management features that can help controlling resource allocation. Vendor may use any tool for effective database management as well as early alerts.
  • Download, Install, and configure patches as and when required.
  • Maintain multiple production database systems or create testing and development database system similar to production database systems, roll out existing installation to other hosts.
  • Create and develop strong disaster management policy as per requirement of SLA.
  • Periodic Performance Tuning and proactive database tasks and maintain proper documentation for future usage.
What we are looking for:
  • Any Engineering Graduate (B.E. or B.Tech in computer/IT/EEE)
  • with 3+yrs of exp In Oracle databse administration