Job Description

Title: Oracle Apps DBA

Location: Hyd/Mum/Bang


Education: Bachelors


Exp Level: 8+ Years

Responsibilities:

8+ years of experience in providing Oracle DBA and Applications DBA support for large number of databases in Oracle. An excellent understanding of Oracle internals and Administration in 19c, 23ai, GRID and HA. Experience in managing Real Application Clusters and Dataguard is preferable. Solid experience of installation, upgrade, patching and cloning, maintenance, system administration of EBS R12.1 and R12.2.x application. Experience in complex Oracle E-biz upgrades and Cross platform migrations (on-premises as well as Cloud) - from 12.1 to 12.2 and related database upgrades. Having Cloud Infra (Azure/AWS/OCI) experience is added advantage. Having DevOps expertise is added advantage. Advanced Performance tuning skill to identify the contention at Database and operating system level and able to provide the solution quickly to resolve production issues. Experience in analysing the Database Health check reports like AWR, ADDM, OEM Diagnostics Packages and should have experience to interpret the performance metrics quickly. Demonstrable experience of managing high-performance, high-capacity databases in a critical production environment L3 level support. Handle escalations from L2 incident Management team. Ability to successfully handle multiple tasks while under pressure. Strong Oracle 19c/23ai RAC experience including general administration, troubleshooting and L3 performance tuning skills. Generate innovative approaches and solutions to recurring tasks or problems. Experienced in Clusterware (GRID Infrastructure) - CRS management and configuration. Exhibit strong organizational, analytical, multi-tasking, and prioritization skills. Flexible at work and willing to work 24 X 7 Shift operations. Candidate should be SME in anyone of the specialized/Advanced skills like RAC, Golden Gate, Exadata, Weblogic, Oracle Database Appliance (ODA), Oracle Private Cloud Appliance (PCA), OAM, OBIEE, Hyperion, SQL/PLSQL Tuning etc

Required Skills:

Needs to have at least 8 years of experience on Oracle Applications/Database administration, including customer communication experience. Willing to work 24/7 environment. Must be flexible to work on weekends and after business hours, if required. Willing to work extended hours for supporting projects and troubleshooting issues Must have the strong communication skills to deal directly with business and development teams. Must have strong technical skills to manage and take ownership of technical projects without any assistance. Expert in Troubleshooting any kind of issue. Proficient Oracle RAC (Real Application Cluster) DBA skills with Backup and Recovery Full EBS R12.2 Oracle Applications lifecycle support Implementing database and application patches, new releases including major upgrades Practical knowledge of Parallel Concurrent Processing as well as debugging concurrent managers and requests Working with AD utilities, patching techniques and cloning tools. Develop and maintain expertise in use of automated tools for database design and implementation They should have hands-on architecture, installation, upgrade, production support skills Excellent troubleshooting and problem solving skills for the Oracle Application. Shell scripting and work automation/troubleshooting Experience in Oracle Applications System Administration e.g. User, Security, Performance/Concurrent Managers Experience with setting up of Single sign-on, OAM, OID etc Must be proactive and self-motivated, and not wait for direction. Must be easily understood and possess excellent English communication skills, both verbal and writing skills.

Good to Have:

SSO and SSL implementation knowledge with Oracle Application. OBIEE/Hyperion Administration and troubleshooting knowledge. Oracle Fusion Middleware knowledge. Expertise in cloud platforms such as AWS, Azure, Oracle Cloud (OCI) or Google Cloud. Expertise in DevOps.

Qualifications:

Engineering Bachelor's Degree or Higher

Certifications:

Oracle Certified professional (19c) (Optional)


Oracle Application Certified (R12.2) (Optional)


Cloud Certifications (OCI, AWS, Azure) (Optional)