Job Description

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.
• In addition, application DBA s will provide support and direction to developers and other support personnel as needed.
• 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.