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