Oracle Apps DBA

Locals only

Interview Process/# of Rounds: 2 Rounds 1 in person

Must Have:

• 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.
• ShellScript5 years

NICE TO HAVE:

• Hyperion 2 years
• Informatica 3 years
• Obiee 3 years
• Data guard 3 years
• RMAN 3 years
• OneSource/Sabix 2 years

Environment: EBS R12 OIEE

Additional Notes:

• Why the role is open: Looking for Oracle Apps DBA looking for an engineer who can support on Oracle Database Postgres and MySQL
• Business problem: Lot of work struggling with that augment the team and get support for the team. Will Knowledge share in the environment resource will be helping on the project. Migration projects. Handling upcoming projects.

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 multinode eBusiness 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 followon 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 nonprod 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

• 5 years of experience in Oracle EBS Administration
• 3 years of experience with Oracle WebLogic Administration and related technologies
• 3 years of experience in managing Oracle MySql and PostgreSQL Databases
• Bachelors degree in computer science (or equivalent); or 3 years and a Masters degree in Computer Science (or equivalent)
• 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