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 valuable 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 valuable 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.