Oracle Applications DBA

We are seeking a highly skilled Oracle Applications DBA to manage and maintain the Oracle E-Business Suite (EBS) and associated databases. The ideal candidate will be responsible for the installation, configuration, performance tuning, patching, cloning, backup, and recovery of Oracle Applications environments. This role requires strong expertise in Oracle database administration and a deep understanding of Oracle Applications architecture.

Key Responsibilities:

• Install, configure, and maintain Oracle E-Business Suite (R12.x) environments on Oracle Cloud Infrastructure using Ansible for automation.

• Optimize database performance, ensuring high availability and reliability.

• Perform backup, recovery, and disaster recovery planning using RMAN and other tools.

• Troubleshoot database-related issues, working closely with application and infrastructure teams.

• Performance Tuning & Optimization:

• Identify and resolve bottlenecks using tools like AWR, ADDM, and SQL Tuning Advisor.

• Optimize SQL queries and database indexing strategies for improved performance.

• Implement partitioning, compression, and other techniques to enhance efficiency.

• Security & Compliance:

• Implement database security policies, user access controls, and encryption techniques.

• Conduct regular security audits and vulnerability assessments.

• High Availability & Disaster Recovery:

• Configure and manage Oracle RAC, Data Guard, and GoldenGate for HA and replication

• Automation & Scripting:

• Develop scripts using Shell, PL/SQL, or Python for database automation and monitoring.

• Collaboration & Documentation:

• Work with developers to optimize database schemas and queries.

• Document database architecture, configurations, and standard operating procedures.

Qualifications & Requirements:

• Bachelor s or master s degree in computer science, Information Technology, or a related field.
• 5-8 years of experience as an Oracle DBA in enterprise environments
• Strong knowledge of SQL, PL/SQL, and performance tuning techniques.
• Experience with Oracle Enterprise Manager (OEM) for monitoring and administration.
• Hands-on experience with Unix/Linux environments and shell scripting.
• Strong troubleshooting and problem-solving skills.
• Certifications such as Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) are a plus.

Preferred Skills:

• Experience in Ansible or Terraform for database automation.
• Exposure to NoSQL or other RDBMS (PostgreSQL, MySQL) is an advantage.
• Exposure to Python is a plus