Associate Consultant

Associate Consultant – Oracle DBA & Cloud Services

The position is intended to develop into a broader Oracle Cloud and Applications consulting role through structured learning, certification, shadowing, and hands-on customer delivery.

Key Responsibilities

Oracle DBA & Database Operations

• Support Oracle application and database environments across production and non-production systems.
• Perform routine Oracle database monitoring, health checks and administration.
• Monitor database availability, tablespace utilization, CPU, memory, storage, sessions and database alerts.
• Support Oracle database backup and recovery using RMAN.
• Perform Data Pump export/import and database/schema refresh activities.
• Support database and application cloning activities.
• Assist with Oracle database and application patching activities.
• Support user, role, privilege, profile and tablespace administration.
• Review alert logs, trace files and ORA errors and assist with troubleshooting.
• Support performance monitoring and basic SQL/database performance analysis.
• Follow established SOPs, runbooks, change-management and incident-management processes.
• Participate in production support, incident resolution, RCA and preventive improvement activities.

Oracle Applications / Apps DBA

Develop hands-on capability in:

• Oracle E-Business Suite architecture and administration.
• Application tier and database tier administration.
• Application services start/stop and health monitoring.
• Concurrent processing and application service monitoring.
• Oracle EBS cloning and environment refresh.
• Application and database patching.
• Configuration and troubleshooting.
• Performance and availability monitoring.
• Backup, recovery and DR operational procedures.

OCI & Cloud

Develop practical understanding of:

• OCI architecture and core services.
• Compute, Storage, Networking and IAM.
• OCI database services.
• Monitoring, Logging and Notifications.
• Backup and recovery.
• Security and access management.
• Cloud provisioning and operational support.
• Cost, capacity and resource management.
• Automation and Infrastructure as Code concepts.

PeopleSoft

Build foundational operational knowledge of:

• PeopleSoft architecture and components.
• Application Server.
• Process Scheduler.
• Web Server.
• PeopleSoft database architecture.
• Environment start/stop and health checks.
• Monitoring and troubleshooting.
• Backup, recovery and environment refresh concepts.
• PeopleSoft patching and maintenance processes.

Automation & Operational Improvement

• Identify repetitive DBA/operational activities suitable for automation.
• Support scripting and automation initiatives.
• Contribute to monitoring and alerting improvements.
• Maintain operational documentation, SOPs, runbooks and Knowledge Base articles.
• Participate in CCOE/Practice improvement initiatives.
• Leverage existing Java, API and CI/CD knowledge where applicable to cloud and database automation.

Development Goals

Rajesh's structured development objectives will include:

OCI Foundation Certification

• Complete OCI Foundation training and achieve the relevant Oracle Cloud Infrastructure Foundations certification.

OLA

• Develop working knowledge of OLA, including architecture, operational processes, deployment/support methodology and its use within the Oracle managed-services environment.

PeopleSoft

• Develop foundational PeopleSoft administration knowledge sufficient to participate in routine operational support under guidance.

Oracle Apps DBA

• Transition existing Core DBA knowledge into practical Oracle Apps DBA capability through training, shadowing and hands-on support.

Performance Expectations

Performance will be evaluated across both customer delivery and capability development, including:

• Quality and timeliness of assigned support activities.
• Adherence to SLA, change and operational processes.
• Reduction of repeat operational issues through documentation and automation.
• Quality of SOPs/runbooks and knowledge contribution.
• Progress in Oracle Apps DBA capability.
• Completion of OCI certification.
• Demonstrated progress in OLA and PeopleSoft.
• Ability to independently handle progressively more complex Oracle operational activities.
• Collaboration with Apps DBA, Cloud, Infrastructure and Application teams.

Target Capability

The objective is to develop Rajesh from his existing Oracle Core DBA foundation into a multi-skilled Oracle Apps DBA / Cloud Associate Consultant capable of supporting Oracle Core DBA → Oracle Apps DBA → OCI → OLA → PeopleSoft while progressively contributing to the broader IMS Oracle Cloud and Managed Services practice.