Oracle Database Administrator

Pyramid Consulting, Inc; Región Centro; Presencial; MXN 600.000 - 900.000; Jornada completa

Descripción de la vacante

Pyramid Consulting, Inc. is seeking an experienced Oracle DBA to install, configure, and maintain Oracle databases across development, testing, and production environments. You will monitor performance, tune SQL, and implement robust backup and recovery using RMAN.

The ideal candidate has strong knowledge of Oracle Data Guard, RAC, and high-availability configurations, plus shell scripting for automation and on-call support.

Formación

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

Responsabilidades

• Install, configure, upgrade, patch, and maintain Oracle databases across development, testing, and production environments.
• Perform day-to-day database administration including schema and storage management, user administration, and configuration.
• Monitor database performance, availability, capacity, and system health.
• Tuning SQL and database performance, including execution plans and indexing.
• Develop, configure, and maintain backup and recovery strategies using RMAN.
• Support database recovery, disaster recovery, and business continuity activities.
• Administer Oracle RAC, Data Guard, and standby environments; manage migrations and patches.
• Implement and maintain database security, roles, privileges, and auditing.

Conocimientos

Oracle SQL

PL/SQL

RMAN

Oracle Data Guard

Oracle RAC

Linux/Unix

Shell scripting

Performance tuning

Security and access control

Descripción del empleo

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