Oracle Apps DBA Job Description
Oracle apps DBA
provides technical and functional support for database monitoring, database installation, database configuration, database administration, troubleshooting techniques, performance tuning and application system updates.
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:
Perl, Shell, Sql & PL/Sql scripting for Alerts, Monitoring, Reporting & Auditing
Ability to develop SQL and PL/SQL scripts
Install, patch, upgrade, configure, tune and maintain the Oracle E-business Suite 12i and 11g/12c Oracle databases
Oracle E-business 12i application, the Oracle databases and PL/SQL code
Serve as day-to-day technical lead for developers enhancements or problem resolutions.Analyze, design, develop, test and implement application enhancements
Deploy code and setup changes to production
Participate in system administration and operational support (e.g., maintenance and support, reviewing and analyzing system logs and problem reports, adds, changes, backups, and file restores) and assist in monitoring of the system's performance and capacity planning
Evaluates and implements new technologies, products and tools used in the application development environment
Analyze performance issues in the application, concurrent manager and database tiers of E-Business Suite installationsManage resources to provide assistance to development teams with tuning database queries, reviewing and testing patches, configuration and code migrations.Develop purging, archiving, and cloning strategies
Manage relationship with customers to understand customer and project needs and priorities
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:
Oracle applications architecture in a RAC and Data Guard configuration
Installation
Upgrade
Database and Application parameters
Oracle database wait events
Patching and cloning of EBS 11i
R12.1 and R12.2
SQL
Database Performance and System tuning skills in Oracle Core DBA and EBS administration
Database changes
Desired experience for oracle apps DBA includes:
Plan for hardware and the software requirements and submit it to supervisor for review
Prepare high level infrastructure requirement
For support projects, understand the customer landscape
Evaluate customer demographics and prepare analysis reports
While performing the duties of this job, the employee is frequently required to sit
15+ years total DBA experience with a minimum of 10 years experience as Oracle Applications DBA in a multi-node multi-tier data center environment with recent skills in Oracle release 11/12g and eBusiness Suite R12x
Oracle Apps DBA Examples
1
Oracle Apps DBA Job Description
Job Description Example
Our company is looking for an oracle apps DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle apps DBA
- 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
Qualifications for oracle apps DBA
- 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
2
Oracle Apps DBA Job Description
Job Description Example
Our company is looking for an oracle apps DBA. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for oracle apps DBA
- 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
Qualifications for oracle apps DBA
- 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
3
Oracle Apps DBA Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of oracle apps DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle apps DBA
- 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
Qualifications for oracle apps DBA
- 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
4
Oracle Apps DBA Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of oracle apps DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for oracle apps DBA
- 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
Qualifications for oracle apps DBA
- 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
5
Oracle Apps DBA Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of oracle apps DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for oracle apps DBA
- 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
Qualifications for oracle apps DBA
- 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