01Overview
Job Description:
Job Title/Designation: Dpty Manager - Oracle Database Administration
Employment Type: Full Time, Permanent
Job Description
Skill, Knowledge & Trainings: Knowledge 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.
Good 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.
Functional Competencies:
Requires knowledge and experience in Banking and financial domain.
Job Purpose:
Responsible for Designing/ supporting / administration / management the Oracle databases in and ensuring their performance, availability and security
Area of Operations
Production database support to ensure the highest standards of availability, resilience, integrity, security and performance required by our business systems.
Administration with PL/SQL work.
Design, development and administration of Oracle databases.
Performance monitoring, reporting, and tuning of Oracle databases.
Management and maintenance of back-ups & recovery procedures.
Installation and maintenance of database server, replication and client environments.
Reviewing and tuning SQL and PL/SQL code.
Key Responsibility
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.
Designing database packages and procedures.
Security and access control.
Provision of support and assistance to development team in the design, development, testing, tuning and implementation of database applications
Creation and maintenance of SQL queries and routines
Provisioning of (database)development and testing environments.
Writing ad-hoc queries based on schema knowledge for various reporting requirements.
Required to deal with complex data models and object relational database mapping, while producing complex reports.
Manage physical/logical standby database.
Setup and maintain documentation and standards.
Provide a strategic database direction for the organization.
Plan growth and changes (capacity planning)
Work as part of a team and provide s .
