Experience: 6 plus years
Role Overview
We are seeking a mid level and hands-on Database Administrator (DBA) with deep expertise in Oracle (Core/EBS) 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.
- Support Oracle EBS, OAM and other applications associated with EBS.
- 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 and application 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
- 5-6 years of enterprise DBA experience across EBS, Oracle and PostgreSQL environments.
- Strong Oracle DBA experience (including RAC, DataGuard, Exadata, EBS administration, and patching via Rimini Support).
- Hands-on experience with PostgreSQL (on-prem 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.
- Familiarity with compliance frameworks (e.g., SOX) and implementation of access controls and audit logs.
- Comfortable working in a 24x5 support model, including enhanced responsiveness during period-close cycles.
