Oracle DB Administrator - High Availability & Automation

Observatorio ALMA; Santiago; Presencial; CLP 35.000.000 - 60.000.000; Jornada completa

Descripción de la vacante

Observatorio ALMA seeks a Database Administrator to manage ALMA's production Oracle databases, focusing on high availability, security, and performance. The role covers installation, patching, monitoring, backup/recovery, and coordination with global teams across Europe, North America, and East Asia.

You will work with Grid Infrastructure, RAC, ASM, GoldenGate, and Enterprise Manager, ensuring data integrity and operational resilience in a high-altitude, Chilean setting.

Formación

• Minimum university degree in a computer-related field.
• At least 2 years of database administration experience with Oracle or similar databases.
• Experience with SQL and PL/SQL development and tuning.
• Familiarity with Unix/Linux environments (Red Hat/Oracle Linux desirable).

Responsabilidades

• Administer and maintain Oracle database environments across development, test, integration, and production platforms.
• Manage lifecycle for Single-Instance and RAC databases including installation, patching, migration, upgrade, and support for Grid Infrastructure, ASM, GoldenGate, and Cloud Control.
• Monitor availability, capacity, performance, replication, and health; identify risks and implement corrective actions.
• Perform tuning and optimization of SQL/PL-SQL, indexing, and execution plans.
• Ensure database security, including users, roles, privileges, authentication, auditing, and compliance.
• Coordinate capacity planning and lifecycle activities with infrastructure teams.
• Design, test, and maintain backup, recovery, DR, and failover capabilities.
• Collaborate with system admins, and cross-functional teams; participate in incident response and problem management.
• Develop technical documentation and runbooks; contribute to automation and monitoring initiatives.

Conocimientos

SQL queries

Oracle database tuning

Linux administration

Database security

Performance monitoring

Scripting (Bash, Python)

Backup and recovery

High availability (RAC, ASM)

Educación

University degree in Computer Science / IT / related field

Oracle Database Certification (preferred)

Herramientas

Oracle Grid Infrastructure

GoldenGate

Oracle Enterprise Manager

RMAN

Descripción del empleo

Observatorio ALMA seeks a Database Administrator to manage ALMA's production Oracle databases, focusing on high availability, security, and performance. The role covers installation, patching, monitoring, backup/recovery, and coordination with global teams across Europe, North America, and East Asia.

You will work with Grid Infrastructure, RAC, ASM, GoldenGate, and Enterprise Manager, ensuring data integrity and operational resilience in a high-altitude, Chilean setting.