Yash Technologies Hiring for Oracle Apps Database Administrator at Pune, Maharashtra Full Time

Full Job Description
Date: Mar 15, 2023
Job Requisition Id: 52405
Job Category: Digital

Location:
Pune, MH, IN

We are looking forward to hire “Oracle Apps Database Administrator” for the Infrastructure team, who thrives on challenges and desires to make a real difference in the business world.

With an environment of extraordinary innovation and unprecedented growth, this is an exciting opportunity for a self-starter who enjoys working in a fast-paced, quality-oriented, and team environment.

You are required to have skills in the following areas :
Primary Skills:
Oracle Apps DBA is required to support Production/ Stage/ Development Oracle EBS in a 24*7 shift support model. The
Oracle APPS DBA will be responsible for installation, configuration, upgrading, administrating, monitoring,
troubleshooting, cloning, Patching, Backup, and restoring of Oracle EBS. Would be responsible for reviewing applications/databases, identifying performance bottlenecks, and fixing along with daily production health checks

Responsibilities:
Performing Daily health checks for a production environment, identifying the performance bottlenecks, and working on fixing them.
Perform regular DBA support using tools like Serena or ServiceNow.
Providing technical inputs towards maintaining a large complex production environment.
Perform Capacity planning for instances and growth.
Good knowledge of the latest versions of Oracle database/E Business suite architecture and components (19c, 12c, 12.2 EBS,etc.)
Knowledge of Oracle security basics, and experience in working with ISO and Auditing.
Expert in RAC, ASM, and WebLogic Administration.
Experience in all routine DBA tasks including health checks, troubleshooting issues, and installations.
Good knowledge of PLSQL and SQL
Knowledge of traces, tkprof, and finding poorly performing SQL.sql, profiling, rewrite poorly performing SQL.
Knowledge of Load balancing, PCP, Configurators, JVM’s, archiving and purging tools like HP Archiving, SOA gateway, ekanban knowledge is add on.
Knowledge of Oracle database wait for events, Database, and Application parameters
Ability to fine-tune concurrent processing in a large EBS environment.
Good knowledge of OEM.
Install, upgrade, patch, and administer the EBusiness application and database.
Experience with Oracle data guard.
Experience in RMAN backup & restore activities
Knowledge of OS parameters and settings, UNIX shell scripting.
Performing (DB + Application) Patch Analysis & Applying Patches.