Oracle Apps DBA

You should have at least 8 years of experience in designing, developing, implementing, and maintaining core Oracle DB and associated applications. Your responsibilities will include configuring, monitoring, troubleshooting, performance tuning, clones, patches, and upgrading the DB and Oracle EBS applications version 11 or above for effective business operations and administration. It is essential to have experience with Oracle Application Manager (OAM) and Oracle Enterprise Manager (OEM). You must also have experience with Cloud (OCI) migrations for both DB and/or APPS. Your role will require comprehensive knowledge of Oracle EBS v 11 or above application administration, including installation, configuration, cloning, and upgrades using Oracle EBS R12 Applications DBA (AD) utilities and other tools to apply patches and system updates. Maintaining SQL / PLSQL processes to ensure DB availability is a key part of the job. As part of your responsibilities, you will proactively manage and maintain security standards and controls, optimize and simplify DB architecture, and take ownership of performance and capacity monitoring aspects of the DB. You will be expected to execute data migration jobs and scripts when required, assist the infrastructure team in sizing hardware for the DB, and create a reliable backup strategy. It is crucial to ensure that database backups are appropriately executed and periodic restorations are performed to maintain backup quality. You will be responsible for determining and documenting DB policies, procedures, and standards, as well as conducting performance testing and evaluation to ensure data security, privacy, and integrity. Identifying bottlenecks and deadlock issues and ensuring SLA's & operational KPIs are met are also part of your role, requiring collaboration with internal and external support functions during major incidents.,