Description :

Job Responsibilities :

Database Performance & Optimization :

- Advanced knowledge of Oracle Database Architecture.

- Perform advanced SQL tuning, indexing, partitioning, and query optimization.

- Use AWR, ASH, SQL Profiles, and SQL Baselines to troubleshoot performance issues.

- Optimize memory, CPU, and storage configurations for Exadata, Oracle RAC, and Cloud environments.

- OS Basic (Linux RedHat/Oracle), Storage Basic concepts, Networking Basic concepts.

High Availability & Disaster Recovery :

- Maintain Data Guard, Oracle RAC and RMAN-based backup/recovery strategies.

- Ensure zero-data-loss disaster recovery using Flashback Technology, Snapshot Standby.

- Conduct disaster recovery (DR) drills and failover testing for compliance.

Automation & DevOps Integration :

- Develop and manage DB automation scripts (Shell, Ansible, Python) for operational tasks.

- Use OEM Cloud Control for database monitoring & alerting.

Leadership, Documentation & Stakeholder Management :

- Mentor colleagues within the squad and provide technical leadership for database arena.

- Maintain runbooks, SOPs, and knowledge base for database operations.

- Collaborate with infrastructure Squad for seamless database integration.

- Act as a trusted advisor for customer, providing structured communication on technical requirements and queries.

Information Security Responsibilities :

- All employees are expected to adhere to the Information Security policies day in and day out.

- Report any ISMS events / incidents as per the reporting procedures.

- Shall be aware of all ISMS principles and guidelines.

Database Backup and Recovery :

Qualification, Experience And Skills :

Qualification : Any Bachelor Degree.

Experience : 10+ years relevant experience.

Skills : Oracle Database administration.

- Knowledge of SQL, PL/SQL.

- Shell scripting, Ansible,.

- Performance Tuning.

- High Availability (HA) and Disaster Recovery (DR) options for Oracle Database.

Certification : OCP,OCI Certifications.

- A fundamental grasp of AI tools will be an added benefit.