Job Description

SHift - Ok to work in rotaional shift ( including night)
Experince - 10+ yrs of relevant exp.

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, user's 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.

---

Skills

Database Administration ,

---

Qualifications

• KNOWLEDGE IN SQL DESIGN
• BE / BTech Engineering - Computer Science / IT / AI
• Engineering