-

- 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 (Jalisco)
🏢 Pyramid Consulting
📍 Jalisco