Dpty / Asst Manager - Oracle Database Administration (DBA)

Job Description

Description:Job Title/Designation:Dpty / Asst Manager - Oracle Database AdministrationEmployment Type: Full Time, PermanentSkill, Knowledge & Trainings: KnowledgeThe incumbent must have proficient knowledge in the following areas:Should have worked on Unix, Linux O/S SkillsThe 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.TrainingThe incumbent must have undergone these trainings in his/her previous jobOCP / OCA (DBA track) certification in Oracle 10g / 11g /19cCore 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 productsEvaluate 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 monitoringProvision of support and assistance to development team in the design, development, testing, tuning and implementation of database applicationsRequired 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 Oracledatabases in CCIL and ensuring their performance, availability and securityArea of OperationsProduction 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 ResponsibilityInstallation, configuration and upgrading of Oracle server software and related productsEvaluate 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 applicationsCreation and maintenance of SQL queries and routinesProvisioning 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:1. Working Conditions:-The unavoidable, externally imposed conditions under which the work must be performedand which create hardship for the incumbent including the frequency and duration ofoccurrence of physical demands, environmental conditions, demands on ones senses and metal demands. late hours/shift duty/staggered shift/outside office working/visitingcustomers/clients)Working hours will be as per normal DBA work hours of CCIL however there candidate must be prepared to adjust to demands of the work assignment2. Personal AttributesThe incumbent must demonstrate the following personal attributes:Excellent communicationSelf-motivatedAbility to learn quicklyAbility to solve problem under high pressureEnjoys a challenging yet rewarding environment

Keyskills :
oracle dbaoracle