ORACLE DBA ||

Roles and Responsibilities

- 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.

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