Oracle Database Administrator

Overview

Oracle Database Administrator responsible for the operations, installation and performance of SAP and non-SAP Oracle database landscapes, serving as the primary point of contact for the Oracle database environment.

What you'll do

• Act as the primary point of contact for Oracle database issues.
• 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.
• Participate in the IT Change Management process and validate/approve all Oracle database related changes.
• Work with internal and external customers to understand their requirements and 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.
• Define solutions by identifying requirements and writing functional specifications; consult with technical subject matter experts.
• Advise on options, risks, costs versus benefits and impact on other business processes and system priorities; contribute to cost versus benefit measures.
• Participate in security/vulnerability assessment and remediation/patching for affected Oracle DBs or Exadata hardware issues.
• Perform related duties as assigned.
• Manage and monitor Oracle databases required for Non-prod and Prod DBs running on Exadata environment.
• Install, configure and maintain Oracle databases 12c to 19c running on Exadata environment.
• Clone and refresh databases using RMAN backup-based, active duplicate or ZDLRA appliance.
• Create standby databases (Active Data Guard), configure Data Guard broker and maintain them.
• Resolve standby database out-of-sync and other generic Data Guard issues.
• Perform DR drill activity for Active Data Guard, cascade and snapshot standby databases.
• Configure physical backup and recovery strategies using Oracle RMAN to ZDLRA/ZFS appliance.
• Restore and recover Oracle databases in various scenarios.
• Perform logical backup and restore using Data Pump (expdp and impdp).
• Add and delete/drop disks for storage management and performance in ASM environment.
• Generate, review and analyze AWR, ASH and ADDM reports for database performance analysis.
• Perform SQL, database and RMAN backup performance tuning.
• Apply patches (RU/RUR/MRP/one-off) for GRID/DB homes (RAC) using rolling method on Exadata environment.
• Troubleshoot cluster-related issues using srvctl or crsctl utilities or by reviewing cluster logs.
• Add, configure and monitor HA services and workload management for application batch or report jobs.
• Install, configure and maintain OEM agent (13cR5) on RAC environment.
• Monitor and manage Exadata machine for mission-critical databases, including compute, storage, network and PDU.
• Troubleshoot hardware failure events, break-fix, and follow up with Oracle support for part replacement.
• Raise priority SRs for critical issues or own open ASR issues and work with Oracle Platinum team.
• Raise patch requests with Oracle Platinum team to schedule patch/upgrade activities on Exadata machines.
• Provide DBA support during monthly/quarterly patching events for Exadata environment.
• Review Exadata performance metrics via OEM console (CPU, memory, IO, network, etc.).
• Generate and review monthly Exa check reports for score analysis.
• Generate and review AWR/ASH/ADDM reports for Exadata machines periodically and tune performance.
• Provide 24x7 (on-call) database support and respond to critical situations.
• Handle INC, CHG, REQ and PBI tickets in ServiceNow, and user/project requests (SRs) in Jira.
• Escalate to Oracle support for issues across Production, Test and Development environments.

What you'll need

• Bachelor's degree in Computer Science, Information Technology, or equivalent (or equivalent experience).
• 5-8 years of professional and responsible experience as an Oracle database administrator, handling SAP and non-SAP databases (12c to 19c) infrastructure activities.
• 5+ years of experience in database administration or database engineering supporting production systems, or a related field.
• Experience installing and supporting Oracle RAC databases.
• Experience with multiple Oracle database installations.
• Good basic knowledge of the Oracle RAC environment on Exadata.
• Good knowledge of Oracle Exadata Machine architecture and all component layers.
• Good understanding of Exadata features and functionality: Smart Scan, Storage Indexes, Smart Flash Cache, IORM, DBRM.
• Knowledge of performance tuning: SQL queries, database and RMAN backup.
• Experience with Oracle Partitioning, Oracle Advanced Compression and Oracle Transparent Data Encryption.
• Knowledge of Oracle Enterprise Manager 13cR5 Grid Control for DBA environment.
• Ability to foster innovation and out-of-the-box thinking while ensuring practical applications.
• Ability to direct the formulation, definition and documentation 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, with 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.
• Knowledge of computers to operate effectively with computer hardware such as general mainframe, midrange, network and desktop technologies; and computer software including application development lifecycle, ServiceNow, MS Office Suite and Outlook.
• Ability to lift up to 25 lbs.
• Ability to deal with stressful situations as they arise.

Nice to have

• Experience on ZDLRA appliance for Oracle database backup.
• Knowledge of Azure/OCI cloud for Oracle database environment.
• Certification in IT service management (e.g., ITIL).
• Certified ScrumMaster (CSM) or equivalent certification.
• Scaled Agile Framework Scrum Master (SAFe) or equivalent certification.

Details

• Location: Pune, India.
• Minimum 3 days' work from office (WFO).
• 24x7 shift support and on-call rotational support.
• Full-time position.
• Work environment is generally quiet, open-culture.
• Sedentary work; 50% or more time spent looking directly at a computer; frequently required to stand and walk.