Oracle Database Administrator

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. Apply today!

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 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 environment as plus.

MINIMUM INTERPERSONAL SKILLS, KNOWLEDGE AND ABILITY REQUIREMENTS:

Ø Must have experience installing and supporting Oracle RAC databases.

Ø Minimum 5-8 yrs. Oracle database experience, with multiple installations.

Ø Experience with Oracle ZDLRA appliance for backups a plus.

Ø Ability to foster innovation and “out of the box” thinking while ensuring practical applications

Ø Ability to direct the formulation, definition and documenting of system architecture and objectives for assigned projects

Ø Solid understanding of business requirements and ability to prepare architectural specifications from which applications will be designed

Ø Ability to communicate effectively both orally and in writing, good group presentation skills

Ø Strong organizational skills, Good analytical, conceptual and problem-solving skills to evaluate business problems and apply technology knowledge to identify appropriate solutions

Ø Good interpersonal skills; effective team player, Excellent discovery and active listening skills

Ø Good relationship building skills, Ability to communicate effectively both orally and in writing

Ø Knowledge of computers to operative effectively with computer hardware such as general mainframe, midrange, network and desktop technologies; computer software includes application development lifecycle, ServiceNow, MS Office Suite and Outlook

WORK ENVIRONMENT:

The work environment characteristics described here are representative of those associate encounters while performing the essential functions of this job. Reasonable accommodation may be provided to enable individuals with disabilities to perform the essential functions: The noise level in the work environment is generally quiet, open culture environment.

PHYSICAL AND MENTAL REQUIREMENTS:

The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions:

ü Sedentary physical activity requires reaching, sifting, lifting, finger dexterity, grasping, feeling, repetitive moti