Oracle APP DBA

Oracle Apps DBA

As the Oracle Apps DBA/Platform Administrator you will be responsible for the administration of Oracle e-Business Suite (EBS), Oracle database, Oracle middleware and related environments. The role requires exercise of discretion and independent judgement in evaluation of user requests/requirements, architecting, determining and implementing an optimum technology solution and related documentation by applying best practices. The ideal candidate will work with DBA's, Integration SME, Security teams, Infrastructure teams, Project Managers, Change Management team and other counterparts and internal IT teams.

Duties and Responsibilities include the following:

• A mindset for automation and ability to design, code and implement automation using ansible, shell or any other modern programming language.
• Install, configure, secure, performance tuning, backup, restore, patching PostgreSQL, MySQL and Oracle Databases.
• Performs Oracle EBS Applications database administration (DBA) tasks including patching (adop cycle and opatch), cloning, creating backup and recovery strategies, upgrading, performance tuning/optimization of Oracle EBS systems for recoverability, security, confidentiality, and integrity.
• Establish, contribute to and adhere to all key departmental operating procedures around governance, project management, software lifecycle management, change management and application controls.
• Provide oversight on key delivery of application topology solutions and enhancements as needed in Oracle technology space.
• Utilizes Oracle EBS R12 Applications DBA (AD) utilities to perform maintenance of the multi-node e-Business Suite environment with Shared File System, managing and administering Concurrent Managers, Concurrent Programs, Request Sets, Request Groups, Workflows, and troubleshooting Workflow Mailer/Notification issues.
• Experience with Cloning, Oracle Recovery Manager (RMAN) and Data Guard for backup and disaster recovery in Linux operating system.
• Use Oracle Application Manager (OAM) and Oracle Enterprise Manager (OEM) Grid Control for proactive monitoring and notification of system status.
• Administer WebLogic/SOA Suite environment and drive Single Sign On implementation using Oracle Identity management and similar technologies.
• Performs administration and maintenance of the Oracle Service Oriented Architecture (SOA) Suite, Oracle WebLogic Server to support Oracle ERP system integration with legacy systems.
• Reviews, develops, recommends, enforces, and adheres to database policies and standards Develops new standard operating procedures (SOPs) for Oracle EBS application software installation and configuration including high availability and disaster recovery solutions. Recommends changes and participates in the implementation and follow-on management of upgrades or replacements.
• Evaluates critical Oracle EBS security issues (content, internal controls, access levels, etc.) and makes recommendations, such as disaster recovery plans and upgrades to new versions of Oracle EBS R12 or successor releases.
• Communicates and interacts effectively with internal customers.
• Performing Code and patch migration from non-prod to production environment using the deployed tool or manually by adhering to the set change migration policies and procedures laid out by the company.
• Team player and able to support during different shifts for project and production support.
• Work with business users and IT colleagues to provide solutions to match business needs.
• Ensure technological documentation is created and updated.
• Ensure adherence to internal service management, ITIL guidelines and internal SLAs.
• Adhere to all key departmental operating procedures around governance, project management, software lifecycle management, change management and application controls.
• Act as a liaison between the Functional/Technical teams and infrastructure teams.
• Always ensure stability and performance of Oracle Applications production instance and update the system capacity and resources proactively.

Requirements:

• At least 5 years of experience in Oracle EBS Administration.
• Minimum of 3 years of experience with Oracle WebLogic Administration and related technologies.
• Minimum of 3 years of experience in managing Oracle, MySql and PostgreSQL Databases.
• Ability to articulate to stakeholders the value of recommended approaches and solutions.
• Excellent time and project management skills.
• Able to exercise discretion and independent judgment.
• Minimum of 5 years of related experience with a Bachelor’s degree in Computer Science (or equivalent); or 3 years and a Master’s degree in Computer Science (or equivalent).