Oracle Database Administrator

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 support when required.

- Perform general technical troubleshooting and give consultation to development / support teams.

- Interface with Oracle Corporation for technical support.

- Maintain 100% uptime.

Any Other Requirement:

Working Conditions :

The unavoidable, externally imposed conditions under which the work must be performed and which create hardship for the incumbent including the frequency and duration of occurrence of physical demands, environmental conditions, demands on ones senses and metal hours/shift duty/staggered shift/outside office working/visiting customers/clients)Working hours will be as per normal DBA work hours of however there candidate must be prepared to adjust to demands of the work assignment

Personal Attributes :

The incumbent must demonstrate the following personal attributes:

- Excellent communication

- Self-motivated

- Ability to learn quickly

- Ability to solve problem under high pressure

- Enjoys a challenging yet rewarding environment