Sr. Oracle DBA & System Administrator (Oracle E-Business Suite R12 on Exadata)

Schlage de México, S.A. de C.V.; Santiago de Querétaro; Presencial; MXN 900.000 - 1.500.000; Jornada completa

Descripción de la vacante

Schlage de México, S.A. de C.V. seeks a Senior Oracle DBA & System Administrator to design, implement, and optimize Oracle E-Business Suite R12 databases on Exadata. You will ensure availability, performance, backups, and security; lead automation efforts; and mentor the team.

You will administer EBS R12 on Exadata, patch and upgrade, implement OEM monitoring, and develop robust DR/testing procedures while collaborating with security and compliance teams.

Formación

• 10+ years hands-on experience as Oracle DBA & System Administrator for Oracle E-Business Suite R12.
• Proven experience with Exadata hardware installation, config, patching and troubleshooting.
• Strong experience with OEM for monitoring and administration.
• Extensive RMAN backups and disaster recovery knowledge; Data Guard a plus.
• Experience cloning EBS environments (Rapid Clone, AD utilities, RMAN).
• Experience tuning databases and app tiers for parallel processing and Concurrent Manager optimization.
• Experience routing/workload distribution with additional app servers.
• Knowledge of ASM/Grid Infrastructure/Oracle RAC, Linux for Oracle, storage/networking.
• SQL, PL/SQL and shell scripting; automation/orchestration tools (Ansible, Puppet, Chef) and CI/CD a plus.
• Excellent documentation and knowledge transfer skills; certifications preferred.
• Willingness to participate in on-call rotation and travel.

Responsabilidades

• Administer and support Oracle E-Business Suite R12 databases on Exadata hardware.
• Install, configure, patch and upgrade Oracle databases, Grid Infrastructure, ASM for EBS R12.
• Implement and maintain end-to-end monitoring with OEM.
• Design robust backup and restore procedures (RMAN, Data Guard) and validate restores.
• Create and execute cloning procedures for Dev/Test/QA/DR environments.
• Tune Concurrent Manager, allocations and scheduling for performance.
• Operate EBS environment and perform performance monitoring.
• Conduct root cause analysis and implement preventative measures.
• Create runbooks and train other DBAs and system admins.
• Participate in on-call rotation and travel for deployments/DR testing.

Conocimientos

Oracle E-Business Suite R12

Exadata hardware

Oracle Enterprise Manager (OEM)

RMAN backups

Data Guard

Cloning procedures

Concurrent Manager tuning

ASM/Grid Infrastructure

Linux for Oracle

SQL/PLSQL

Shell scripting (bash)

Automation (Ansible/Puppet/Chef)

CI/CD concepts

Documentation & knowledge transfer

Oracle RAC

Security/compliance awareness

Herramientas

OEM

RMAN

Data Guard

Rapid Clone

AD utilities

Ansible

Puppet

Chef

CI/CD

Oracle RAC

Grid Infrastructure

ASM

Linux for Oracle

Descripción del empleo

The Sr. Oracle DBA & System Administrator is responsible for the design, implementation, administration and ongoing optimization of Oracle E-Business Suite R12 databases running on Oracle Exadata hardware. As a Sr. Oracle DBA & System Administrator, you will ensure availability, performance, backup/recovery and secure operations of the EBS database and related infrastructure; provide technical leadership; lead and develop automation efforts for database provisioning, patching, monitoring and deployment; and transfer knowledge to the broader team.

What You Will Do:

• Administer and support Oracle E-Business Suite R12 databases and related components on Oracle Exadata hardware
• Install, configure, patch and upgrade Oracle databases, Grid Infrastructure, ASM and related components necessary for EBS R12
• Implement and maintain end-to-end monitoring using Oracle Enterprise Manager (OEM)
• Design, document and operate robust backup and restore procedures (RMAN, Data Guard where applicable), and validate recovery procedures with regular restore tests
• Create, document and execute cloning procedures for Dev/Test/QA/DR environments (Rapid Clone, AD utilities, RMAN-based clones)
• Concurrent Manager tuning, parallel execution settings, resource allocation and scheduling
• EBS environment
• Perform performance monitoring
• Perform root cause analysis and implement preventative measures
• Create runbooks, standard operating procedures, train and mentor other DBAs and system administrators
• Participate in an on-call rotation for after-hours support as required
• Travel to data centers or other company locations for deployments, DR testing or hardware upgrades as needed
• Lead architecture and design reviews for new EBS/Exadata projects, upgrades or migrations
• Collaborate with Security and Compliance on audits (PCI, SOX)
• Evaluate new Exadata features Oracle releases and third-party tools
• Develop and maintain capacity-planning models, cost analyses and lifecycle roadmaps for database infrastructure

What You Need to Succeed:

• Minimum 10+ years’ hands-on experience as an Oracle DBA & System Administrator supporting Oracle E-Business Suite R12.
• Proven experience with Oracle Exadata hardware (installation, configuration, tuning, patching and troubleshooting).
• Strong experience with Oracle Enterprise Manager (OEM) for monitoring and administration.
• Solid expertise with RMAN backups, recovery scenarios, disaster recovery concepts; experience with Data Guard is a plus.
• Experience designing and executing cloning procedures for EBS environments (Rapid Clone, AD utilities, RMAN, hot/cold clones).
• Experience configuring and tuning databases and application tiers for parallel concurrent processing and Concurrent Manager optimization.
• Experience implementing and supporting model routing in EBS and configuring additional application servers to support routing and workload distribution.
• Strong knowledge of ASM, Grid Infrastructure, Oracle RAC, Linux for Oracle, and storage/networking concepts as they relate to Exadata.
• Proficiency in SQL, PL/SQL and shell scripting (bash); experience with automation/orchestration tools (Ansible, Puppet, Chef, etc.) and CI/CD is a plus.
• Excellent written and verbal communication skills; experience creating technical documentation and conducting knowledge transfer.
• Oracle certifications (OCA/OCP/OCE) are preferred.
• Must be able to participate in an on-call rotation and travel to data centers or other sites as required.
• Hands-on experience with automation/orchestration tools beyond basic scripting
• Familiarity with cloud or hybrid Exadata-Cloud architectures (OCI, AWS RDS, Azure)
• Proficiency in a general-purpose scripting language (Python, Perl) for complex automation tasks
• Understanding of database security standards and best practices (encryption-at-rest, key management)
• Strong collaboration and stakeholder-management skills
• Oracle Exadata Database Machine Administrator or Oracle Cloud Infrastructure certifications (preferred)