Oracle DBA Developer

Pyramid Consulting; Región Centro; Presencial; MXN 480.000 - 820.000; Jornada completa

Descripción de la vacante

Pyramid Consulting in Mexico's Jalisco region seeks an experienced Oracle Database Administrator to oversee the administration, maintenance, and optimization of mission-critical database environments, ensuring high availability and compliance.

Responsibilities include installing and upgrading Oracle databases, managing DEV to PROD environments, developing SQL/PLSQL, and leading DR security efforts with RMAN, Data Guard, ODI, and ODA support. Strong Linux skills are required.

Formación

• Strong hands-on experience with Oracle Database Administration.
• Advanced SQL and PL/SQL skills.
• Experience with ODI (installation, configuration, and support).
• Knowledge of ODA platform (deployment, patching using odacli).
• Expertise in RMAN backup and recovery.
• Experience with performance tuning and troubleshooting.
• Proficiency in Linux (RHEL/Oracle Linux).
• Familiarity with Data Guard (RAC is a plus).

Responsabilidades

• Install, configure, and maintain Oracle databases (19c/21c).
• Manage database environments across DEV, SIT, UAT, and PROD.
• Perform database patching, upgrades, and migrations.
• Develop and optimize SQL and PL/SQL code.
• Manage RMAN backups, restores, and disaster recovery processes.
• Administer Oracle Database Appliance (ODA), including patching and monitoring.
• Configure and support Oracle Data Integrator (ODI), including repositories and agents.
• Monitor system performance and resolve database-related issues.
• Implement security controls, encryption, and auditing to meet compliance requirements.
• Support High Availability solutions such as Data Guard.
• Participate in incident management, RCA, and change implementation.

Conocimientos

Oracle DBA

SQL/PLSQL

Linux

Data Guard

ODI

ODA

RMAN

Performance tuning

Herramientas

ODI

ODA

odacli

Descripción del empleo

Role Summary:

The ideal candidate will be responsible for the administration, maintenance, and optimization of mission-critical database environments, ensuring high availability, performance, and compliance within a regulated environment.

Key Responsibilities:

• Install, configure, and maintain Oracle databases (19c/21c)
• Manage database environments across DEV, SIT, UAT, and PROD
• Perform database patching, upgrades, and migrations
• Develop and optimize SQL and PL/SQL code
• Manage RMAN backups, restores, and disaster recovery processes
• Administer Oracle Database Appliance (ODA), including patching and monitoring
• Configure and support Oracle Data Integrator (ODI), including repositories and agents
• Monitor system performance and resolve database-related issues
• Implement security controls, encryption, and auditing to meet compliance requirements
• Support High Availability solutions such as Data Guard
• Participate in incident management, RCA, and change implementation

Required Skills & Experience:

• Strong hands‑on experience with Oracle Database Administration
• Advanced SQL and PL/SQL skills
• Experience with ODI (installation, configuration, and support)
• Knowledge of ODA platform (deployment, patching using odacli)
• Expertise in RMAN backup and recovery
• Experience with performance tuning and troubleshooting
• Proficiency in Linux (RHEL/Oracle Linux)
• Familiarity with Data Guard (RAC is a plus)