Job 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), 247 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 advantages 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 workplace.
- 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 the Exadata machines
- Provide the DBA support during the patching event (Monthly/Quarterly) for Exadata environment.
- Review performance metrics for Exadata machine via OEM Console -- CPU/Memory/IO/Network etc.
- Generate Exa check report and review on Monthly basis for score analysis on Exadata environment.
- Generate AWR/ASH/ADDM reports for Exadata machine periodically, review and performance tuning.
- Provide support for database issues on 24x7 (on-call) and responding to critical situations.
- SNOW ticket tool to handle INC, CHG, REQ, PBI, and Jira Tool for user/project requests (SRs).
- Escalation to oracle support on issues related to all environments (Production, Test and Development).
- Knowledge of Azure/OCI cloud for Oracle database.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Oracle Database Administrator (Pune)
🏢 Amerisource Bergen
📍 Pune