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

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