Oracle Applications Job Description
Oracle Applications Duties & Responsibilities
To write an effective oracle applications job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle applications job description templates that you can modify and use.
Sample responsibilities for this position include:
Oracle Applications Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle Applications
List any licenses or certifications required by the position: DBA, OBIA, OBIEE, MBA, PMP, OCP, SPHR, CP, SHRM, PHR
Education for Oracle Applications
Typically a job would require a certain level of education.
Employers hiring for the oracle applications job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Information Technology, Business/Management, Information Systems, Technical, Engineering, Education, Business, Software Engineering, Management
Skills for Oracle Applications
Desired skills for oracle applications include:
Desired experience for oracle applications includes:
Oracle Applications Examples
Oracle Applications Job Description
- Install, configure, and support database management systems (Oracle, MySQL, MongoDB & SQLServer databases) and related software to resolve highly complex and/or unique issues without precedent and/or structure
- Design, develop, and maintain highly-available databases
- Take responsibility for database design and performance optimization, backup and recovery strategies and implementation, monitoring the overall health of the database environment
- Execute complete database solutions from evaluation to implementation
- Provide on-going system administration and technical infrastructure support
- Review the physical and logical design of databases for optimal database structures, performance tuning, security, and database backup/recovery
- Evaluate and test marketplace tools and utilities, including system integration and automation, which enhance server functionality and promote the development of RDBMS applications
- Develop and maintain efficient and appropriate connectivity solutions between various campus databases to ensure necessary data is available as needed
- Create data flow and data lifecycle documentation
- Develop and enforce database standards and/or new development protocols
- NetApp storage administration including database cloning and snapshot back-ups
- Data migration using Export Import, including Transportable Tablespace feature
- Concurrent Manager job scheduling/report running
- Practical experience in IT - minimum 4 years
- At least 3 years experience in EBS/Apps Database AdministrationAdministrator, R12, 11i, , Install, Patch, Maintain, Upgrade, Tune, Backup and Recovery, and Security
- 3+ years combined experience with Windows 2008/2012
Oracle Applications Job Description
- Oversee activity of staff to ensure that production problems are resolved quickly, ensuring continued accurate system operations
- Design data warehouse solutions
- Responsible for configuration management, performance tuning, and administration of multiple development, test, and production databases and Applications (such as EBS R12, SOA )
- At least 3 to 5 years of experience in analyzing, designing, testing and implementing software solutions related to Planning Systemsystems
- Installation, configuration, upgrades, patching, cloning, performance monitoring and optimization of the multi-node Oracle EBS 12 Applications on 11g/12c Databases
- Working with System Analysts in the implementation of newer modules of Oracle HRMS, Financials and custom interfaces, as needed
- Implementing robust backup solutions and policies
- Root-cause analysis and resolution of complex problems in support of production environments, including 24/7 on-call support on a rotating basis
- This position is not limited to supporting only Oracle databases, but includes a variety of different Applications like Oracle Portal, E-Business Suite (11i/R12), Application Server, OBIEE, Essbase, SOA
- Analyzes, defines, and documents requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls, and outputs for both new and existing applications
- At least 6 years experience in conversion/ interfaces/ Reports
- A DBA should possess a sound understanding of the business
- Relevant third level degree or equivalent and at least 8 years relevant experience
- Relevant Application Certification
- Functional knowledge of Oracle Financials with a proven track record in of these modules (AP, AR, CM, FA, iProc, PO, INV, PA, OTL and GL)
- At least 2 year experience managing teams is a big plus
Oracle Applications Job Description
- Oversees large, complex, higher visibility projects or more than one project, including planning
- Complete understanding of the SDLC lifecycle and the requirements associated with maintaining SOX compliance
- Possesses and applies comprehensive knowledge in field of specialization and has well-developed leadership skills, operating with considerable latitude for un-reviewed action or decision
- Provides mentoring of development staff on current and newly obtained development technologies
- Develops, codes, tests, debugs, maintains, modifies, and installs applications
- Develops and maintains technical specifications
- Consults with business units to gather information about application needs, objectives, functions and features input and output requirements
- Plans and prepares documentation on the development and functioning of enterprise applications
- Assists in the training of end users or technical support staff to use applications and/or associated hardware
- Participates in meetings, seminars, and training sessions to stay apprised of new development technologies
- Minimum 5 years of proven experience in implementing Oracle EBS Tech
- Bachelor's degree or minimum five years equivalent work experience in combined business, and IT experience required
- Minimum 5 years of Oracle Applications experience
- Extensive experience with Oracle Applications R12.1 and R12.2 configuration, patching, upgrades, cloning, maintenance, troubleshooting and support
- Worked with high availability setups (including load balancing and Oracle Data Guard)
- Expert knowledge of 11g and 12c Database Administration
Oracle Applications Job Description
- Month End Close and Reconciliation
- Knowledgeable of Administering Web based application like Salesforce/CRM Administrator and or Developer functionalities, ERP (accounting/tracking/reporting)
- Administer configuration of application workflows, page layouts, and approval processes
- Good knowledge in web servers like Apache, Tomcat, IIS and WebLogic with respective to maintain, administer and deploy packages and applications
- Establish well defined documented processes to support users of various technical comprehensions levels
- Learn about existing and future business applications that will integrate with specific business needs and strategies
- Optimize processes and workflows of users
- Review, analyze, configure, test, debug and install applications/systems
- Work with business end user and IT to plan and execute maintenance and updates as required
- Document best policies for coding, development, and corrections
- Demonstrated experience in the support requirements of large database applications/systems including performance analysis and tuning of high volume, transaction systems
- Ideal candidate should have at least 5 years of experience as Oracle Applications DBAR12.x applications and 11gR2 database
- Working knowledge of Oracle E-Business Suite 12.2 as an Applications DBA
- Must be familiar with Oracle Applications system cloning procedures
- Working knowledge of Oracle DB backup and recovery using RMAN
- Using Oracle Enterprise manager for monitoring and administration of databases
Oracle Applications Job Description
- Strong knowledge in Unix platforms and shell scripting
- Be a pro-active contributor to a support organization which is running 24x7x365, this will require the ability to work flexible hours
- Contribute to the development and management of knowledge-sharing methodologies, diagnostic tools, and creative processes, to improve the client experience
- Create scripts to identify, analyze and correct data issues
- Maintain and support an IT environment that is conducive to driving and accelerating the business strategies of the company
- Good experience in supporting SOX, PCI and PII compliance controls
- Investigate and troubleshoot issues related to Oracle EBS apps database
- Perform daily system monitoring activities and resources around EBS application server
- Provides Oracle application system administrator duties such as troubleshooting issues with concurrent manager queues, printers, workflow mailer and alerts
- Performs backups, installations, configurations, upgrades, and advanced cloning and patching of EBS environments and other third party applications EBS interfaces with (ESSBASE Hyperion, Discoverer Reporting, etc…)
- Must be able to perform all Oracle Database administration tasks to support both production and test systems
- Knowledge of database and applications patching, configuring and maintaining using AD utilities such as online patching
- Must be able to deliver under tight time constraints
- Must be available for some after hours work and on-call support
- Patching FMW components in EBS Instances
- Database design and data modeling background required