Oracle Apps Dba Consultant

Job Title:

Role Overview:

We are seeking a seasoned and hands-on Database Administrator (DBA) with deep expertise in Oracle (Core/EBS/Exadata) and PostgreSQL administration. This role demands the ability to operate across a heterogeneous and high-availability database ecosystem, proactively tune performance, drive automation, and ensure enterprise-grade uptime and compliance.

Key Responsibilities:

• Manage, tune, and optimize performance across 220+ database instances using tools such as Oracle Enterprise Manager (OEM), Quest Spotlight, and custom observability scripts.
  
• Implement and maintain robust backup and recovery strategies for production and non-production environments.
  
• Participate in and support Disaster Recovery (DR) tests, failover drills, and maintain High Availability (HA) setups (e.g., Oracle DataGuard, Oracle RAC, SQL Clustering).
  
• Build and maintain system health dashboards, track performance baselines, and provide capacity planning insights.
  
• Collaborate cross-functionally with application, BI, and infrastructure teams to identify and resolve performance bottlenecks and database-related issues.
  
• Administer database patching, access control, and provisioning activities, ensuring alignment with SOX compliance standards.
  
• Contribute to infrastructure automation using Shell scripting, Python, or Ansible.
  
• Support and maintain replication and integration tools including Oracle GoldenGate, Qlik Replicate, and Oracle Data Integrator (ODI).
  

Required Skills & Qualifications:

• 6+ years of enterprise DBA experience across Oracle and PostgreSQL environments.
  
• Strong Oracle DBA experience, including RAC, DataGuard, Exadata, EBS administration, and patching via Rimini Support.
  
• Hands-on experience with PostgreSQL (both on-premises and AWS-hosted), including deployment, scaling, and tuning.
  
• Proven expertise in monitoring, diagnosing, and optimizing high-throughput transactional databases.
  
• Experience managing replication tools like Oracle GoldenGate and Qlik Replicate.
  
• Proficiency in shell scripting and at least one automation tool (e.g., Python, Ansible).
  
• Familiarity with compliance frameworks (e.g., SOX) and implementing access controls and audit logs.
  
• Comfortable working in a 24x7 support model, including enhanced responsiveness during period-close cycles.