Oracle DBA — High Availability & Automation

ALMA Observatory

Santiago

Presencial

CLP 9.000.000 - 13.000.000

Jornada completa

Hace 3 días

Sé de los primeros/as/es en solicitar esta vacante

Generador de candidaturas

No envíes un currículum genérico — crea un currículum y una carta de presentación adaptados a este puesto concreto.

Supera los filtros ATS

Descripción de la vacante

ALMA Observatory in Santiago, Chile, seeks a Database Administrator to oversee Oracle production environments, focusing on availability, performance, security, and lifecycle management across development to production platforms. You will configure, patch, tune, monitor, back up, and recover Oracle infrastructure including Grid Infrastructure, ASM, RAC, GoldenGate, and OEM.

The role requires strong SQL/PLSQL skills, RAC experience, Linux expertise, and a proactive approach to automation and

Formación

University degree in Computer Science, Computing Engineering, Software Engineering, Information Technology, or a closely related discipline.
At least 2 years of experience in database administration or related database support activities, with Oracle, Sybase, InfluxDB, or similar.
Academic coursework or internship in database administration, preferably Oracle databases.
Knowledge of SQL and ability to create queries, analyze data, and perform routine tasks.
Solid understanding of database performance monitoring, troubleshooting, and tuning concepts.
Familiarity with Unix/Linux environments; exposure to Red Hat/Oracle Linux desirable.
Oracle RAC and high-availability environments preferred but not mandatory.
Oracle, SQL, Linux, or Red Hat training or entry-level certification desirable.
Oracle Database Administrator Certification (12c+) preferred but not mandatory.
Strong interest in career development in database administration; willingness to on-the-job train.
Fluent Spanish and advanced English level.

Responsabilidades

Administer and maintain Oracle database environments across development, test, integration, and production platforms.
Manage lifecycle for Single-Instance and RAC databases, including installation, configuration, patching, migration, upgrade, and support for Grid Infrastructure, ASM, GoldenGate, and Cloud Control.
Monitor availability, capacity, performance, replication, and overall health; identify risks and implement corrections.
Perform database performance analysis and tuning, including SQL/PLSQL optimization, profiling, indexing, and execution-plan review.
Administer database security, users, roles, privileges, authentication, auditing, and ALMA cybersecurity compliance.
Plan and execute capacity, lifecycle, and growth activities with infrastructure/service owners.
Design, implement, test, and maintain backup, recovery, disaster-recovery, and failover capabilities with IT Group.
Administer and troubleshoot Oracle GoldenGate replication between distributes ALMA sites.
Review and authorize production schema changes and Oracle-related software upgrades.
Develop and maintain technical documentation, procedures, standards, architecture records, and recovery runbooks.
Evaluate new Oracle capabilities and related technologies, recommending improvements for reliability and automation.
Provide Linux and storage administration support and collaborate with system admins on OS/network/storage issues.
Coordinate support with Oracle and vendors; enable timely diagnosis, escalation, resolution, and knowledge capture.
Participate in incident response, root-cause analysis, problem management, maintenance, and service-continuity planning.
Contribute to automation, monitoring, and observability using scripting, metrics, dashboards, logging, and alerting tools.
Provide technical guidance and cross-training within Archive/Pipeline Operations Group.