- Install, configure, upgrade, patch, and maintain Oracle databases across development, testing, and production environments.
- Perform day-to-day database administration, including schema management, storage management, user administration, and database configuration.
- Monitor database performance, availability, capacity, and overall system health.
- Perform SQL and database performance tuning , including execution plan analysis, query optimization, indexing, and resource utilization.
- Develop, configure, and maintain database backup and recovery strategies using RMAN .
- Support database recovery, disaster recovery, and business continuity activities.
- Administer and troubleshoot Oracle RAC, Data Guard, and standby database environments .
- Manage database migrations, upgrades, refreshes, cloning, and patching activities.
- Implement and maintain database security, including roles, privileges, access controls, and auditing.
- Troubleshoot database incidents, connectivity issues, performance degradation, and production failures.
- Collaborate with application, infrastructure, development, and support teams to resolve database-related issues.
- Develop automation scripts using Shell scripting, SQL, and PL/SQL to improve operational efficiency.
- Maintain database documentation, standard operating procedures, and operational support guidelines.




- Participate in L2/L3 production support , incident management, problem management, and on-call support as required.

Mandatory Skills and Qualifications

Candidates must meet the following requirements:

- 5+ years of hands-on experience as an Oracle DBA in enterprise production environments.
- Strong experience in Oracle Database Administration and database maintenance.
- Proficiency in Oracle SQL and PL/SQL .
- Hands-on experience with RMAN backup and recovery .
- Experience with Oracle Data Guard , including standby database configuration, monitoring, and troubleshooting.
- Experience with Oracle RAC and high-availability database environments.
- Strong knowledge of Oracle database performance tuning and troubleshooting .
- Experience with Oracle database installation, patching, upgrades, and migrations .
- Working knowledge of Linux/Unix operating systems .
- Experience with Shell scripting for database administration and automation.
- Strong understanding of database security, user management, roles, privileges, and access controls.
- Experience providing production support , incident resolution, and root cause analysis.
- Strong communication, analytical, and problem-solving skills.

#J-18808-Ljbffr

📌 Oracle Database Administrator (Centro)
🏢 Pyramid Consulting
📍 Centro