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.