[Hiring] Senior Oracle DBA @Prophecy Technologies

Role Description

Responsible for administration, reliability, and optimization of Oracle database environments supporting enterprise applications.

• Install, configure, upgrade, and patch Oracle Database environments.
• Create and manage Oracle databases, tablespaces, schemas, tables, indexes, and views.
• Monitor and optimize database performance through SQL tuning, indexing, and resource management.
• Implement backup and recovery strategies using RMAN and recovery procedures.
• Ensure high availability and disaster recovery through Oracle Data Guard, RAC, and failover solutions.
• Manage database security, user accounts, roles, privileges, and auditing.
• Monitor database health, storage utilization, and capacity planning.
• Troubleshoot database errors, performance bottlenecks, and production issues.
• Configure and maintain Oracle networking components such as Oracle Net Listener and TNS.
• Perform database migration, cloning, refreshes, and data movement activities.
• Automate routine administration tasks using Shell Scripts, SQL, and PL/SQL.
• Support application teams during deployments and release activities.
• Manage Oracle RAC, ASM, Data Guard, and Multitenant databases (CDB/PDB).
• Ensure compliance with security, audit, and organizational standards.
• Prepare and maintain database documentation, SOPs, and operational procedures.
• Provide 24x7 production support and participate in on-call rotations.
• Work with infrastructure, application, and cloud teams for database reliability and scalability.

Qualifications

• At least 10 years of experience, including work with 30+ TB databases handling 80,000 transactions per second.

Requirements

• Oracle RDBMS (on-prem + OCI/cloud exposure)
• PL/SQL, query optimization
• Oracle HA/DR (RAC, Data Guard)
• Performance diagnostics and tuning
• Unix Shell Scripting and text processing tools
• Oracle DBA
• Unix / Linux Basics and Commands