Oracle Dba

**Job Category**:Professional services**Job Type**:Full Time**Job Location**:Thane**Experience**:3-5 Yrs**Job description**
- **The Oracle Database Administrator **is responsible for configuring, administering, and maintaining the Oracle database environments.
- Responsibilities include database upgrades, patching, security, troubleshooting and issue resolution, backup procedures, and performance tuning.
- Daily responsibilities include monitoring production environment, providing acceptable system performance, and assuring data is protected and recoverable as required and assuring data is protected and recoverable as required.

**Key Responsibilities**
- Installation, configuration, tunning, patching, refreshes and upgrading database environment using different utilities.
- Setting up and monitoring standby databases, DR-Drill, backup and recovery techniques, diagnose and correct performance problems.
- Proven experience managing database configurations.
- Managing database Users, Roles, Profiles, Permissions and Security. Create and publish database health check reports.
- Perform regular maintenance activities.
- Monitoring Space management, users activities, and resource utilization. Ability to independently maintain and administer databases.
- Ability to learn and adapt procedures, processes, and new technologies quickly.
- Good logical and analytical skill.
- Good communication skill.
- Collaborate with other team members and stakeholders
- Good understanding of Oracle database concepts and structures on various in-house and cloud platforms.
- Oracle database skills and Unix operating system understanding is required.
- Good Knowledge of architecture and configuration of latest Oracle versions. Good experience of patching, cloning, security, backup and recovery procedures, node addition, deletion, replication setup and DR-Drill activities. Good understanding of Performance Tuning, Query Optimization, Client/Server Connectivity.
- Experience of implementing operational automation using Ansible playbooks or any other tools.
- Experience of writing shell scripts as well as knowledge in general system administration tasks.
- Experience of setting up Oracle high availability [RAC, Dataguard] environment using various tools.
- Experience of database administration, development, maintenance, and production support.
- Experience of managing Oracle databases on various cloud environments. Experience of identifying performance problems and optimization of database performance.
- Experience on planning and Performing optimal Backup and Recovery solutions.
- Good knowledge of RAC, ASM, RMAN, Dataguard, Datapump and other Oracle utilities.
- Good understanding of SQL and PLSQL Procedures, Functions, triggers. Good in providing guidance to the development team in optimizing SQL statements.
- Good understanding on deploying code moves as part of change management.
- Proficient in performing the recovery of the Oracle database files in various recovery scenarios.
- Basic understanding of replication.
- Strong trouble shooting and problem-solving skills.
- Ability to work well in teams with good oral, written, and interpersonal skills.
- Ability to provide FANATICAL support.

**Qualifications**:

- Bachelor’s degree in computer science, Information Technology, or a related field.
- Minimum of 3-5 years of hands-on experience as an Oracle DBA, preferably at an L2 level.
- Strong knowledge of Oracle database administration, performance tuning, and troubleshooting.
- Experience with Oracle Database versions 11g, 12c, and 19c.
- Proficiency in SQL, PL/SQL, and scripting languages.
- Familiarity with database monitoring and diagnostic tools.
- Excellent problem-solving and analytical skills.
- Strong communication and interpersonal skills.
- Ability to work independently and collaboratively in a team environment.

Willingness to work in a 24/7 shift operations setup on a rotation basis.