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

Schlage de México, S.A. de C.V.; Tijuana; Presencial; MXN 700.000 - 1.100.000; Jornada completa

Descripción de la vacante

Schlage de México, S.A. de C.V. is seeking a Sr Oracle DBA & System Administrator to design, implement and optimize Oracle E-Business Suite R12 databases running on Exadata. You will ensure availability, performance, and secure operations.

You will lead automation for provisioning, patching, monitoring, and deployment, and mentor other DBAs. You will participate in on-call rotations and travel to data centers as needed to support deployments and DR testing.

Formación

• 10+ years hands-on Oracle DBA & System Administrator experience with Oracle E-Business Suite R12
• Experience with Oracle Exadata hardware (installation, configuration, tuning, patching)
• Proficient in Oracle Enterprise Manager (OEM) for monitoring and administration
• Strong RMAN backups, recovery and Data Guard knowledge
• Experience cloning EBS environments (Rapid Clone, AD utilities, RMAN)
• Experience tuning Concurrent Manager and parallel processing for EBS environments

Responsabilidades

• Administer Oracle E-Business Suite R12 databases on Exadata hardware
• Install, patch and upgrade Oracle databases and Grid Infrastructure components
• Implement and maintain end-to-end monitoring using OEM
• Design and validate robust backup and restore procedures (RMAN, Data Guard where applicable)
• Create and execute cloning procedures for Dev/Test/QA/DR environments
• Tune Concurrent Manager and optimize parallel execution and resource allocation
• Lead architecture and design reviews for EBS/Exadata projects
• Collaborate with Security and Compliance on audits (PCI, SOX)
• Develop capacity-planning models and lifecycle roadmaps for database infrastructure
• Mentor other DBAs and system administrators

Conocimientos

Oracle EBS

Exadata

OEM monitoring

RMAN backups

Data Guard

SQL/PLSQL

Automation scripts

Ansible/Puppet

CI/CD

Bash scripting

Security/compliance

OCP/OCA

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)