About the role
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.
Role and Responsibility:
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 goldengate 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.
Candidate requirements:
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.