Oracle Apps DBA

Key Responsibilities :

Database Management :

• Administer and maintain Oracle Core DB and App DB environments.
• Ensure high availability, performance, and security of database systems.
• Perform regular database backups, recovery, and disaster recovery planning.

EBS and ERP Systems :

• Manage and support Oracle E-Business Suite (EBS) and other ERP systems.
• Implement and maintain ERP modules, ensuring seamless integration with other systems.
• Troubleshoot and resolve issues related to EBS and ERP applications.

Oracle Quote Builder and Configurator (Oracle CPQ)

• Implement and manage Oracle Quote Builder and Configurator tools.
• Ensure accurate and efficient configuration of products and services.
• Develop and maintain product configurations, pricing rules, and quoting processes.
• Customize and enhance CPQ functionalities using Oracle CPQ tools and scripting.
• Provide training and support to end-users on CPQ applications.
• Troubleshoot and resolve issues related to CPQ configurations and integrations.
• Ensure data integrity and accuracy within the CPQ system.
• Stay updated with the latest Oracle CPQ features and best practices.

Cloud Technologies :

• Deploy, configure, and manage databases on Oracle Cloud Infrastructure (OCI) and Azure PostgreSQL.
• Optimize cloud-based database performance and cost-efficiency.
• Ensure data security and compliance with cloud service providers.

Scripting and Automation :

• Develop and maintain scripts using Python for database automation and monitoring.
• Implement automated processes for database maintenance and performance tuning.
• Create and manage database-related documentation and procedures.

Performance Tuning and Optimization :

• Monitor database performance and identify areas for improvement.
• Conduct performance tuning and optimization of SQL queries and database configurations.
• Collaborate with development teams to optimize application performance.

C ollaboration and Support :

• Work closely with IT, development, and business teams to support database-related needs.
• Provide technical guidance and mentorship to junior database administrators.
• Participate in on-call rotation for database support and maintenance.

Skills Required

Database Administration, Backup And Recovery, Performance Tuning