Dpty Manager - Oracle Database Administration (DBA), Mumbai

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 .