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 QualificationsCandidates 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-*****-Ljbffr

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