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.
Collaboration 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.
