Oracle Apps DBA Job Description
Oracle Apps DBA Duties & Responsibilities
To write an effective oracle apps DBA job description, begin by listing detailed duties, responsibilities and expectations. We have included oracle apps DBA job description templates that you can modify and use.
Sample responsibilities for this position include:
Oracle Apps DBA Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Oracle Apps DBA
List any licenses or certifications required by the position: OCI, DBA, OIM, SSL, OCP
Education for Oracle Apps DBA
Typically a job would require a certain level of education.
Employers hiring for the oracle apps DBA job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Engineering, Technical, Education, Science, Information Systems, Information Technology, Communication, Design, Administration
Skills for Oracle Apps DBA
Desired skills for oracle apps DBA include:
Desired experience for oracle apps DBA includes:
Oracle Apps DBA Examples
Oracle Apps DBA Job Description
- Oracle administration experience on 11gR2 & 12c databases
- Implement, enforce and adhere to Disaster Recovery plan for platforms
- Single node & Multi Node cloning of Oracle Apps Instances in Normal and Shared Appltop Architecture
- Update DBA Processes/Standards and documents (DBA Run book, Cloning, Upgrades, Issues/Resolutions )
- Monitor and troubleshoot Concurrent Manager Problems, Performance, Errors
- Delivery and management of project instances
- Manage EBS instances on the Oracle Public Cloud
- Troubleshooting and resolving Application and Database issues
- Ensure database standards and controls are maintained
- Plan, enhance and execute database monitoring and alerts
- Minimum Educational Requirements Bachelor's degree in Information Technology or related field or equivalent work experience
- Good knowledge on Shell scripting
- Assists provider with examination and procedures as requested
- 8+ years of experience managing Oracle EBS, and Core Databases in high availability configuration (Database RAC, PCP, Load Balancing )
- Ability to multi-task and effectively delegate tasks to geographically dispersed technical team
- Undergraduate degree and at least 4-6 years of experience related to Oracle application and operations support
Oracle Apps DBA Job Description
- Manage the DBA related open SRs with Oracle support
- Securing access control by developing and maintaining policies, procedures and controls
- Regular reporting to the teams you work with
- Building new databases
- Lead database administration team
- 7 + years Oracle E-business Suite administration supporting a production environment
- At least ten (10) years of hands-on technical experience in addition to strong conceptual knowledge about Oracle database and RAC, its underlying architecture and fundamentals are required
- Setup Oracle Replication using Data guard
- Backup and recovery with strong RMAN skills
- Clone Oracle applications non-oracle application databases as needed to support development and testing efforts
- Required technical experience should include experience with the latest versions of Oracle eBS, broad experience with Oracle functional capabilities, and experience with enterprise level scale and performance requirements
- Candidates are required to hold UK citizenship, a detailed background check will be conducted in order to obtain UK security clearance which is required for this role
- Minimum 5+ years’ experience in Oracle Applications, Database & Fusion Middleware administration on enterprise level platforms running on Solaris and Linux
- Extensive hand-on Oracle administration experience on 11gR2 & 12c databases
- Minimum 9+ years’ experience in IT and over 6+ in Oracle Applications, Database & Fusion Middleware administration on enterprise level platforms running on Solaris and Linux
- 5-7 years experience in design/manage/administer Oracle 9i/11g/12c databases on RAC and non-RAC – 24 x7 environments
Oracle Apps DBA Job Description
- Oracle Service Bus and SOA
- OBIEE set up and install
- GTM install and set up
- SMTP – Email set-up in EBS
- SSO – Secure Socket Layer / HTTPs
- Working within an agile Oracle EBS team environment
- Document DBA processes and prepares documentation for new and modified systems, environments, hardware, software or databases
- In depth knowledge in AD utilities like adpatch, adadmin, adctrl, adrelink, admrgpch
- Monitoring and taking care of tablespace alerts, blocking sessions, mount point issues in all the instances
- Performed cloning activities from Production database to Development / Test database
- Map all functional requirements to technical requirement
- MySQL/Mongo/Cassandra/BigData/Hadoop Database Administration knowledge/hands-on is desired
- Expertise in Performance tuning and troubleshooting application database
- Expertise in Oracle EBS Sysadmin setup task for Oracle application like responsibility, forms, function, menu, user setup, buyer, employee
- 3+ years of Oracle database and system administration experience
- For larger DBA teams, may serve as team lead, responsible for maintaining standards and processes to allow for repeatable and predictable services
Oracle Apps DBA Job Description
- Good exposure of Backup and Recovery (Oracle RMAN, Import/Export and Datapump)
- Good exposure in Dataguard implementation and maintenance
- Basic knowledge of performance monitoring and tuning
- Good understanding of EBS R12.2 application architecture (including adop concepts, dual file system architecture, FMW concepts, PCP, concurrent managers, workflow, layout of application on infrastructure)
- Data Center Migration experience is a major plus
- Knowledge on Oracle products like Endeca and OBIEE is a plus
- Administration of concurrent managers
- Experience with UNIX/Shell/Perl scripting
- Database / Apps process
- Monitoring of database performance
- Conduct sizing based on the inputs during requirement gathering (hardware configuration)
- Identify any prerequisites and dependencies for application
- Understands Oracle application and database technical architecture and how to optimize for performance
- Experienced in structured analytical methods and incident troubleshooting
- Experienced in instance patching, cloning, refreshing, back-up, and recovery
- Experienced in monitoring performance of applications and database servers
Oracle Apps DBA Job Description
- Scheduling database RMAN Back-up and recovery processes
- Experience with SSO-EBS is a big plus
- Experience with tools such as OEM
- Ability to multi-task while maintaining high quality of deliverables
- Scheduled jobs (Backups, Concurrent manager jobs)
- Provide production and operational support including active database monitoring, issue resolution and on call duties
- 4+ Years of Experience as Oracle Applications DBA
- Hands-On Experience in a multi-node multi-tier environment with recent skills in Oracle Database Release 11gR2 and 12c and eBusiness Suite R12.2 with WebLogic Administration
- Hands-On Experience in Administering Oracle RAC, Oracle DataGuard, ASM, RMAN, Linux/Unix Operating Systems
- Knowledge of Oracle Fusion Technology a plus
- Experienced in performance tuning custom developed objects
- Knowledgeable with various flavors of Unix, Unix shell scripting, RAC, AD tools, and configuration of application in a load balanced environment
- Experienced with service management tools, processes, and protocols
- Cloning, Refreshing, backup and recovery
- Unix Shelling Scripting
- AD Tools