18 Nov
|
Clovio IT Consulting P
|
India
18 Nov
Clovio IT Consulting P
India
Job Description
We are looking for an experienced Senior Oracle Database Administrator to own the reliability, performance, and security of our mission-critical production database infrastructure. You will be responsible for managing high-availability Oracle clusters, driving deep query and system tuning, leading database upgrades and cloud migrations, and partnering closely with engineering teams to support scalable, low-latency applications.
Key responsibilities
- High availability & cluster management: Architect, administer, and maintain multi-node Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), and Oracle Data Guard (Physical and Active Standby) to meet strict uptime SLAs.
- Performance tuning & diagnostics: Proactively monitor database health using Oracle Enterprise Manager (OEM), AWR, ADDM, and ASH reports; diagnose and resolve complex SQL bottlenecks, execution plan regressions, locking/latching contention, and I/O or memory issues.
- Backup, recovery & disaster recovery: Design, automate, and audit RMAN backup policies; perform point-in-time recoveries and lead scheduled Disaster Recovery (DR) switchover and failover drills.
- Upgrades, patching & migrations: Plan and execute quarterly Release Updates (RUs), major version upgrades (19c / 23ai), and heterogeneous or cloud database migrations with minimal downtime.
- Security & compliance:
Enforce database security best practices including Transparent Data Encryption (TDE), fine-grained auditing, privilege management, and compliance readiness for internal and external audits.
- Automation & incident leadership: Automate repetitive operational tasks using Shell scripting, Python, or Ansible; lead root-cause analysis (RCA) for high-severity production incidents, participate in on-call rotations, and guide application developers on schema design and query optimization.
RequirementsRequired qualifications & technical skills
- Core experience: 6+ years of hands-on production experience managing large, high-transaction OLTP and/or data warehouse Oracle environments (multi-terabyte scale).
- Oracle architecture: Deep expertise in Oracle Database 12c and 19c (including Multitenant CDB/PDB architecture), with working familiarity in Oracle 23ai features.
- HA & DR stack: Proven production mastery of Oracle RAC, Clusterware, ASM, Data Guard (including Data Guard Broker), and RMAN.
- Tuning & SQL: Solid command over SQL/PL-SQL performance tuning, index design, table partitioning, and optimizer statistics management.
- OS & scripting: Solid proficiency in Linux/Unix environments (RHEL / Oracle Linux), OS-level performance diagnostics, storage fundamentals, and Shell/Bash scripting.
- Education: Bachelor's degree in Computer Science, Information Technology, or a related engineering discipline.
📌 Senior Oracle Database Administrator (DBA) (India)
🏢 Clovio IT Consulting P
📍 India