Oracle Database Administrator

Value Apothecaries; Pune District; Hybrid; INR 2.500.000 - 4.000.000; Vollzeit

Zusammenfassung

Cencora is seeking an experienced Oracle Database Administrator to manage Oracle and Exadata landscapes in Pune, India. You will serve as the primary contact for Oracle DB issues and collaborate with infrastructure teams to ensure stability and performance.

The role requires 5-8 years of DBA experience, expertise in Oracle 12c–19c, Data Guard, RMAN, and Exadata, plus involvement in DR drills and patching. This position is on-site with ongoing 24/7 support requirements.

Qualifikationen

• BS Degree in Computer Science, Information Technology, or equivalent.
• 5-8 years of professional Oracle database administration experience (SAP & Non-SAP DBs).
• Experience with Exadata environment for production and non-prod databases.
• Configure Data Guard broker and maintenance; perform DR drills.
• Patch management and security hardening for Oracle DBs (RU/RUR).
• Familiarity with RMAN backups and Oracle RAC in Exadata environments.

Aufgaben

• Primary point of contact for Oracle database issues.
• Troubleshoot with infrastructure teams to resolve problems.
• Manage performance, capacity planning, and tuning of Oracle databases.
• Coordinate software consistency across Oracle landscape.
• Participate in IT Change Management for Oracle DB changes.
• Interact with Oracle for product support and questions.
• Design solutions by gathering requirements and writing specs.

Kenntnisse

Oracle DBA

Oracle RAC

RMAN

Data Guard

Exadata

Performance Tuning

srvctl/crsctl

Grid Control/OEM 13cR5

Backup & Recovery

Ausbildung

BS in Computer Science/Information Technology

Tools

RMAN

Data Guard

Active Duplicate

ZDLRA

ASM

Exadata

OEM 13cR5

srvctl

crsctl

Jobbeschreibung

Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere.

Job Details

POSITION SUMMARY

Under general direction of the designated Manager, individuals will be responsible for operations, installation, and performance of the SAP and Non-SAP Oracle database landscapes. Candidates will serve as the primary point of contact within the organization for the Oracle database environment. Will define and enforce standards related to Oracle database administration. Will be responsible for proactively identifying opportunities to utilize the technology to solve technical and business problems.

Minimum 3 days' Work from Office (WFO), 24*7 shift support and On-call rotational support.

PRIMARY DUTIES AND RESPONSIBILITIES

• Primary point of contact for Oracle database issues.
• Will work closely with infrastructure teams (servers, network, ITCC etc.) to troubleshoot and resolve problems.
• Actively manage the performance of the various Oracle databases, including capacity planning and tuning.
• Coordinate with other team members to ensure software consistency across the Oracle landscape.
• Will participate in the IT Change Management process and validate/approve all Oracle database related changes.
• Works with internal and external customers to understand their requirements to form a forward-thinking DBA vision for the Oracle DBs in use by the Company.
• Provide input on and support new projects affecting the Oracle database landscape.
• Engage and interface directly with Oracle as required for product support/questions.
• Defines solutions by identifying requirements and writing functional specifications; consults with technical subject matter experts.
• Advice on options, risks, costs versus benefits and impact on other business processes and system priorities; contributes to cost versus benefit measures.
• Participates in Security/Vulnerability assessment and remediation/patching for affected Oracle DBs or Exadata hardware issues.
• Performs related duties as assigned.

TECHNICAL EXPERIENCE AND EDUCATIONAL REQUIREMENTS

• Requires a BS Degree in Computer Science, Information Technology, or equivalent.
• Minimum 5-8 yrs of Professional and responsible experience as Oracle database Administrator, handling SAP & Non-SAP DBs (12c to 19c) Infrastructure activities.
• Manage and monitor Oracle databases required for Non-prod and Prod DBs running on Exadata environment.
• Install, configure, and maintenance of Oracle databases 12c to 19c running on Exadata environment.
• Database cloning/refresh using RMAN Backup-based/Active duplicate/ZDLRA appliance.
• Creating standby database (Active Data Guard), configure Data Guard broker and maintenance.
• Resolve standby database out of sync and other generic issues related to data guard environment.
• Perform DR drill activity for Active Data Guard, Cascade and Snapshot standby databases.
• Configure physical backup and recovery strategies using Oracle's RMAN utility to ZDLRA/ZFS appliance.
• Restoring and recovery of Oracle databases in various scenarios.
• Experience on ZDLRA appliance for Oracle database backup as plus
• Logical backup and restore using Data pump (expdp & impdp) utility.
• Add, delete/drop disks for storage management & performance in ASM environment.
• Generate, review, and analyze AWR, ASH and ADDM Report for database performance analysis.
• Knowledge of Performance Tuning - SQL queries, Database and RMAN backup.
• Good basic knowledge of the Oracle RAC environment on Exadata environment.
• Patches apply (RU/RUR/MRP/One-off) for GRID/DB homes (RAC) using rolling fashion method on Exadata environment.
• Troubleshoot cluster related issues using srvctl or crsctl utility or by reviewing cluster logs.
• Add, configure, monitor HA services and workload mgmt. for application batch or report jobs.
• Experience with Oracle Partitioning, Oracle Advanced Compression, Oracle Transparent Data Encryption
• Knowledge of Oracle Enterprise Manager 13cR5 Grid Control for DBA environment.
• Install, configure, and maintain OEM agent (13cR5) on RAC environment.
• Good knowledge of Oracle Exadata Machine architecture and all component layers.
• Good understanding of Exadata Features & functionality - Smart Scan, Storage Indexes, Smart Flash Cache, IORM, DBRM etc.
• Monitor and manage Exadata Machine for mission critical databases - Compute, Storage, Network, PDU.
• Troubleshot Hardware failure events, break-fix & follow-up with Oracle support for the part replacement.
• Raise priority SR for critical issues or own open ASR issues and work with Oracle platinum team.
• Raise Patch request with Oracle Platinum team for scheduling the patch/upgrade activity on t