Oracle Apps DBA

About Doyensys: 

Doyensys is a Management & Technology Consulting company with expertise in Enterprise applications, Infrastructure Platform Support, and solutions. Doyensys helps clients to harness the power of innovation to thrive on change. The company leverages its technology expertise, global talent, and extensive industry experience to deliver powerful next-generation IT services and solutions. Doyensys Inc has operations in India, the US, Mexico, and Canada.

Job Requirement

• Project Role: Senior Oracle Apps DBA for Support Operations
• Project Role Description: The Senior Oracle Apps DBA will be responsible for providing support for Oracle applications and databases. The Senior Oracle Apps DBA will work closely with the project team, stakeholders, and clients to ensure that support requests are resolved in a timely and efficient manner.
• Work Experience: 5 – 8 Years
• Work location: PAN

Technical Expertise

Must Have Skills:

• Oracle Database Administration: In-depth knowledge of Oracle database administration and maintenance, including database architecture, backup and recovery, performance tuning, and security.
• Oracle EBS Application Administration: Hands-on experience in installing, configuring, and managing Oracle EBS 12.2, including managing concurrent managers, managing Oracle Workflow, managing Oracle Forms and Reports Services, and managing Oracle WebLogic Server.
• Oracle EBS Upgrade and Patching: Experience in performing Oracle EBS upgrades and patching to maintain a stable and secure system.
• Oracle EBS Cloning and Refresh: Experience in cloning and refreshing Oracle EBS environments for testing, development, and production environments.
• Performance Tuning: Ability to identify and resolve performance issues by analyzing database and system performance metrics, tuning SQL queries, and identifying and resolving hardware and network bottlenecks.
• Backup and Recovery: Experience in implementing and managing backup and recovery strategies to ensure high availability and disaster recovery for Oracle EBS.
• Disaster Recovery: Knowledge of disaster recovery planning and execution, including developing and implementing backup and recovery strategies, and testing disaster recovery plans.
• Security: In-depth knowledge of Oracle EBS security features, including user management, roles, responsibilities, and access control.
• Monitoring and Troubleshooting: Ability to proactively monitor system health and troubleshoot issues as they arise to ensure system availability and uptime.
• Scripting and Automation: Experience in developing scripts and using automation tools to simplify routine tasks and improve system efficiency.
•  Communication and Collaboration: Strong communication and collaboration skills to work with cross-functional teams, vendors, and customers to ensure successful project delivery.
• Familiarity with Linux and Unix operating systems

Good To Have Skills:

• Cloud experience: Experience in migrating Oracle EBS to cloud platforms such as Oracle Cloud Infrastructure or Amazon Web Services (AWS).
• DevOps & SRE: Familiarity with DevOps and/or SRE practices, tools, and methodologies to streamline the development and deployment of Oracle EBS.
• Oracle Fusion Middleware: Knowledge of Oracle Fusion Middleware components such as Oracle SOA Suite, Oracle Service Bus, and Oracle Identity Management.
• Automation: Experience in automating Oracle EBS administrative tasks using tools such as Oracle Enterprise Manager (OEM) and shell scripting.
• Soft skills: Strong interpersonal skills, including communication, leadership, and teamwork, to work effectively with stakeholders and team members.

Key Responsibilities: 

• Oracle EBS Patching and Upgrades: Planning, testing, and performing Oracle EBS patching and upgrades to ensure that the system is up-to-date and free from vulnerabilities.
• Oracle EBS Performance Tuning: Analyzing performance issues and tuning Oracle EBS components, including databases, concurrent managers, and web servers to improve system performance and scalability.
• Backup and Recovery: Implementing backup and recovery strategies for Oracle EBS components to ensure data availability and disaster recovery.
• Disaster Recovery Planning and Execution: Developing and executing disaster recovery plans for Oracle EBS environments to ensure business continuity in the event of a disaster.
• Security Management: Managing security for Oracle EBS environments, including user and role management, access control, and auditing.
• Monitoring and Troubleshooting: Monitoring system health and proactively identifying and troubleshooting issues to ensure high system availability and uptime.
• Cloning and Refreshing: Cloning and refreshing Oracle EBS environments for testing, development, and production purposes.
• Documentation and Reporting: Documenting project activities and maintaining accurate records, as well as generating reports to inform management and stakeholders about project status and issues.
• Mentoring and Training: Mentoring junior DBAs and providing training to other teams on Oracle EBS components and related technologies.

Professional Attributes: 

• Technical Expertise: Possessing in-depth technical knowledge and experience with Oracle EBS 12.1, 12,.2 and related technologies, including databases, application servers, and middleware components.
• Analytical and Problem-Solving Skills: Being able to analyze complex issues, identify root causes, and develop effective solutions to resolve them.
• Communication Skills: Possessing excellent communication skills to interact effectively with stakeholders, management, and team members to understand their requirements and communicate technical issues in a clear and concise manner.
• Leadership Skills: Possessing leadership skills to manage projects, mentor junior DBAs, and provide guidance to other team members.
• Attention to Detail: Paying close attention to detail to ensure accuracy and completeness in project documentation, testing, and troubleshooting.
• Customer Service Orientation: Focusing on providing high-quality support to customers and stakeholders, and ensuring their satisfaction with the delivered solutions.
• Continuous Learning: Staying up-to-date with the latest Oracle EBS and related technologies, and continuously learning to enhance technical and professional skills.
• Teamwork: Collaborating effectively with other team members, vendors, and customers to achieve project goals and deliver high-quality solutions.
• Proactivity: Being proactive in identifying potential issues and taking steps to prevent them, and in proposing new ideas to improve the system’s performance and efficiency.
• Accountability: Taking responsibility for the assigned tasks, meeting deadlines, and delivering quality results.

Educational Qualification:

• Bachelor’s or master’s degree in Computer Science, Information Technology, or a related field
• Oracle Certified Professional (OCP) or Oracle Certified Expert (OCE) in Oracle EBS or Database.
• Any Cloud Certifications (OCI, AWS, Azure) – Optional

Behavioral Attribute:

• Adaptability: Being flexible and able to adapt to changing project requirements, priorities, and schedules.
• Ownership: Taking ownership of the assigned tasks and proactively working to complete them in a timely and efficient manner.
• Initiative: Taking the initiative to identify and propose new ideas, solutions, and improvements to the system and the project.
• Integrity: Being honest and ethical in all interactions with stakeholders, customers, and team members.
• Empathy: Being able to understand and empathize with the needs and concerns of customers and stakeholders and being able to provide effective solutions to address them.
• Patience: Demonstrating patience and calmness in dealing with challenging situations, and being able to handle stress and pressure effectively.
• Positive Attitude: Maintaining a positive attitude towards the project, team members, and customers, and being able to motivate and inspire others.
• Collaborative: Being a team player and actively collaborating with other team members to achieve project goals and deliver high-quality solutions.
• Detail-oriented: Being attentive to details and ensuring accuracy and completeness in project documentation, testing, and troubleshooting.
• Continuous Improvement: Being committed to continuous improvement and learning, and seeking opportunities to enhance technical and professional skills.