oracle DBA
- Quinnox
- 8 - 13 years
- Bengaluru
- 6 days ago
- Email to a friend
- Report this job
Job Description
1. Database Installation & Configuration
- Install, configure, and upgrade Oracle Database (11g/12c/19c) across Linux and UNIX environments.
- Create and manage databases using DBCA and manual methods.
- Configure listener, TNS entries, and network connectivity.
- Apply PSU/RU patches and perform version upgrades with minimal downtime.
- Implement multitenant architecture (CDB/PDB) administration.
2. Backup & Recovery Management
- Design and implement backup strategies using Oracle Recovery Manager (RMAN).
- Configure full, incremental, cumulative, and archive log backups.
- Perform database recovery scenarios including point-in-time recovery (PITR) and block-level recovery.
- Conduct regular restore validation and disaster recovery drills.
- Manage backup retention policies and optimize storage usage.
3. High Availability & Disaster Recovery
- Configure and manage Oracle Data Guard (Physical & Logical Standby).
- Monitor redo transport and apply lag; perform switchover and failover activities.
- Support Oracle Real Application Clusters (RAC) environments for high availability.
- Implement ASM (Automatic Storage Management) disk groups and manage storage allocation.
- Coordinate DR testing and document recovery procedures.
4. Performance Monitoring & Tuning
- Monitor database health using AWR, ADDM, ASH reports.
- Identify and resolve performance bottlenecks related to CPU, memory, I/O, and SQL queries.
- Tune poorly performing SQL queries using execution plans and indexing strategies.
- Optimize memory parameters (SGA/PGA) and initialization parameters.
- Implement partitioning and indexing strategies to improve performance.
5. Security & Compliance
- Create and manage database users, roles, and privileges.
- Implement password policies and auditing policies.
- Configure Transparent Data Encryption (TDE).
- Perform database vulnerability assessments and apply security patches.
- Ensure compliance with enterprise security standards.
6. Database Maintenance & Monitoring
- Perform space management activities including tablespace resizing and datafile management.
- Monitor archive log generation and FRA usage.
- Schedule and manage jobs using DBMS_SCHEDULER.
- Automate routine DBA tasks using shell scripting and PL/SQL.
- Proactively monitor alert logs and resolve database issues.
7. Cloud & Migration Exposure
- Support database deployments in cloud platforms (OCI/AWS/Azure).
- Manage databases hosted on Oracle Cloud Infrastructure (OCI).
- Perform on-prem to cloud database migrations using Data Pump and RMAN duplication.
- Work with hybrid cloud architectures and storage integrations.
8. Production Support
- Provide 24/7 on-call support for critical production databases.
- Perform root cause analysis (RCA) for incidents and implement preventive measures.
- Coordinate with application teams for release deployments.
- Maintain SLA adherence and system uptime above 99.9%.
9. Documentation & Collaboration
- Maintain detailed documentation for database architecture and procedures.
- Work closely with developers for schema design and query optimization.
- Participate in capacity planning and hardware sizing discussions.
- Support audit and compliance documentation requirements.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: DBA / Data warehousing - OtherEmployement Type: Full timeContact Details:
Company: QuinnoxLocation(s): Bengaluru+ View Contact
Keyskills: Oracle DBA Upgradation Oracle Ebs Technical Installation oracle technologies Migration
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in