Senior Technical Specialist

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)