Senior Technical Specialist -Oracle Apps DBA

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 Bachelors Degree or Higher

Certifications:

Oracle Certified professional (19c) (Optional)

Oracle Application Certified (R12.2) (Optional)

Cloud Certifications (OCI AWS Azure) (Optional)