19 Nov
|
Clovio IT Consulting P
|
Bengaluru
19 Nov
Clovio IT Consulting P
Bengaluru
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.
Requirements Required 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: Robust 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) (Bengaluru)
🏢 Clovio IT Consulting P
📍 Bengaluru