The incumbent must have proficient knowledge in the following areas:
Should have worked on Unix, Linux O/S Skills
The incumbent must demonstrate the following skills:
- Familiarity with various Oracle database specific technologies, tools and utilities.
- A good knowledge of the physical database design.
- Knowledge of ALL Oracle backup and recovery scenarios.
- A good knowledge of Oracle security management.
- Ability to analyze, assess and evaluate technologies / tools related to DB.
- Ability to understand and troubleshoot the problem quickly.
- Valuable documentation skills.
Training
The incumbent must have undergone these trainings in his/her previous job
OCP / OCA (DBA track) certification in Oracle 10g / 11g /19c
Core Competencies:
- Must have good knowledge of oracle database architecture with job experience of Database Administrator with following hands on experience:
- Installation, configuration and upgrading of Oracle server software and related products
- Evaluate Oracle features and Oracle related products.
- Establish and maintain sound backup and recovery policies and procedures.
- Take care of the Database design and implementation.
- Implement and maintain database security (create, update and maintain users and roles, assign privileges).
- Perform database tuning and performance monitoring
- Provision of support and assistance to development team in the design, development, testing, tuning and implementation of database applications
- Required to deal with complex data models and object relational database mapping, while producing complex reports.
- Writing ad-hoc queries based on schema knowledge for various reporting requirements.
- Designing database packages and procedures.
- Provide a strategic database direction for the organization.